Historic HPMS Data (Sample) - 1998 by US Government | Demographics and Population Studies

About this Dataset

Historic HPMS Data (Sample) - 1998

Historic Highway Performance Monitoring System data sample for the year 1998
Organization: Department of Transportation
Last updated: 2022-07-20T06:12:53.824687
Tags: highway, highway-performance-monitoring, highway-performance-monitoring-system, highways, hpms, sample

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_sample_1998.table_1

8.09 MB
122078 rows
127 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,
  "sample_number" VARCHAR,
  "sample_subdivision" BIGINT,
  "standard_expansion_factor" DOUBLE,
  "donut_expansion_factor" BIGINT,
  "surface_type" BIGINT,
  "pavement_section" BIGINT,
  "sn_d" DOUBLE,
  "type_base" BIGINT,
  "type_subgrade" BIGINT,
  "overlay_pav_thickness" DOUBLE,
  "year_surface_improv" BIGINT,
  "type_improvement" BIGINT,
  "lane_width" BIGINT,
  "shoulder_type" BIGINT,
  "shoulder_width_right" BIGINT,
  "shoulder_width_left" BIGINT,
  "peak_parking" BIGINT,
  "right_of_way_width" BIGINT,
  "widening_feasibility" BIGINT,
  "horizontal_alignment_adq" BIGINT,
  "num_classes_curves_a" BIGINT,
  "len_classes_curves_a" DOUBLE,
  "num_classes_curves_b" BIGINT,
  "len_classes_curves_b" DOUBLE,
  "num_classes_curves_c" BIGINT,
  "len_classes_curves_c" DOUBLE,
  "num_classes_curves_d" BIGINT,
  "len_classes_curves_d" DOUBLE,
  "num_classes_curves_3" BIGINT,
  "len_classes_curves_e" DOUBLE,
  "num_classes_curves_f" BIGINT,
  "len_classes_curves_f" DOUBLE,
  "num_classes_curves_g" BIGINT,
  "len_classes_curves_g" DOUBLE,
  "num_classes_curves_h" BIGINT,
  "len_classes_curves_h" DOUBLE,
  "num_classes_curves_i" BIGINT,
  "len_classes_curves_i" BIGINT,
  "num_classes_curves_j" BIGINT,
  "len_classes_curves_j" BIGINT,
  "num_classes_curves_k" BIGINT,
  "len_classes_curves_k" DOUBLE,
  "num_classes_curves_l" BIGINT,
  "len_classes_curves_l" DOUBLE,
  "num_classes_curves_m" BIGINT,
  "len_classes_curves_m" BIGINT,
  "type_terrain" BIGINT,
  "vertical_alignment_adq" BIGINT,
  "num_classes_grades_a" BIGINT,
  "len_classes_grades_a" DOUBLE,
  "num_classes_grades_b" BIGINT,
  "len_classes_grades_b" DOUBLE,
  "num_classes_grades_c" BIGINT,
  "len_classes_grades_c" DOUBLE,
  "num_classes_grades_d" BIGINT,
  "len_classes_grades_d" DOUBLE,
  "num_classes_grades_e" BIGINT,
  "len_classes_grades_e" DOUBLE
);