next
previous
items

Data

Waterbase - Water Quantity

Data
Prod-ID: DAT-58-en
Created 01 Jan 2002 Published 01 Jan 2002 Last modified 15 Dec 2022
5 min read
This is an old version, kept for reference only.

Go to latest version
This page was archived on 25 Aug 2017 with reason: A new version has been published
Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources.

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
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

Additional information

Quantity: metadata of the QuantityWater table
Quantity: metadata of the Stations table

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

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: waterbase
Document Actions