Name: Currently Adopted
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Currently Adopted

A visual representation of the currently "adopted" sections of highway in Iowa. Additionally, this map displays the sections of highway that are never available for adoption. This data is updated hourly at the top of the hour.
Organization: State of Iowa
Last updated: 2024-04-12T12:45:57.543252
Tags: aah, adopt-a-highway, asset, eps, inventory

Tables

Table 1

@usgov.state_of_iowa_currently_adopted_data.table_1

1.03 MB
885 rows
22 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "permit_key" BIGINT,
  "revision_number" BIGINT,
  "is_current_revision" BIGINT,
  "in_city_limits" DOUBLE,
  "city_notified" DOUBLE,
  "sponsor_verified" DOUBLE,
  "sign_text_line_1" VARCHAR  -- Sign Text - Line 1,
  "sign_text_line_2" VARCHAR  -- Sign Text - Line 2,
  "sign_text_line_3" VARCHAR  -- Sign Text - Line 3,
  "segment_id" BIGINT,
  "is_dot_sign" BIGINT,
  "is_special_request" BIGINT,
  "single_day_permit_utc" VARCHAR  -- Single Day Permit (UTC),
  "location_description" VARCHAR,
  "sign_line" 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
);