Dataset: Historic HPMS Data (Sample) - 2003

About this Dataset

Historic HPMS Data (Sample) - 2003

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

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_sample_2003.table_1

6.76 MB
113139 rows
97 columns


CREATE TABLE table_1 (
  "year_record" BIGINT,
  "state_code" BIGINT,
  "is_metric" BIGINT,
  "county_code" BIGINT,
  "section_id" VARCHAR,
  "is_sample" BIGINT,
  "is_donut" BIGINT,
  "is_grouped" BIGINT,
  "lrs_id" VARCHAR,
  "begin_lrs" DOUBLE,
  "end_lrs" DOUBLE,
  "rural_urban" BIGINT,
  "sampling_tech" BIGINT,
  "urban_code" BIGINT,
  "nonatt_code" BIGINT,
  "f_system" BIGINT,
  "gf_system" BIGINT,
  "nhs" BIGINT,
  "unbuilt_facility" BIGINT,
  "inter_route_number" VARCHAR,
  "route_signing" BIGINT,
  "route_qualifier" BIGINT,
  "route_number" VARCHAR,
  "ownership" BIGINT,
  "special_systems" BIGINT,
  "type_facility" BIGINT,
  "truck_route" BIGINT,
  "toll" BIGINT,
  "section_length" DOUBLE,
  "donut_volume_group" BIGINT,
  "std_volume_group" BIGINT,
  "aadt" BIGINT,
  "through_lanes" BIGINT,
  "iri" BIGINT,
  "psr" DOUBLE,
  "hov" BIGINT,
  "surv_a" BIGINT,
  "surv_b" BIGINT,
  "surv_c" BIGINT,
  "surv_d" BIGINT,
  "surv_e" BIGINT,
  "surv_f" BIGINT,
  "surv_g" BIGINT,
  "surv_h" BIGINT,
  "surv_i" BIGINT,
  "sample_id" VARCHAR,
  "donut_exp_factor" DOUBLE,
  "std_exp_factor" DOUBLE,
  "pavement_type" BIGINT,
  "sn_d" DOUBLE,
  "climate_zone" BIGINT,
  "year_surf_improv" BIGINT,
  "lane_width" BIGINT,
  "access_control" BIGINT,
  "median_type" BIGINT,
  "median_width" BIGINT,
  "shoulder_type" BIGINT,
  "shoulder_width_r" BIGINT,
  "shoulder_width_l" BIGINT,
  "peak_parking" BIGINT,
  "wide_feas" BIGINT,
  "curves_a" DOUBLE,
  "curves_b" DOUBLE,
  "curves_c" DOUBLE,
  "curves_d" DOUBLE,
  "curves_e" DOUBLE,
  "curves_f" DOUBLE,
  "horz_align" BIGINT,
  "type_terrain" BIGINT,
  "vert_align" BIGINT,
  "grades_a" DOUBLE,
  "grades_b" DOUBLE,
  "grades_c" DOUBLE,
  "grades_d" DOUBLE,
  "grades_e" DOUBLE,
  "grades_f" DOUBLE,
  "perc_sight" BIGINT,
  "design_speed" BIGINT,
  "speed_limit" BIGINT,
  "perc_single_unit" BIGINT,
  "avg_single_unit" BIGINT,
  "perc_combination" BIGINT,
  "avg_combination" BIGINT,
  "k_factor" BIGINT,
  "dir_factor" BIGINT,
  "peak_lanes" BIGINT,
  "turn_lanes_l" BIGINT,
  "turn_lanes_r" BIGINT,
  "type_signal" BIGINT,
  "perc_green" BIGINT,
  "at_grade_signal" BIGINT,
  "at_grade_signs" BIGINT,
  "at_grade_other" BIGINT,
  "peak_capacity" BIGINT,
  "vsf" DOUBLE,
  "fut_aadt" BIGINT,
  "fut_aadt_year" BIGINT
);