City Of Pittsburgh Facilities by US Government | Demographics and Population Studies

About this Dataset

City Of Pittsburgh Facilities

City Facility data pulled from the Operations Management System for the Department of Public Works
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:08.736823
Tags: _etl, cabin, community-center, dugout, facilities, parks, police, police-station, pools, rec-center, recreation-centers, salt-dome, shelter, storage

Tables

City Facilities

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_facilities.city_facilities

50.32 KB
412 rows
22 columns


CREATE TABLE city_facilities (
  "n__id" BIGINT,
  "id" BIGINT,
  "parcel_id" VARCHAR,
  "inactive" VARCHAR,
  "name" VARCHAR,
  "rentable" VARCHAR,
  "type" VARCHAR,
  "primary_user" VARCHAR,
  "address_number" VARCHAR,
  "street" VARCHAR,
  "zip" DOUBLE,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "ward" DOUBLE,
  "tract" BIGINT,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

City Facilities Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_facilities.city_facilities_data_dictionary

3.07 KB
21 rows
3 columns


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