Data management for monitoring through GIS

A GIS (Geographic Information System) has been created to manage, display and share the project data. The possibility of making the data available in one single place, with explicit coding, metadata and an established structure, as set out by the rules for database design, helps to make the data interoperable and efficiently searchable.

This data consists of:

  • basic cartographic data
  • georeferenced geometric entities [managed in an ESRI ArcGIS geodatabase]
Springs Study subject, selected springs
Weather stations Weather stations near to the studied springs, from which data is extracted to be compared with the chemical and physical values recorded at the springs
Supply areas Supply areas of each spring. These areas will be further investigated through the tracing carried out during the project
Hydrogeological systems The hydrogeological systems that form the region being studied, which will be compared with the supply areas of the springs
Tracing injection points The points where the tracer is injected for the tracing tests conducted to define the supply areas of the springs
Isotope lines Sample recording points for isotope analysis
  • related dynamic entities (tables with lots of variable data over time) [managed in an external MS Access database]
Monitoring Timed data monitoring of the physical parameters of the springs
Springs: C-A water (Basic quality) Sampling and analysis (C-A): Results from the chemical analysis carried out each season on the spring water, in relation to basic chemical qualities
Springs: C-A water (Metals) Results from the chemical analysis carried out each season on the spring water, in relation to metals
Springs: C-A water (Lanthanides) Results from the chemical analysis carried out each season on the spring water, in relation to lanthanides
Springs: Water isotope parameters Isotope sampling data conducted on the spring water each season
Reference Data: Water isotope parameters Values of the isotopes recorded at the sampling points along the isotope line, which can be compared with the values from the springs
Tracing parameters Measured summary results from the tracing
Tracer tests Data recorded by the tracing equipment at the springs, before it is processed
Hourly meteorological parameters Meteorological data recorded by weather stations every hour, including back data, which can be compared with the physical or chemical parameters of the springs
Daily meteorological parameters Meteorological data recorded by weather stations every day, including back data, which can be compared with the physical or chemical parameters of the springs
Reference data: snow isotope parameters Values of the isotopes recorded in the snow at the sampling points along the isotope line, which can be compared with the values from the springs

The storage formats of the two databases mean we can export the data template (with or without the data content) in XML so we can easily replicate the data management method used in the project by using the same software which, although commercial, is widely used.