Name: Never Adoptable
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Never Adoptable

This layer represents the sections of highway which are never available for adoption within the Adopt-A-Highway program. This symbolization was developed for utilization by the Electronic Permitting System (EPS) at the Iowa Department of Transportation.
Organization: State of Iowa
Last updated: 2024-04-12T12:47:21.445542
Tags: aah, adopt-a-highway, asset, eps, inventory

Tables

Table 1

@usgov.state_of_iowa_never_adoptable_data.table_1

1.26 MB
486 rows
19 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "district" BIGINT,
  "garage" BIGINT,
  "route_name" VARCHAR,
  "start_post" BIGINT,
  "start_post_offset" DOUBLE,
  "end_post" BIGINT,
  "end_post_offset" DOUBLE,
  "description" VARCHAR,
  "location_error" VARCHAR,
  "county_number" VARCHAR,
  "location_id" BIGINT,
  "dot_representative" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "utc_offset" VARCHAR,
  "length_mile_state_plane" DOUBLE  -- Length (Mile - State Plane),
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);