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

About this Dataset

Historic HPMS Data (Universe) - 1997

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

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_universe_1997.table_1

15.55 MB
1,048,575 rows
42 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "state" BIGINT,
  "metric_english" BIGINT,
  "county" BIGINT,
  "section_id" VARCHAR,
  "has_sample" BIGINT,
  "has_hov" BIGINT,
  "has_surveil" BIGINT,
  "is_donut" BIGINT,
  "lrs_id" VARCHAR,
  "begin_lrs" DOUBLE,
  "end_lrs" DOUBLE,
  "type_section" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sample" BIGINT,
  "urbanized_code" BIGINT,
  "nonattainment_area_code" BIGINT,
  "functional_system" BIGINT,
  "gen_functional_system" BIGINT,
  "national_highway_system" BIGINT,
  "unbuilt_facility" BIGINT,
  "official_inter_rt_num" DOUBLE,
  "route_signing" BIGINT,
  "route_qualifier" BIGINT,
  "signed_route_number" VARCHAR,
  "governmental_ownership" BIGINT,
  "special_systems" BIGINT,
  "type_facility" BIGINT,
  "designated_truck_route" BIGINT,
  "toll" BIGINT,
  "section_length" DOUBLE,
  "donut_aadt_volume" BIGINT,
  "standard_aadt_volume" BIGINT,
  "aadt" BIGINT,
  "aadt_derivation" BIGINT,
  "number_lanes" BIGINT,
  "urban_location" BIGINT,
  "access_control" BIGINT,
  "median_type" BIGINT,
  "median_width" BIGINT,
  "roughness" BIGINT,
  "pavement_condition" DOUBLE
);