Distributed Spatial Databases The MIDCARB Carbon Sequestration Project
Distributed Spatial Databases The MIDCARB Carbon Sequestration Project Nathan Eaton Indiana Geological Survey Jerry Weisenfluh Kentucky Geological Survey Jim Mc. Donald Ohio Geological Survey
Overview • MIDCARB objectives and design • SDE design and functionality • Arc. IMS deployment
MIDCARB Consortium
MIDCARB Project Goals • Characterize Major CO 2 Sources – Quantity, Quality, Location • Characterize Potential Sequestration Sites – Geology and Reservoir Characteristics • Develop Relational/Spatial Databases – Local and Regional Reporting Levels • Supply this data to the public – For use as tools in cost/feasibility analyses, etc.
MIDCARB Data Relationship Model Internet (html browser accessible) Query & Reporting Applications (Arc. IMS, SDE, & Java) . . .
Spatial Database Design Arc. IMS RDBMS SDE Arc. Map Arc. Explorer CLIENTS Arc. View
KGS Spatial Database Basemaps Hazards SDE Geology Land Use Coal Data Petroleum Data Infrastructure Water Data Sequestration
Database Organization
Pre-clipped features to facilitate queries
Custom Geologic Map Query Woodford County Fayette County
Future SDE Work • Application tools for querying multiple themes • Symbol palettes derived from database • A lot of testing for robustness
MIDCARB Arc. IMS Deployment www. midcarb. org
Spatial Database Connections Kentucky SDE Ohio SDE Kansas SDE Indiana SDE Illinois SDE RDBMS GIS Integration Arc. IMS Data Distribution and Analysis Web browser
Table of Contents Customization
Legend Customization GIF-based legends
Metadata Access
Tabular Data Access
Indiana (SQL Server) Cold. Fusion Request Kansas SDE Kentucky SDE CF Server (Oracle) (SQL Server) Ohio (SQL Server) SDE Return Results Query RDBMS (Oracle) SDE RDBMS Illinois SDE Cold. Fusion Data Pathways Cold. Fusion Report Arc. IMS Web browser
Distributed Coal Themes
Arc. IMS - Level of Detail KS Arc. IMS OH Arc. IMS IL SDE IN SDE KY SDE OH SDE
Distributed Petroleum Fields Illinois Indiana
Future IMS Work • Database views to fully integrate themes • Pre-IMS query interface to simplify the user view • Arc. IMS 4. 0 metadata facility
Summary • Arc. IMS and Arc. SDE appear to be a robust environment for distributed data • SDE promises interesting opportunities for institutional data sharing (outside of IMS) • Challenge for sharing large and complex databases is design as much as technology
- Slides: 23