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

About this Dataset

Highways

The Iowa Highway Five Year Improvement Program with amendments. Created in June 2018.
Organization: State of Iowa
Last updated: 2024-04-12T12:51:03.262308
Tags: asset, asset-improvement, five-year-plan, highways, improvement, planning, program, program-management

Tables

Table 1

@usgov.state_of_iowa_highways_data.table_1

348.77 kB
493 rows
23 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "county_number" DOUBLE,
  "route" DOUBLE,
  "district" DOUBLE,
  "work_type" VARCHAR,
  "fiscal_year" DOUBLE,
  "cost_k" DOUBLE  -- Cost ($K),
  "location" VARCHAR,
  "fiveyear_pin" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "year_id" DOUBLE,
  "official_common_route_name" VARCHAR,
  "from_ref_post" VARCHAR,
  "from_reference_post_offset" VARCHAR,
  "to_reference_post" VARCHAR,
  "to_reference_post_offset" VARCHAR,
  "mile_point" VARCHAR,
  "route_id" VARCHAR,
  "county_name" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);