SAG 2008 Winners

USDOI Office of Surface Mining Reclamation and Enforcement and West Virginia Department of Environmental Protection

View Photo(s) of Award Presentation

Project Goal

The US Office of Surface Mining (OSM) regulates surface coal mines throughout the United States. Much of this regulation is performed by states in cooperative arrangements with OSM. Because OSM and these state agencies do their work in different ways, there is not a central repository for coalmine permit boundaries for the United States. OSM, in conjunction with the states of Virginia and West Virginia, conducted a prototype project to collect coalmine permit boundary information. The concept of the prototype was to create one-way replicas of the state geodatabases in an OSM geodatabase. The Data Interoperability Extension was then used to perform an extract, transform and Load (ETL) operation on those data as well as internal data from different OSM locations. The Data Interoperability Extension allowed OSM to transform each of these desperate data sources to have the proper attributes, re-project each source into a common projection, and merge the data into a common output.
Learn more about us

Business Problem Solved

Coalmine permit information resides in states and
no central repository of coalmine permit information exists. There is a need for a centralized geodatabase of permit boundaries and other coalmine information. This prototype moves OSM in this direction.

Technology Implemented

The following ESRI products were used:
- ArcSDE 9.2
- ArcGIS Server 9.2
- ArcGIS Desktop 9.2 (ArcInfo License)
- Data Interoperability Extention 9.2
- MicroSoft IIS 6.0
- MicroSoft Server 2003
- MicroSoft SQL Server 2000 & 2005

Development Team Biography

State of Virginia – Department of Mines, Minerals and Energy:
Daniel Kestner
Steve Mullins
David Sanders
Vic Palmer
Todd Richardson

State of West Virginia – West Virginia Department of Environmental Protection:
Larry Evans
Mike Shank
Sarah Clapham

Office of Surface Mining Prototype Team
Denver:
Greg Morlock
Alan Wilhelm
Janine Ferarese

OSM Knoxville:
Bill Card
Daniel Lewis

OSM St. Louis:
Kwang Kim

OSM Pittsburgh:
Arielle Avishai