Abstract
 An Advanced GIS to Legacy Database Linking Application Track: Water, Wastewater, and Stormwater Author(s): Roxanne Gregorio, Chris Peluso, Andrew Hu, Rami Raad 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. Roxanne Gregorio Philadelphia Water Department GIS Aramark Center 1101 Market Street Fourth Floor Philadelphia , PA 19103 US Phone: 215-685-6333 E-mail: roxanne.gregorio@phila.gov Chris Peluso CH2M HILL Consulting 1700 Market Street Suite 1600 Philadelphia , PA 19118 US Phone: 215-563-4244 Fax: 267-675-4525 E-mail: cpeluso@ch2m.com Andrew Hu CH2M HILL GIS 13921 PARK CENTER ROAD, SUITE 600 Herndon , PA 20171 US Phone: 703-471-6405 E-mail: ahu@ch2m.com Rami Raad CH2M HILL 1700 Market Street, Suite 1600 Philadelphia , PA 19103 US Phone: 215-922-0911 E-mail: rraad@ch2m.com |
|||||
