Bathing Water Directive – State of bathing water — European Environment Agency

0
Postal code

International country code (ISO 3166-1-Alpha-2 code elements)

varchar(2)

Nope


monitoringSiteIdentifier

Internationally unique identifier of the monitoring site from which the data was obtained

varchar(24)

Yes


bathingWaterName

Name of bathing water provided by a Member State

varchar(100)

Nope


bwWaterCategory

Water body category code, as defined in the code list

CW – Coastal Water Body; LW – Lake water body; RW – Mass of river water; TW – Transitional water body;

varchar(2)

Nope


waterBodyId

Identifier of the surface water body or marine region or sub-region being monitored

varchar(100)

Nope


bwProfileUrl

Hyperlink to documents or web pages with bathing water profile, if available

varchar(max)

Nope


latitude

Geographic latitude coordinate of a monitoring site in decimal degrees

decimal(8)

Nope


longitude

Longitude geographic coordinate of a monitoring site in decimal degrees

decimal(8)

Nope


quality1990

Classification of bathing water quality for the 1990 season

nvarchar(50)

Nope


quality1991

Classification of bathing water quality for the 1991 season

nvarchar(50)

Nope


quality1992

Classification of bathing water quality for the 1992 season

nvarchar(50)

Nope


quality1993

Classification of bathing water quality for the 1993 season

nvarchar(50)

Nope


quality1994

Classification of bathing water quality for the 1994 season

nvarchar(50)

Nope


quality1995

Classification of bathing water quality for the 1995 season

nvarchar(50)

Nope


quality1996

Classification of bathing water quality for the 1996 season

nvarchar(50)

Nope


quality1997

Classification of bathing water quality for the 1997 season

nvarchar(50)

Nope


quality1998

Classification of bathing water quality for the 1998 season

nvarchar(50)

Nope


quality1999

Classification of bathing water quality for the 1999 season

nvarchar(50)

Nope


quality2000

Classification of bathing water quality for the 2000 season

nvarchar(50)

Nope


quality2001

Classification of bathing water quality for the 2001 season

nvarchar(50)

Nope


quality2002

Classification of bathing water quality for the 2002 season

nvarchar(50)

Nope


quality2003

Classification of bathing water quality for the 2003 season

nvarchar(50)

Nope


quality2004

Classification of bathing water quality for the 2004 season

nvarchar(50)

Nope


quality2005

Classification of bathing water quality for the 2005 season

nvarchar(50)

Nope


quality2006

Ranking of bathing water quality for the 2006 season

nvarchar(50)

Nope


quality2007

Ranking of bathing water quality for the 2007 season

nvarchar(50)

Nope


quality2008

Ranking of bathing water quality for the 2008 season

nvarchar(50)

Nope


quality2009

Ranking of bathing water quality for the 2009 season

nvarchar(50)

Nope


quality2010

Ranking of bathing water quality for the 2010 season

nvarchar(50)

Nope


quality2011

Ranking of bathing water quality for the 2011 season

nvarchar(50)

Nope


quality2012

Ranking of bathing water quality for the 2012 season

nvarchar(50)

Nope


quality2013

Ranking of bathing water quality for the 2013 season

nvarchar(50)

Nope


quality2014

Ranking of bathing water quality for the 2014 season

nvarchar(50)

Nope


quality2015

Ranking of bathing water quality for the 2015 season

nvarchar(50)

Nope


quality2016

Ranking of bathing water quality for the 2016 season

nvarchar(50)

Nope


quality2017

Ranking of bathing water quality for the 2017 season

nvarchar(50)

Nope


quality2018

Ranking of bathing water quality for the 2018 season

nvarchar(50)

Nope


monitoringCalendar2018

Ranking of the monitoring calendar for the 2018 season

nvarchar(50)

Nope


management2018

Management ranking for the 2018 season

nvarchar(50)

Nope


quality2019

Ranking of bathing water quality for the 2019 season

nvarchar(50)

Nope


monitoringCalendar2019

Ranking of the tracking calendar for the 2019 season

nvarchar(50)

Nope


management2019

Management ranking for the 2019 season

nvarchar(50)

Nope


quality2020

Ranking of bathing water quality for the 2020 season

nvarchar(50)

Nope


monitoringCalendar2020

Management ranking for the 2020 season

nvarchar(50)

Nope


management2020

Ranking of the tracking calendar for the 2020 season

nvarchar(50)

Nope


Share.

Comments are closed.