About this Dataset

Allegheny County Traffic Counts

Traffic sensors at over 1,200 locations in Allegheny County collect vehicle counts for the Pennsylvania Department of Transportation. Data included in the Health Department's DASH project includes hourly averages and average daily counts. The data was collected from years 2012-2014 and compiled by Carnegie Mellon University’s Traffic21 Institute.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:09:01.637849
Tags: achd-dash, sensors, social-determinants-of-health, traffic, traffic-count, transportation

Tables

Traffic Counts 2012-2014 Data

@usgov.allegheny_county_city_of_pitts_allegheny_county_traffic_counts.traffic_counts_2012_2014_data

142.66 kB
1,305 rows
27 columns

CREATE TABLE traffic_counts_2012_2014_data (
  "sensor_id" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "n_1a" DOUBLE  -- 1a,
  "n_2a" DOUBLE  -- 2a,
  "n_3a" DOUBLE  -- 3a,
  "n_4a" DOUBLE  -- 4a,
  "n_5a" DOUBLE  -- 5a,
  "n_6a" DOUBLE  -- 6a,
  "n_7a" DOUBLE  -- 7a,
  "n_8a" DOUBLE  -- 8a,
  "n_9a" DOUBLE  -- 9a,
  "n_10a" DOUBLE  -- 10a,
  "n_11a" DOUBLE  -- 11a,
  "n_12p" DOUBLE  -- 12p,
  "n_1p" DOUBLE  -- 1p,
  "n_2p" DOUBLE  -- 2p,
  "n_3p" DOUBLE  -- 3p,
  "n_4p" DOUBLE  -- 4p,
  "n_5p" DOUBLE  -- 5p,
  "n_6p" DOUBLE  -- 6p,
  "n_7p" DOUBLE  -- 7p,
  "n_8p" DOUBLE  -- 8p,
  "n_9p" DOUBLE  -- 9p,
  "n_10p" DOUBLE  -- 10p,
  "n_11p" DOUBLE  -- 11p,
  "n_12a" DOUBLE  -- 12a
);