the city of fargo master address file project. discovering what the heck is out there? the city of...

The City of Fargo Master The City of Fargo Master Address File Project.Address File Project.

Discovering what the heck is out there?Discovering what the heck is out there?

The City of Fargo is currently developing a The City of Fargo is currently developing a comprehensive, standardized, master comprehensive, standardized, master

address database and address management address database and address management system to serve the needs of City system to serve the needs of City

Departments, citizens and outside agencies.Departments, citizens and outside agencies.

The City of Fargo Master Address File The City of Fargo Master Address File ProjectProject

The purpose of this master address file project is to The purpose of this master address file project is to develop and designate a centralized develop and designate a centralized master master address databaseaddress database to serve as an authorized, to serve as an authorized, single-source of site addresses for use by the City single-source of site addresses for use by the City of Fargo and Cass County.of Fargo and Cass County.

This database will act as a bridge to ‘link’ together This database will act as a bridge to ‘link’ together the different (and often disparate) Departmental the different (and often disparate) Departmental specific databases to the GIS Base Map.specific databases to the GIS Base Map.

‘‘Address’ is the most common data element found Address’ is the most common data element found in local government records (databases).in local government records (databases).


Comprehensive, digital database of ALL addressesComprehensive, digital database of ALL addresses

SQL based = a spatially managed GIS databaseSQL based = a spatially managed GIS database

Maintenance toolsMaintenance tools

Cleanup toolsCleanup tools

Validation of internal and external databases Validation of internal and external databases

What is itWhat is it??


Parcel AddressesParcel Addresses

Building and Unit AddressesBuilding and Unit Addresses

Centerline Address RangesCenterline Address Ranges

Street IntersectionsStreet Intersections

Incident AddressesIncident Addresses

Vanity Names (& Aliases)Vanity Names (& Aliases)

Building NamesBuilding Names

Common Place NamesCommon Place Names

What will it containWhat will it contain??


No reliable address sourceNo reliable address source

Existing legacy databases on multiple-platformsExisting legacy databases on multiple-platforms

‘‘Free-form’ address entry fieldsFree-form’ address entry fields

Only Assessors’ data has consistent ‘link’ to the Only Assessors’ data has consistent ‘link’ to the base map because of Parcel-ID maintenancebase map because of Parcel-ID maintenance

Large amount of GIS staff time spent on cleaning Large amount of GIS staff time spent on cleaning address fields for geocoding purposesaddress fields for geocoding purposes

Current Issues and ProblemsCurrent Issues and Problems

Conceptual Design:

Accounting for one-to-one,one-to-many, many-to-many, many-to-one, active, vacant, future, and theoretical addresses.

Current Status(Nov 2004):

Contains 31,000 point records. By comparison, there are 26,000 parcels

We are currently quality checking Fire Department Inspection records – which are a great source of apartment and commercial unit addresses not found in any other City data set.

Next up Utility billing database consisting of water meter location addresses.


Implement an Address Standard that defines how all Implement an Address Standard that defines how all address records must be formattedaddress records must be formatted

Give the Address Standard some teeth!Give the Address Standard some teeth!

Begin cleaning Departmental databases to adhere to Begin cleaning Departmental databases to adhere to the Address Standardthe Address Standard

We started with the Assessors’ property address We started with the Assessors’ property address database – began geocoding other databases to the database – began geocoding other databases to the Assessors’ databaseAssessors’ database

Investigate the records that do not match to see if they Investigate the records that do not match to see if they are legitimate addresses or areare legitimate addresses or are incorrectly formatted incorrectly formatted

What steps are involved to build this database?What steps are involved to build this database?


Place all legitimate addresses and continue Place all legitimate addresses and continue adding them to the collection in the master file adding them to the collection in the master file databasedatabase

Clean-up tools should be ready to goClean-up tools should be ready to go

Validation tools should be ready to goValidation tools should be ready to go

Maintenance tools should be ready to goMaintenance tools should be ready to go

Lots and lots of patience! This is going to take a Lots and lots of patience! This is going to take a long time and it is a very slow processlong time and it is a very slow process

What steps are involved to build this database?What steps are involved to build this database?


Different ‘types’ of addresses:Different ‘types’ of addresses:

MailingMailing PremisePremiseLegalLegal PropertyPropertyOwnerOwner OccupantOccupantBillingBilling BusinessBusinessBuildingBuilding StructureStructureUnitUnit SuiteSuiteUtility AccessUtility Access VanityVanityCoordinateCoordinate VacantVacant


Extremely Important StepExtremely Important Step!!

Creation of an Creation of an Address StandardAddress Standard for for the City of Fargo.the City of Fargo.

Formal adoption by the City Formal adoption by the City Commission in July 2004.Commission in July 2004.

Available on the Assessors’ Available on the Assessors’ website:website:http://www.cityoffargo.com/Assessors/default.htmhttp://www.cityoffargo.com/Assessors/default.htm

Highlights of Document:Highlights of Document:Includes official comprehensive list of all Includes official comprehensive list of all named roads and their correct formatting.named roads and their correct formatting.Examples of how to address cul-de-sacs, Examples of how to address cul-de-sacs, blisters, and looped or circular roads.blisters, and looped or circular roads.New streets and avenues will be ‘numbered’ New streets and avenues will be ‘numbered’ in proper ascending order.in proper ascending order.Named roads will only be allowed to avoid Named roads will only be allowed to avoid 1/2 numbering of streets or avenues.1/2 numbering of streets or avenues.


An additional benefit of the Address Standard will be the An additional benefit of the Address Standard will be the implementation of a process that will outline the City implementation of a process that will outline the City policies to be followed during the assignment of new policies to be followed during the assignment of new addresses and\or changes to existing addressesaddresses and\or changes to existing addresses

With due concern to public safety and liability, there With due concern to public safety and liability, there needs to be a clear process in place for all addressing needs to be a clear process in place for all addressing issues within the Cityissues within the City

Creation of an Creation of an Address Standards CommitteeAddress Standards Committee to to approve all new addresses and deal with change issues. approve all new addresses and deal with change issues. The Committee is comprised of staff from the Assessors’, The Committee is comprised of staff from the Assessors’, GIS, Planning, Fire and Police DepartmentsGIS, Planning, Fire and Police Departments

The City of Fargo Master Address File Project.The City of Fargo Master Address File Project.

Water Main Break DatabaseWater Main Break Database(Translated…)(Translated…)

Additional Address Examples from Additional Address Examples from Departmental DatabasesDepartmental Databases

Other Problems:

•Non-address data stored in Address fields

•Inconsistent formatting on names, directional, and street types

•House numbers out of range

•Mailing addresses included in the site address fields

•Unit and Suite level addresses not maintained in parsed fields

•½ house numbers & ½ street names


Database Clean-up Tools:

Before running program to draw geocoded lines to street centerline shapefile


Database Clean-up Tools:

After running program to draw geocoded lines to street centerline shapefile


Database Clean-up and QA ToolsDatabase Clean-up and QA ToolsDrawing lines from Address Points to appropriate place along the Street Drawing lines from Address Points to appropriate place along the Street

Centerline shapefile – Good Address Range Example:Centerline shapefile – Good Address Range Example:


Database Clean-up and QA ToolsDatabase Clean-up and QA ToolsVisual QA Checks – geocoding line crosses street CL segment. Incorrect Visual QA Checks – geocoding line crosses street CL segment. Incorrect

Street Type on several address records.Street Type on several address records.


PlanningDept

Database

BuildingPermits

Police DeptIncidents &Complaints

AssessorsDept

ParcelInfo

UtilityBilling

Database

Fire DeptInspections

MasterAddress

Database

The goal is to ‘clean’ all current Departmental address The goal is to ‘clean’ all current Departmental address databases to adhere to the Address Standard. Once completed, databases to adhere to the Address Standard. Once completed,

this will enable City and County staff the ability to view all this will enable City and County staff the ability to view all information pertaining to a property or location through the information pertaining to a property or location through the

City\County desktop GIS application.City\County desktop GIS application.

Base Map


In 2005, Fargo and Cass County will migrate our GIS In 2005, Fargo and Cass County will migrate our GIS data into the geodatabase and begin maintaining it in data into the geodatabase and begin maintaining it in that environment on a new SQL \ ArcSDE server.that environment on a new SQL \ ArcSDE server.

The Master Address Database will be the main link for The Master Address Database will be the main link for all City and County data sets in this new system. An all City and County data sets in this new system. An address link is ideal, because:address link is ideal, because:

* Parcel-ID maintenance is too cumbersome.* Parcel-ID maintenance is too cumbersome.

* An address is a unique identifier, right?* An address is a unique identifier, right?

* Address is the most important – if not critical – * Address is the most important – if not critical – component of local government data. component of local government data.


Data Model Example for Calgary, Alberta CanadaData Model Example for Calgary, Alberta Canada( From http://support.esri.com - Address Data Model section )( From http://support.esri.com - Address Data Model section )


Future Goals ( the “wish list” )Future Goals ( the “wish list” )Streamlined custom maintenance tools for GIS staffStreamlined custom maintenance tools for GIS staff

Validation at point of user entryValidation at point of user entry

True ‘Enterprise Address Management’ cross-True ‘Enterprise Address Management’ cross-jurisdictionallyjurisdictionally

Full time position – Address CoordinatorFull time position – Address Coordinator

Data Mining – Revenue Source Auditing, $$$,….. Data Mining – Revenue Source Auditing, $$$,….. maybe next year’s presentation ???maybe next year’s presentation ???


Questions?Questions?

Brad AndersonBrad AndersonGIS CoordinatorGIS Coordinator

City of FargoCity of Fargo

[email protected]@ci.fargo.nd.us

701-476-6796701-476-6796

Thank YouThank You

the city of fargo master address file project. discovering what the heck is out there? the city of...

Documents

address records

address standard

cleaning address fields

address management system

assessors database

legitimate addresses

site addresses

addresses sql