About this Dataset

Allegheny County Addressing Landmarks

This dataset shows the address points in Allegheny County.

Usage

The value in the ADDRESS_ID field lets you look up more information about the landmark locations in the Addressing Address Points dataset (https://data.wprdc.org/dataset/allegheny-county-addressing-address-points2), including the geocoordinates (though they are in the State Plane coordinate system, in that table's point_x and point_y fields).

Limitations

Since the CSV file currently does not provide geocoordinates, we can't generate a GeoJSON file from it; until we do, the GeoJSON link will remain as a broken placeholder.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-04-15T15:43:27.596980
Tags: _etl, address, allegheny-county, landmarks, points

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_addres_4ecb8b41.table_1

2.85 MB
40,432 rows
8 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "objectid" BIGINT,
  "address_id" DOUBLE,
  "landmark" VARCHAR,
  "globalid" VARCHAR,
  "class" BIGINT,
  "type" VARCHAR,
  "pub" VARCHAR
);