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

980.97 MB
41,102,672 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  -- This Field Contains The Segment Length Covered By The Station Reported In Miles,
  "number_of_samples" BIGINT,
  "n_5_minute_lanes_point" BIGINT  -- 5-minute Lanes Point,
  "n_5_minute_vehicle_flow" DOUBLE  -- 5-minute Vehicle Flow,
  "n_5_minute_station_occupancy" DOUBLE  -- 5-minute Station Occupancy,
  "n_5_minute_station_speed" DOUBLE  -- 5-minute Station Speed,
  "delay_over_the_station_length_35mph" DOUBLE  -- Delay Over The Station Length (35mph),
  "delay_over_the_station_length_40mph" DOUBLE  -- Delay Over The Station Length (40mph),
  "delay_over_the_station_length_45mph" DOUBLE  -- Delay Over The Station Length (45mph),
  "delay_over_the_station_length_50_mph" DOUBLE  -- Delay Over The Station Length (50 Mph),
  "delay_over_the_station_length_55_mph" DOUBLE  -- Delay Over The Station Length (55 Mph),
  "delay_over_the_station_length_60_mph" DOUBLE  -- Delay Over The Station Length (60 Mph),
  "n_5_minute_flows_for_lane_1" DOUBLE  -- 5-minute Flows For Lane 1,
  "n_5_minute_occupancy_for_lane_1" DOUBLE  -- 5-minute Occupancy For Lane 1,
  "n_5_minute_speeds_lane_1" DOUBLE  -- 5-minute Speeds Lane 1,
  "n_5_minute_flows_for_lane_2" DOUBLE  -- 5-minute Flows For Lane 2,
  "n_5_minute_occupancy_for_lane_2" DOUBLE  -- 5-minute Occupancy For Lane 2,
  "n_5_minute_speeds_lane_2" DOUBLE  -- 5-minute Speeds Lane 2,
  "n_5_minute_flows_for_lane_3" DOUBLE  -- 5-minute Flows For Lane 3,
  "n_5_minute_occupancy_for_lane_3" DOUBLE  -- 5-minute Occupancy For Lane 3,
  "n_5_minute_speeds_lane_3" DOUBLE  -- 5-minute Speeds Lane 3,
  "n_5_minute_flows_for_lane_4" DOUBLE  -- 5-minute Flows For Lane 4,
  "n_5_minute_occupancies_for_lane_4" DOUBLE  -- 5-minute Occupancies For Lane 4,
  "n_5_minute_speeds_for_lane_4" DOUBLE  -- 5-minute Speeds For Lane 4,
  "n_5_minute_flows_for_lane_5" DOUBLE  -- 5-minute Flows For Lane 5,
  "n_5_minute_occupancies_for_lane_5" DOUBLE  -- 5-minute Occupancies For Lane 5,
  "n_5_minute_speeds_for_lane_5" DOUBLE  -- 5-minute Speeds For Lane 5,
  "n_5_minute_flows_for_lane_6" DOUBLE  -- 5-minute Flows For Lane 6,
  "n_5_minute_occupancies_for_lane_6" DOUBLE  -- 5-minute Occupancies For Lane 6,
  "n_5_minute_speeds_for_lane_6" DOUBLE  -- 5-minute Speeds For Lane 6,
  "n_5_minute_flows_for_lane_7" DOUBLE  -- 5-minute Flows For Lane 7,
  "n_5_minute_occupancies_for_lane_7" DOUBLE  -- 5-minute Occupancies For Lane 7,
  "n_5_minute_speeds_for_lane_7" DOUBLE  -- 5-minute Speeds For Lane 7,
  "n_5_minute_flows_for_lane_8" VARCHAR  -- 5-minute Flows For Lane 8,
  "n_5_minute_occupancies_for_lane_8" VARCHAR  -- 5-minute Occupancies For Lane 8,
  "n_5_minute_speeds_for_lane_8" VARCHAR  -- 5 Minute Speeds For Lane 8
);