# Presentation: 262537

## Accessing / Sharing InformationGIS Database ContentandData Delivery

**Notes:**
The advent of coal mining in Ohio is unknown.  However, the first reported production of coal mining was in 1800.
It was not until 1874 that an accurate map of underground mining was required to be prepared and filed with the State. Annual updates to these maps were required and were to be filed with the Office of the State Inspector of Mines --- later incorporated into the Ohio Department of Industrial Relations, Division of Mines.
Maps placed in the abandoned-mine file were used by the ODGS as the principal source of information to begin development of a database on Ohio’s AUMs. 

The ODGS first embarked on the mapping of abandoned-underground mines in 1968 with the mapping of mine polygons on planimetric maps (scale: 1:62,500). 

## DATA SHEETSTO DATABASES

**DATA SHEETS****TO ****DATABASES**

**Notes:**
Data sheets, providing information such as: location (county, township, section or lot, and quadrangle), name of mine (mine ID), operating company, seam identification and elevation, commodity (e.g. coal, clay, shale, salt, or limestone), type of mine (drift, slope, or shaft), and year of abandonment, supplemented the Abandoned-Underground-Mine Map Series; consequently listing all known pertinent information for each mine.  In addition, each mine plotted on the 71/2-minute quadrangle was referenced to a data sheet by a county abbreviation-numeric designation.  

## Original AUM Feature Class Attribute Tables

**Original AUM Feature Class Attribute Tables**

## AUM Points Symbology and Feature Class Attribute Table

**Notes:**
All point locations were merged into a single feature class and digitized entry lines were eliminated.

A new attribute table was created for Mine Polygons and Mined-Out Areas.

A color was adopted for representing mine AUM polygons.

## New AUM Mines, Points and Mined-Out Areas Feature Class Attribute Tables

## AUM_Hachured Areas (Mined-Out Areas) Polygon Attribute Table

## The AUM Application Toolbar Tools

**The AUM Application Toolbar Tools**

## The AUM Images

## API  INDEXING

-         12345678901234 – the standard is a 14-digit system broken down as:
- 12-345-6-7890-12-34
- Where:
- 12 = state code, Ohio = 34 (see attached list of all other states)
- 345 = county code (see attached list for all counties)
- 6 – data type-indicator
- 7-10 – permit number or individual feature ID
- 11-12 – sidetrack number used for O&G wells; data type indicator for all other collections
- 13-14 – multi-completion number used for O&G wells; can be used for qualifier for other types

** **Data Type Identifier
-  Digit # 6
- 0-7 is reserved for various types of oil and gas well data
- 8 will be used for Abandoned Underground Mines (this may change to 9 - miscellaneous)
- 9 will designate miscellaneous data.  Thus, if you see a 9 you will know that it is not oil-and-gas- well data and to look at characters 11 and 12 to define the type of data.
- _ _
- _ _
- _52 – AUM data_
- _this data will also use the 13 and 14 characters to further qualify the data as:_
- _34115900015201 – mine poly_
- _34115900025202 – mine points_
- _34115900455203 – hachured poly_
- _ _

**API  INDEXING**

## The New AUM Personal Geodatabase

**A Single Data Repository**** !!!**

**Notes:**
In addition to all AUM data, all pertinent statewide GIS base map layers and supporting tables were added to the AUM personal geodatabase, producing a single data repository. 

## The AUM Data Storage Folder -- on the NR728Mather Server

## Recent Work.......

_**AUM Geodatabase**_:
- Migration from a personal geodatabase to a multi-user geodatabase in ArcSDE running on a SQL Server DBMS.

## Now Available.....  AUM ArcIMS Website

**On the Ohio Geological Survey Website --- ****http://www.dnr.state.oh.us/geosurvey/index.html**