Bathing water Master data

Master data of bathing waters in Schleswig-Holstein

The following columns are included:

— ‘BADEGEWAESSERID’ — Generally valid identification code of bathing water
— ‘BADEGEWAESSERNAME’ — Full name of bathing water
— ‘short name’ — short name of bathing water
— ‘ALLGEMEIN_GEBRAEUCHL_NAME’ — commonly used name of bathing water
— ‘WAESSER CATEGORIE’ — Type of water body in which the bathing water is located
— ‘Kuestengewaesser’ — associated coastal waters (North Sea or Baltic Sea)
— ‘BADEGEWAESSERTYP’ — bathing water status (existing or new)
— ‘Further DESCRIPTION’ — further description of bathing water
— ‘BADESTELLENLAENGE’ — length of the shoreline of the bathing site in meters
— ‘EU Reporting’ — Date of registration with the EU
— ‘EU DECISION’ — Date of deregistration with the EU
— ‘FLOWING UNIVERSITY’ — ID of the river basin district to which the bathing water belongs; Disclosure according to WFD reporting
— The name of the river basin district to which the bathing water belongs; Disclosure according to WFD reporting
— ‘WASSERKOERPERID’ — ID of the body of water to which the bathing water belongs; Disclosure according to WFD reporting
— ‘WASSERKOERPERNAME’ — 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)
— ‘district’ — internal number of the district or city in charge of monitoring bathing water
— ‘circle’ — Name of the district or city in charge of monitoring bathing water
— ‘GEMEINDENR’ — internal number of the municipality in which the bathing water is located
— ‘community’ — name of the municipality in which the bathing water is located
— ‘UTM_OST’ — Legal value of 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 location in KBS (EPSG:4326, WGS 84)
— ‘GEOGR_BREITE’ — Latitude of bathing water situation in KBS (EPSG:4326, WGS 84)
— ‘BADESTELLENINFORMATION’ — Tourist information on bathing waters
— ‘OFFER_AUF_BADEGEWAESSER’ — indication of whether the bathing water is susceptible to adverse effects
— ‘MOVAL CONSTRUCTIONS’ — indication of possible sources of pollution for bathing waters

Character set is ISO-8859-1, column separator is semicolon, string separator is the double quote character (").

—

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

— master data
— qualification of bathing water quality
— information on existing infrastructure
— season duration
— measures