servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39322 24082 swimming_water_temperature 2020-10-14T11:05:00.666183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 791 swimming_water_temperature 2019-06-15T15:56:24.279647+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1432 swimming_water_temperature 2019-06-24T14:39:56.078527+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1482 swimming_water_temperature 2019-06-25T10:42:46.178701+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1596 swimming_water_temperature 2019-06-27T09:04:50.295586+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1636 swimming_water_temperature 2019-06-27T13:16:26.703830+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1811 swimming_water_temperature 2019-06-29T10:35:09.132448+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1842 swimming_water_temperature 2019-06-29T14:39:13.572336+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1900 swimming_water_temperature 2019-06-30T12:36:43.333583+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1991 swimming_water_temperature 2019-07-01T10:36:01.507939+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1992 swimming_water_temperature 2019-07-01T10:36:22.100902+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1993 swimming_water_temperature 2019-07-01T10:36:51.678706+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 1996 swimming_water_temperature 2019-07-01T10:37:07.201673+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2019 swimming_water_temperature 2019-07-01T14:10:01.247802+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2195 swimming_water_temperature 2019-07-04T11:46:35.178176+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2222 swimming_water_temperature 2019-07-04T13:56:31.650386+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2347 swimming_water_temperature 2019-07-05T19:59:41.774650+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2383 swimming_water_temperature 2019-07-06T10:39:17.747107+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2451 swimming_water_temperature 2019-07-07T10:31:20.885625+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2525 swimming_water_temperature 2019-07-08T10:17:33.486203+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2546 swimming_water_temperature 2019-07-08T13:59:12.331068+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2661 swimming_water_temperature 2019-07-10T10:01:14.812001+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2871 swimming_water_temperature 2019-07-12T15:37:38.160641+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 2882 swimming_water_temperature 2019-07-13T09:17:58.628768+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 3046 swimming_water_temperature 2019-07-15T10:10:00.805006+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 3094 swimming_water_temperature 2019-07-15T14:10:51.465109+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8357 swimming_water_temperature 2020-06-01T10:41:35.614635+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8361 swimming_water_temperature 2020-06-01T10:45:04.388055+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8362 swimming_water_temperature 2020-06-01T10:45:07.299199+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8363 swimming_water_temperature 2020-06-01T10:45:09.040748+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8442 swimming_water_temperature 2020-06-02T10:04:25.196825+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8508 swimming_water_temperature 2020-06-02T18:01:14.285686+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8542 swimming_water_temperature 2020-06-03T10:13:44.753310+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8809 swimming_water_temperature 2020-06-07T10:58:53.139152+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8819 swimming_water_temperature 2020-06-07T14:16:27.736246+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8843 swimming_water_temperature 2020-06-08T08:43:51.423919+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8888 swimming_water_temperature 2020-06-08T13:37:44.271269+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8903 swimming_water_temperature 2020-06-09T08:13:44.613876+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11160 swimming_water_temperature 2020-07-10T08:09:36.055647+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11328 swimming_water_temperature 2020-07-12T14:06:02.422587+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11515 swimming_water_temperature 2020-07-14T22:54:47.249613+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11604 swimming_water_temperature 2020-07-15T15:43:25.351708+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12146 swimming_water_temperature 2020-07-23T08:40:28.331757+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12227 swimming_water_temperature 2020-07-24T07:56:18.925684+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12309 swimming_water_temperature 2020-07-25T09:09:41.896741+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12377 swimming_water_temperature 2020-07-26T10:08:03.937303+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12520 swimming_water_temperature 2020-07-28T08:13:31.183734+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12607 swimming_water_temperature 2020-07-29T08:18:14.666008+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 687 swimming_water_temperature 2019-06-13T16:33:38.469330+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 689 swimming_water_temperature 2019-06-13T16:33:49.353692+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 692 swimming_water_temperature 2019-06-13T18:16:53.623298+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 975 swimming_water_temperature 2019-06-18T09:52:13.128959+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1457 swimming_water_temperature 2019-06-25T09:38:13.506010+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1702 swimming_water_temperature 2019-06-27T14:58:52.599260+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1815 swimming_water_temperature 2019-06-29T10:37:15.570586+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1839 swimming_water_temperature 2019-06-29T14:36:03.257726+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1840 swimming_water_temperature 2019-06-29T14:36:09.937849+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1852 swimming_water_temperature 2019-06-29T18:22:20.289613+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1903 swimming_water_temperature 2019-06-30T13:49:12.486308+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1904 swimming_water_temperature 2019-06-30T13:49:23.543952+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 1969 swimming_water_temperature 2019-07-01T10:07:55.633355+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2044 swimming_water_temperature 2019-07-01T18:40:40.680455+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2126 swimming_water_temperature 2019-07-03T11:09:03.948749+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2146 swimming_water_temperature 2019-07-03T17:20:11.125564+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2309 swimming_water_temperature 2019-07-05T11:55:25.991460+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2328 swimming_water_temperature 2019-07-05T14:38:19.633616+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2339 swimming_water_temperature 2019-07-05T18:00:09.544582+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2463 swimming_water_temperature 2019-07-07T10:54:43.021478+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2478 swimming_water_temperature 2019-07-07T14:04:46.830475+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2542 swimming_water_temperature 2019-07-08T13:52:17.203341+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2610 swimming_water_temperature 2019-07-09T11:15:57.035398+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2669 swimming_water_temperature 2019-07-10T10:12:53.283387+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2732 swimming_water_temperature 2019-07-10T18:38:53.374227+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2787 swimming_water_temperature 2019-07-11T10:32:15.659731+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2811 swimming_water_temperature 2019-07-11T18:02:31.361019+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2900 swimming_water_temperature 2019-07-13T10:26:41.196324+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2934 swimming_water_temperature 2019-07-13T14:59:26.484239+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2949 swimming_water_temperature 2019-07-13T18:09:53.095297+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 2973 swimming_water_temperature 2019-07-14T10:13:40.210585+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 3022 swimming_water_temperature 2019-07-14T19:35:18.145893+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8408 swimming_water_temperature 2020-06-01T13:33:35.638740+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8499 swimming_water_temperature 2020-06-02T15:30:38.994620+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8610 swimming_water_temperature 2020-06-04T10:30:50.607339+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8648 swimming_water_temperature 2020-06-05T09:52:48.469011+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8649 swimming_water_temperature 2020-06-05T09:52:53.521156+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8650 swimming_water_temperature 2020-06-05T09:52:58.076787+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 8697 swimming_water_temperature 2020-06-05T14:20:04.905257+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11205 swimming_water_temperature 2020-07-10T12:56:56.750866+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11248 swimming_water_temperature 2020-07-10T23:54:23.312656+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11330 swimming_water_temperature 2020-07-12T14:06:13.325033+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12148 swimming_water_temperature 2020-07-23T09:02:05.133213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12230 swimming_water_temperature 2020-07-24T08:26:07.613327+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12361 swimming_water_temperature 2020-07-26T09:15:09.797332+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12397 swimming_water_temperature 2020-07-26T13:52:09.139325+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2370 swimming_water_temperature 2019-07-06T10:16:15.781751+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2402 swimming_water_temperature 2019-07-06T14:16:08.022698+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2408 swimming_water_temperature 2019-07-06T17:45:37.924256+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2521 swimming_water_temperature 2019-07-08T10:10:57.318786+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2670 swimming_water_temperature 2019-07-10T10:13:51.633773+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2701 swimming_water_temperature 2019-07-10T13:51:08.431318+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39583 2912 swimming_water_temperature 2019-07-13T12:09:20.642302+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown