Violetta Sokola Szewioła

In every mining company, the process of extracting deposits requires recalculating resources and, consequently, updating surveying-geological documentation. This documentation is necessary, among other things, to introduce changes to the deposit development project, the mining company operation plan, and finally, for proper planning of activities in the field of processing, namely pollution removal of the mining spoil, as well as transport and sale. Software was developed that allows you to create spatial models of deposits. The article presents solutions applied in this scope in the majority of mining enterprises conducting underground hard coal excavation in the Upper Silesian Region. The applied system, called the Numerical Model of the Deposit, uses the Oracle Spatial, AutoCAD Civil 3D, GEONET, GEOLISP, EDBJ-OPN software. The article focuses on the possibilities of the system in the aspect of coal quality assessment based on chemical, physicochemical, physical and petrographic methods. Basic functionalities of the system that uses the qualitative model of the deposit were presented. Chemical analyses of coal made by laboratories are recorded on a current basis into a relational database, and then verified by an authorized geologist. It allows us, among others, to supplement geological data of lots with attributes such as: field, tonnage, average fall, sulphation, etc.

AutoCAD Civil 3D with the Geolisp overlay are one of the most popular programs used in the GIS class systems in Polish mining. The article describes some interesting and little known possibilities of the programs in the scope of data importing. In particular, it presents the issue of using the data which are available on the Internet in WMS and WFS formats. The issue was discussed on the basis of data obtained from the website geoportal.gov.pl. The possibility of the two-way connection with the relational databases and popular in GIS programs shapefi le format was mentioned. The ability to load data using Geolisp software was mentioned.