SUMTER COUNTY An Addressing Success Story Our Addressing

SUMTER COUNTY An Addressing Success Story

Our Addressing History �Quick History

The Problem �We would no longer be updating hard copy maps �We used the hard copy maps to assign addresses �We didn’t have an address layer in GIS to edit �Even if we did, we didn’t know how to manage the addressing process

The Path to a Solution �We extracted all addresses from our AS 400(tax database)

The Path to a Solution �We extracted all addresses from our AS 400(tax database) �Asked for ideas at a Pee Dee Users Group meeting �Consulted with Bradshaw Consulting Services, Inc. (BCS)

The Path to a Solution �We extracted all addresses from our AS 400(tax database) �Asked for ideas at a Pee Dee Users Group meeting �Consulted with BCS �Geocoded addresses from excel file

The Path to a Solution �We extracted all addresses from our AS 400(tax database) �Asked for ideas at a Pee Dee Users Group meeting �Consulted with BCS �Geocoded addresses from excel file �Moved addresses with a corresponding parcel number to the center of the parcel

The Path to a Solution �We extracted all addresses from our AS 400(tax database) �Asked for ideas at a Pee Dee Users Group meeting �Consulted with BCS �Geocoded addresses from excel file �Moved addresses with a corresponding parcel number to the center of the parcel �Went through the unmatched addresses from the Geocode and corrected any errors in centerlines

The Solution �Implemented The Addresser Extension for Arc. GIS Desktop provided by BCS

The Solution �Implemented The Addresser Extension for Arc. GIS Desktop provided by BCS �Used aerial photography to manually adjust all addresses to proper location

The Solution �Implemented The Addresser Extension for Arc. GIS Desktop provided by BCS �Used aerial photography to manually adjust all addresses to proper location �Coded addresses based on options in The Addresser

The Results �Very accurate single addresses and centerlines

The Results �Very accurate single addresses and centerlines �Built in checks when adding new addresses and streets

The Results �Very accurate single addresses and centerlines �Built in checks when adding new addresses and streets �Error checks to continue quality control

The Results �Very accurate single addresses and centerlines �Built in checks when adding new addresses and streets �Error checks to continue quality control �Data with proven accuracy

My Favorite Tools �Address Locator

My Favorite Tools �Address Locator �Import Allowance

My Favorite Tools �Address Locator �Import Allowance �Mass Name Change

DEMO �By Scott Davis of BCS

Basic Business Rules �Location �Duplicate �Zero �Out of range �Odd/Even mismatch �Range �Zero �Overlap