The Database for The Processing of Environmental Data

Abstract

Abstract The main purpose of the research was to design a database for collected measurements of the Computer System for Monitoring River Embankments (ISMOP) project. The ISMOP project aimed to conduct research on comprehensive monitoring and forecasting the flood embankments condition. As a part of the project, measurement data were collected continuously, transformed, interpreted and analysed using computer simulations. The assumption of the database was to achieve high availability of data in a short time, allowing quick (in less than 15 minutes) decision about the state of the flood embankment. The warehouse project contains large amount of time series data sets, 2D numerical models, analysis results of flood embankments condition and additional measurements like thermographic simulations. Simple database structure was proposed. Data were loaded into small number of tables, data types were adjusted for high accessibility. Such structure allows to use quick data selection for analysis and visualization and prevents from unnecessary data redundancy. To effectively visualize and analyse sensor’s data an additional ArcGIS plugin tool was created. The plugin offers the spatial visualization functionality of sensor placement (2D and 3D views), their selection, distance and area measurements, statistical calculations and spatial analysis. The tool also provides ability of manual modification and exporting data into shape and spreadsheet files for further analysis. For the examples that were carried out, the database structure and the plugin were efficient and results were quickly achievable. Data were presented in a manageable way in form of 2D charts and 3D visualizations.