About this Dataset

Allegheny County Park Features

A combination of all park features, events, recreations, facilities, all in one layer, including Activenet information.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:02:37.623132
Tags: _etl, activenet, ballfield, barn, bocce, camping, court, events, facilities, field, horse, parks, picnic, pools, recreation, rink, shelters, skating-rink, soccer, sports, stage, swimming-pools, tennis, volleyball

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_park_features.table_1

78.68 kB
563 rows
49 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "objectid" BIGINT,
  "unicode" VARCHAR,
  "name" VARCHAR,
  "facility_type" VARCHAR,
  "type_code" DOUBLE,
  "center" VARCHAR,
  "center_code" VARCHAR,
  "feature_name" VARCHAR,
  "website" VARCHAR,
  "capacity" DOUBLE,
  "access_to_fire_extinguisher" VARCHAR,
  "access_to_kitchenette" VARCHAR,
  "access_to_parking_lot" VARCHAR,
  "access_to_playground" VARCHAR,
  "access_to_restrooms" VARCHAR,
  "access_to_spray_park" VARCHAR,
  "access_to_vending_machines" VARCHAR,
  "ada_accessible_facility" VARCHAR,
  "ada_accessible_playground_near" VARCHAR,
  "ada_accessible_port_a_john_near" VARCHAR,
  "ada_accessible_restroom" VARCHAR,
  "bocci_court" VARCHAR,
  "furniture_chairs" VARCHAR,
  "furniture_tables" VARCHAR,
  "indoor_air_conditioning" VARCHAR,
  "indoor_audio_system" VARCHAR,
  "indoor_heating" VARCHAR,
  "indoor_television" VARCHAR,
  "outdoor_basketball_courts_near" VARCHAR,
  "outdoor_fishing" VARCHAR,
  "outdoor_grill" VARCHAR,
  "outdoor_horseshoe_pits_near" VARCHAR,
  "outdoor_lake_view" VARCHAR,
  "outdoor_lighting" VARCHAR,
  "outdoor_swimming_pool_near" VARCHAR,
  "outdoor_volleyball" VARCHAR,
  "outdoor_water_spigot" VARCHAR,
  "outlet_data" VARCHAR,
  "outlet_power" VARCHAR,
  "outlet_telephone" VARCHAR,
  "pet_friendly" VARCHAR,
  "port_a_john_near" VARCHAR,
  "smoking_not_permitted" VARCHAR,
  "smoking_permitted" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "x2" DOUBLE,
  "y2" DOUBLE
);