Abstract

Infrastructure Integration: All You Need is a Key
Track: State and Local Government
Authors: Robert Parsons

The City of Columbus completed a system upgrade of our GIS infrastructure in 2012. One of the main challenges was ensuring that applications that rely on GIS data would still function with a minimum impact. ESRI Technology gave us the key solution with the ability integrate and interchange datatypes for the various needs of different departments. The Multi-Geodatabase functionality on the Oracle RDBMS keeps the transactional data for each department separate and easier to manage for our DBA's. ArcGIS replication gave us the ability to refresh our read-only repository much more frequently than we were able to in the past. From ST_ GEOMETRY to SDO_GEOMETRY, from PLSQL to Python we have succeeded in solving the problem of integrating our systems and keeping the data up to date. This would be useful for anyone who is contemplating a system upgrade and are hesitant because of disparate application requirements.