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.
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
- Your contact details, affiliation and intended use of the requested data
- 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)
- Carefully read and sign a printout of the user declaration and attach a scan of the signed document.
- 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, 1.9MB)
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, 1.9 MB)
|Parameter Group 1||Main group of the water quality parameter.|
(Biological, Chemical and Physical)
|Parameter Group 2||Secondary group of the water quality parameter.||Nutrient|
|Parameter 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|
|Description||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).||Organic nitrogen fractions in unfiltered samples, reported as nitrogen.|
|Medium||Medium (or matrix) of which a sample was taken.||Water|
|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 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, 1.9 MB)
|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
|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.
|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 ...|