title,note,,, 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. ",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes CASNumber,CAS Number,"Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. ",nvarchar(10), Determinand,Determinand,determinand name. ,nvarchar(30), DischargeType ,Discharge type,"I=industrial, M=municipal, T=total. ",nvarchar(1), 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), Load,Load,estimated load of determinand. ,real(4), 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), 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(255), SeaConventionArea,Marine convention area,name of Marine Convention area of which regional sea is a part.,nvarchar(20), SeaRegionName,Sea region name,name of regional sea of which local sea area is a part.,nvarchar(255), Unit,Unit,unit of measurement. ,nvarchar(10), 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(20), 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(255), 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), title,note,,, 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 uni",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes CASNumber,CAS Number,"Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. ",nvarchar(10), Determinand,Determinand,determinand name. ,nvarchar(30), 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), Load,Load,estimated load of determinand. ,real(4), 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), NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50), Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255), Unit,Unit,unit of measurement. ,nvarchar(20), 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), title,note,,, Waterbase-TCM: HazSubs Biota ,"The HSBiota 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 ide",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes Basis,Basis,"basis of measurement. D=dry, L=lipid (fat), W=wet. ",nvarchar(1), CASNumber,CAS Number,"Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. ",nvarchar(30), 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), DataSource,Data source ,"source of data: Eionet, ICES, MEDPOL. ",nvarchar(10), 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) Determinand,Determinand,determinand name. ,nvarchar(100) Drywetratio,Dry wet ratio,ratio of dry weight to wet weight as a percentage. ,float(8) Fat,Fat,fat content as a percentage of total wet matter.,float(8) LimitOfDetectionFlag,Limit of detection or determination flag,flag to indicate sample below analytical limit of detection or determination in format <. ,nvarchar(2) 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) NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50) SampleID,Sample ID,unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. ,nvarchar(20) Species,Species,species monitored. ,nvarchar(50) Tissue,Tissue,"tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body. ",nvarchar(5) Unit,Unit,unit of measurement.,nvarchar(5) 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) title,note,, Waterbase-TCM: HazSubs Sediment ,"The HSSediment 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 Waterba",, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes Basis,Basis,"basis of measurement. D=dry, L=lipid (fat), W=wet, X=unknown. ",nvarchar(1), BottomDepth,Bottom depth of sediment,depth of sea bottom at sampling site in m. ,float(8), Casnumber,CAS Number,"Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. ",nvarchar(30), 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), DataSource,Data source ,"source of data: Eionet, ICES, MEDPOL. ",nvarchar(10), 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), Determinand,Determinand,determinand name. ,nvarchar(100), DryWetRatio ,Dry wet ratio,ratio of dry weight to wet weight as a percentage. ,float(8), Fraction,Fraction ,upper limit of particle size in analysed fraction in µm.,nvarchar(6), GrainType ,Grain type,"sediment type description. M=mud, FS=fine sand, MS=middle sand, CS=coarse sand, S=sand, unspecified coarseness, G=gravel. ",nvarchar(15), LimitOfDetectionFlag,Limit of detection or determination flag,flag to indicate sample below analytical limit of detection or determination in format <. ,nvarchar(4), 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), Nationalstationid,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50), Organic carbon,Organic carbon,organic carbon content as a percentage of total dry weight. ,float(8), SampleID,Sample ID,unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. ,nvarchar(20), Sampler,Sampler,name of sampling equipment used.,nvarchar(30), SedimentBottom,Bottom of sediment layer,bottom of analysed sediment layer measured from the sediment surface in cm. ,float(8), 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. ,float(8), Unit,Unit,unit of measurement.,nvarchar(13), 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), title,note,,, Waterbase-TCM: HazSubs Water ,"The HSWater 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 ",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes CASNumber,CAS Number,"Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. ",nvarchar(30) 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) DataSource,Data source ,"source of data: Eionet, ICES, MEDPOL. ",nvarchar(10) 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) Determinand,Determinand,determinand name. ,nvarchar(100) 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(15) LimitOfDetectionFlag,Limit of detection or determination flag,flag to indicate sample below analytical limit of detection or determination in format .,nvarchar(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) NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50) Salinity,Salinity,salinity of sample.,float(8) SampleDepth,Sample depth,depth at which sample taken in m below water surface ,float(8) SampleID,Sample ID,unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. ,nvarchar(20) 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(15) Unit,Unit,unit of measurement.,nvarchar(5) 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) title,note,,, Waterbase-TCM: Quality ,"The Quality 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 u",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes 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), DataSource,Data source ,"source of data: Eionet, ICES, MEDPOL. ",nvarchar(10), 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), Determinand,Determinand,determinand name. ,nvarchar(50), 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(15), LimitOfDetectionFlag,Limit of detection or determination flag,flag to indicate sample below analytical limit of detection or determination in format <. ,nvarchar(3), 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), NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50), Salinity,Salinity,salinity of sample.,nvarchar(10), SampleDepth,Sample depth,depth at which sample taken in m below water surface ,float(8), SampleID,Sample ID,unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. ,nvarchar(30), 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(15), Unit,Unit,unit of measurement.,nvarchar(15), 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), title,note,,, Waterbase-TCM: EIONET stations,"The Stations_EIONET 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 ",,, item,definition,note,data type,key CountryCode,Country code,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes CatchmentName,Catchment name ,name of major catchment or basin. ,nvarchar(255), ClosestCoast,Closest coast,distance of marine station from closest coast expressed in km. Only shown if different from MainlandCoast. ,real(4), Datasource,Data source ,"source of data: Eionet-Water, ICES. ",nvarchar(10), HazsubsStation,Hazardous substances category station,"hazardous substances monitored at station type: R = Represenatative station, I = Impact station. ",nvarchar(1) 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. ",float(8) 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. ",float(8) MainlandCoast,Mainland coast,distance of marine station from nearest mainland coast expressed in km. ,real(4) Mixing,Mixing characteristics,"mixing characteristics at transitional, coastal or marine water monitoring station: FM = Fully mixed, PM = Partially mixed, VS = Vertically stratified. ",nvarchar(20) NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50) PhysChemStation,Physico-Chemicals category station,"physico-chemical conditions monitored at station. R=represenatative station type, I=impact station type. ",nvarchar(3) 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. ",nvarchar(1) Region,Region,national region in which water body is located. ,nvarchar(100) SalinityMaximum,Maximum annual salinity ,"maximum annual salinity measured at transitional, coastal or marine water station. ",real(4) SalinityMean,Mean annual salinity ,"mean annual salinity measured at transitional, coastal or marine water station. ",real(4) SalinityMinimum,Minimum annual salinity,"minimum annual salinity measured at transitional, coastal or marine water station. ",real(4) 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(255) SeaConventionArea,Marine Convention Area,name of Marine Convention area of which regional sea is a part. ,nvarchar(20) SeaDepth,Mean annual depth,"mean annual sea depth at transitional, coastal or marine water station in m. ",real(4) SeaRegionName,Sea region name ,name of regional sea of which local sea area is a part. ,nvarchar(255) SeaResidence,Residence time,residence time of transitional or coastal water body in days. ,real(4) 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(10) 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) StationSite,Station Site,"Specify whether station represents a single point location, a linear feature or a wider area (Area, Line, Point). ",nvarchar(5) 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(5) Temperature,Mean annual temperature ,"mean annual temperature at transitional, coastal or marine water station in degrees Celsius. ",real(4) WaterbaseName,Waterbase name ,national name of station or groundwater body. ,nvarchar(255) 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(40) 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(255) WaterBodyType,Water body type,"RV=river, CN=canal, T=transitional water, C=coastal water, M=marine water. ",nvarchar(2) WaterBodyTypeDescription,Water Body Type Description ,Additional water body type description. ,nvarchar(100) title,note,, Waterbase-TCM: ICES and MEDPOL Stations,"The Stations_ICES_MEDPOL table contains the ICES and MEDPOL monitoring stations, provided by Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the stations with their respective Qua",, item,definition,note,data type,key Countrycode,Country Code,ISO3166 two digit code ,nvarchar(2),Yes Waterbaseid,Unique Waterbase Identifier,represents the EWN groundwater body code ,nvarchar(60),Yes Datasource,Data source ,"source of data: Eionet-Water, ICES. ",nvarchar(10), Latitude_max,Latitude maximum,Latitude maximum for the particular station. ,float(8), Latitude_min,Latitude minimum,Latitude minimum for the particular station. ,float(8), Longitude_max,Longitude maximum,Longitude maximum for the particular station. ,float(8), Longitude_min,Longitude minimum,Longitude minimum for the particular station. ,float(8), Nationalstationid,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50), title,note,,, Waterbase-TCM: Flux stations,"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 ",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. ,nvarchar(2),Yes 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),Yes CatchmentName,Catchment name,name of major catchment or basin.,nvarchar(255), 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.",real(4), 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.",real(4), NationalStationID,National station ID ,"Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. ",nvarchar(50), Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255), RiverName,River name,national name of river.,nvarchar(255), 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(255), SeaConventionArea,Marine convention area,name of Marine Convention area of which regional sea is a part.,nvarchar(20), SeaRegionName,Sea region name,name of regional sea of which local sea area is a part.,nvarchar(255), WaterbaseName,Waterbase name,national name of station or groundwater body.,nvarchar(255), 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(20), 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(255), title,note,,, Waterbase-TCM: Proxy pressures,"The ProxyPressures table contains information about 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. ",,, item,definition,note,data type,key CountryCode,Country code ,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.,nvarchar(2),Yes 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),Yes Fishing,Fishing,"commercial fishing activity in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1), GasExtraction,Gas extraction,"exploration for or extraction of gas in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1), 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), LandFill,Landfill,"transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites. Y=yes, N=no.",nvarchar(1), LanduseArable,Land use arable,"Arable 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 data based on Corine Land Cover category 2.1. ",float(8), 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.",float(8), 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.",float(8), 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).",float(8), 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.",float(8), 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.",float(8), 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.",float(8), 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.",float(8) 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.",float(8) Mariculture,Mariculture,"fish and shellfish farming in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1) Marina,Marina,"presence of a marina in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(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) OilExtraction,Oil extraction,"exploration for or extraction of oil in the transitional, coastal or marine water body. Y = yes, N = no.",nvarchar(1) OtherActivities,Other activities,"any other activities in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1) 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.",nvarchar(1) 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/km2.",float(8) Port,Port,"presence of port facilities in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1) Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255) 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(1) Spoil,Spoil,"dredged spoil disposal ground in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1) Waste,Waste,"waste disposal ground in the transitional, coastal or marine water body. Y=yes, N=no.",nvarchar(1)