Distributed Spatial Databases

1
Distributed Spatial Databases

• The MIDCARB Carbon
• Sequestration Project

Jerry Weisenfluh Kentucky Geological Survey
Nathan Eaton Indiana Geological Survey
Jim McDonald Ohio Geological Survey
2
Overview

• MIDCARB objectives and design
• SDE design and functionality
• ArcIMS deployment

3
MIDCARB Consortium
4
MIDCARB Project Goals

• Characterize Major CO2 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.

5
MIDCARB Data Relationship Model
...
6
Spatial Database Design
ArcView
ArcIMS
RDBMS
SDE
CLIENTS
ArcMap
ArcExplorer
7
KGS Spatial Database
Basemaps
Hazards
SDE
Geology
Land Use
Infrastructure
Sequestration
8
Database Organization
9
Pre-clipped features to facilitate queries
10
Custom Geologic Map Query
Fayette County
Woodford County
11
Future SDE Work

• Application tools for querying multiple themes
• Symbol palettes derived from database
• A lot of testing for robustness

12
MIDCARB ArcIMS Deployment
www.midcarb.org
13
Spatial Database Connections
RDBMS
Data Distribution and Analysis
Illinois
GIS Integration
Web browser
Indiana
ArcIMS
Kansas
Kentucky
Ohio
14
Table of Contents Customization
15
Legend Customization
16
Metadata Access
17
Tabular Data Access
18
ColdFusion Data Pathways
RDBMS
Web browser
CF Server
Kentucky
(SQL Server)
Ohio
(SQL Server)
19
Distributed Coal Themes
20
ArcIMS - Level of Detail
KS ArcIMS
OH ArcIMS
OH SDE
IL SDE
IN SDE
KY SDE
OH SDE
21
Distributed Petroleum Fields
22
Future IMS Work

• Database views to fully integrate themes
• Pre-IMS query interface to simplify the user
  view
• ArcIMS 4.0 metadata facility

23
Summary

• ArcIMS and ArcSDE 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