City Of Pittsburgh Pools by US Government | Environmental and Climate Sciences

About this Dataset

City Of Pittsburgh Pools

City of Pittsburgh pools and spray parks.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:02.191312
Tags: diving-board, pool, spray-parks, swimming, water

Tables

City Pools

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_pools.city_pools

15.38 KB
28 rows
18 columns


CREATE TABLE city_pools (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "retired" VARCHAR,
  "water_source" VARCHAR,
  "capacity" DOUBLE,
  "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 Pools Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_pools.city_pools_data_dictionary

3.02 KB
17 rows
3 columns


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