Personal tools

Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


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

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

[+] Show table definition (records:   9772)

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
Basis Basis basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. nvarchar(1) 0
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
Determinand Determinand determinand name. nvarchar(200) 0
DryFreshRatio Dry fresh ratio ratio of dry weight to fresh weight of biota monitored expressed as %. float(8) 0
Fat Fat fat content of biota expressed as % of total wet matter. float(8) 0
LimitOfDetection Limit of detection concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected, i.e. there is a 95% probability that the determinand will be detected. float(8) 0
LimitOfDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). 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
Tissue Tissue code of tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. varchar(2) 0
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
Species Species code of species monitored. varchar(20) 0
Waterbase - TCM: QualitySediment

The QualitySediment table contains aggregated data on hazardous substances in sediment, measured at Eurowaternet transitional, coastal or marine water monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressure data.

[+] Show table definition (records:   200)

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
Unit Unit unit of measurement. nvarchar(30) 0
AggregationPeriod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. nvarchar(20) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
DryWetRatio Dry wet ratio average ratio of dry weight to wet weight expressed as %. float(8) 0
SedimentTop Top of sediment layer top of analysed sediment layer measured from the sediment surface expressed in cm. Value will be 0 if top of sediment layer is the sediment surface for at least one sample in the aggregate. float(8) 0
SedimentBottom Bottom of sediment layer bottom of analysed sediment layer measured from the sediment surface expressed in cm. float(8) 0
OrganicCarbon Organic carbon average organic carbon content expressed as % of total dry weight. float(8) 0
Median Median median concentration value in aggregation period. float(8) 0
StandardDeviation Standard deviation standard deviation of concentration values in aggregation period. float(8) 0
SedimentDepth Depth of sediment depth of sediment at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
Mean Mean mean concentration value in aggregation period. float(8) 0
Minimum Minimum minimum concentration value in aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. 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
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
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
Waterbase - TCM: QualityWater

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

[+] Show table definition (records:   247595)

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
AggregationPeriod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 0
MeanSalinity Mean salinity average salinity of samples included in aggregate. 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 value in aggregation period. float(8) 0
Minimum Minimum minimum concentration value in 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
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
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: FluxStations

The FluxStations table contains the physical characteristics of the Eurowaternet transitional, coastal and marine water stations used to monitor riverine input loads. 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:   100)

SeaConventionArea Sea convention area marine Convention area of which regional sea is a part: BSC, HELCOM, HELCOM/OSPAR, OSPAR, UNEP/MAP. nvarchar(50) 0
SeaRegionName Sea region name name of regional sea of which sea area is a part. nvarchar(200) 0
CatchmentName Catchment name catchment name at the national level, referring to major river catchment or basin draining into transitional or coastal water. nvarchar(100) 0
NationalStationID National station ID identifier of the transitional, coastal or marine water flux station, unique at the national level. The identifier should be the same as previously supplied to represent the (flux) river monitoring station. nvarchar(200) 0
SeaAreaName Sea area name name of local sea area in which station is located. WaterBodyName and SeaAreaName may be the same. nvarchar(200) 0
RiverName River name river name at the national level. nvarchar(200) 0
WaterBodyName Water body name water body name as defined for the Water Framework Directive. nvarchar(200) 0
Country Country name (ISO 3166-1) Official short name in English. nvarchar(50) 0
WaterbaseName Waterbase Name name of the transitional, coastal or marine water monitoring station. nvarchar(200) 0
Longitude Longitude (X) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the flux monitoring station, in the format CountryCode_WaterDataSetF_NationalStationID (e.g. GB_TCMF_12345). Due to the inclusion of the WaterDataSet code and the “F” (TCMF), the WaterbaseID for a flux station will always differ from the WaterbaseID of other stations, even if the same NationalStationID is used. varchar(200) -1
DataSource Data source source of data: Eurowaternet, ICES. varchar(50) 0
Waterbase - TCM: QualitySedimentD

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

[+] Show table definition (records:   11743)

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 was 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
Sampler Sampler name of sampling equipment used at transitional, coastal or marine water monitoring station. nvarchar(200) 0
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
Determinand Determinand determinand name. nvarchar(200) 0
OrganicCarbon Organic carbon average organic carbon content expressed as % of total dry weight. float(8) 0
DryWetRatio Dry wet ratio ratio of dry weight to wet weight expressed as %. float(8) 0
SedimentDepth Depth of sediment depth of sediment at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
SedimentTop Top of sediment layer top of analysed sediment layer measured from the sediment surface expressed in cm. Value will be 0 if top of sediment layer is the sediment surface for at least one sample in the aggregate. float(8) 0
SedimentBottom Bottom of sediment layer bottom of analysed sediment layer measured from the sediment surface expressed in cm. float(8) 0
LimitOfDetection Limit of detection concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected i.e. there is a 95% probability that the determinand will be detected. float(8) 0
LimitOfDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). 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
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 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
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
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
Waterbase - TCM: QualityWaterD

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

[+] Show table definition (records:   570723)

Year Year year of aggregation period or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample was 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
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
Unit Unit unit of measurement. nvarchar(30) 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
LimitOfDetection Limit of detection concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected i.e. there is a 95% probability that the determinand will be detected. float(8) 0
LimitOfDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). 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
ThermoPos Thermocline position vertical position relative to thermocline at transitional, coastal or marine water monitoring station: AT = Above thermocline, IT = In thermocline, BT = Below thermocline. varchar(2) 0
HaloPos Halocline position vertical position relative to halocline at transitional, coastal or 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
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
Waterbase - TCM: Stations

The Stations table contains the physical characteristics of the Eurowaternet transitional, coastal and marine water monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressure data.

[+] Show table definition (records:   35154)

SeaConventionArea Marine convention area Marine Convention area of which regional sea is a part: BSC, HELCOM, HELCOM/OSPAR, OSPAR, UNEP/MAP. nvarchar(50) 0
WaterbaseName Waterbase name name of the transitional, coastal or marine water monitoring station. nvarchar(200) 0
Temperature Mean Annual Temperature Mean annual temperature at transitional, coastal or marine water monitoring station expressed in degree Celsius. 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 annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
CatchmentName Catchment name Catchment name at the national level, referring to major river catchment or basin draining into transitional or coastal water. nvarchar(200) 0
Longitude Longitude (X) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
NationalStationID National station ID Identifier of the transitional, coastal or marine water monitoring station, unique at the national level. 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. Where national station identifiers are not available for data provided by Marine Conventions, the national station identifier will be populated with a unique value based on a combination of Convention, quality data table and co-ordinate position. nvarchar(200) 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
MainCoast Mainland coast distance of marine station from nearest mainland coast expressed in km. float(8) 0
WaterBodyType Water body type T = Transitional water, C = Coastal water, M = Marine water. varchar(1) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
SeaAreaName Sea area name Name of local sea area in which station is located. WaterBodyName and SeaAreaName may be the same. nvarchar(200) 0
StationType Station type type of transitional, coastal or marine water monitoring station: B = Reference, R(PHYS) = Station representative of general conditions in terms of physico-chemical quality elements (organic matter and nutrients), I(PHYS) = Station impacted directly by discharges affecting physico-chemical conditions (organic matter and nutrients), R(HZ) = Station representative of general conditions in terms of hazardous substances, I(HZ) = Station impacted directly by discharges containing hazardous substances. Stations can be of more than one type, listed ordered as above, with no separator e.g. BR(PHYS)R(HZ). nvarchar(30) 0
Region Region region in which water body is located at the national level. varchar(200) 0
SeaRegionName Sea region name name of regional sea of which sea area is a part. nvarchar(200) 0
WaterBodyName Water body name water body name as defined for the Water Framework Directive. nvarchar(200) 0
WaterBodyTypeDesc Water body type description additional water body description, e.g. Estuary, Fjord, Coastal Lagoon, Embayment. varchar(50) 0
StnReporting 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
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
SeaDepth Mean annual depth mean annual depth at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
TidalMean Mean tidal range mean tidal range at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
WaterDataset Water data set TCM = Transitional, Coastal and Marine water. varchar(3) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
Country Country name (ISO 3166-1) Official short name in English. nvarchar(50) 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
Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
Matrix 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
DataSource Data Source Source of data: Eurowaternet, ICES. varchar(50) 0
Waterbase - TCM: QualityHSWater

The QualityHSWater table contains aggregated data on hazardous substances in seawater, measured at Eurowaternet transitional, coastal or marine water monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressure data.

[+] Show table definition (records:   266)

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(60) 0
AggregationPeriod Aggregation period Period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. nvarchar(20) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 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 value in aggregation period. float(8) 0
Maximum Maximum maximum concentration value in aggregation period. float(8) 0
MeanSalinity Mean salinity average salinity of samples included in aggregate. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
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: QualityHSWaterD

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

[+] Show table definition (records:   1126)

Year Year year of aggregation period or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample was 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
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
Determinand Determinand determinand name. nvarchar(200) 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
LimitOfDetection Limit of detection concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected, i.e. there is a 95% probability that the determinand will be detected. float(8) 0
LimitOfDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). 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
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
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
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
Waterbase - TCM: Pressures

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

[+] Show table definition (records:   168)

LanduseOtherAgriculture Landuse other agriculture other agricultural land use as % of 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 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 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
Landfill Landfill transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites. 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
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
LanduseOther Landuse other other land use as % of 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 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 pastural land use as % of 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 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) 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 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 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
Marina Marina presence of a marina in the transitional, coastal or marine water body. Y = yes, N = no. varchar(1) 0
Port Port presence of port facilities 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
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
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
OilExtraction Oil extraction exploration for or extraction of oil 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
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
OtherActivities Other activities any other activities 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
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
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 Eurowaternet flux stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective FluxStations data.

[+] Show table definition (records:   6794)

Year Year year of aggregation period or year in which sample taken, in format YYYY. int(4) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 0
Value Value Measured value 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 Country code ISO 3166-alpha-2 code elements. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
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
Waterbase - TCM: QualityBiota

The QualityBiota table contains aggregated data on hazardous substances in biota, measured at Eurowaternet transitional, coastal or marine water monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressure data.

[+] Show table definition (records:   40145)

HighRangeNoOfSamples 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
DryDreshNoOfSamples 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 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) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
LowRangeNoOfSamples 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
Unit Unit unit of measurement. nvarchar(30) 0
Aggregationperiod Aggregation period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. nvarchar(20) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
FatMinimum Fat minimum minimum fat content of biota expressed as % of total wet matter. float(8) 0
FatMaximum Fat 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 mean mean fat content of biota expressed as % of total wet matter. float(8) 0
HighRange90Percentile 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
HighRangeMaximum 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
LowRangeMedian 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
HighRangeMean High range mean average 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
HighRangeMedian 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
LowRangeMinimum 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
LowRange10Percentile 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
LowRangeMean Low range mean Average concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). float(8) 0
Tissue Tissue code of tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. varchar(2) 0
Basis Basis basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. varchar(1) 0
CountryCode Country Code ISO3166 two digit code. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
Species Species code of species monitored. varchar(20) 0
Waterbase - TCM: Discharges

The Discharges table contains data on the yearly direct discharges to transitional, coastal or marine waters.

[+] Show table definition (records:   42)

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
SeaConventionArea Sea convention area marine Convention area of which regional sea is a part: BSC, HELCOM, HELCOM/OSPAR, OSPAR, UNEP/MAP. nvarchar(100) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
WaterBodyName Water body name water body name as defined for the Water Framework Directive. nvarchar(200) 0
SeaAreaName Sea area name name of local sea area in which direct discharge enters. WaterBodyName and SeaAreaName may be the same. nvarchar(200) 0
SeaRegionName Sea region name name of regional sea of which sea area is a part. nvarchar(200) 0
Value Value 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 Country code 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

Additional information

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.

 
Document Actions

Comments

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