• Menu
    • Home
    • Online Mapping
      • Explore the Maps
      • Metadata
    • Visit the Lab
    • Order Maps & Data
      • County-Wide Digital Data
      • Digital Data by Tile
      • Featured Maps
      • Historical Maps
      • NKYmapLAB Maps
    • Key Performance Indicators
    • How Do I…
      • Become a Business Client
      • Contact LINK-GIS
      • Find Flood Zones
      • Find My City
      • Find My Polling Location
      • Use the LINK-GIS Map Viewer
      • Use the Park Finder Map Viewer
      • Locate Survey Monuments
      • Retrieve Zoning Information
    • About LINK-GIS
      • About LINK-GIS
      • Contact LINK-GIS
        • Frequently Asked Questions
        • Control Network Recovery
      • LINK-GIS History: Achievements, Articles and Awards
      • Partners
      • GIS Team
    • Awards
  • Menu
    • Home
    • Online Mapping
      • Explore the Maps
      • Metadata
    • Visit the Lab
    • Order Maps & Data
      • County-Wide Digital Data
      • Digital Data by Tile
      • Featured Maps
      • Historical Maps
      • NKYmapLAB Maps
    • Key Performance Indicators
    • How Do I…
      • Become a Business Client
      • Contact LINK-GIS
      • Find Flood Zones
      • Find My City
      • Find My Polling Location
      • Use the LINK-GIS Map Viewer
      • Use the Park Finder Map Viewer
      • Locate Survey Monuments
      • Retrieve Zoning Information
    • About LINK-GIS
      • About LINK-GIS
      • Contact LINK-GIS
        • Frequently Asked Questions
        • Control Network Recovery
      • LINK-GIS History: Achievements, Articles and Awards
      • Partners
      • GIS Team
    • Awards

Maintaining master address database is critical and frustrating work

November 22, 2017

Have you ever mistakenly received someone else’s mail or had a package delivered that wasn’t yours because your address was similar to the address on the label? Does your street name end in “Drive” while another identically-named street ends in “Road”? These are just two of many addressing situations causing problems for people every day.

Addresses are important, and therefore need to be correct, unique, and easily located. Otherwise, duplications or similarities in spelling or pronunciation can confuse even the most experienced people who deal with them every day.

In an emergency when emotions run high, the difference between “Byrd Road” and “Bird Road” can be the difference between life and death.

“Keeping address records up to date can be frustrating because there is no single, authoritative, and comprehensive list on which to base them,” said Tom East, a senior GIS specialist with PDS. “There are dozens, if not hundreds, of address lists maintained by different agencies, organizations, and companies, each with its own unique way of recording addresses.”

These different lists typically have large numbers of addresses in common, but they will also have a smaller number of addresses that are unique to their needs and purposes, which are not likely to be found in other lists.

“Trying to collect all of a community’s unique addresses in a single location is a challenging and time-consuming task,” said East. “It’s made more difficult because these address lists rarely get shared or distributed to others to use.”

PDS staff—primarily Tom East—has built and maintained a master address database for Kenton County over the past ten years. All addresses in it have been standardized to correct road misspellings, to replace incorrect suffixes (like “Rd” instead of “Dr”), and to fix transposed numbers (like “5590” instead of “5509”) along with many other issues. The database does not contain information beyond addresses.

Staff has also standardized all addresses to meet the US Postal Service’s suggested formatting guidelines. This standard doesn’t dictate what a street is named, it just recommends a standard way to write it for improving mail delivery. Millions of companies across the US use this standard every day to provide products and services to the American public.

“We’re confident enough now with the accuracy of our data that we intend to start reaching out and sharing it with those who’ll benefit from it,” said Dennis Gordon, FAICP, Executive Director of PDS. “We’ve invested a lot of work in this project and it’s time to begin seeing a return on investment… not just for PDS and its member local governments but for all of Kenton County.”

Keeping these data up to date is a critical and never-ending job that can require hours of research and field work to verify. Changes to the database occur every day according to East.

When staff finds road names that need to be corrected, based on official records likes plats or city or county ordinances, they update the information ensuring that the data is consistent, correct, and complete.

When a new address is discovered, it is verified and then added to the database. When a house or building is torn down, the address is not deleted but is marked “Retired” if the property no longer requires it. In this way, a record of previous address is maintained.

“These changes are documented literally every day at PDS,” concluded East. “We see it as a necessity for the provision of services to citizens.”

For more information on Kenton County’s master address database, email Tom East or call him at 859.331.8980.

Data Development, LINK-GIS News, Technology
Address, Database, LINK-GIS, PDS
Two staffers elected to posts at the state and national levels
NKYmapLAB product highlights Latonia ‘complete street’ proposal
  • Home
  • LINK-GIS News
  • Technology
  • Data Development
  • Maintaining master address database is critical and frustrating work

Recent Articles

  • Adjusted Operation Details for LINK-GIS
  • How You Can Vote in the Kenton County General Election-November 3, 2020
  • Adjusted Operation Details for LINK-GIS

Archives

  • November 2020
  • October 2020
  • March 2020
  • January 2020
  • March 2019
  • August 2018
  • June 2018
  • December 2017
  • November 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • October 2016
  • August 2016
  • July 2016
  • June 2016
  • March 2016
  • December 2015
  • October 2015
  • August 2015
  • February 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • May 2013
  • March 2013
  • March 2012
  • January 2012
  • December 2011
  • February 2011
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • April 2009
  • March 2009
  • October 2008
  • August 2008
  • July 2008
  • May 2008
  • April 2008
  • March 2008
  • January 2008
  • December 2007
  • October 2007
  • August 2007
  • June 2007
  • May 2007
  • April 2007
  • February 2007
  • January 2007
  • November 2006
  • October 2006
  • August 2006
  • June 2006
  • May 2006
  • April 2006
  • February 2006
  • January 2006
  • December 2005
  • September 2005
  • April 2005
  • March 2005
  • February 2005
  • October 2003

LINK-GIS Disclaimer  •  Copyright @2016  •  Planning and Development Services of Kenton County