AMS Pasadena Main Data by US Government | Transportation and Logistics

About this Dataset

AMS Pasadena Main Data

The data in this data environment was collected from the Pasadena, California testbed, namely I-210, SR 134, and nearby arterials. The source of these data is from the Caltrans – Performance Measurement System (PeMS). Speed data from this dataset were used to derive the freeway travel time. There are three separate text files with one for each operational condition.
Organization: Department of Transportation
Last updated: 2020-11-12T12:41:38.832307
Tags: ams, ams-pasadena-testbed, analysis-modeling-and-simulation-ams-testbed-development, arterial, california, cluster-analysis, freeway, i-210, incident-data, intelligent-transportation-systems-its, its-joint-program-office-jpo, pasadena, performance-measurement-system-pems, sr-134, travel-time

Tables

Table 1

@usgov.dot_gov_ams_pasadena_main_data.table_1

935.53 MB
41102672 rows
42 columns


CREATE TABLE table_1 (
  "date" VARCHAR,
  "station_report_id" BIGINT,
  "engineering_district_number" BIGINT,
  "route_number" BIGINT,
  "direction_of_travel" VARCHAR,
  "type_of_facility" VARCHAR,
  "this_field_contains_the_segment_length_covered_by_the__a41a5f9f" DOUBLE,
  "number_of_samples" BIGINT,
  "n_5_minute_lanes_point" BIGINT,
  "n_5_minute_vehicle_flow" DOUBLE,
  "n_5_minute_station_occupancy" DOUBLE,
  "n_5_minute_station_speed" DOUBLE,
  "delay_over_the_station_length_35mph" DOUBLE,
  "delay_over_the_station_length_40mph" DOUBLE,
  "delay_over_the_station_length_45mph" DOUBLE,
  "delay_over_the_station_length_50_mph" DOUBLE,
  "delay_over_the_station_length_55_mph" DOUBLE,
  "delay_over_the_station_length_60_mph" DOUBLE,
  "n_5_minute_flows_for_lane_1" DOUBLE,
  "n_5_minute_occupancy_for_lane_1" DOUBLE,
  "n_5_minute_speeds_lane_1" DOUBLE,
  "n_5_minute_flows_for_lane_2" DOUBLE,
  "n_5_minute_occupancy_for_lane_2" DOUBLE,
  "n_5_minute_speeds_lane_2" DOUBLE,
  "n_5_minute_flows_for_lane_3" DOUBLE,
  "n_5_minute_occupancy_for_lane_3" DOUBLE,
  "n_5_minute_speeds_lane_3" DOUBLE,
  "n_5_minute_flows_for_lane_4" DOUBLE,
  "n_5_minute_occupancies_for_lane_4" DOUBLE,
  "n_5_minute_speeds_for_lane_4" DOUBLE,
  "n_5_minute_flows_for_lane_5" DOUBLE,
  "n_5_minute_occupancies_for_lane_5" DOUBLE,
  "n_5_minute_speeds_for_lane_5" DOUBLE,
  "n_5_minute_flows_for_lane_6" DOUBLE,
  "n_5_minute_occupancies_for_lane_6" DOUBLE,
  "n_5_minute_speeds_for_lane_6" DOUBLE,
  "n_5_minute_flows_for_lane_7" DOUBLE,
  "n_5_minute_occupancies_for_lane_7" DOUBLE,
  "n_5_minute_speeds_for_lane_7" DOUBLE,
  "n_5_minute_flows_for_lane_8" VARCHAR,
  "n_5_minute_occupancies_for_lane_8" VARCHAR,
  "n_5_minute_speeds_for_lane_8" VARCHAR
);