Waterbase - Quantity: Stations

Data Table

This page was archived on 25 Aug 2017 with reason: A new version has been published

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.

Data and maps

Menu

Category

European data

Records

3003

Table definition

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