Operation Green Spaces by US Government | Demographics and Population Studies

About this Dataset

Operation Green Spaces

Inventory of City of Pittsburgh green spaces, maintained by the Operations Division in the Department of Public Works.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:12:44.082377
Tags: department-of-public-works, dpw, green, green-space, operations, public-works, spaces

Tables

Green Spaces 2015

@usgov.allegheny_county_city_of_pitts_operation_green_spaces.green_spaces_2015

32.55 KB
35 rows
45 columns


CREATE TABLE green_spaces_2015 (
  "responsibility_parks_or_operations" VARCHAR,
  "facility" VARCHAR,
  "division" DOUBLE,
  "total_acreage" DOUBLE,
  "maintainable_acreage" VARCHAR,
  "shelter" VARCHAR,
  "rec_center" DOUBLE,
  "senior_center" DOUBLE,
  "pool" VARCHAR,
  "spray_pool" VARCHAR,
  "play_area" DOUBLE,
  "tennis_court_with_lights" DOUBLE,
  "tennis_court_without_no_lights" DOUBLE,
  "basketball_full_court_with_lights" DOUBLE,
  "basketball_full_court_without_lights" DOUBLE,
  "basketball_half_court_with_lights" DOUBLE,
  "basketball_half_court_without_lights" DOUBLE,
  "basketball_standards" DOUBLE,
  "multi_purpose_court" VARCHAR,
  "funnel_ball" DOUBLE,
  "baseball_field_with_lights" DOUBLE,
  "baseball_field_without_lights" DOUBLE,
  "volleball_court" DOUBLE,
  "boccie_court" DOUBLE,
  "hockey_court" DOUBLE,
  "horseshoe" DOUBLE,
  "drinking_fount" DOUBLE,
  "neighborhood" VARCHAR,
  "census_tract" DOUBLE,
  "bleachers" DOUBLE,
  "council_dist" DOUBLE,
  "cd_area" VARCHAR,
  "grill" DOUBLE,
  "decorative_foutain" VARCHAR,
  "flag_pole" DOUBLE,
  "grandstand" VARCHAR,
  "control_link_for_basketball_courts" VARCHAR,
  "control_link_for_tennis_court" VARCHAR,
  "control_linkl_for_hockey_court" VARCHAR,
  "dek_hockey_court" VARCHAR,
  "dog_park" VARCHAR,
  "spray_park" VARCHAR,
  "ownership_of_facility" VARCHAR,
  "benches" DOUBLE,
  "tables" DOUBLE
);