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