

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.
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.
Related content




By Huo Jinsheng Mittl Alfred Reilly George Sosnowski Rick
Proceedings of the Water Environment Federation, Vol. 2006, Iss. 12, 2006-01 ,pp. :




GIS Data Modeling for Water/Wastewater Pipelines
By Garaci Mike
Proceedings of the Water Environment Federation, Vol. 2010, Iss. 8, 2010-01 ,pp. :