Waterbase - TCM: QualityWater

Data Table

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)

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

Data and maps

Menu

Category

European data

Records

247595

Table definition

Year	Year	year of aggregation period or year in which sample taken, in format YYYY.	int(4)	0
PeriodLength	Period length	number of months in aggregation period.	int(4)	0
NoOfObservations	Number of observations	number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.	int(4)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years.	nvarchar(20)	0
Determinand	Determinand	determinand name.	nvarchar(200)	0
Unit	Unit	unit of measurement.	nvarchar(30)	0
MeanSalinity	Mean salinity	average salinity of samples included in aggregate.	float(8)	0
MinimumDepth	Minimum depth	minimum depth limit for samples included in aggregate expressed in m.	float(8)	0
MaximumDepth	Maximum depth	maximum depth limit for samples included in aggregate expressed in m.	float(8)	0
Mean	Mean	mean concentration value in aggregation period.	float(8)	0
Minimum	Minimum	minimum concentration value in aggregation period.	float(8)	0
Maximum	Maximum	maximum concentration during aggregation period.	float(8)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	varchar(2)	0
WaterbaseID	Waterbase ID	Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345).	varchar(200)	-1
AggregationMethod	Aggregation method	description of aggregation process: MeanOfMinimum = Minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean = Average of all samples on same date and in same depth profile calculated then average of averages calculated by year.	varchar(20)	0