About this Dataset

City Of Pittsburgh Public Art

Public art projects in the City of Pittsburgh, including type of art, artist's name, and location.

NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:34.561657
Tags: _etl, artist, city-of-pittsburgh, memorial, monument, public-art

Tables

City Of Pittsburgh Public Art

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_public_art.city_of_pittsburgh_public_art

29.13 kB
199 rows
18 columns

CREATE TABLE city_of_pittsburgh_public_art (
  "n__id" BIGINT  -- Id,
  "id" BIGINT,
  "name" VARCHAR,
  "title" VARCHAR,
  "artist_name" VARCHAR,
  "art_type" VARCHAR,
  "park" VARCHAR,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "tract" DOUBLE,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);