Database Analysis in Mine Subsidence Research

Stache, Jan E.
Organization: Society for Mining, Metallurgy & Exploration
Pages: 6
Publication Date: Jan 1, 1986
Commercial software programs are being utilized to create and maintain a mine subsidence database in conjunction with the U.S. Bureau of mines research on mine subsidence in Illinois. A three-year survey net of monitored structures in an Illinois subdivision was entered as textual information (attributes), on an existing AutoCAD drawing. These attributes can be optionally displayed on the corresponding drawing or extracted as a text file for import to a database program. The database program, dBASEIV, allows combinations of multiple database files for extensive querying capabilities. Subsurface database files can be merged with surface database files to enhance the effectiveness of surface response analyses in mine subsidence research. The geographic information system (GIS), pcARC/INFO, was chosen to integrate existing AutoCAD drawings and dBASEIV database files into a relational database with a graphical representation. The relational database allows users to update either the graphical representation or the database, with the changes being reflected automatically in its alternate format. The increased capacity, through use of a GIS, to query combinations of database files and have the results reflected graphically has significant potential for expediting mine subsidence research.
Full Article Download:
(1339 kb)