no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionLast revision | |||
— | en:documentation [2022-11-13] – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Documentation ====== | ||
+ | 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. We have designed multiple reports and developed multiple analyses and models (identifying redox processes, hydrochemical type of water, or average hydraulic gradient). | ||
+ | |||
+ | ===== ETL ===== | ||
+ | The data are loaded to the database (data warehouse) by the ETL tool PDI. Data transformations in < | ||
+ | * {{: | ||
+ | * {{: | ||
+ | * {{: | ||
+ | * {{: | ||
+ | * {{: | ||
+ | * {{: | ||
+ | * formats from some other data vendors (groundwater pumping, river discharges etc.). | ||
+ | Subsequent transformations provide data cleaning, anti-aliasing, | ||
+ | |||
+ | ===== Visualization ===== | ||
+ | Data 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: | ||
+ | * The graph and the table of time development of an arbitrary quantity in arbitrary observation points and basic descriptive statistics. | ||
+ | * Profile of geologically documented borehole. | ||
+ | |||
+ | ===== Analyses and models ===== | ||
+ | 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: | ||
+ | * Data aggregation (e.g. total annual precipitation computed from daily precipitation, | ||
+ | * Computation of the hydrochemical type of water (based on major cations and anions) – e.g. Ca-Mg-HCO3. | ||
+ | |||
+ | Some analyses and a model are utilizing PDI and formulas in Pentaho Reporting (OpenFormula), | ||
+ | * Identifying redox processes in ground water from chemical composition (dissolved O< | ||
+ | * Multicriterial analysis assessing water quality trends in correspondence to eutrophication. Aggregated values of quantities (nitrogen/ | ||
+ | |||
+ | Some analyses were performed in external tools (data were exported with PDI): | ||
+ | * The average hydraulic gradient was calculated from the hydraulic heads of selected boreholes. Consecutively seepage velocity and retention time were computed. This calculation is performed in MS Excel spreadsheet ((DEVLIN, J.F., 2003. A spreadsheet method of estimating best-fit hydraulic gradients using head data from multiple wells. //Ground Water//. **41**(3), 316–320. ISSN 1745-6584. [[doi> | ||
+ | * To support the geological interpretation of thousands of exploratory boreholes from a former mining area we tested an automated classification of the detailed text characterizations of strata. We used [[https:// | ||
+ | |||
+ | The above-mentioned analyses support conceptual model developments. The same techniques can be used to implement simple procedural site-specific groundwater models. | ||
+ | |||
+ | ===== Use cases ===== | ||
+ | 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. | ||
+ | |||
+ | |||
+ | ===== Further reading ===== | ||
+ | * **[[cheatsheet|PDI cheat sheet]]** | ||
+ | Pages only in Czech: | ||
+ | * [[cs: | ||
+ | \\ | ||
+ | |||
+ | ---- | ||
+ | ===HgIS was developed within projects financially supported by the Technology Agency of the Czech Republic: | ||
+ | [[https:// | ||
+ | [[http:// | ||
+ | [[https:// | ||
+ | [[https:// |
Last modified: 2022-12-20