oracle spatial sig · oracle spatial sig. customer profile • top tier gas distribution and...
TRANSCRIPT
Jennifer Kinney / Dennis BeckSpatial Business Systems, Inc.
How a Spatial Data Mart and Web Mapping Tool Can Support Leak
Survey Scheduling
Oracle Spatial SIG
Agenda
• Customer Overview• Problem Statement• Solution Overview• Demonstration
Oracle Spatial SIG
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
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
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
Leak Survey Application Architecture
• Key components:• Oracle Spatial• OC4J App Server• GeoXtension• SBS Spatial Portal
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
Interoperability Architecture
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)
Plans Forward
• Currently in deployment• More spatially enabled applications will move to
Oracle Spatial environment• Outage visualization• Leak management• Vegetation management• Spatially enabled reporting
Demonstration
Solution Architecture
SBS FMEPlugin
SmallworldGIS
OracleSpatial
GEOx Server(J2EE)
SBS SpatialPortal
(JSEXT; SVG Plugin; Browser)
SmallworldSWMFS
SmallworldClient