About this Dataset

Pittsburgh Parking Meters And Payment Points

This dataset contains information on the Pittsburgh Parking Authority's parking meters and other payments points, including a description of the location of the meter, which parking zone it is in, and its geocoordinates.

The "Payment Points + Rates" table is augmented with information about rates and the limits on when parking is metered.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:52.553736
Tags: _etl, parking, transportation

Tables

Payments Points + Rates

@usgov.allegheny_county_city_of_pitts_pittsburgh_parking_mete_e0972e9c.payments_points_rates

121.71 kB
1,224 rows
17 columns

CREATE TABLE payments_points_rates (
  "n__id" BIGINT  -- Id,
  "id" VARCHAR,
  "location" VARCHAR,
  "location_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "status" VARCHAR,
  "zone" VARCHAR,
  "all_groups" VARCHAR,
  "guid" VARCHAR,
  "in_service_utc" TIMESTAMP,
  "rate" VARCHAR,
  "max_hours" VARCHAR,
  "hours" VARCHAR,
  "restrictions" VARCHAR,
  "special_events" VARCHAR,
  "rate_as_of" TIMESTAMP
);