About this Dataset

Maintenance Cost Center

This is a representation of all primary roads as well as parks and institution roads that the Iowa Department of Transportation has the responsibility to maintain. Each maintenance garage is displayed in a different color to show where one area of responsibility ends and another begins. Updated August 2016.
Organization: State of Iowa
Last updated: 2024-04-12T12:49:18.635541
Tags: asset-classification, garage, maintenance

Tables

Table 1

@usgov.state_of_iowa_maintenance_cost_center_data.table_1

13.05 MB
40,135 rows
31 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "cost_center" DOUBLE,
  "garage_name" VARCHAR,
  "maintenance_district_number" DOUBLE,
  "route_name" VARCHAR,
  "official_route_number" BIGINT,
  "official_common_name" VARCHAR,
  "from_measure" DOUBLE,
  "to_measure" DOUBLE,
  "county_number" DOUBLE,
  "county_name" VARCHAR,
  "ref_post_start" VARCHAR,
  "ref_post_offset_start" DOUBLE,
  "ref_post_end" VARCHAR,
  "ref_post_offset_end" DOUBLE,
  "number_of_lanes" DOUBLE,
  "facility_type_code" DOUBLE,
  "facility_type" VARCHAR,
  "maintenance_service_level" VARCHAR,
  "road_status_code" BIGINT,
  "road_status" VARCHAR,
  "speed_limit_mph" DOUBLE  -- Speed Limit (MPH),
  "segement_length_miles_state_plane" DOUBLE  -- Segement Length (Miles - State Plane),
  "cost_center_circle" DOUBLE,
  "n_911_route_name" VARCHAR  -- 911 Route Name,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "utc_offset" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);