servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39267 166 swimming_water_cyanobacteria 2019-06-06T11:41:52.590712+0300 2019-06-07T11:41:52.590712+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 181 swimming_water_cyanobacteria 2019-06-06T14:10:39.762394+0300 2019-06-07T14:10:39.762394+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 297 swimming_water_cyanobacteria 2019-06-08T17:01:12.529283+0300 2019-06-09T17:01:12.529283+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 302 swimming_water_cyanobacteria 2019-06-08T17:58:58.552883+0300 2019-06-09T17:58:58.552883+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 340 swimming_water_cyanobacteria 2019-06-09T10:21:47.250145+0300 2019-06-10T10:21:47.250145+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 375 swimming_water_cyanobacteria 2019-06-09T17:54:15.065650+0300 2019-06-10T17:54:15.065650+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 476 swimming_water_cyanobacteria 2019-06-11T10:10:11.349976+0300 2019-06-12T10:10:11.349976+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 591 swimming_water_cyanobacteria 2019-06-12T10:45:42.523400+0300 2019-06-13T10:45:42.523400+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 608 swimming_water_cyanobacteria 2019-06-12T14:02:40.781786+0300 2019-06-13T14:02:40.781786+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 686 swimming_water_cyanobacteria 2019-06-13T15:03:58.499130+0300 2019-06-14T15:03:58.499130+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13355 swimming_water_cyanobacteria 2020-08-07T09:01:30.604509+0300 2020-08-08T09:01:30.604509+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13542 swimming_water_cyanobacteria 2020-08-10T10:45:49.935972+0300 2020-08-11T10:45:49.935972+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13599 swimming_water_cyanobacteria 2020-08-11T09:48:48.687193+0300 2020-08-12T09:48:48.687193+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13646 swimming_water_cyanobacteria 2020-08-12T10:47:18.051060+0300 2020-08-13T10:47:18.051060+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13699 swimming_water_cyanobacteria 2020-08-13T09:38:57.257624+0300 2020-08-14T09:38:57.257624+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13739 swimming_water_cyanobacteria 2020-08-14T09:05:18.949087+0300 2020-08-15T09:05:18.949087+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13780 swimming_water_cyanobacteria 2020-08-15T10:28:18.560527+0300 2020-08-16T10:28:18.560527+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13831 swimming_water_cyanobacteria 2020-08-16T10:24:09.270120+0300 2020-08-17T10:24:09.270120+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13906 swimming_water_cyanobacteria 2020-08-18T11:54:33.209405+0300 2020-08-19T11:54:33.209405+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 13928 swimming_water_cyanobacteria 2020-08-19T10:52:10.652922+0300 2020-08-20T10:52:10.652922+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39289 8978 swimming_water_cyanobacteria 2020-06-10T10:03:19.811846+0300 2020-06-11T10:03:19.811846+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 223 swimming_water_cyanobacteria 2019-06-07T11:23:46.934289+0300 2019-06-08T11:23:46.934289+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 225 swimming_water_cyanobacteria 2019-06-07T11:35:37.275884+0300 2019-06-08T11:35:37.275884+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 227 swimming_water_cyanobacteria 2019-06-07T11:35:37.729851+0300 2019-06-08T11:35:37.729851+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 229 swimming_water_cyanobacteria 2019-06-07T11:35:38.182549+0300 2019-06-08T11:35:38.182549+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 246 swimming_water_cyanobacteria 2019-06-07T15:17:51.371667+0300 2019-06-08T15:17:51.371667+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 259 swimming_water_cyanobacteria 2019-06-07T19:42:43.393878+0300 2019-06-08T19:42:43.393878+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 307 swimming_water_cyanobacteria 2019-06-08T23:41:39.898126+0300 2019-06-09T23:41:39.898126+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 338 swimming_water_cyanobacteria 2019-06-09T10:15:22.169332+0300 2019-06-10T10:15:22.169332+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 367 swimming_water_cyanobacteria 2019-06-09T14:07:48.854694+0300 2019-06-10T14:07:48.854694+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 392 swimming_water_cyanobacteria 2019-06-10T10:01:32.789022+0300 2019-06-11T10:01:32.789022+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 407 swimming_water_cyanobacteria 2019-06-10T13:40:35.075811+0300 2019-06-11T13:40:35.075811+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 425 swimming_water_cyanobacteria 2019-06-10T17:51:08.455237+0300 2019-06-11T17:51:08.455237+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 461 swimming_water_cyanobacteria 2019-06-11T09:50:57.103281+0300 2019-06-12T09:50:57.103281+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 555 swimming_water_cyanobacteria 2019-06-11T13:45:46.922981+0300 2019-06-12T13:45:46.922981+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 566 swimming_water_cyanobacteria 2019-06-11T17:52:48.301558+0300 2019-06-12T17:52:48.301558+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 573 swimming_water_cyanobacteria 2019-06-12T10:04:15.093719+0300 2019-06-13T10:04:15.093719+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 606 swimming_water_cyanobacteria 2019-06-12T14:01:03.590432+0300 2019-06-13T14:01:03.590432+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 621 swimming_water_cyanobacteria 2019-06-12T17:49:11.759700+0300 2019-06-13T17:49:11.759700+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 652 swimming_water_cyanobacteria 2019-06-13T10:08:24.438606+0300 2019-06-14T10:08:24.438606+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 696 swimming_water_cyanobacteria 2019-06-13T18:42:37.809008+0300 2019-06-14T18:42:37.809008+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 710 swimming_water_cyanobacteria 2019-06-14T09:44:12.773863+0300 2019-06-15T09:44:12.773863+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 833 swimming_water_cyanobacteria 2019-06-16T10:08:53.647603+0300 2019-06-17T10:08:53.647603+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 2043 swimming_water_cyanobacteria 2019-07-01T18:09:21.935312+0300 2019-07-02T18:09:21.935312+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 2097 swimming_water_cyanobacteria 2019-07-03T09:51:33.108914+0300 2019-07-04T09:51:33.108914+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8621 swimming_water_cyanobacteria 2020-06-04T13:31:19.565447+0300 2020-06-05T13:31:19.565447+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8629 swimming_water_cyanobacteria 2020-06-04T15:04:26.455349+0300 2020-06-05T15:04:26.455349+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8642 swimming_water_cyanobacteria 2020-06-04T19:26:00.900564+0300 2020-06-05T19:26:00.900564+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8644 swimming_water_cyanobacteria 2020-06-05T08:30:31.940629+0300 2020-06-06T08:30:31.940629+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8701 swimming_water_cyanobacteria 2020-06-05T14:21:21.577935+0300 2020-06-06T14:21:21.577935+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8771 swimming_water_cyanobacteria 2020-06-06T18:14:05.010617+0300 2020-06-07T18:14:05.010617+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8792 swimming_water_cyanobacteria 2020-06-07T10:09:35.389842+0300 2020-06-08T10:09:35.389842+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8816 swimming_water_cyanobacteria 2020-06-07T13:53:23.711738+0300 2020-06-08T13:53:23.711738+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8825 swimming_water_cyanobacteria 2020-06-07T14:40:36.392081+0300 2020-06-08T14:40:36.392081+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8831 swimming_water_cyanobacteria 2020-06-07T17:51:55.192106+0300 2020-06-08T17:51:55.192106+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8861 swimming_water_cyanobacteria 2020-06-08T10:05:25.541820+0300 2020-06-09T10:05:25.541820+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8891 swimming_water_cyanobacteria 2020-06-08T13:59:41.861684+0300 2020-06-09T13:59:41.861684+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8898 swimming_water_cyanobacteria 2020-06-08T17:51:54.558749+0300 2020-06-09T17:51:54.558749+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8923 swimming_water_cyanobacteria 2020-06-09T10:09:36.162775+0300 2020-06-10T10:09:36.162775+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8939 swimming_water_cyanobacteria 2020-06-09T13:58:21.098675+0300 2020-06-10T13:58:21.098675+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8943 swimming_water_cyanobacteria 2020-06-09T14:56:16.422279+0300 2020-06-10T14:56:16.422279+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 8951 swimming_water_cyanobacteria 2020-06-09T18:00:51.021183+0300 2020-06-10T18:00:51.021183+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9016 swimming_water_cyanobacteria 2020-06-10T14:44:25.179799+0300 2020-06-11T14:44:25.179799+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9028 swimming_water_cyanobacteria 2020-06-10T17:53:00.155785+0300 2020-06-11T17:53:00.155785+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9092 swimming_water_cyanobacteria 2020-06-11T10:08:02.997986+0300 2020-06-12T10:08:02.997986+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9120 swimming_water_cyanobacteria 2020-06-11T14:42:34.386552+0300 2020-06-12T14:42:34.386552+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9132 swimming_water_cyanobacteria 2020-06-11T18:00:02.458284+0300 2020-06-12T18:00:02.458284+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9189 swimming_water_cyanobacteria 2020-06-12T11:24:38.307195+0300 2020-06-13T11:24:38.307195+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9209 swimming_water_cyanobacteria 2020-06-12T18:04:10.099605+0300 2020-06-13T18:04:10.099605+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9250 swimming_water_cyanobacteria 2020-06-13T11:15:24.569304+0300 2020-06-14T11:15:24.569304+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9259 swimming_water_cyanobacteria 2020-06-13T14:15:58.221285+0300 2020-06-14T14:15:58.221285+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9291 swimming_water_cyanobacteria 2020-06-14T10:13:51.779788+0300 2020-06-15T10:13:51.779788+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9318 swimming_water_cyanobacteria 2020-06-14T13:46:32.134787+0300 2020-06-15T13:46:32.134787+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9371 swimming_water_cyanobacteria 2020-06-15T09:54:22.298060+0300 2020-06-16T09:54:22.298060+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9434 swimming_water_cyanobacteria 2020-06-15T14:22:09.130688+0300 2020-06-16T14:22:09.130688+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9450 swimming_water_cyanobacteria 2020-06-15T17:58:38.978253+0300 2020-06-16T17:58:38.978253+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9452 swimming_water_cyanobacteria 2020-06-15T18:00:14.727657+0300 2020-06-16T18:00:14.727657+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9515 swimming_water_cyanobacteria 2020-06-16T13:57:06.392827+0300 2020-06-17T13:57:06.392827+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9531 swimming_water_cyanobacteria 2020-06-16T18:13:24.918634+0300 2020-06-17T18:13:24.918634+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9571 swimming_water_cyanobacteria 2020-06-17T10:11:27.141434+0300 2020-06-18T10:11:27.141434+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9608 swimming_water_cyanobacteria 2020-06-17T14:19:22.937205+0300 2020-06-18T14:19:22.937205+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9620 swimming_water_cyanobacteria 2020-06-17T17:58:41.358364+0300 2020-06-18T17:58:41.358364+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9638 swimming_water_cyanobacteria 2020-06-18T09:34:19.146127+0300 2020-06-19T09:34:19.146127+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9683 swimming_water_cyanobacteria 2020-06-18T14:00:21.579476+0300 2020-06-19T14:00:21.579476+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9695 swimming_water_cyanobacteria 2020-06-18T18:05:39.431509+0300 2020-06-19T18:05:39.431509+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9697 swimming_water_cyanobacteria 2020-06-18T18:16:56.781501+0300 2020-06-19T18:16:56.781501+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9822 swimming_water_cyanobacteria 2020-06-22T09:46:30.354376+0300 2020-06-23T09:46:30.354376+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9865 swimming_water_cyanobacteria 2020-06-22T14:03:35.174189+0300 2020-06-23T14:03:35.174189+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9883 swimming_water_cyanobacteria 2020-06-22T18:01:49.226631+0300 2020-06-23T18:01:49.226631+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9891 swimming_water_cyanobacteria 2020-06-23T09:14:49.376914+0300 2020-06-24T09:14:49.376914+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9929 swimming_water_cyanobacteria 2020-06-23T10:10:46.775990+0300 2020-06-24T10:10:46.775990+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 9990 swimming_water_cyanobacteria 2020-06-23T14:11:07.649365+0300 2020-06-24T14:11:07.649365+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10006 swimming_water_cyanobacteria 2020-06-23T18:36:55.274246+0300 2020-06-24T18:36:55.274246+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10039 swimming_water_cyanobacteria 2020-06-24T10:02:54.936726+0300 2020-06-25T10:02:54.936726+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10086 swimming_water_cyanobacteria 2020-06-24T13:58:09.622144+0300 2020-06-25T13:58:09.622144+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10097 swimming_water_cyanobacteria 2020-06-24T18:12:37.146743+0300 2020-06-25T18:12:37.146743+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10125 swimming_water_cyanobacteria 2020-06-25T09:59:23.395827+0300 2020-06-26T09:59:23.395827+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10167 swimming_water_cyanobacteria 2020-06-25T14:14:56.356339+0300 2020-06-26T14:14:56.356339+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10180 swimming_water_cyanobacteria 2020-06-25T18:01:42.923454+0300 2020-06-26T18:01:42.923454+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10224 swimming_water_cyanobacteria 2020-06-26T10:24:20.153206+0300 2020-06-27T10:24:20.153206+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39322 10271 swimming_water_cyanobacteria 2020-06-26T14:16:18.850798+0300 2020-06-27T14:16:18.850798+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good