Data

Waterbase - Transitional, coastal and marine waters

Data

Prod-ID: DAT-12-en

Created 01 Jan 2002 Published 01 Jan 2002 Last modified 15 Dec 2022

38 min read

This page was archived on 26 Jun 2015 with reason: Other (New version data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-11 was published)

Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources

Data and maps

Menu

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

qualitysediment_tcm_en_v2.mdb (application/msaccess)
2.62 MB Download file
qualitysediment_tcm_en_v2.csv (text/comma-separated-values)
1.59 MB Download file
qualitysediment_tcm_en_v2.xls (Microsoft Excel spreadsheet)
2.89 MB Download file
qualitysediment_tcm_en_v2.dbf (dBASE document)
8.91 MB Download file

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

tcm_fluxstations_en_v2.csv (text/comma-separated-values)
43.26 KB Download file
tcm_fluxstations_en_v2.dbf (dBASE document)
596.27 KB Download file
tcm_fluxstations_en_v2.mdb (application/msaccess)
172.00 KB Download file
tcm_fluxstations_en_v2.xls (Microsoft Excel spreadsheet)
90.50 KB Download file

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

qualitybiotad_tcm_en_v2.mdb (application/msaccess)
2.26 MB Download file
qualitybiotad_tcm_en_v2.csv (text/comma-separated-values)
1.36 MB Download file
qualitybiotad_tcm_en_v2.dbf (dBASE document)
7.07 MB Download file
qualitybiotad_tcm_en_v2.xls (Microsoft Excel spreadsheet)
2.22 MB Download file

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

qualitysedimentd_tcm_en_v2.mdb (application/msaccess)
2.69 MB Download file
qualitysedimentd_tcm_en_v2.xls (Microsoft Excel spreadsheet)
2.63 MB Download file
qualitysedimentd_tcm_en_v2.dbf (dBASE document)
11.58 MB Download file
qualitysedimentd_tcm_en_v2.csv (text/comma-separated-values)
1.60 MB Download file

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

inputs_tcm_en_v2.csv (text/comma-separated-values)
1.23 MB Download file
inputs_tcm_en_v2.mdb (application/msaccess)
2.03 MB Download file
inputs_tcm_en_v2.dbf (dBASE document)
7.76 MB Download file
inputs_tcm_en_v2.xls (Microsoft Excel spreadsheet)
2.16 MB Download file

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

Access 2000 (zip) (ZIP archive)
628.47 KB Download file
ASCII Delimited (zip) (ZIP archive)
478.50 KB Download file
DBaseIV (zip) (ZIP archive)
937.32 KB Download file
Excel 2000 (zip) (ZIP archive)
2.14 MB Download file

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

Access 2000 (zip) (ZIP archive)
4.77 MB Download file
ASCII Delimited (zip) (ZIP archive)
3.27 MB Download file

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

Access 2000 (zip) (ZIP archive)
1.63 MB Download file
ASCII Delimited (zip) (ZIP archive)
1.06 MB Download file
DBaseIV (zip) (ZIP archive)
1.60 MB Download file
Excel 2000 (zip) (ZIP archive)
4.70 MB Download file

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

Access 2000 (zip) (ZIP archive)
7.25 MB Download file
ASCII Delimited (zip) (ZIP archive)
5.04 MB Download file

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)
SeaRegionName	Sea region name	regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature.	nvarchar(200)
SeaConventionArea	Marine Convention Area	name of Marine Convention area.	nvarchar(200)
Determinand	Determinand	determinand name.	nvarchar(200)
CaSNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)
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)
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)
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)
Load	Load	estimated load of determinand.	float(8)
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)
CountryCode	CountryCode	ISO 3166-alpha-2 code elements	varchar(2)
DischargeType	Discharge type	I = Industrial, M = Municipal, T = Total.	varchar(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)
Unit	Unit	unit of measurement.	nvarchar(30)

discharges_tcm_en_v2.mdb (application/msaccess)
120.00 KB Download file
discharges_tcm_en_v2.xls (Microsoft Excel spreadsheet)
28.00 KB Download file
discharges_tcm_en_v2.csv (text/comma-separated-values)
9.46 KB Download file
discharges_tcm_en_v2.dbf (dBASE document)
118.62 KB Download file

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

qualityhswater_tcm_en_v2.csv (text/comma-separated-values)
47.63 KB Download file
qualityhswater_tcm_en_v2.dbf (dBASE document)
240.42 KB Download file
qualityhswater_tcm_en_v2.mdb (application/msaccess)
200.00 KB Download file
qualityhswater_tcm_en_v2.xls (Microsoft Excel spreadsheet)
98.00 KB Download file

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

tcm_pressures_en_v2.csv (text/comma-separated-values)
25.37 KB Download file
tcm_pressures_en_v2.dbf (dBASE document)
87.35 KB Download file
tcm_pressures_en_v2.mdb (application/msaccess)
160.00 KB Download file
tcm_pressures_en_v2.xls (Microsoft Excel spreadsheet)
119.00 KB Download file

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

qualityhswaterd_tcm_en_v2.mdb (application/msaccess)
404.00 KB Download file
qualityhswaterd_tcm_en_v2.csv (text/comma-separated-values)
202.03 KB Download file
qualityhswaterd_tcm_en_v2.xls (Microsoft Excel spreadsheet)
369.00 KB Download file
qualityhswaterd_tcm_en_v2.dbf (dBASE document)
1.16 MB Download file

Additional information

TCM: metadata (fields description) of the 13 tables

TCM: metadata (fields description) of the 13 tables (ZIP archive)
17.15 KB Download file

Waterbase TCM: determinands and units

Waterbase TCM: determinands and units (PDF document)
252.10 KB Download file

Metadata

Reporting obligations (ROD)

WISE SoE - Water quality (WISE-6)

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Units:

Determinands and units used in the data base are listed in the "pdf" document called "Determinand and units in Waterbase TCM" available within the "Additional information" section.

Data sources

The European Topic Centre on Water. Version 2, date of delivery (date sent to the Data Service): 29/03/2005.

Owners:

European Environment Agency (EEA)

Processors:

European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

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.

For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-1 or scan the QR code.

PDF generated on 11 May 2024, 01:29 AM