What This Source Covers
Master county address point inventory used for address search, place-level counts, and the raw point layer in the public explorer.
This is the anchor dataset for the place explorer. It drives address search, visible-point counts, and most place-level address summaries.
Why Someone Would Open This Page
This source appears on 219 of the 219 mapped place pages in the Allegheny County section, including 129 borough and township pages and 90 Pittsburgh neighborhood pages. That gives a quick sense of how broadly the layer is used across the county.
The example below is here to make the source concrete. Instead of talking about the layer in the abstract, the page shows what it actually looks like on the map.
Example Map
This page uses 001 – Address Points in Arlington Heights as the example area. Dense sources use a full selected place; lighter sources use the full sample area.
Live Example Map
Address Points
Arlington Heights / Addressing / point sample
Full neighborhood sample.
Quick Facts
| Fact | Current value |
|---|---|
| Rows in the source | 653,615 |
| Main data fields | 33 |
| Total fields | 35 |
| Source system | WPRDC CKAN package allegheny-county-addressing-address-points2 |
| Map geometry | PASDA layer 32 |
| Mapped place pages using this source | 219 / 219 (100.0%) |
| Example area used here | Arlington Heights |
| Features drawn in this example | 186 |
Where You Will See It
| Place type | Coverage |
|---|---|
| All mapped place pages in the county section | 219 |
| Pages using this source | 219 (100.0%) |
| Borough and township pages | 129 / 129 |
| Pittsburgh neighborhood pages | 90 / 90 |
| Pages where the source is hidden | 0 |
For Technical Readers
- Source table:
[WPRDC PASDA].[001 - AddressPoints] - Refresh procedure:
[WPRDC PASDA].[001 - Address points update] - Documentation map table:
[Allegheny].[WPRDC PASDA MAPS].[Documentation Map - 001 - Address Points] - Metadata timestamp: 2026-03-16T17:09:07.925Z
Field List
The table below lists the current columns in [WPRDC PASDA].[001 - AddressPoints].
| # | Field | SQL type | Nullable | Role |
|---|---|---|---|---|
| 1 | _id |
int |
Yes | Attribute |
| 2 | feature_key |
nvarchar(4000) |
Yes | Attribute |
| 3 | address_id |
nvarchar(4000) |
Yes | Attribute |
| 4 | parent_id |
nvarchar(4000) |
Yes | Attribute |
| 5 | street_id |
nvarchar(4000) |
Yes | Attribute |
| 6 | address_type |
nvarchar(4000) |
Yes | Attribute |
| 7 | status |
nvarchar(4000) |
Yes | Attribute |
| 8 | addr_num_prefix |
nvarchar(4000) |
Yes | Attribute |
| 9 | addr_num |
nvarchar(4000) |
Yes | Attribute |
| 10 | addr_num_suffix |
nvarchar(4000) |
Yes | Attribute |
| 11 | st_premodifier |
nvarchar(4000) |
Yes | Attribute |
| 12 | st_prefix |
nvarchar(4000) |
Yes | Attribute |
| 13 | st_pretype |
nvarchar(4000) |
Yes | Attribute |
| 14 | st_name |
nvarchar(4000) |
Yes | Attribute |
| 15 | st_type |
nvarchar(4000) |
Yes | Attribute |
| 16 | st_postmodifier |
nvarchar(4000) |
Yes | Attribute |
| 17 | unit_type |
nvarchar(4000) |
Yes | Attribute |
| 18 | unit |
nvarchar(4000) |
Yes | Attribute |
| 19 | floor |
nvarchar(4000) |
Yes | Attribute |
| 20 | municipality |
nvarchar(4000) |
Yes | Attribute |
| 21 | county |
nvarchar(4000) |
Yes | Attribute |
| 22 | state |
nvarchar(4000) |
Yes | Attribute |
| 23 | zip_code |
nvarchar(4000) |
Yes | Attribute |
| 24 | comment |
nvarchar(4000) |
Yes | Attribute |
| 25 | edit_date |
nvarchar(4000) |
Yes | Attribute |
| 26 | edit_user |
nvarchar(4000) |
Yes | Attribute |
| 27 | source |
nvarchar(4000) |
Yes | Attribute |
| 28 | exp_flag |
nvarchar(4000) |
Yes | Attribute |
| 29 | full_address |
nvarchar(4000) |
Yes | Attribute |
| 30 | point_x |
nvarchar(4000) |
Yes | Attribute |
| 31 | point_y |
nvarchar(4000) |
Yes | Attribute |
| 32 | latitude |
nvarchar(4000) |
Yes | Attribute |
| 33 | longitude |
nvarchar(4000) |
Yes | Attribute |
| 34 | geometry_type |
nvarchar(200) |
Yes | Geometry storage |
| 35 | geometry_json |
nvarchar(max) |
Yes | Geometry storage |