Bathing waters Master data

Master data of bathing waters in Schleswig-Holstein

The following columns are included:

‘BADEGEWAESSERID’ – Generally valid bathing water identification code
‘BADEGEWAESSERNAME’ – Full name of bathing water
‘Short name’ – short name of bathing water
‘ALLGEMEIN_GEBRAEUCHL_NAME’ – commonly used name of bathing water
‘WAESSERCATEGORY’ – Type of water body in which the bathing water is situated
‘Kuestengewaesser’ – associated coastal waters (North Sea or Baltic Sea)
‘BADEGEWAESSERTYP’ – bathing water status (existing or new)
‘Other DESCRIPTION’ – further description of bathing water
‘BADESTELLENLAENGE’ – Length of the shoreline of the bathing site in meters
‘EU RECOMMENDATION’ – Date of notification to the EU
‘EU RECOMMENDATION’ – Date of deregistration to the EU
‘FLUSSGEBIETSEINHEITID’ – ID of the river basin unit to which the bathing water belongs; Disclosure according to WFD reporting
‘FLUSSGEBIETSEINHEITNAME’ – name of the river basin unit to which the bathing water belongs; Disclosure according to WFD reporting
‘Water cooker’ – ID of the body of water to which the bathing water belongs; Disclosure according to WFD reporting
‘Water cooker’ – name of the body of water to which the bathing water belongs; Disclosure according to WFD reporting
‘NATWASSERKOERPERID’ – ID of the national water unit to which the bathing water belongs
‘NATWASSERKOERPERNAME’ – Name of the national water unit to which the bathing water belongs
“Schluesselwoerter” – for the search of bathing water in WISE (Water Information System for Europe)
‘Circle’ – internal number of the district or city which is responsible for monitoring the bathing water
‘Circle’ – Name of the district or city which is responsible for monitoring the bathing water
‘Community’ – internal number of the municipality in which the bathing water is located
‘Municipality’ – Name of the municipality in which the bathing waters lie
‘UTM_OST’ – Legal value of the bathing water situation in KBS (EPSG:4647, ETRS89/UTM zone N32)
‘UTM_NORD’ – High value of bathing water situation in KBS (EPSG:4647, ETRS89/UTM zone N32)
‘GEOGR_LAENGE’ – Longitude of bathing water position in KBS (EPSG:4326, WGS 84)
‘GEOGR_BREITE’ – Latitude of the position of the bathing water in the KBS (EPSG:4326, WGS 84)
— ‘BADESTELLENINFORMATION’ – Tourist information on bathing waters
‘Effects_AUF_BADEGEWAESSER’ – indication of whether the bathing water is susceptible to adverse effects
‘MOEGLICIAL RESOLUTIONS’ – indication of possible sources of pollution for bathing water

Character set is ISO-8859-1, column separator is perpendicular line (pipe), string separator is the double quotation mark (").

—

For a complete view of bathing water quality in Schleswig-Holstein, these five data sets should be included:

— master data
— classification of bathing water quality
— information on existing infrastructure
— season duration
— measurements