Crossing Inventory Data (Form 71) - Current by US Government | Ecommerce and Consumer Trends

About this Dataset

Crossing Inventory Data (Form 71) - Current

This dataset is in a user-friendly human-readable format. It contains the current crossing inventory - one record for each crossing. To download historical data, go here: https://data.transportation.gov/Railroads/Crossing-Inventory-Data-Historical/vhwz-raag. To download the source dataset that contains raw data values, go here: https://data.transportation.gov/dataset/Crossing-Inventory-Source-Data-Form-71-Current/xp92-5xme.
Organization: Department of Transportation
Last updated: 2021-05-17T20:11:51.616993
Tags: crossing, crossing-inventory, form-71, highway-rail, inventory

Tables

Table 1

@usgov.dot_gov_crossing_inventory_data_current.table_1

76.75 MB
438044 rows
257 columns


CREATE TABLE table_1 (
  "revision_date" TIMESTAMP,
  "railroad_code" VARCHAR,
  "railroad_name" VARCHAR,
  "reporting_agency_type_id" BIGINT,
  "reporting_agency_type" VARCHAR,
  "reason_code" BIGINT,
  "reason_description" VARCHAR,
  "crossing_id" VARCHAR,
  "crossing_id_suffix" VARCHAR,
  "reporting_agency_code" VARCHAR,
  "reporting_agency_name" VARCHAR,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "county_code" VARCHAR,
  "county_name" VARCHAR,
  "in_near_code" DOUBLE,
  "in_near" VARCHAR,
  "city_code" DOUBLE,
  "city_name" VARCHAR,
  "city_description" VARCHAR,
  "street" VARCHAR,
  "block_number" DOUBLE,
  "highway_name" VARCHAR,
  "separate_track" VARCHAR,
  "separate_track_railroad_1" VARCHAR,
  "separate_track_railroad_2" VARCHAR,
  "separate_track_railroad_3" VARCHAR,
  "separate_track_railroad_4" VARCHAR,
  "same_track" VARCHAR,
  "same_track_railroad_1" VARCHAR,
  "same_track_railroad_2" VARCHAR,
  "same_track_railroad_3" VARCHAR,
  "same_track_railroad_4" VARCHAR,
  "railroad_division" VARCHAR,
  "railroad_subdivision" VARCHAR,
  "branch_name" VARCHAR,
  "railroad_milepost_prefix" VARCHAR,
  "railroad_milepost_number" VARCHAR,
  "railroad_milepost_suffix" VARCHAR,
  "line_segment" VARCHAR,
  "nearest_timetable_station" VARCHAR,
  "timetable_station" VARCHAR,
  "parent_railroad_code" VARCHAR,
  "crossing_owner_code" VARCHAR,
  "crossing_type_code" DOUBLE,
  "crossing_type" VARCHAR,
  "crossing_purpose_code" DOUBLE,
  "crossing_purpose" VARCHAR,
  "crossing_position_code" BIGINT,
  "crossing_position" VARCHAR,
  "public_access" VARCHAR,
  "type_of_train_service_ids" DOUBLE,
  "type_of_train_service_id_1" DOUBLE,
  "type_of_train_service_1" VARCHAR,
  "type_of_train_service_id_2" DOUBLE,
  "type_of_train_service_2" VARCHAR,
  "type_of_train_service_id_3" DOUBLE,
  "type_of_train_service_3" VARCHAR,
  "type_of_train_service_id_4" DOUBLE,
  "type_of_train_service_4" VARCHAR,
  "type_of_train_service_id_5" DOUBLE,
  "type_of_train_service_5" VARCHAR,
  "type_of_train_service_id_6" DOUBLE,
  "type_of_train_service_6" VARCHAR,
  "less_than_one_passenger_train_per_day" VARCHAR,
  "number_passenger_train_per_day" DOUBLE,
  "development_type_code" DOUBLE,
  "development_type" VARCHAR,
  "adjacent_crossing" VARCHAR,
  "adjacent_crossing_number" VARCHAR,
  "whistleban_code" DOUBLE,
  "whistle_ban" VARCHAR,
  "whistle_date" TIMESTAMP,
  "high_speed_rail_corridor_id_suffix" VARCHAR,
  "high_speed_rail_corridor_id" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "lat_long_source_code" DOUBLE,
  "lat_long_source" VARCHAR,
  "railroad_narrative_base" VARCHAR,
  "railroad_use" VARCHAR,
  "state_narrative_base" VARCHAR,
  "state_use" VARCHAR,
  "emergency_telephone_number" VARCHAR,
  "railroad_contact_telephone_number" VARCHAR,
  "state_contact_telephone_number" VARCHAR,
  "total_daylight_thru_trains" DOUBLE,
  "total_nighttime_thru_trains" DOUBLE,
  "total_switching_trains" DOUBLE,
  "total_transit_trains" DOUBLE,
  "movements_per_day_code" DOUBLE,
  "movements_per_day" VARCHAR,
  "trains_per_week" DOUBLE,
  "trains_per_week_captured_year" DOUBLE,
  "maximum_timetable_speed" DOUBLE,
  "typical_minimum_speed_over_crossing" DOUBLE,
  "typical_maximum_speed_over_crossing" DOUBLE,
  "number_of_main_tracks" DOUBLE,
  "number_of_siding_tracks" DOUBLE,
  "number_of_yard_tracks" DOUBLE
);