Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Transitional, coastal and marine waters

Waterbase - Transitional, coastal and marine waters

Note: new version is available!
Topics: ,
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 - TCM: QualitySediment

The QualitySediment table contains aggregated data on hazardous substances in sediment, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   13313)

NoOfSamples Number of samples number of samples in aggregation period. int(4) 0
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
Fraction Fraction upper limit of particle size in analysed fraction expressed in µm. Blank if whole sediment has been analysed. int(4) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
AggregationPeriod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) 0
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
OrganicCarbon Organic carbon mean organic carbon content expressed as % of total dry weight. float(8) 0
DryWetRatio Dry wet ratio mean ratio of dry weight to wet weight expressed as %. float(8) 0
BottomDepth Bottom depth of sediment bottom depth where the sediment sample was taken at transitional, coastal or marine water monitoring station expressed in m, measured from the water surface. float(8) 0
SedimentTop Top of sediment layer top of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available. float(8) 0
SedimentBottom Bottom of sediment layer bottom of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available. float(8) 0
Mean Mean mean concentration in aggregation period. float(8) 0
Minimum Minimum Minimum concentration during aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
GrainType Grain type sediment type description if no analysis of grain size: M = Mud, FS = Fine Sand, MS = Middle Sand, CS = Coarse Sand, G = Gravel. varchar(2) 0
Basis Basis basis of aggregate: D = Dry, W = Wet. varchar(1) 0
Waterbase - TCM: FluxStations

The FluxStations table contains the physical characteristics of the Eionet-Water transitional, coastal and marine water stations used to monitor riverine input loads, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the FluxStations with their respective Input (load) data.

[+] Show table definition (records:   314)

SeaRegionName Sea Region name regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. nvarchar(200) 0
SeaConventionArea Marine convention area name of Marine Convention area. nvarchar(200) 0
WaterbodyID Water body ID national identification code of marine water body (if applicable) that the flux station relates to. Water body as defined / required by Water Framework Directive. A water body may be related to more than one flux station. nvarchar(200) 0
WaterBodyName Water Body Name name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may be related to more than one flux station. nvarchar(200) 0
SeaAreaName Sea area name sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature. 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(200) 0
RiverName River name River name at the national level. nvarchar(200) 0
CatchmentName Catchment name catchment name at the national level. For transitional, coastal and marine waters, catchment name refers to major river catchment or basin draining into transitional or coastal water. nvarchar(200) 0
Country Country Official short name in English nvarchar(50) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
WaterbaseName Waterbase name name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or name of the groundwater body. nvarchar(200) 0
Longitude Longitude (X) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
Latitude Latitude (Y) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
DataSource Data source source of data: Eionet-Water, ICES. varchar(50) 0
WaterDataset Water data set RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine Water, QA = Water Quantity. varchar(3) 0
Waterbase - TCM: QualityBiotaD

The QualityBiotaD table contains disaggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   12012)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) -1
Month Month month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). int(4) -1
Day Day day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). int(4) -1
Determinand Determinand determinand name. nvarchar(200) -1
Unit Unit unit of measurement. nvarchar(30) 0
Basis Basis basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. nvarchar(1) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) -1
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
Concentration Concentration concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. float(8) 0
Fat Fat fat content of biota expressed as % of total wet matter. float(8) 0
LimitOfDetectionFlag Limit Of Detection Flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
DryFreshRatio Dry fresh ratio ratio of dry weight to fresh weight of biota monitored expressed as %. varchar(10) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
Species Species species monitored. varchar(20) 0
Tissue Tissue tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. varchar(1) -1
Waterbase - TCM: QualitySedimentD

The QualitySedimentD table contains disaggregated data on hazardous substances in sediment, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   13384)

Fraction Fraction upper limit of particle size in analysed fraction expressed in µm. Blank if whole sediment has been analysed. int(4) 0
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). int(4) 0
Day Day day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). int(4) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 0
Sampler Sampler name of sampling equipment used at transitional, coastal or marine water monitoring station. nvarchar(200) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) 0
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
SedimentBottom Bottom of sediment layer bottom of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available. float(8) 0
OrganicCarbon Organic carbon mean organic carbon content expressed as % of total dry weight. float(8) 0
DryWetRatio Dry wet ratio mean ratio of dry weight to wet weight expressed as %. float(8) 0
Concentration Concentration concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. float(8) 0
BottomDepth Bottom depth of sediment bottom depth where the sediment sample was taken at transitional, coastal or marine water monitoring station expressed in m, measured from the water surface. float(8) 0
SedimentTop Top of sediment layer top of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available. float(8) 0
Basis Basis basis of aggregate: D = Dry, W = Wet. varchar(1) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
GrainType Grain type sediment type description if no analysis of grain size: M = Mud, FS = Fine sand, MS = Middle sand, CS = Coarse sand, G = Gravel. varchar(2) 0
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
Waterbase - TCM: Inputs

The Inputs table contains data on the yearly riverine inputs of loads to transitional, coastal and marine waters which are monitored at Eionet-Water flux stations, provided by national sources or Marine Conventions. Each flux station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective Flux Stations data.

[+] Show table definition (records:   15839)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) -1
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) -1
Load Load estimated load of determinand. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
Estimate Estimate type L = Lower estimate based on treating determinand values that are less than the limits of detection as zero, U = Upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X = Unspecified. varchar(1) -1
Method Method of estimation OutY = Calculations including outlier values, OutN = Calculations excluding outlier values, FloodY = Calculations accounting for flood events, FloodN = Calculations not accounting for flood events, XSS = Loads calculated by extrapolation from concentrations (of micropollutants) in suspended sediment, Other = Other methods. varchar(20) 0
Waterbase - TCM: Stations

The Stations table contains the Eionet-Water transitional, coastal and marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressures data.

[+] Show table definition (records:   40684)

SeaConventionArea Marine convention area name of Marine Convention area. nvarchar(200) 0
WaterBodyName Water body name name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station. nvarchar(200) 0
SeaAreaName Sea area name sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature. nvarchar(200) 0
SeaRegionName Sea region name regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. nvarchar(200) 0
CatchmentName Catchment name catchment name at the national level. For transitional, coastal and marine waters, catchment name refers to major river catchment or basin draining into transitional or coastal water. nvarchar(200) 0
Region Region region in which water body is located at the national level. nvarchar(200) 0
WaterbodyID Water body ID national identification code of water body (if applicable) in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station. nvarchar(200) 0
Country Country Official short name in English nvarchar(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(200) 0
SeaDepth Mean annual depth mean annual depth at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
SeaResidence Residence time residence time of transitional or coastal water body expressed in number of days. float(8) 0
SalinityMaximum Maximum Annual Salinity maximum annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
Temperature Mean Annual Temperature mean annual temperature at transitional, coastal or marine water monitoring station expressed in degrees Celsius (oC). float(8) 0
TidalMean Mean tidal range mean tidal range at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
ClosestCoast Closest coast distance of marine station from closest coast expressed in km (if different from MainCoast). float(8) 0
SalinityMean Mean Annual Salinity mean salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
SalinityMinimum Minimum annual salinity minimum annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
Longitude Longitude (X) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
Latitude Latitude (Y) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
MainlandCoast Mainland coast distance of marine station from nearest mainland coast expressed in km. float(8) 0
TCMMatrix Matrix environmental compartments measured at transitional, coastal or marine water monitoring station: B = Biota, S = Sediment, W = Water column. Any combination allowed, listed alphabetically with no separator (e.g. BSW). varchar(3) 0
Mixing Mixing characteristics mixing characteristics at transitional, coastal or marine water monitoring station: FM = Fully mixed, PM = Partially mixed, VS = Vertically stratified. varchar(2) 0
PhysChemStatio Physico-Chemicals category station physico-chemical conditions monitored at station type: R = Represenatative station, I = Impact station. varchar(1) 0
HazSubsStation Hazardous substances category station hazardous substances monitored at station type: R = Represenatative station, I = Impact station. varchar(1) 0
StationReporting Station reporting purpose reporting purpose of the transitional, coastal or marine water monitoring station: EC = European Commission, MC = Marine Conventions, N = National purposes. Station can be for more than one reporting purpose, listed alphabetically with no separator (e.g. ECN). varchar(10) 0
WaterDataset Water data set RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine Water, QA = Water Quantity. varchar(3) 0
WaterBodyType Water body type RV = River, CN = Canal, T = Transitional water, C = Coastal water, M = Marine water. varchar(2) 0
WaterBodyTypeDesc Water body type description additional water body description, e.g. Estuary, Fjord, Coastal Lagoon, Embayment. varchar(50) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
DataSource Data source source of data: Eionet-Water, ICES. varchar(50) 0
StationClass Station Class proximity to land, defined by comparing supplied station co-ordinates with maps: Coast = within 20 km of closest land or island, Open Water = more than 20 km from closest land or island. varchar (10) 0
ReferenceStation ReferenceStation reference station: 1 = Yes, 0 = No. varchar(1) 0
Waterbase - TCM: QualityWater

The QualityWater table contains aggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   311812)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
NoOfObservations Number of observations number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. int(4) 0
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
AggregationPeriod Period of aggregation period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
SalinityMean Mean salinity mean salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
MinimumDepth Minimum depth minimum depth limit for samples included in aggregate expressed in m. float(8) 0
MaximumDepth Maximum depth maximum depth limit for samples included in aggregate expressed in m. float(8) 0
Mean Mean mean concentration in aggregation period. float(8) 0
Minimum Minimum minimum concentration during aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
AggregationMethod Aggregation method description of aggregation process: MeanOfMinimum = Minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean = Average of all samples on same date and in same depth profile calculated then average of averages calculated by year. varchar(20) 0
Waterbase - TCM: QualityBiota

The QualityBiota table contains aggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   54564)

HighNoOfSamples High range number of samples number of samples in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). int(4) 0
DryFreshNoOfSamples Dry fresh ratio number of samples number of samples taken in ratio of dry weight to fresh weight of biota expressed as %. int(4) 0
FatNoOfSamples Fat content number of samples number of samples of fat content of biota expressed as % of total wet matter. int(4) 0
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) -1
PeriodLength Period length number of months in aggregation period. int(4) 0
LowNoOfSamples Low range number of samples number of samples in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). int(4) 0
Determinand Determinand determinand name. nvarchar(200) -1
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
AggregationPeriod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) -1
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
FatMinimum Fat content minimum minimum fat content of biota expressed as % of total wet matter. float(8) 0
FatMaximum Fat content maximum maximum fat content of biota expressed as % of total wet matter. float(8) 0
DryFreshMinimum Dry fresh ratio minimum minimum ratio of dry weight to fresh weight of biota expressed as %. float(8) 0
DryFreshMaximum Dry fresh ratio maximum maximum ratio of dry weight to fresh weight of biota expressed as %. float(8) 0
FatMean Fat content mean mean fat content of biota expressed as % of total wet matter. float(8) 0
High90Percentile High range 90th percentile 90th percentile concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). float(8) 0
HighMaximum High range maximum maximum concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). float(8) 0
DryFreshMean Dry fresh ratio mean mean ratio of dry weight to fresh weight of biota expressed as %. float(8) 0
LowMedian Low range median median concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). float(8) 0
HighMean High range mean mean concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). float(8) 0
HighMedian High range median median concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). float(8) 0
LowMinimum Low range minimum minimum concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). float(8) 0
Low10Percentile Low range 10th percentile 10th percentile concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). float(8) 0
LowMean Low range mean mean concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). float(8) 0
Basis Basis basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. varchar(1) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
Species Species species monitored. varchar(20) -1
Tissue Tissue tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. varchar(2) -1
Waterbase - TCM: QualityWaterD

The QualityWaterD table contains disaggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   696340)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). int(4) 0
Day Day day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). int(4) 0
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) 0
Determinand Determinand determinand name. nvarchar(200) 0
Concentration Concentration concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. float(8) 0
SampleDepth Sample depth depth at which sample taken expressed as m below surface, with value >=0. float(8) 0
Salinity Salinity salinity of sample or salinity to which sample concentration is normalised in practical salinity units (psu). float(8) 0
HaloPos Halocline position vertical position relative to halocline at transitional, coastal and marine water monitoring station: AH = Above halocline, IH = In halocline, BH = Below halocline. varchar(2) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
ThermoPos Thermocline position vertical position relative to thermocline at transitional, coastal and marine water monitoring station: AT = Above thermocline, IT = In thermocline, BT = Below thermocline. varchar(2) 0
Waterbase - TCM: Discharges

The Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.

[+] Show table definition (records:   92)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
SeaRegionName Sea region name regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. nvarchar(200) 0
SeaConventionArea Marine Convention Area name of Marine Convention area. nvarchar(200) 0
Determinand Determinand determinand name. nvarchar(200) 0
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
WaterbodyID Water body ID national identification code of water body (if applicable) in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station. nvarchar(200) 0
WaterBodyName Water body name name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station. nvarchar(200) 0
SeaAreaName Sea area name sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature. nvarchar(200) 0
Load Load estimated load of determinand. float(8) 0
Method Method of estimation OutY = Calculations including outlier values, OutN = Calculations excluding outlier values, FloodY = Calculations accounting for flood events, FloodN = Calculations not accounting for flood events, XSS = Loads calculated by extrapolation from concentrations (of micropollutants) in suspended sediment, Other = Other methods. varchar(20) 0
CountryCode CountryCode ISO 3166-alpha-2 code elements varchar(2) 0
DischargeType Discharge type I = Industrial, M = Municipal, T = Total. varchar(1) 0
Estimate Estimate type L = Lower estimate based on treating determinand values that are less than the limits of detection as zero, U = Upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X = Unspecified. varchar(1) 0
Unit Unit unit of measurement. nvarchar(30) 0
Waterbase - TCM: QualityHSWater

The QualityHSWater table contains aggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   365)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) -1
PeriodLength Period Length number of months in aggregation period. int(4) 0
NoOfObservations Number of observations number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. int(4) 0
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
Unit Unit unit of measurement. nvarchar(30) 0
AggregationMethod Aggregation method description of aggregation process: MeanOfMinimum = Minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean = Average of all samples on same date and in same depth profile calculated then average of averages calculated by year. nvarchar(20) -1
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
Determinand Determinand determinand name. nvarchar(200) -1
AggregationPeriod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) 0
SalinityMean Mean salinity mean salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
MinimumDepth Minimum depth minimum depth limit for samples included in aggregate expressed in m. float(8) 0
MaximumDepth Maximum depth maximum depth limit for samples included in aggregate expressed in m. float(8) 0
Mean Mean mean concentration in aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. float(8) 0
Minimum Minimum Minimum concentration during aggregation period. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
Waterbase - TCM: Pressures

The Pressures table contains proxy pressure data on the upstream catchment or drainage basin of the Eionet-Water transitional water monitoring stations, or within the River Basin District to which the coastal water monitoring stations have been assigned, provided by national sources. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressures data with their respective Stations and Quality data.

[+] Show table definition (records:   212)

WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
LanduseOther Landuse other other land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseOtherAgriculture Landuse Other Agriculture other agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseArableLand Landuse arable land arable land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LandusePasture Landuse Pasture pastoral land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseNature Landuse nature natural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseForest Landuse forest forested land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseTotalAgriculture Landuse total agriculture total agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
PopulationDensity Population density population density (capita/km2) of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseUrban Landuse urban urban land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseWetland Landuse wetland wetland land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
Port Port presence of port facilities in the transitional, coastal or marine water body: Y = Yes, N = No. varchar(1) 0
OtherActivities Other activities any other activities in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
Mariculture Mariculture fish and shellfish farming in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
Fishing Fishing commercial fishing activity in the transitional, coastal or marine water body: Y = Yes, N = No. varchar(1) 0
Marina Marina presence of a marina in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
Spoil Spoil dredged spoil disposal ground in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
Waste Waste waste disposal ground in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
LandFill Landfill transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites: Y = Yes, N = No. varchar(1) 0
OtherDischarge Other discharge direct discharges from other sources to the transitional, coastal or marine water body. The OSPAR RID guidelines define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". Y = yes, N = no. varchar(1) 0
OilExtraction Oil extraction exploration for or extraction of oil in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
GasExtraction Gas extraction exploration for or extraction of gas in the transitional, coastal or marine water body: Y = Yes, N = No. varchar(1) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
SewageDischarge Sewage discharge direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made": U = UWWT, NU = Non-UWWT, BU = Both. varchar(2) 0
IndustrialDischarge Industrial discharge direct discharges from industry to the transitional, coastal or marine water body. The OSPAR RID guidelines define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made": E = EPER, NE = Non-EPER, BE = Both. varchar(2) 0
Waterbase - TCM: QualityHSWaterD

The QualityHSWaterD table contains disaggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   1943)

Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). int(4) 0
Day Day day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). int(4) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) 0
CaSNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
Concentration Concentration concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. float(8) 0
SampleDepth Sample depth depth at which sample taken expressed as m below surface with value >=0. float(8) 0
Salinity Salinity salinity of sample or salinity to which sample concentration is normalised in practical salinity units (psu). float(8) 0
HaloPos Halocline position vertical position relative to halocline at transitional, coastal and marine water monitoring station: AH = Above Halocline, IH = In Halocline, BH = Below Halocline. varchar(2) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
LimitOfDetectionFlag Limit Of Detection Flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
ThermoPos Thermocline position vertical position relative to thermocline at transitional, coastal and marine water monitoring station: AT = Above Thermocline, IT = In Thermocline, BT = Below Thermocline. varchar(2) 0

Additional information

Metadata

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water 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 Eionet-Water 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.

 

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100