About this Dataset

City Of Pittsburgh Parks

City of Pittsburgh Parks

NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it. This parks dataset, also published by the City, has been updated more recently: https://data.wprdc.org/dataset/parks1
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:38.693133
Tags: _etl, parks

Tables

City Parks

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_parks.city_parks

25.34 KB
209 rows
16 columns


CREATE TABLE city_parks (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "maintenance_responsibility" VARCHAR,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "ward" BIGINT,
  "tract" BIGINT,
  "public_works_division" BIGINT,
  "pli_division" BIGINT,
  "police_zone" BIGINT,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

City Parks Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_parks.city_parks_data_dictionary

2.99 KB
15 rows
3 columns


CREATE TABLE city_parks_data_dictionary (
  "n__id" BIGINT,
  "id" VARCHAR,
  "type" VARCHAR
);