All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
The Stations table contains the physical characteristics of the Eurowaternet water quantity monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective QuantityWater data.
[+] Show table definition (records: 3003)
DataSource | Data Source | source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC." varchar(50) No WaterDataSet Water Data Set "RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine water, QA = Water Quantity. | varchar(50) | 0 |
WaterbaseName | Waterbase Name | name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or the name of the groundwater body | nvarchar(200) | 0 |
NationalStationID | National Station ID | national station identifier for rivers, lakes, transitional, coastal and marine waters and water quantity monitoring station. For transitional, coastal and marine waters, areas are recorded and reported as a discrete location, but location may relate to a station at a fixed geographical point, a broader area in which sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. When calculating loads, the national station identifier used should be the same ID previously supplied to represent the (flux) river monitoring station. | nvarchar(50) | 0 |
IndexStation | Index Station | index station for precipitation or discharge monitoring, used for spatial aggregation (1 = yes, 0 = no). | int(4) | 0 |
PrecipitationStation | Precipitation Station | rain gauge station which also measures snowfall (1 = yes, 0 = no). | int(4) | 0 |
ReferenceStation | Reference Station | reference discharge monitoring station located in a river section with a flow regime as natural as possible or with only slight anthropogenic influence (1 = yes, 0 = no). | int(4) | 0 |
FluxStation | Flux Station | flux discharge monitoring station located in the mouth of a river or on national boundary (1 = yes, 0 = no). | int(4) | 0 |
Latitude | Latitude | (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. | float(8) | 0 |
CatchmentArea | Catchment Area | upstream catchment area in km2. | float(8) | 0 |
Altitude | Altitude | altitude of monitoring station in m above sea level. | float(8) | 0 |
Longitude | Longitude | (X) International geographical co-ordinates of the monitoring station in decimal degrees format. | float(8) | 0 |
RiverName | River Name | River name at the national level. | nvarchar(100) | 0 |
Region | Region | region in which water body is located at the national level. | nvarchar(100) | 0 |
CountryCode | Country code | ISO 3166-alpha-2 code elements. | nvarchar(2) | 0 |
Country | Country name (ISO 3166-1) | official short name in English. | nvarchar(100) | 0 |
WaterbaseID | Waterbase ID | internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, and groundwater bodies, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). WaterDataSet: RV = rivers, LK = lakes, GW = groundwater, TCM = transitional, coastal and marine waters, QA = water quantity. | varchar(200) | -1 |
WaterDataSet | Water Data Set | RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine water, QA = Water Quantity. | varchar(3) | 0 |
The QuantityWater table contains data on water resources measured at Eurowaternet monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the QuantityWater data with their respective Stations data.
[+] Show table definition (records: 31140)
Value | Value | measured value of determinand | float(8) | 0 |
Year | Year | year of aggregation period, or year in which sample taken, in format YYYY | int(4) | 0 |
Unit | Unit | unit of measurement | nvarchar(30) | 0 |
CountryCode | Country code | ISO 3166-alpha-2 code elements | varchar(2) | 0 |
WaterbaseID | WaterbaseID | Internally produced, unique identifier used to represent the quantity monitoring stations. | varchar(200) | -1 |
Determinand | Determinand | determinand name | nvarchar(200) | 0 |
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eurowaternet (EWN) process. EWN selects validated monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. The added value of Waterbase is that data collected through the EWN process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEA's indicator-based factsheets.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-water-quantity or scan the QR code.
PDF generated on 09 Jun 2023, 05:39 PM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others