GIS DATA CONVERSION PROCESS FOR WATER AND SEWER INFRASTRUCTURE WITH APPLICATIONS FOR LINKING LEGACY DATA

Author: Mohl Brian   Gregorio Roxanne   Raad Rami   Peluso Chris  

Publisher: Water Environment Federation

ISSN: 1938-6478

Source: Proceedings of the Water Environment Federation, Vol.2005, Iss.10, 2005-01, pp. : 5750-5772

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Previous Menu Next

Abstract

CH2M HILL, Inc. has developed an advanced ArcGIS application for the Philadelphia Water Department which links newly acquired GIS data to legacy valve, inlet, and hydrant data. The application includes a Legacy Data Conversion Toolset, a Legacy GIS Linking Toolset, and a Legacy GIS Matching Geodatabase. Legacy Data Conversion Toolset contains functions to automatically map each legacy record based on an advanced geocoding and migration algorithm. Legacy–GIS Linking Toolset automatically determines possible matches between legacy data and nearby GIS data based on complex matching rules. It also contains manual checking tools for correcting multiple matches and non-matched data records. By using the ArcGIS application, we were able to map 88 to 92 percent of legacy data records and match 74 to 86 percent of them to GIS in a very short time, thus significantly reducing the manual effort required to link the databases and increase the confidence in the matching results.