Name: Historic HPMS Data (Universe) - 1989
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Historic HPMS Data (Universe) - 1989

Historic Highway Performance Monitoring System universe data for the year 1989
Organization: Department of Transportation
Last updated: 2022-07-20T06:13:17.298691
Tags: highway, highway-performance-monitoring, highway-performance-monitoring-system, highways, hpms

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_universe_1989.table_1

10.45 MB
943,708 rows
22 columns

CREATE TABLE table_1 (
  "data_year" BIGINT,
  "state_fips_code" BIGINT,
  "county_fips_code" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sampling_technique" BIGINT,
  "urbanized_area_code" BIGINT,
  "type_of_section" BIGINT,
  "section_identification" VARCHAR,
  "functional_class" BIGINT,
  "federal_aid_system" BIGINT,
  "route_signing" BIGINT,
  "federal_aid_system_status" BIGINT,
  "unnamed_column" BIGINT,
  "route_number" VARCHAR,
  "governmental_level_of_control" BIGINT,
  "federal_state_and_local_domain" BIGINT  -- Federal, State And Local Domain,
  "unnamed_column_1" BIGINT,
  "unnamed_column_2" BIGINT,
  "unnamed_column_3" BIGINT,
  "section_grouped_length" DOUBLE,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT
);