This is simplified technical documentation. User's documentation is available for customers only.
HgIS is mostly built upon the Pentaho platform. It uses ETL tool Pentaho Data Integration to load data to the database. The database PostgreSQL uses our data model. To formulate conceptual models, data can be explored in 3D hydrogeological visualization software EnviroInsite. The approach is simplified due to the compatibility of our data model with that of EnviroInsite. We have designed multiple reports and developed multiple analyses and models (identifying redox processes, hydrochemical type of water or average hydraulic gradient).
The data are loaded to the database (data warehouse) by the ETL tool PDI. Data transformations in PDI can be implemented without coding through an intuitive graphical user interface and run also in the command-line interface or on the ETL server. We implemented the loading of the following data:
Subsequent transformations provide data cleaning, anti-aliasing, validation and loading to the database. Coordinate conversion and loading of data to PostGIS is performed by PDI GIS Plugins. Ad-hoc loading is performed by common GIS software (e.g. QGIS). PDI is also used to export data to third-party simulation tools.
Due to the compatibility of our data model with that of EnviroInsiteData can be easily exported to MS Access or MS Excel file and can be visualized in EnviroInsite. This is suitable for professional hydrogeologists to develop conceptual groundwater models. Stakeholders and other nonspecialists can view data in a web application we have developed. The application combines tables, a graph and a map on a single screen. Different map layers are provided as mapping services. We have developed the following reports:
We have developed the following analyses and the models that are reusable because of their general purpose and connection to the database. Some analyses are utilizing PDI. Results are stored directly in the database as separate quantities:
Some analyses and a model are utilizing PDI and formulas in Pentaho Reporting (OpenFormula), results are depicted in reports:
Some analyses were performed in external tools (data were exported with PDI):
The above-mentioned analyses support conceptual model developments. The same techniques can be used to implement simple procedural site-specific groundwater models.
Components of HgIS are being used in a state enterprise (that carries out recultivation) for data management and for the water balance model of a lake. HgIS is deployed and used within research projects at the Technical University of Liberec.
Pages only in Czech: