Abstract
Spatially Extending a Regulatory Compliance Management System Using ArcGIS Engine Track: Application Development Author(s): Beth Brown, Ryan Reich, Chuang-chang Chiang, Karin Erickson, Tad Schindler This presentation describes recent efforts of the Minnesota Pollution Control Agency (MPCA) to spatially enable its existing legacy DELTA regulatory compliance and management system. The current system is based on Oracle DBMS and PowerBuilder technology. Project work involved designing and developing separate, interoperable GIS extensions to DELTA including an ArcSDE geodatabase, C## .NET ArcGIS Engine application, and a set of Oracle Stored Procedures. These new components now allow agency staff to browse and query DELTA data in a spatial format as well as edit the locational characteristics of records as part of standard data maintenance workflows. The new components also manage integrity and synchronization of data between the core DELTA nonspatial database and new GIS database. This presentation reviews final GIS component functionality, design decisions made, and lessons learned in ensuring spatial-tabular data integrity management. Beth Brown State of Minnesota Pollution Control Agency 520 Lafayette Road North Saint Paul , MN 55155 US Phone: (651) 297-8668 E-mail: beth.brown@pca.state.mn.us Ryan Reich GeoAnalytics, Inc. 1716 Fordem Avenue Madison , WI 53704 US Phone: (608) 241-7100 E-mail: rreich@geoanalytics.com Chuang-chang Chiang GeoAnalytics, Inc. 1716 Fordem Avenue Madison , WI 53704 US Phone: (608) 241-7100 E-mail: chiang@geoanalytics.com Karin Erickson State of Minnesota Pollution Control Agency 520 Lafayette Road North Saint Paul , MN 55155 US Phone: (651) 296-7280 E-mail: karin.erickson@pca.state.mn.us Tad Schindler State of Minnesota Pollution Control Agency 520 Lafayette Road North Saint Paul , MN 55155 US Phone: (651) 297-8378 E-mail: tad.schindler@pca.state.mn.us |
|||||
