Bathing Water Directive - Status 1990 - 2008
Category
European data set
Records
22037
Table definition
| Field name |
Field definition |
Note |
Data type |
Primary key |
| Latitude |
Latitude value of station position in decimal degrees |
|
decimal(9) |
No |
| Longitude |
Longitude value of station position in decimal degrees |
|
decimal(9) |
No |
| Numind |
Code |
primary key of the table |
varchar(20) |
Yes |
| Country_code |
International Country Code (ISO 3166-1-Alpha-2 code elements) |
|
varchar(2) |
No |
| Country |
Country name (ISO 3166-1) |
official short name in English |
varchar(50) |
No |
| Watertype |
Type of bathing water sampled |
|
nvarchar(255) |
No |
| Seawater |
Type of bathing water |
O=seawater; N=freshwater |
nvarchar(255) |
No |
| Region |
Region name reported by Member State |
|
nvarchar(255) |
No |
| Y2005 |
Status of bathing water for year 2005 |
|
varchar(5) |
No |
| Y2006 |
Status of bathing water for year 2006 |
|
varchar(5) |
No |
| Y2007 |
Status of bathing water for year 2007 |
|
varchar(5) |
No |
| Y2008 |
Status of bathing water for year 2008 |
|
varchar(5) |
No |
| Y1999 |
Status of bathing water for year 1999 |
|
varchar(5) |
No |
| Y2000 |
Status of bathing water for year 2000 |
|
varchar(5) |
No |
| Y2001 |
Status of bathing water for year 2001 |
|
varchar(5) |
No |
| Y2002 |
Status of bathing water for year 2002 |
|
varchar(5) |
No |
| Y2003 |
Status of bathing water for year 2003 |
|
varchar(5) |
No |
| Y2004 |
Status of bathing water for year 2004 |
|
varchar(5) |
No |
| Y1993 |
Status of bathing water for year 1993 |
|
varchar(5) |
No |
| Y1994 |
Status of bathing water for year 1994 |
|
varchar(5) |
No |
| Y1995 |
Status of bathing water for year 1995 |
|
varchar(5) |
No |
| Y1996 |
Status of bathing water for year 1996 |
|
varchar(5) |
No |
| Y1997 |
Status of bathing water for year 1997 |
|
varchar(5) |
No |
| Y1998 |
Status of bathing water for year 1998 |
|
varchar(5) |
No |
| Province |
Province name reported by Member State |
|
nvarchar(255) |
No |
| Commune |
Commune name reported by Member State |
|
varchar(255) |
No |
| Prelev |
Bathing water name reported by Member State |
|
nvarchar(255) |
No |
| Y1990 |
Status of bathing water for year 1990 |
|
varchar(5) |
No |
| Y1991 |
Status of bathing water for year 1991 |
|
varchar(5) |
No |
| Y1992 |
Status of bathing water for year 1992 |
|
varchar(5) |
No |
Write to us
Call us
Green tips
Document Actions
Share with others