Nicolet Federated Library System
  • Libraries
    • Advocacy
    • Employment Opportunities
  • Catalogs & Resources
    • Beanstack Library Reading Challenges
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About
    • NFLS Staff
  • Blog
  • Libraries
    • Advocacy
    • Employment Opportunities
  • Catalogs & Resources
    • Beanstack Library Reading Challenges
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About
    • NFLS Staff
  • Blog
Search

Cleaning Up Your Patron Database - Address Verification Tools (by Heidi at SCLS)

4/3/2017

0 Comments

 
Interested in cleaning up and verifying address information in your patron records?  Here are some free tools to help you out.
​

Free address look-up tools:
  • SmartyStreets: 250 free lookups every month.
  • Experian data quality: verify up to 500 addresses for free against the USPS database (no mention if per month or total).
  • American Factfinder Address lookup: provided by the U.S. Census Bureau, this tool has been used by LINKcat libraries for years to determine the municipality of a patron's legal place of residence.  Provides geographical, municipal and political information about the address you submit.
  • USPS provides address verification and change of address (COA) tools, many through vendors that may allow a set number of free searches and require payment after that.
    • The Zip+4 Code Lookup tool can be used to confirm street address, City and zip code information.
    • Viewing the USPS change-of-address database (NCOA) requires end-user certification and licensing.  There are multiple vendors that are certified and licensed to provide this service; the amounts charged vary according to the number of addresses submitted. 
Bulk address mapping tool:
  • BatchGeo:  up to 250 addresses mapped for free each month.  Allows you to map out a set of addresses, from Excel format, so you can look at the set and see if any of the addresses you submitted lie outside of the range you are confirming.  For example, if you have a set of addresses that are marked as being in the "Town of X", use the BatchGeo mapping software to confirm that all of the addresses lie within that town.  If not, use the American FactFinder Address lookup tool to find the correct municipality for an address.
HINT: using the USPS standardized data entry formats may expedite searching, especially when using the  U.S. Census Bureau's American FactFinder Address lookup.
USPS Publication 28 - Postal Addressing Standards
  • Appendix B - Two-Letter State and Possession Abbreviations (p. 55)
  • Appendix C - Street Abbreviations (p. 59)
  • Appendix F - Address Standardization — County, State, Local Highways (p. 79)
0 Comments



Leave a Reply.

    Author

    John's collection of tech tips, trends, and training for NFLS librarians

    Click to set custom HTML

    Archives

    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015

    RSS Feed

    Back to Tech Support
    The Tech Tank

return to homepage
Nicolet Federated Library System
1595 Allouez Avenue, Suite 4, Green Bay, WI 54311
Email: nic@nflsoffice.org
​
Phone:
 920-448-4410
​Fax: 920-448-4420
Staff Hours: Weekdays, 8:00 a.m. - 4:30 p.m.
Visitor Hours: By Appointment Only
Accessibility Statement
​​Office 365 Email Login
© Nicolet Federated Library System
  • Libraries
    • Advocacy
    • Employment Opportunities
  • Catalogs & Resources
    • Beanstack Library Reading Challenges
    • Brown County Library Catalog
    • InfoSoup Library Catalog
    • OWLSnet
    • Wisconsin's Digital Library
    • Wisconsin's Online Library: BadgerLink
  • Library Services
  • Trustees
  • NEWIL
  • About
    • NFLS Staff
  • Blog