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

European data

Waterbase - TCM (11 tables)

Dataset contains data on physical characteristics of the transitional, coastal and marine water monitoring and flux stations, proxy pressures on the upstream catchment, basin and River Basin District associated with transitional and coastal waters, chemical quality data on nutrients in seawater and hazardous substances in biota, sediment and seawater, as well as data on direct discharges and riverine input loads.

Station is reference station - 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.

text(1)

PhysChemStation

Physico-chemical category of the station

text(1)

WaterBodyID

National identification code of water body in which station is located

text(50)

WaterBodyName

Name of water body in which station is located.

text(255)

SeaAreaName

Name of the local sea into which the river discharges or in which the TCM station is located.

text(150)

SeaRegionName

Name of regional sea of which local sea area is a part.

text(150)

SeaConventionArea

Name of Marine Convention area of which regional sea is a part.

text(50)

StationReporting

Reporting purpose of the transitional, coastal or marine water monitoring station.

EC - European Commission purposes only ECMC - European Commission and Marine Convention purposes ECMCN - European Commission, Marine Convention and national purposes ECN - European Commission and national purposes MC - Marine Convention purposes only MCN - Marine Convention and national purposes N - National purposes only

text(5)

MainlandCoast

Distance of marine monitoring station from nearest mainland coast in kilometres.

single

ClosestCoast

Distance of marine monitoring station from closest coast in kilometres.

single

TCMMatrix

Environmental compartments measured at transitional, coastal or marine water monitoring station, as defined in the codelist.

Proxy pressures on the upstream catchment or drainage basin of the transitional water or the area within the River Basin District to which the coastal water has been assigned, relating to flux stations.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

Disaggregated data on nutrients, organic matter and general physico-chemical determinands in seawater, measured at WISE-SoE transitional, coastal or marine water monitoring stations, provided by national sources only.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

Disaggregated data on hazardous substances and other chemical determinands in seawater, measured at WISE-SoE transitional, coastal or marine water monitoring stations, provided by national sources and Marine Conventions.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

Disaggregated data on hazardous substances and other chemical determinands in sediment, measured at WISE-SoE transitional, coastal or marine water monitoring stations, provided by national sources and Marine Conventions.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

Disaggregated data on hazardous substances and other chemical determinands in biota, measured at WISE-SoE transitional, coastal or marine water monitoring stations, provided by national sources and Marine Conventions.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

Identifier of the TCM flux station or monitoring station, all unique at the national level.

text(100)

Year

Year of aggregation period in which samples were taken/Year in which sample was taken.

long

Determinand_InputDischarge

Name of riverine inputs determinand.

text(100)

CASNumber

Chemical Abstract Service Number of the hazardous substance or other chemical determinand.

text(64)

Unit_InputDischarge

Unit of measurement of riverine input.

text(20)

Estimate

Estimate type.

L - Lower estimate based on treating concentration values that are below the limits of detection or determination as zero U - Upper estimate based on treating concentration values that are below the limits of detection or determination as equivalent to the value of the limits of detection or determination X - Unspecified

List of codes of station data issues detected in the record. Details are explained in the QA documentation.

text(100)

QA_DDviolations

Quality assessment field - data definition errors

List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation.

memo

Direct Discharges (Waterbase_TCM_v9_Discharges, 3624 records)

Data on direct discharges to transitional, coastal and marine waters which are monitored at flux stations, provided by national sources or Marine Conventions.

Field name

Definition

Note

data type

RecordID

Unique record identifier

long

RecordReported

Date when the record was reported by the data provider.

text(10)

CountryCode

Abbreviation of EEA Member or Collaborating Country from which territory the data come from.

ISO 3166-1-alpha-2 code elements

text(2)

WaterBodyID

National identification code of water body in which station is located

text(50)

WaterBodyName

Name of water body in which station is located.

text(255)

SeaAreaName

Name of the local sea into which the river discharges or in which the TCM station is located.

text(150)

SeaRegionName

Name of regional sea of which local sea area is a part.

text(150)

SeaConventionArea

Name of Marine Convention area of which regional sea is a part.

text(50)

Year

Year of aggregation period in which samples were taken/Year in which sample was taken.

long

DischargeType

Information on discharge type.

I - Industrial discharge M - Municipal discharge T - Total discharge

text(1)

Determinand_InputDischarge

Name of direct discharge determinand.

text(100)

CASNumber

Chemical Abstract Service Number of the hazardous substance or other chemical determinand.

text(64)

Unit_InputDischarge

Unit of measurement of direct discharge.

text(20)

Estimate

Estimate type.

L - Lower estimate based on treating concentration values that are below the limits of detection or determination as zero U - Upper estimate based on treating concentration values that are below the limits of detection or determination as equivalent to the value of the limits of detection or determination X - Unspecified

QA documentation

Quality control documentation briefly presents ETC/ICM and EEA activities focused on quality of Waterbase-TCM dataset and results of these activities. In addition warning is given on the use of certain records for analytical purposes.

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.

Data sources

The European Topic Centre on Inland, Coastal and Marin waters. Version 9, date of delivery (date sent to the Data Service): 04/07/2012.

Additional information

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

Check with your local authorities for their advice as they might recommend that you take it to a special disposal site, or to a garage which collects them for recycling and proper disposal.
More green tips