Data
Waterbase - Water Quantity
Go to latest version
European data
Waterbase - Quantity: Stations
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 |
-
quantity_stations.mdb (application/msaccess)
772.00 KB Download file -
quantity_stations.csv (text/comma-separated-values)
414.32 KB Download file -
quantity_stations.xls (Microsoft Excel spreadsheet)
769.50 KB Download file -
quantity_stations.dbf (dBASE document)
2.77 MB Download file
Waterbase - Quantity: QuantityWater
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 |
-
quantity_water.dbf (dBASE document)
14.05 MB Download file -
quantity_water.mdb (application/msaccess)
4.03 MB Download file -
quantity_water.csv (text/comma-separated-values)
2.39 MB Download file -
quantity_water.xls (Microsoft Excel spreadsheet)
3.25 MB Download file
Additional information
Quantity: metadata of the QuantityWater table
-
Quantity: metadata of the QuantityWater table (text/comma-separated-values)
822 Bytes Download file
Quantity: metadata of the Stations table
-
Quantity: metadata of the Stations table (text/comma-separated-values)
3.35 KB Download file
Metadata
Additional information
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.
Permalinks
- Permalink to this version
- 9053EDBC-734B-4292-8A05-353A92B493D8
- Permalink to latest version
- DAT-58-en
Geographic coverage
Temporal coverage
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 28 Jan 2023, 11:34 AM
Document Actions
Share with others