Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

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


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

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

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.
Category
European data
Records
16711
Table definition
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. int(4) -1
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. int(4) -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. int(4) -1
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) -1
Unit Unit unit of measurement. nvarchar(30) 0
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 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(255) -1
CASNo Chemical Abstract Service Number Chemical Abstract Service Number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(255) -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 <. float(8) 0
DryFreshRatio Dry fresh ratio ratio of dry weight to fresh weight as a percentage. float(8) 0
Fat Fat fat content as a percentage of total wet matter. float(8) 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
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. varchar(2) 0
Basis Basis basis of measurement. D=dry, L=lipid (fat), W=wet. varchar(1) 0
LimitOfDetectionFlag Limit of detection or determination flag flag to indicate sample below analytical limit of detection or determination in format <. varchar(1) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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