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.
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.
name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or the name of the groundwater body
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.
index station for precipitation or discharge monitoring, used for spatial aggregation (1 = yes, 0 = no).
rain gauge station which also measures snowfall (1 = yes, 0 = no).
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).
flux discharge monitoring station located in the mouth of a river or on national boundary (1 = yes, 0 = no).
(Y) International geographical co-ordinates of the monitoring station in decimal degrees format.
upstream catchment area in km2.
altitude of monitoring station in m above sea level.
(X) International geographical co-ordinates of the monitoring station in decimal degrees format.
River name at the national level.
region in which water body is located at the national level.
ISO 3166-alpha-2 code elements.
Country name (ISO 3166-1)
official short name in English.
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.
Water Data Set
RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine water, QA = Water Quantity.
Some 97.5% of water on the Earth is salt water, leaving only 2.5% as fresh water. Of this over two thirds is frozen in glaciers and polar ice caps. The remaining unfrozen fresh water is found mainly as groundwater, with only a small fraction present in rivers, lakes or in the air. Water is a precious resource, use it responsibly and don’t waste it!
More green tips