united states address fabric v2019.12.3 release...
TRANSCRIPT
United States Address FabricVersion 2019.12.3
Release Notes
Contents:
What's New 2Issues Fixed 2Known Issues 2Product Metrics 5Future Release Updates 8Product Support 9
What's New
We have upgraded the address content based on the October Master Location Data (MLD) geocodinglibraries. As a result of sourcing changes released in the 2019.04.3 version, there will be coordinatemove differences for ~12% of the dataset, compared to MLD. Please see Product Metrics for moredetails. Please utilize the Change Log File (<x_ChangeLog.txt>) to detect transactional recordupdates from the previous version.
• Total record count is over 180M• Coordinate moves for ~ 21.5M records
Issues Fixed
• PBAB-353/PBAB-361 (DGEM-1353): Every secondary address now has a parent pbKey.
Known Issues
The following known issues exist in the product and are under investigation.
• PBAB-352: There are about 42K addresses duplicates in the product where the address andlocation components are same except for the city and zipcode. Example shown below:
Record 2 ValueRecord 1 ValueField
P0000OEK2M7PP0000OELV50RPBKEY
316316ADD_NUMBER
ORCHARD DRORCHARD DRSTREETNAME
UNIT_DES
UNIT_NUM
2United States Address Fabric 2019.12.3 Release Notes
Release Notes
Record 2 ValueRecord 1 ValueField
EASTSOUNDFRIDAY HARBORCITY
WAWASTATE
9824598250ZIPCODE
P02P02TYPE
530559601001001530559601001001FIPS
48.613848.6138LATITUDE
-123.02-123.02LONGITUDE
PARENT
XXPROP_TYPE
• PBAB-354 (DGEM-1362): There are 38K secondary addresses that are tagged to the same parentrecord but have a different city or zipcode. Example shown below:
Record 2 ValueRecord 1 ValueColumn Name
P0000GLCXZE7P0000GLDJ8QBPBKEY
31043104ADD_NUMBER
MAIN STMAIN STSTREETNAME
#UNIT_DES
NYSUNIT_NUM
DELEVANYORKSHIRECITY
NYNYSTATE
1404214173ZIPCODE
3United States Address Fabric 2019.12.3 Release Notes
Release Notes
Record 2 ValueRecord 1 ValueColumn Name
P02P02TYPE
360099602001000360099602001000FIPS
42.53065442.530654LATITUDE
-78.470091-78.470091LONGITUDE
P0000GLCXZE7PARENT
XXPROP_TYPE
• PBAB-398: There are about 2.3K records for which the UNIT_DES is not available.• PBAB-412: There are about 498K coordinate moves greater than 1000m, compared to the MasterLocation Referential Geocoding Dataset. These are under investigation.
Note: Please report any support issues to [email protected].
4United States Address Fabric 2019.12.3 Release Notes
Release Notes
Product Metrics
Table 1: Counts Table
2019.12.3State AbbreviationsState
2,978,388ALALABAMA
370,223AKALASKA
3,832,945AZARIZONA
1,921,711ARARKANSAS
17,204,906CACALIFORNIA
3,179,958COCOLORADO
1,907,536CTCONNECTICUT
569,590DEDELAWARE
424,144DCDISTRICT OF COLUMBIA
13,510,704FLFLORIDA
5,668,068GAGEORGIA
795,490HIHAWAII
933,216IDIDAHO
7,277,894ILILLINOIS
3,943,018ININDIANA
1,831,193IAIOWA
5United States Address Fabric 2019.12.3 Release Notes
Release Notes
2019.12.3State AbbreviationsState
1,665,421KSKANSAS
2,534,679KYKENTUCKY
2,667,161LALOUISIANA
906,675MEMAINE
3,127,165MDMARYLAND
3,848,680MAMASSACHUSETTS
6,036,747MIMICHIGAN
3,034,690MNMINNESOTA
1,722,102MSMISSISSIPPI
3,547,814MOMISSOURI
701,052MTMONTANA
1,057,590NENEBRASKA
1,504,132NVNEVADA
783,139NHNEW HAMPSHIRE
4,986,016NJNEW JERSEY
1,181,904NMNEW MEXICO
10,522,640NYNEW YORK
6,327,380NCNORTH CAROLINA
456,196NDNORTH DAKOTA
6,818,425OHOHIO
6United States Address Fabric 2019.12.3 Release Notes
Release Notes
2019.12.3State AbbreviationsState
2,172,404OKOKLAHOMA
2,211,953OROREGON
7,404,574PAPENNSYLVANIA
322,261PRPUERTO RICO
613,038RIRHODE ISLAND
3,170,870SCSOUTH CAROLINA
475,573SDSOUTH DAKOTA
3,962,752TNTENNESSEE
14,533,446TXTEXAS
1,476,636UTUTAH
466,732VTVERMONT
1,723VIVIRGIN ISLANDS
4,533,188VAVIRGINIA
4,117,031WAWASHINGTON
1,204,536WVWEST VIRGINIA
3,590,559WIWISCONSIN
349,718WYWYOMING
180,385,586Total
Note: For more details on product metrics refer to the product metrics sheet bundled inUS_AddressFabric_YYYYMM.zip, where YYYYMM represents the year and month ofrelease.
7United States Address Fabric 2019.12.3 Release Notes
Release Notes
Future Release Updates
Please note the following changes will be made in upcoming release which may affect our data loadscripts.
• 2020.03.0 - Change FIPS field name to Geo_ID• 2020.06.0 - Add new field for Zip+4
8United States Address Fabric 2019.12.3 Release Notes
Release Notes
Product Support
If you have any questions or concerns, you may contact our support or fulfillment team directly byphone or email:
Software Support
Call: 1.800.367.6950
Email - [email protected] - [email protected] for issues related to order fulfillment
Technical Support
• Visit: https://www.pitneybowes.com/us/support.html
Customer Feedback
• Please use the following link to submit customer feedback about the product:https://ideas.pitneybowes.com/?project=ADF
Knowledge Communities
• Please use the following link to connect to the Data Community:https://community.pitneybowes.com
Global Contact
For global contacts information on different software solution products kindly visit the link sharedbelow:
https://www.pitneybowes.com/us/contact-dcs.html
9United States Address Fabric 2019.12.3 Release Notes
Release Notes
3001 Summer Street
Stamford CT 06926-0700
USA
www.pitneybowes.com
© 2019 Pitney Bowes Software Inc.
All rights reserved