About this Dataset

Allegheny County Addressing Address Points

This dataset shows the Address Points in Allegheny County. The Address Points were created by GDR for the Allegheny County CAD project, October 2008. Data is updated by County staff as changes and corrections are found, on a continuous basis. Updates are sent to PASDA monthly.

The most authoritative source for this data is now the PASDA page (https://www.pasda.psu.edu/uci/DataSummary.aspx?dataset=1219), which includes links to historical versions of the shapefile representations of this data.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-05-14T23:31:50.527906
Tags: _etl, address, allegheny-county, points

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_addres_9c1765a4.table_1

36.77 MB
648,283 rows
33 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "feature_key" BIGINT,
  "address_id" BIGINT,
  "parent_id" BIGINT,
  "street_id" BIGINT,
  "address_type" BIGINT,
  "status" VARCHAR,
  "addr_num_prefix" VARCHAR,
  "addr_num" BIGINT,
  "addr_num_suffix" VARCHAR,
  "st_premodifier" VARCHAR,
  "st_prefix" VARCHAR,
  "st_pretype" VARCHAR,
  "st_name" VARCHAR,
  "st_type" VARCHAR,
  "st_postmodifier" VARCHAR,
  "unit_type" VARCHAR,
  "unit" VARCHAR,
  "floor" VARCHAR,
  "municipality" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "comment" VARCHAR,
  "edit_date" TIMESTAMP,
  "edit_user" VARCHAR,
  "source" VARCHAR,
  "exp_flag" VARCHAR,
  "full_address" VARCHAR,
  "point_x" DOUBLE,
  "point_y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);