![Page 1: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/1.jpg)
Jennifer Kinney / Dennis BeckSpatial Business Systems, Inc.
How a Spatial Data Mart and Web Mapping Tool Can Support Leak
Survey Scheduling
Oracle Spatial SIG
![Page 2: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/2.jpg)
Agenda
• Customer Overview• Problem Statement• Solution Overview• Demonstration
Oracle Spatial SIG
![Page 3: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/3.jpg)
Customer Profile
• Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana
• Have an established Smallworld GIS from GE Energy• Network documentation• Engineering design• Asset management integration• Engineering analysis• Traditional mapping applications
![Page 4: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/4.jpg)
Problem Statement
• Centralized mapping department backlogged• Self service approach to disseminating spatial information is key
to gaining efficiencies and keeping data current• Traditional GIS not tuned to support business applications
• Advanced functions inhibit ease-of-use (the “Google Effect”)• Limited functional requirements necessary• Cost of deployment prohibitive for lower-end applications• Requires custom integration with Asset Management to support
leak survey mapping
![Page 5: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/5.jpg)
Leak Survey Application: Key Business Requirements
• Timely, accurate leak survey maps are required to:• Support mandated inspection requirements• Plan inspections with other pending work in the same area
• Mobile data necessary in the form of “Smart PDFs”• Supports limited hardware footprint• Ease-of-use
• Self-service oriented• Some flexibility• Ease of use
![Page 6: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/6.jpg)
Leak Survey Application Architecture
• Key components:• Oracle Spatial• OC4J App Server• GeoXtension• SBS Spatial Portal
![Page 7: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/7.jpg)
Why Oracle and a Spatial Portal?
• Platform for spatially enabled business applications• Alignment with corporate IT strategy• Low cost of deployment• Application maintainability• Critical performance requirements as system grows
![Page 8: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/8.jpg)
Interoperability Architecture
![Page 9: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/9.jpg)
Why Interoperability?
• Allows existing GIS investment to remain in place• Enables platform for spatially enabled business
applications• Eliminates need for costly migration• Reduces dependence on specialized development
tools and databases• Built using industry standard ETL tools ( Safe
Software’s FME product)
![Page 10: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/10.jpg)
Plans Forward
• Currently in deployment• More spatially enabled applications will move to
Oracle Spatial environment• Outage visualization• Leak management• Vegetation management• Spatially enabled reporting
![Page 11: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/11.jpg)
Demonstration
![Page 13: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/13.jpg)
![Page 14: Oracle Spatial SIG · Oracle Spatial SIG. Customer Profile • Top tier gas distribution and pipeline company, serving 1.1 million customers in Ohio and Indiana • Have an established](https://reader030.vdocuments.us/reader030/viewer/2022041201/5d49421888c9935f218bd66b/html5/thumbnails/14.jpg)
Solution Architecture
SBS FMEPlugin
SmallworldGIS
OracleSpatial
GEOx Server(J2EE)
SBS SpatialPortal
(JSEXT; SVG Plugin; Browser)
SmallworldSWMFS
SmallworldClient