About this Dataset

City Of Pittsburgh Water Features

Water fountains, spray fountains and other assets which provide water for public use.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:42.700551
Tags: _etl, drinking, fountains, spray, water

Tables

Water Features

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_wate_54bf296d.water_features

28.32 KB
232 rows
18 columns


CREATE TABLE water_features (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "control_type" VARCHAR,
  "feature_type" VARCHAR,
  "inactive" VARCHAR,
  "make" VARCHAR,
  "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
);

Water Features Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_wate_54bf296d.water_features_data_dictionary

3 KB
17 rows
3 columns


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