Dataset: City Of Pittsburgh Traffic Count

About this Dataset

City Of Pittsburgh Traffic Count

This traffic-count data is provided by the City of Pittsburgh's Department of Mobility & Infrastructure (DOMI). Counters were deployed as part of traffic studies, including intersection studies, and studies covering where or whether to install speed humps. In some cases, data may have been collected by the Southwestern Pennsylvania Commission (SPC) or BikePGH.

Data is currently available for only the most-recent count at each location.

Traffic count data is important to the process for deciding where to install speed humps. According to DOMI, they may only be legally installed on streets where traffic counts fall below a minimum threshhold. Residents can request an evaluation of their street as part of DOMI's Neighborhood Traffic Calming Program. The City has also shared data on the impact of the Neighborhood Traffic Calming Program in reducing speeds.

Different studies may collect different data. Speed hump studies capture counts and speeds. SPC and BikePGH conduct counts of cyclists. Intersection studies included in this dataset may not include traffic counts, but reports of individual studies may be requested from the City. Despite the lack of count data, intersection studies are included to facilitate data requests.

Data captured by different types of counting devices are included in this data. StatTrak counters are in use by the City, and capture data on counts and speeds. More information about these devices may be found on the company's website. Data includes traffic counts and average speeds, and may also include separate counts of bicycles.

Tubes are deployed by both SPC and BikePGH and used to count cyclists. SPC may also deploy video counters to collect data.

NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:13.151164
Tags: _etl, bike, car, city-property, count, counter, cyclist, mobility, pittsburgh-open-data, speed-limit, traffic, traffic-count

Tables

Traffic Count Data

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_traffic_count.traffic_count_data

47.88 KB
420 rows
26 columns


CREATE TABLE traffic_count_data (
  "n__id" BIGINT,
  "id" BIGINT,
  "device_id" BIGINT,
  "record_oid" DOUBLE,
  "count_start_date" TIMESTAMP,
  "count_end_date" TIMESTAMP,
  "average_daily_car_traffic" DOUBLE,
  "average_daily_bike_traffic" DOUBLE,
  "counter_number" VARCHAR,
  "counter_type" VARCHAR,
  "speed_limit" DOUBLE,
  "max_speed" DOUBLE,
  "median_speed" DOUBLE,
  "percent_over_limit" DOUBLE,
  "speed85_percent" DOUBLE,
  "speed95_percent" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "tract" BIGINT,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR
);