DESIGN AND CONSTRUCTION OF A GIS-BASED DATABASE FOR MANAGING LANDSLIDES IN MINING AREA

Landslides caused by mining are seriously affecting the construction and sustainable development of mining area. With the characteristics of multi-resource, multi-format, multi-theme and large storage capacity, mining landslide data is difficult to be managed effectively and applied to the evaluation, forecast, prevention and treatment of landsides. Based on mechanism of landslides in mining areas and GIS technology, we analyzed the data in mining area landslide database on different aspects. Landslides and other related objects in mining area were abstracted to relational models by conceptual design, logical design and physical design. A new unique coding method was present according to current specifications and the features of mining areas. Then, we built a GIS-based mining area landslide database using Oracle and ArcSDE. Through program implementation and an experiment, the results shows that the database with rich content is well-structured, satisfying the users who manage mining area landslide information or collect data in the field.