About this Dataset

Aggregated Parking Transactions

This dataset records Pittsburgh Parking Authority parking transactions for street parking and parking lots, aggregated in ten-minute bins by parking zone. Each row includes the start and end times of the ten-minute bin, the parking zone or lot, the number of transactions, and the payments made during that time span.

DATA ADVISORY: As of April/May 2021, the Parking Authority changed its mobile payments system, and since then we have not been able to extract all mobile transactions. We hope to fix this in the future.

NOTE: The first resource below is big enough that the download link will time out and not let you download the file. We are working on changing this link.

In the meantime, you may use this download link: https://tools.wprdc.org/downstream/1ad5394f-d158-46c1-9af7-90a9ef4e0ce1
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:45.555113
Tags: _etl, parking

Tables

Transactions By Sampling Zone And Time Of Day

@usgov.allegheny_county_city_of_pitts_aggregated_parking_transactions.transactions_by_sampling_zone_and_time_of_day

16.32 MB
1,120,000 rows
10 columns

CREATE TABLE transactions_by_sampling_zone_and_time_of_day (
  "n__id" BIGINT  -- Id,
  "zone" VARCHAR,
  "start" TIMESTAMP,
  "end" TIMESTAMP,
  "utc_start" TIMESTAMP,
  "meter_transactions" BIGINT,
  "meter_payments" DOUBLE,
  "mobile_transactions" BIGINT,
  "mobile_payments" DOUBLE,
  "parent_zone" VARCHAR
);