Waterbase - TCM: Input
|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|
|Load||Load||estimated load of determinand.||real(4)||0|
|CountryCode||Country code||abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.||nvarchar(2)||-1|
|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(60)||-1|
|NationalStationID||National station ID||Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level.||nvarchar(50)||0|
|CASNumber||CAS Number||Chemical Abstract Service Number of the hazardous substance, as defined in the codelist.||nvarchar(10)||0|
|Unit||Unit||unit of measurement.||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)||0|
|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|
For references, please go to www.eea.europa.eu/soer or scan the QR code.
This briefing is part of the EEA's report The European Environment - State and Outlook 2015. The EEA is an official agency of the EU, tasked with providing information on Europe’s environment.
PDF generated on 30 Jan 2015, 02:23 AM