About this Dataset

Playground Equipment

A listing of all playground equipment maintained by the city, including a description, the manufacturer, included safety surface and whether or not it is ADA accessible.

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: 2020-11-30T02:49:52.607233
Tags: _etl, parks, playgrounds, recreation, youth

Tables

Playground Equipment

@usgov.allegheny_county_city_of_pitts_playground_equipment.playground_equipment

38.45 kB
445 rows
19 columns

CREATE TABLE playground_equipment (
  "n__id" BIGINT  -- Id,
  "id" BIGINT,
  "name" VARCHAR,
  "equipment_type" VARCHAR,
  "manufacturer" VARCHAR,
  "safety_surface_type" VARCHAR,
  "ada_accessible" VARCHAR,
  "street_number" DOUBLE,
  "street" 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
);