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

About this Dataset

Historic HPMS Data (Sample) - 1988

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

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_sample_1988.table_1

5.55 MB
111003 rows
111 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "state" BIGINT,
  "county" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sampling_technique" BIGINT,
  "urbanized_area_code" BIGINT,
  "type_of_section" BIGINT,
  "section_identification" VARCHAR,
  "functional_system" BIGINT,
  "generated_functional_system_code" BIGINT,
  "federal_aid_system" BIGINT,
  "federal_aid_system_status" BIGINT,
  "route_signing" BIGINT,
  "route_number" VARCHAR,
  "governmental_level_of_control" BIGINT,
  "special_systems" BIGINT,
  "type_of_facility" BIGINT,
  "designated_truck_route_parkway" BIGINT,
  "toll" BIGINT,
  "section_grouped_length" DOUBLE,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT,
  "sample_number" VARCHAR,
  "sample_subdivision" BIGINT,
  "aadt_volume_group_identifier" BIGINT,
  "expansion_factor" DOUBLE,
  "surface_pavement_type" BIGINT,
  "concrete_joint_spacing" BIGINT,
  "load_transfer_devices" BIGINT,
  "pavement_section" BIGINT,
  "structural_number" DOUBLE,
  "type_of_base" BIGINT,
  "type_of_subgrade" BIGINT,
  "subsurface_drainage" BIGINT,
  "measured_pavement_roughness" BIGINT,
  "pavement_condition_rating" DOUBLE,
  "overlay_or_pavement_thickness" DOUBLE,
  "year_of_surface_improvement" BIGINT,
  "type_of_improvement" BIGINT,
  "access_control" BIGINT,
  "lane_width" BIGINT,
  "shoulder_type" BIGINT,
  "right_shoulder_width" BIGINT,
  "left_shoulder_width" BIGINT,
  "median_type" BIGINT,
  "median_width" DOUBLE,
  "right_of_way_width" DOUBLE,
  "is_widening_feasible" DOUBLE,
  "horizontal_alignment_adequacy" BIGINT,
  "number_class_a_curves" BIGINT,
  "length_class_a_curves" DOUBLE,
  "number_class_b_curves" BIGINT,
  "length_class_b_curves" DOUBLE,
  "number_class_c_curves" DOUBLE,
  "length_class_c_curves" DOUBLE,
  "number_class_d_curves" BIGINT,
  "length_class_d_curves" DOUBLE,
  "number_class_e_curves" BIGINT,
  "length_class_e_curves" DOUBLE,
  "number_class_f_curves" BIGINT,
  "length_class_f_curves" DOUBLE,
  "number_class_g_curves" BIGINT,
  "length_class_g_curves" DOUBLE,
  "number_class_h_curves" BIGINT,
  "length_class_h_curves" DOUBLE,
  "number_class_i_curves" BIGINT,
  "length_class_i_curves" DOUBLE,
  "number_class_j_curves" BIGINT,
  "length_class_j_curves" DOUBLE,
  "number_class_k_curves" BIGINT,
  "length_class_k_curves" DOUBLE,
  "number_class_l_curves" BIGINT,
  "length_class_l_curves" DOUBLE,
  "number_class_m_curves" BIGINT,
  "length_class_m_curves" DOUBLE,
  "vertical_alignment_adequacy" BIGINT,
  "number_class_a_grades" BIGINT,
  "length_class_a_grades" DOUBLE,
  "number_class_b_grades" BIGINT,
  "length_class_b_grades" DOUBLE,
  "number_class_c_grades" BIGINT,
  "length_class_c_grades" DOUBLE,
  "number_class_d_grades" BIGINT,
  "length_class_d_grades" DOUBLE,
  "number_class_e_grades" BIGINT,
  "length_class_e_grades" DOUBLE,
  "number_class_f_grades" BIGINT,
  "length_class_f_grades" DOUBLE,
  "percent_passing_sight_distance" BIGINT,
  "speed_limit" BIGINT,
  "weighted_design_speed" BIGINT,
  "peak_percent_trucks" BIGINT,
  "off_peak_percent_trucks" BIGINT,
  "k_factor" BIGINT,
  "directional_factor" BIGINT,
  "peak_capacity" BIGINT,
  "volume_service_flow_ratio" DOUBLE,
  "turning_lanes_left" BIGINT,
  "turning_lanes_right" BIGINT,
  "prevailing_type_of_signalization" BIGINT
);