For requesting an export of raw or aggregated water quality data from the GEMStat database.
Water quality data available from GEMStat can be used for status evaluation, research purposes or within the scope of education and training initiatives.
Unfortunately, direct access to raw water quality data from the GEMStat database is currently impossible due to data policy constraints. While this may hopefully change in the future, we can provide interested users with raw water quality data for non commercial purposes upon direct request in the meantime.
For data sets not available on-line through the Data Visualization Portal or Statistics Portal, requests made by non-commercial and non-private persons (i.e. those with no affiliation) will be filled at no cost, but will depend on data availability, UN Environment GEMS/Water Programme workload, and the nature of the data set/product being requested.
Requests will be queued with priority given to those related to joint activities with UN Environment Programme areas and other UN agencies. Data sets with a “Restricted” access rating will not be distributed; however, information about such data sets, including the distributor’s name and summary statistics on country level, can be sent to eligible institutions upon request.
To file a data request, please fill out the data request form, where your contact details, affiliation and intended use of the requested data have to be stated.
Users do not obtain title to the intellectual property of the data provided by GEMStat, nor any copyright or propriety rights to its content. As the data provided are the intellectual property of the organizations which supplied the information, the original source of the data must be fully acknowledged. Please refer to the respective organizations for further inquiries regarding copyright and user limitations.
Users are not allowed to transfer, sublicense, rent, lease or sell the data herein. The overall conditions for requesting data from GEMStat are summarized within a user declaration. Users are required to submit a scan of the signed user declaration with their data request in order to proceed.Download User declaration (RTF-File, 51KB)
Please keep in mind that if you publish any reports or other products based on the data from GEMStat, you are requested to acknowledge the originators of the data and the fact that they were acquired through UN Environment GEMS/Water Programme.
Please cite the data acquired from GEMStat as follows:
United Nations Environment Programme (2018). GEMStat database of the Global Environment Monitoring System for Freshwater (GEMS/Water) Programme. International Centre for Water Resources and Global Change, Koblenz. Accessed DD MONTH YYYY. Available upon request from GEMS/Water Data Centre: gemstat.org
Manual for the request form
In order to place a data request, the user is required to:
- Carefully read and sign a printout of the user declaration, as well as save a scan of the signed printout as a pdf-file for later stages of the data request process.
- Get an overview of the monitoring locations available within GEMStat with the help of the Data Visualization Portal or the Excel table of available monitoring locations.
Download Station catalogue (XLS-File, 1,3MB)
- Get an overview of the water quality parameters available within GEMStat with the help of the Data Visualization Portal, which allows to view available water quality parameters for specific monitoring locations, or the Excel table of overall available water quality parameters.
Download Parameter catalogue (XLS-File, 140 KB)
- Open the Data Request Form by clicking on “Request GEMStat Data” and enter the required information.
- Enter your last name and first name.
- Enter your email address.
- Optionally, enter a short message.
- Select the appropriate sector of your institution.
- Enter the name of your institution.
- Enter the address of your institution.
- Select the country, where you or your institution are residing.
- Select the position that you hold in your institution.
- Describe the intended use for the requested water quality data.
- Select the water quality parameters that you are interested in.
- Select an entire parameter group of your interest.
- Select the monitoring locations, for which the water quality data should be exported.
- Select the countries, for which the water quality data should be exported.
- Enter the years for the beginning and end of the requested data.
- Select the desired format of requested data.
Please note: for commercial purposes, only “Aggregated statistics” should be selected.
- Attach a scan of the signed user declaration.
- Finally: Click on the “Submit” button, and we will get back to you shortly.
- We will get back to you shortly with an email having an “Issue Key” attached to the Subject, either with further queries regarding your request, or with the delivery of the requested data if everything was OK. Please make sure to use the “Reply to all” function of your email client in future correspondence and to include the issue key string in the email subject.
The Parameter Catalogue summarizes all the water quality parameters that are available in GEMStat. It organizes the water quality parameters in three hierarchical groups, loosely based on the CUAHSI-Ontology (http://edscvs.ccny.cuny.edu/cuahsi/index.php?tema=1), and provides the user with a description for almost every parameter in the database.
It offers a convenient filter for every column, which allows for narrowing down the shown parameters according to the selected criteria: Simply click on the small triangles that can be found at the right edge of every column header, and restrict the selection to the entries that you are most interested in. If you, for instance, wish to see only the water quality parameters that are classified as nutrients, click on the triangle in column “Group 2” and deselect all entries except “Nutrient”.
Download Parameter catalogue (XLS-File, 140 KB)
|Group 1||Main group of the water quality parameter.|
(Biological, Chemical and Physical)
|Group 2||Secondary group of the water quality parameter.||Nutrient|
|Group 3||Tertiary group of the water quality parameter with the highest granularity. Some entries from Group 2 may repeat themselves in this group.||Nitrogen|
|Parameter name||General name of a water quality parameter, irrespective of actual speciation.||Organic Nitrogen|
|Parameter long name||Complete parameter name, including speciation. For complex chemical compounds usually the IUPAC name is used (if sufficiently concise).||Total Organic Nitrogen|
|Parameter code||GEMS code of water quality parameter that is used for unique identification of a given water quality parameter and its species in the GEMStat database.||TON|
|Remark||Short description of the water quality parameter. For complex chemical compounds, this includes the empirical formula and optionally the IUPAC name (if too expansive for the "Parameter Long Name" column).|
|Number: CAS||CAS registry number (https://www.cas.org/content/chemical-substances)||7727-37-9|
|Number: EC||EC registry number|
|Number: ChEBI||ChEBI registry number|
The Station Catalogue provides the user with an overview of all monitoring locations that are registered in GEMStat.
The worksheet “Map” offers an overview of the global distribution of monitoring locations and their type.
The worksheet “Stations” presents a table with all relevant information for every single monitoring location, together with Latitude and Longitude coordinates to allow the user to plot the locations with the help of a GIS-software.
It offers a convenient filter for every column, which allows for narrowing down the shown monitoring locations according to the selected criteria: Simply click on the small triangles that can be found at the right edge of every column header, and restrict the selection to the entries that you are most interested in. If you, for instance, wish to see only monitoring locations that are located in the Indus basin, click on the triangle in column “Catchment_name” and deselect all entries except “Indus”.
Download Station catalogue (XLS-File, 1,3MB)
|Country_code||ISO 3166-1 ALPHA-3 code of country, where the station is located.||DEU|
|Station_number||Internal code of the monitoring location in GEMStat.||DEU00005|
|Station_characteristic||Type of water body, at which the monitoring location is situated.||RIVER|
|Monitoring_type||Type of monitoring activity:|
Baseline - determination of natural freshwater qualities in the absence of significant direct human impact
Trend - determination of long-term trends
Impact - determination of short term impacts of potential sources on water quality
Flux - determination of the fluxes of toxic chemicals, nutrients, suspended solids and other pollutants from major river basins to the continent/ocean interfaces
|Catchment_name||Name of major river basin (river with highest Strahler-order), where the monitoring location is situated.||Rhine-Meuse|
|Station_name||Name of the monitoring location.||Moselle River - at Koblenz/Moselle|
|Remark||Description of monitoring location and special conditions.||2 km upstream of the confluence with the Rhine River|
|Latitude||Cartesian y-Coordinates in WGS84 coordinate reference system.||50.35|
|Longitude||Cartesian x-Coordinates in WGS84 coordinate reference system.||7.552778|
|Height||For surface waters: mean elevation of water surface above mean sea level.|
For groundwaters: ground elevation above mean sea level.
|Old_GEMS_number||Historical GEMS code of monitoring location, as in use prior to 2014.||135005|