About this Dataset

City-Owned Property

All property owned by the City of Pittsburgh.

NOTE: The data feed for this dataset stopped updating in late December. We are working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:07.108918
Tags: _etl, city-property, finance, pittsburgh, properties, real-estate, treasury

Tables

City Owned Properties

@usgov.allegheny_county_city_of_pitts_city_owned_property.city_owned_properties

372.71 kB
5,167 rows
19 columns

CREATE TABLE city_owned_properties (
  "n__id" BIGINT  -- Id,
  "pin" VARCHAR,
  "address" VARCHAR,
  "block_lot" VARCHAR,
  "sale_price" DOUBLE,
  "act77_gent_date" TIMESTAMP,
  "last_payment_date" TIMESTAMP,
  "treasury_sale_date" TIMESTAMP,
  "partition_latest_sale_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "neighborhood_name" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "fire_zone" VARCHAR,
  "police_zone" DOUBLE,
  "dpw_streets" DOUBLE,
  "dpw_enviro" VARCHAR,
  "dpw_parks" VARCHAR
);