About this Dataset

Bottlenecks

Bottleneck Mapping is a subproject of the Mobility Performance Report, which is one of the products of the Mobility Performance Reporting and Analysis Program (MPRAP). The Mobility Performance Report is prepared by the California Department of Transportation (Caltrans) and District staff to provide detailed data about highway system performance related to congestion and mobility. Caltrans collects vehicle counts and calculates speeds at all hours of the day and all days of the week in major metropolitan areas throughout California via the Caltrans Performance Measurement System (PeMS--see Data Source tab). This information helps identify congestion bottlenecks and results in more cost-effective investments to improve the performance of the State Highway System.
Organization: State of California
Last updated: 2023-08-12T12:10:02.567619
Tags: bottlenecks, california-department-of-transportation, california-state-transportation-agency, caltrans, caopendata, clearinghouse, highway

Tables

Table 1

@usgov.ca_gov_bottlenecks_705d5.table_1

17.94 KB
89 rows
16 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "district" BIGINT,
  "rank" BIGINT,
  "county" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "shift" VARCHAR,
  "fwy" VARCHAR,
  "abs_pm" DOUBLE,
  "ca_pm" VARCHAR,
  "number_days_active" BIGINT,
  "avg_extent_miles" DOUBLE,
  "total_delay_veh_hrs" DOUBLE,
  "direction" VARCHAR,
  "abs_pm_upstream" DOUBLE,
  "shape_length" DOUBLE
);