development of iac cgm

Data storage and representation system

IAC CGM 2013

Source data of seismic observations

The source data were tables in formats Word and Excel.

Development of a database schemeBy MS Access the database scheme of SeisDB was developed.

Data transferUsing Visual Basic for Applications (VBA) the seismic data from Word and Excel were corrected and transferred with conversion into database Access SeisDB.

SeisDB in AccessExcel tables

Word tables

MS SQL ServerNext step was to transfer the database SeisDB into SQL Server.

Access & SQL ServerThe database SeisDB in Access is used for editing and adding of seismic data.

The database SeisDB in SQL Server is used for representing of seismic data.

CreateShapeGISCreateShapeGIS is a GIS application developed in Visual Basic .NET by Anatol Salanevich. The development includes an ActiveX control MapWinGIS. The main goal of this app is to retrieve data (with Latitude and Longitude fields) from the database SeisDB in SQL Server and to save them in a shapefile. The app can work through a local network.

Main GUI of CreateShapeGIS

Data miningUsing of seismic data is carried out by scheme: SQL Server -> CreateShapeGIS -> a GIS application (such as QGIS, gvSIG, Google Earth).

Transact - SQL query

A shapefile

CreateShapeGIS

GIS apps

The shapefile in gvSIG

The shapefile in QGIS with GEM module in Ubuntu Linux

Google EarthFor Google Earth the shapefile should be converted into a file with kml extension. It can be carried out via a program like Shp2kml.

Thanks for your attention