Background information on the subject bathing water quality in the state portal The following columns are included: - BADEGEWAESSERID - unique identifier of the bathing water, see master data record - MEASURING POINT NAME - name of the measuring point for sampling the bathing water - MEASING POINT ID - ID of the measuring point for sampling the bathing water - UEMONWACHUNGSARTID - ID of the type of sample - MONITORINGARTTEXT - Description of the type of sample - WATER CATEGORY - type of water body in which the bathing water is located - COAL WATERS - associated coastal water (North Sea or Baltic Sea) - SAMPLEID - ID of measurement (number) - DATE MEASUREMENT - time of measurement in the format DD.MM.YYYY hh:mm:ss or DD.MM.YYYY - PROBENART - type of sample - ECOLI - number of E. coli in CFU/100ml - INTEST_ENTEROCOCKS - number of intestinal enterococci in CFU/ 100ml - WATER TEMP - water temperature in degrees Celsius during sampling - AIR TEMP - air temperature in degrees Celsius during sampling - VISIBILITY DEPTH - visibility depth in meters during sampling - NOTE - free text field character set is ISO-8859-1, Column separator is pipe, string separator is double quote ("), decimal separator is comma. ---- For a complete view of the bathing water quality in Schleswig-Holstein, these five data sets should be included: - master data - classification of bathing water quality - Information on the existing infrastructure - duration of season - measurements
