Nicolet Federated Library System
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • About
    • NFLS Staff
  • Blog
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • 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
Home
Libraries
Employment Opportunities

​Online Resources
Beanstack library reading challenges
Wisconsin's Public Library Consortium digital library

Wisconsin's online resources: BadgerLink
Brown County Library online catalog
InfoSoup libraries online catalog
Vertical Divider
Library Services
Continuing education​​
​Cricut maker
Digitization kits
Ellison dies
​Grants
​Helpful sites & abbreviations
​​Homework hotspot labs​​
​Inclusive Services resources
​​Interlibrary Loan & Delivery

Vertical Divider
Intertype library services
​​Librarians' advisory committee meetings
​​Marketing resources
NFLS newsletters
OWLSnet
​
​Programming & resources (blog)
​​Tech support
​​Travel & expenses

Workforce Development resources
Youth Services resources
Vertical Divider
​Trustees
Board members
Board meetings
Trustee resources
Meetings archive

About
About NFLS
​NFLS staff

Blog
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
  • Home
  • Libraries
    • Employment Opportunities
  • Online Resources
    • Beanstack Library Reading Challenges
    • Digital Libraries
      • Wisconsin's Digital Library
      • Wisconsin's Online Library: BadgerLink
        • BadgerLink Resource Guide for Public Libraries
    • Library Catalogs
      • InfoSoup Library Catalog
      • Brown County Library Catalog
    • Wisconsin State Documents
      • Wisconsin Digital Archives
      • Wisconsin Legislative Reference Bureau Digital Collections
      • Wisconsin State Government Web Archives
  • Library Services
    • Inclusive Services
    • Youth Services
  • Trustees
  • About
    • NFLS Staff
  • Blog