Highways
State of Iowa
@usgov.state_of_iowa_highways_data
State of Iowa
@usgov.state_of_iowa_highways_data
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,
"location" VARCHAR,
"fiveyear_pin" VARCHAR,
"rest_service_last_updated_utc" VARCHAR,
"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
);
Anyone who has the link will be able to view this.