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

40 min read

This is an old version, kept for reference only.

Go to latest version

Topics: Water and marine environment

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: 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) and Pressures data.

[+] Show table definition (records: 147)

Longitude	Longitude	(X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided.	numeric(5)	0
Latitude	Latitude	(Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
Country	Country name	official short name in English. ISO 3166-1.	nvarchar(100)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
DataSource	Data source	source of data: Eionet-Water, ICES.	nvarchar(50)	0
WaterDataSet	Water data set	RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity.	nvarchar(10)	0
WaterbaseName	Waterbase name	national name of station or groundwater body.	nvarchar(200)	0
SeaRegionName	Sea region name	name of regional sea of which local sea area is a part.	nvarchar(50)	0
SeaConventionArea	Marine convention area	name of Marine Convention area of which regional sea is a part.	nvarchar(20)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
NationalStationID	National station ID	identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station.	nvarchar(50)	0
RiverName	River name	national name of river.	nvarchar(50)	0
CatchmentName	Catchment name	name of major catchment or basin.	nvarchar(100)	0
WaterBodyID	Water body ID	national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(50)	0
WaterBodyName	Water body name	name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(50)	0
SeaAreaName	Sea area name	name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName.	nvarchar(50)	0

waterbase_tcm_fluxstations_v4.xls (Microsoft Excel spreadsheet)
48.00 KB Download file
waterbase_tcm_fluxstations_v4.csv (text/comma-separated-values)
24.22 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 Flux Stations data.

[+] Show table definition (records: 50)

OtherDischarge	Other discharge	direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) 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.	bit(1)	0
OilExtraction	Oil extraction	exploration for or extraction of oil in the transitional, coastal or marine water body. Y = yes, N = no.	bit(1)	0
GasExtraction	Gas extraction	exploration for or extraction of gas in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
Spoil	Spoil	dredged spoil disposal ground in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
Waste	Waste	waste disposal ground in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
LandFill	Landfill	transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites. Y=yes, N=no.	bit(1)	0
Mariculture	Mariculture	fish and shellfish farming in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
Fishing	Fishing	commercial fishing activity in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
Marina	Marina	presence of a marina in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
Port	Port	presence of port facilities in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
OtherActivities	Other activities	any other activities in the transitional, coastal or marine water body. Y=yes, N=no.	bit(1)	0
PopulationDensity	Population density	population density of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set) in capita/km².	numeric(5)	0
LanduseUrban	Urban land use	urban agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 1.1.	numeric(5)	0
LanduseWetland	Wetland land use	wetland agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 4.1 plus 4.2.	numeric(5)	0
LanduseNature	Natural land use	natural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.2 plus 3.3.	numeric(5)	0
LanduseForest	Landuse forest	forested land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.1.	numeric(5)	0
LanduseTotalAgriculture	Total agricultural land use	total agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.	numeric(5)	0
LanduseOtherAgriculture	Other agricultural land use	other agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.2 plus 2.4.	numeric(5)	0
LanduseArableLand	Arable land use	arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1.	numeric(5)	0
LandusePasture	Pastoral land use	pastoral land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1.	numeric(5)	0
LanduseOther	Other land use	other land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set).	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
SewageDischarge	Sewage discharge	direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) 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.	nvarchar(2)	0
IndustrialDischarge	Industrial discharge	direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) 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.	nvarchar(2)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_tcm_pressures_v4.csv (text/comma-separated-values)
6.08 KB Download file
waterbase_tcm_pressures_v4.xls (Microsoft Excel spreadsheet)
22.50 KB 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 data.

[+] Show table definition (records: 70366)

PeriodLength	Period length	number of months in aggregation period.	tinyint(1)	0
DryFreshNoOfSamples	Dry fresh ratio number of samples	number of samples taken in ratio of dry weight to fresh weight as a percentage.	tinyint(1)	0
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	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).	smallint(2)	0
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).	smallint(2)	0
FatNoOfSamples	Fat content number of samples	number of samples of fat content as a percentage of total wet matter.	smallint(2)	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).	numeric(9)	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).	numeric(9)	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).	numeric(13)	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).	numeric(9)	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).	numeric(13)	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).	numeric(9)	0
FatMinimum	Fat content minimum	minimum fat content as a percentage of total wet matter.	numeric(5)	0
FatMaximum	Fat content maximum	maximum fat content as a percentage of total wet matter.	numeric(5)	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).	numeric(9)	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).	numeric(13)	0
DryFreshMean	Dry fresh ratio mean	mean ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
DryFreshMinimum	Dry fresh ratio minimum	minimum ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
DryFreshMaximum	Dry fresh ratio maximum	maximum ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
FatMean	Fat content mean	mean fat content as a percentage of total wet matter.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).	nvarchar(20)	-1
Species	Species	species monitored.	nvarchar(10)	-1
Tissue	Tissue	tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body.	nvarchar(2)	-1
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet.	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

Ascii delimited (zip) (ZIP archive)
1.30 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 data.

[+] Show table definition (records: 924)

GrainType	Grain type	sediment type description. M=mud, FS=fine sand, MS=middle sand, CS=coarse sand, S=sand, unspecified coarseness, G=gravel.	nvarchar(2)	0
LimitOfDetectionFlag	Limit of detection or determination flag	flag to indicate sample below analytical limit of detection or determination in format <.	nvarchar(1)	0
Sampler	Sampler	name of sampling equipment used.	nvarchar(100)	0
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet, X=unknown.	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
Month	Month	month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.	tinyint(1)	-1
Day	Day	day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.	tinyint(1)	-1
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	0
Fraction	Fraction	upper limit of particle size in analysed fraction in µm.	smallint(2)	0
SedimentTop	Top of sediment layer	top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface.	smallint(2)	-1
SedimentBottom	Bottom of sediment layer	bottom of analysed sediment layer measured from the sediment surface in cm.	smallint(2)	-1
Concentration	Concentration	concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <.	numeric(9)	0
BottomDepth	Bottom depth of sediment	depth of sea bottom at sampling site in m.	numeric(5)	0
OrganicCarbon	Organic carbon	organic carbon content as a percentage of total dry weight.	numeric(5)	0
DryWetRatio	Dry wet ratio	ratio of dry weight to wet weight as a percentage.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
SampleID	Sample ID	unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0

waterbase_tcm_qualitysedimentd_v4.xls (Microsoft Excel spreadsheet)
222.50 KB Download file
waterbase_tcm_qualitysedimentd_v4.csv (text/comma-separated-values)
117.72 KB 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: 141)

Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)
Load	Load	estimated load of determinand.	numeric(9)
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)
Country	Country name	official short name in English. ISO 3166-1.	nvarchar(100)
WaterBodyID	Water body ID	national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(50)
WaterBodyName	Water body name	name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(50)
SeaAreaName	Sea area name	name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName.	nvarchar(50)
SeaRegionName	Sea region name	name of regional sea of which local sea area is a part.	nvarchar(50)
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.	nvarchar(10)
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)
SeaConventionArea	Marine convention area	name of Marine Convention area of which regional sea is a part.	nvarchar(20)
DischargeType	Discharge type	I=industrial, M=municipal, T=total.	nvarchar(1)
Determinand	Determinand	determinand name.	nvarchar(100)
Unit	Unit	unit of measurement.	nvarchar(20)
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)
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.	nvarchar(1)

waterbase_tcm_discharges_v4.csv (text/comma-separated-values)
17.81 KB Download file
waterbase_tcm_discharges_v4.xls (Microsoft Excel spreadsheet)
37.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 data.

[+] Show table definition (records: 6644)

Month	Month	month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.	tinyint(1)	-1
Day	Day	day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.	tinyint(1)	-1
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
Concentration	Concentration	concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to .	numeric(9)	0
SampleDepth	Sample depth	depth at which sample taken in m below water surface	numeric(5)	-1
Salinity	Salinity	salinity of sample.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
SampleID	Sample ID	unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
LimitOfDetectionFlag	Limit of detection or determination flag	flag to indicate sample below analytical limit of detection or determination in format .	nvarchar(1)	0
ThermoPos	Thermocline position	vertical position relative to thermocline at transitional, coastal and marine water station. AT=above thermocline, IT=in thermocline, BT=below thermocline.	nvarchar(2)	0
HaloPos	Halocline position	vertical position relative to halocline at transitional, coastal and marine water station. AH=above halocline, IH=in halocline, BH=below halocline.	nvarchar(2)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_tcm_qualityhswaterd_v4.csv (text/comma-separated-values)
664.56 KB Download file
waterbase_tcm_qualityhswaterd_v4.xls (Microsoft Excel spreadsheet)
1.15 MB Download file

Waterbase-TCM: Microsoft Access database (13 tables)

Database contains all data tables. Includes also simple relation structure. Detailed table definitions are displayed in the sections with individual tables.

Microsoft Access format (zip) (ZIP archive)
23.21 MB 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 data.

[+] Show table definition (records: 2321)

PeriodLength	Period length	number of months in aggregation period.	tinyint(1)	0
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
NoOfObservations	Number of observations	number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.	smallint(2)	0
Mean	Mean	mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Minimum	Minimum	minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Maximum	Maximum	maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
MinimumDepth	Minimum depth	minimum depth limit for samples included in aggregate in m.	numeric(5)	0
MaximumDepth	Maximum depth	maximum depth limit for samples included in aggregate in m.	numeric(5)	0
SalinityMean	Mean salinity	mean salinity measured at transitional, coastal or marine water station.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).	nvarchar(20)	-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.	nvarchar(50)	0

waterbase_tcm_qualityhswater_v4.csv (text/comma-separated-values)
267.36 KB Download file
waterbase_tcm_qualityhswater_v4.xls (Microsoft Excel spreadsheet)
542.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 data.

[+] Show table definition (records: 27039)

Month	Month	month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.	tinyint(1)	-1
Day	Day	day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.	tinyint(1)	-1
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
Concentration	Concentration	concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <.	numeric(9)	0
DryFreshRatio	Dry fresh ratio	ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
Fat	Fat	fat content as a percentage of total wet matter.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
SampleID	Sample ID	unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
Species	Species	species monitored.	nvarchar(10)	-1
Tissue	Tissue	tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body.	nvarchar(2)	-1
LimitOfDetectionFlag	Limit of detection or determination flag	flag to indicate sample below analytical limit of detection or determination in format <.	nvarchar(1)	0
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet.	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

Ascii delimited (zip) (ZIP archive)
191.59 KB Download file
Microsoft Excel format (zip) (ZIP archive)
1.06 MB Download file

Waterbase - TCM: Input

The Input table contains data on the yearly riverine input 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: 6334)

Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
Load	Load	estimated load of determinand.	numeric(9)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	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.	nvarchar(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.	nvarchar(10)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_tcm_input_v4.csv (text/comma-separated-values)
518.23 KB Download file
waterbase_tcm_input_v4.xls (Microsoft Excel spreadsheet)
874.50 KB 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 data.

[+] Show table definition (records: 236726)

PeriodLength	Period length	number of months in aggregation period.	tinyint(1)	0
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
NoOfObservations	Number of observations	number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.	smallint(2)	0
Mean	Mean	mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Minimum	Minimum	minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Maximum	Maximum	maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
MinimumDepth	Minimum depth	minimum depth limit for samples included in aggregate in m.	numeric(5)	0
MaximumDepth	Maximum depth	maximum depth limit for samples included in aggregate in m.	numeric(5)	0
SalinityMean	Mean salinity	mean salinity measured at transitional, coastal or marine water station.	numeric(9)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).	nvarchar(20)	-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.	nvarchar(50)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

Ascii delimited (zip) (ZIP archive)
3.07 MB Download file

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 data.

[+] Show table definition (records: 847)

PeriodLength	Period length	number of months in aggregation period.	tinyint(1)	0
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
Fraction	Fraction	upper limit of particle size in analysed fraction in µm.	smallint(2)	0
NoOfSamples	Number of samples	number of samples in aggregation period.	smallint(2)	0
SedimentTop	Top of sediment layer	top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface. Value -1 means that this information is not available.	smallint(2)	-1
SedimentBottom	Bottom of sediment layer	bottom of analysed sediment layer measured from the sediment surface in cm. Value -1 means that this information is not available.	smallint(2)	-1
Mean	Mean	mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Minimum	Minimum	minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
Maximum	Maximum	maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	numeric(9)	0
BottomDepth	Bottom depth of sediment	depth of sea bottom at sampling site in m.	numeric(5)	0
OrganicCarbon	Organic carbon	organic carbon content as a percentage of total dry weight.	numeric(5)	0
DryWetRatio	Dry wet ratio	ratio of dry weight to wet weight as a percentage.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).	nvarchar(20)	-1
GrainType	Grain type	sediment type description. M=mud, FS=fine sand, MS=middle sand, CS=coarse sand, S=sand, unspecified coarseness, G=gravel.	nvarchar(2)	0
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet, X=unknown.	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_tcm_qualitysediment_v4.xls (Microsoft Excel spreadsheet)
230.00 KB Download file
waterbase_tcm_qualitysediment_v4.csv (text/comma-separated-values)
105.93 KB 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 data.

[+] Show table definition (records: 1099536)

Month	Month	month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.	tinyint(1)	-1
Day	Day	day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.	tinyint(1)	-1
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	smallint(2)	-1
Concentration	Concentration	concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <.	numeric(9)	0
SampleDepth	Sample depth	depth at which sample taken in m below water surface	numeric(5)	-1
Salinity	Salinity	salinity of sample.	numeric(9)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
SampleID	Sample ID	unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.	nvarchar(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
LimitOfDetectionFlag	Limit of detection or determination flag	flag to indicate sample below analytical limit of detection or determination in format <.	nvarchar(3)	0
ThermoPos	Thermocline position	vertical position relative to thermocline at transitional, coastal and marine water station. AT=above thermocline, IT=in thermocline, BT=below thermocline.	nvarchar(2)	0
HaloPos	Halocline position	vertical position relative to halocline at transitional, coastal and marine water station. AH=above halocline, IH=in halocline, BH=below halocline.	nvarchar(2)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

Ascii delimited (zip) (ZIP archive)
7.93 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 data.

[+] Show table definition (records: 35662)

SeaResidence	Residence time	residence time of transitional or coastal water body in days.	smallint(2)	0
ReferenceStation	Reference Station	reference station type, found in catchments or associated River Basin Districts with little or no human activity, natural landscape higher than 90%, and minimally impacted by inflow from adjacent coastal or marine waters. Concentrations of nutrients or hazardous substances occurring naturally would give an indication of background levels. For volatile sunthetic substances, data from these stations might be used to assess the significance of atmospheric deposition. River and lake stations can be of more than one type. 1=yes, 0=no.	bit(1)	0
Longitude	Longitude	(X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided.	numeric(5)	0
Latitude	Latitude	(Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided.	numeric(5)	0
MainlandCoast	Mainland coast	distance of marine station from nearest mainland coast expressed in km.	numeric(5)	0
ClosestCoast	Closest coast	distance of marine station from closest coast expressed in km. Only shown if different from MainlandCoast.	numeric(5)	0
SalinityMean	Mean annual salinity	mean annual salinity measured at transitional, coastal or marine water station.	numeric(9)	0
SalinityMinimum	Minimum annual salinity	minimum annual salinity measured at transitional, coastal or marine water station.	numeric(9)	0
SalinityMaximum	Maximum annual salinity	maximum annual salinity measured at transitional, coastal or marine water station.	numeric(9)	0
Temperature	Mean annual temperature	mean annual temperature at transitional, coastal or marine water station in degrees Celsius.	numeric(5)	0
TidalMean	Mean tidal range	mean tidal range at transitional, coastal or marine water station in m.	numeric(5)	0
SeaDepth	Mean annual depth	mean annual sea depth at transitional, coastal or marine water station in m.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	0
Country	Country name	official short name in English. ISO 3166-1.	nvarchar(100)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(50)	-1
DataSource	Data source	source of data: Eionet-Water, ICES.	nvarchar(50)	0
WaterDataSet	Water data set	RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity.	nvarchar(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.	nvarchar(20)	0
SeaConventionArea	Marine Convention Area	name of Marine Convention area of which regional sea is a part.	nvarchar(20)	0
StationReporting	Station reporting purpose	reporting purpose of the transitional, coastal or marine water 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).	nvarchar(5)	0
TCMMatrix	Matrix	environmental compartments measured at transitional, coastal or marine water station. B=biota, S=sediment, W=water column. Any combination allowed, listed alphabetically with no separator (e.g. BSW).	nvarchar(3)	0
Mixing	Mixing characteristics	mixing characteristics at transitional, coastal or marine water monitoring station: FM = Fully mixed, PM = Partially mixed, VS = Vertically stratified.	nvarchar(2)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
PhysChemStation	Physico-Chemicals category station	physico-chemical conditions monitored at station. R=represenatative station type, I=impact station type.	nvarchar(1)	0
HazsubsStation	Hazardous substances category station	hazardous substances monitored at station type: R = Represenatative station, I = Impact station.	nvarchar(1)	0
WaterBodyID	Water body ID	national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(50)	0
WaterBodyName	Water body name	name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.	nvarchar(100)	0
SeaAreaName	Sea area name	name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName.	nvarchar(100)	0
SeaRegionName	Sea region name	name of regional sea of which local sea area is a part.	nvarchar(50)	0
WaterBodyType	Water body type	RV=river, CN=canal, T=transitional water, C=coastal water, M=marine water.	nvarchar(1)	0
WaterBodyTypeDesc	Water body type description	additional water body description, e.g. Bay, Coastal Lagoon, Embayment, Estuary, Fjord.	nvarchar(50)	0
WaterbaseName	Waterbase name	national name of station or groundwater body.	nvarchar(200)	0
NationalStationID	National Station ID	identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station.	nvarchar(50)	0
CatchmentName	Catchment name	name of major catchment or basin.	nvarchar(100)	0
Region	Region	national region in which water body is located.	nvarchar(50)	0

Ascii delimited (zip) (ZIP archive)
513.15 KB Download file
Microsoft Excel format (zip) (ZIP archive)
1.83 MB Download file

Additional information

Waterbase - TCM: Determinands

Document contains list of all determinands and units used in Waterbase-TCM version 4.

Waterbase - TCM: Determinands (PDF document)
146.19 KB Download file

Country codes and abbreviations (27 records)

Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-TCM version 4

Country codes and abbreviations (27 records) (text/comma-separated-values)
399 Bytes Download file

Tables metadata (6 Ascii delimited files)

Files contain metadata definitions of all data tables.

Tables metadata (6 Ascii delimited files) (ZIP archive)
12.41 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).

Disclaimer:

Data in Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.

Methodology:

Used tools: Microsoft SQL Server 2005, Microsoft Access, Microsoft Excel Applied procedures: MDB database was created by export from SQL Server. Text fields were cleared of trailing spaces. Simple relation structure was added. Whole database was compacted. XLS, CSV files was created from MDB database tables. special features: CSV files - text qualifier is ' " ' character, field separator is ',' character, line breaks were changed to <br /> string.

Units:

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

Data sources

The European Topic Centre on Water. Version 4, date of delivery (date sent to the Data Service): 20/12/2006.

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.

Permalinks

Permalink to this version: A2D347BE-6AB9-4284-A328-F025E5A0DFC1
Permalink to latest version: DAT-12-en

Older versions

01 Jan 2002 - Waterbase - Transitional, coastal and marine waters

Geographic coverage

Albania Belgium Bosnia and Herzegovina Bulgaria Croatia Denmark Estonia Finland France Germany Greece Iceland Ireland Italy Latvia Lithuania Malta Netherlands Norway Poland Portugal Romania Slovenia Spain Sweden Turkey United Kingdom