310 likes | 451 Views
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
E N D
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 AS400(tax database)
The Path to a Solution • We extracted all addresses from our AS400(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 AS400(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 AS400(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 AS400(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 ArcGIS Desktop provided by BCS
The Solution • Implemented The Addresser Extension for ArcGIS Desktop provided by BCS • Used aerial photography to manually adjust all addresses to proper location
The Solution • Implemented The Addresser Extension for ArcGIS 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