Skip to main content

Custom data request

Water quality data available from GEMStat can be used for status evaluation, research purposes or within the scope of education and training initiatives.

For data sets not available online through the Data 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.

Data policy

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 (PDF-File, 16KB)

Information for custom data requests

In order to file a data request, please send an email to including the following information:

  1. Your contact details, affiliation and intended use of the requested data
  2. Description of the required water quality data, including
    • Required parameters or parameter groups
    • The monitoring locations or countries, for which the water quality data should be exported
    • The years for the beginning and end of the requested data
    • The desired format of the requested data (raw data or aggregated statistics)
  3. Carefully read and sign a printout of the user declaration and attach a scan of the signed document.
  4. 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

You can get an overview of the monitoring locations and parameters available within GEMStat with the help of the Data Portal as well as our Parameter and Station catalogues:

GEMStat catalogue (XLSX-File, ~2 MB)

Parameter Catalogue

The worksheet “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, 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 GEMStat Catalogue (XLSX-File, ~2 MB)
DescriptionExample
Parameter Group 1Main group of the water quality parameter.
(Biological, Chemical and Physical)
Chemical
Parameter Group 2Secondary group of the water quality parameter. Nutrient
Parameter Group 3Tertiary group of the water quality parameter with the highest granularity. Some entries from Group 2 may repeat themselves in this group.Nitrogen
Parameter NameGeneral name of a water quality parameter, irrespective of actual speciation.Organic Nitrogen
Parameter Long NameComplete parameter name, including speciation. For complex chemical compounds usually the IUPAC name is used (if sufficiently concise).Total Organic Nitrogen
Parameter CodeGEMS 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
DescriptionShort 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).Organic nitrogen fractions in unfiltered samples, reported as nitrogen.
MediumMedium (or matrix) of which a sample was taken.Water
Number: CASCAS registry number (https://www.cas.org/content/chemical-substances)
7727-37-9
Number: ECEC registry number
(https://echa.europa.eu/information-on-chemicals/ec-inventory)
231-783-9
Number: ChEBIChEBI registry number
(https://www.ebi.ac.uk/chebi/)
25555

Station Catalogue

The worksheet “Stations_Catalogue” provides the user with an overview of all monitoring locations that are registered in GEMStat, with all relevant information for every single monitoring location, together with Latitude and Longitude coordinates to allow the user to plot the locations using a GIS-software of their choosing.

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 “Main Basin” and deselect all entries except “Indus”.

Download GEMStat Catalogue (XLSX-File, ~2 MB)
DescriptionExample
Country Name
ISO 3166-1 name of the country, where the station is located.Germany
GEMS Station Code
Internal code of the monitoring location in GEMStat.DEU00005
Local Station Code
Identification code of the monitoring location within the monitoring network, as reported by the data provider.
Station Name
Name of the monitoring location.Moselle River - at Koblenz/Moselle
Water Body Type
Type of water body, at which the monitoring location is situated.RIVER
Water Body Name
Name of the water body, at which the monitoring location is situated.
Main Basin
Name of major river basin (river with highest Strahler-order), where the monitoring location is situated.Rhine-Meuse
Station Description
Description of monitoring location and special conditions.2 km upstream of the confluence with the Rhine River
Upstream Basin Area
Watershed area upstream of the station.
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
TREND
Responsible Collection Agency
Name of the institution that reported the data.Federal Institute of Hydrology - Global Runoff Data Center
Latitude WGS84
Cartesian y-Coordinates in WGS84 coordinate reference system.50.35
Longitude WGS84
Cartesian x-Coordinates in WGS84 coordinate reference system.7.552778
Elevation
For surface waters: mean elevation of water surface above mean sea level.
For groundwaters: ground elevation above mean sea level.
135
Available Samplings
Number of water quality samplings reported for this location.274
First Sampling Date
Date of the first sampling available in GEMStat.1979-01-28
Last Sampling Date
Date of the last sampling available in GEMStat.1995-12-18
Available Parameters
List of water quality parameters available for this location.Alkalinity;Ammonia ...