servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
41791 97 swimming_water_cyanobacteria 2019-06-05T10:06:58.392343+0300 2019-06-06T10:06:58.392343+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 559 swimming_water_cyanobacteria 2019-06-11T14:00:01.071450+0300 2019-06-12T14:00:01.071450+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 568 swimming_water_cyanobacteria 2019-06-11T17:57:02.168113+0300 2019-06-12T17:57:02.168113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 717 swimming_water_cyanobacteria 2019-06-14T10:00:58.201406+0300 2019-06-15T10:00:58.201406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 744 swimming_water_cyanobacteria 2019-06-14T14:18:28.067442+0300 2019-06-15T14:18:28.067442+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 746 swimming_water_cyanobacteria 2019-06-14T17:56:44.684015+0300 2019-06-15T17:56:44.684015+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 758 swimming_water_cyanobacteria 2019-06-15T10:03:00.084007+0300 2019-06-16T10:03:00.084007+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 767 swimming_water_cyanobacteria 2019-06-15T10:24:01.520366+0300 2019-06-16T10:24:01.520366+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 786 swimming_water_cyanobacteria 2019-06-15T13:56:50.232653+0300 2019-06-16T13:56:50.232653+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 790 swimming_water_cyanobacteria 2019-06-15T15:47:53.775392+0300 2019-06-16T15:47:53.775392+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 797 swimming_water_cyanobacteria 2019-06-15T18:21:02.700288+0300 2019-06-16T18:21:02.700288+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 814 swimming_water_cyanobacteria 2019-06-16T08:25:49.431848+0300 2019-06-17T08:25:49.431848+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 838 swimming_water_cyanobacteria 2019-06-16T10:12:33.333738+0300 2019-06-17T10:12:33.333738+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 840 swimming_water_cyanobacteria 2019-06-16T10:13:39.756849+0300 2019-06-17T10:13:39.756849+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 867 swimming_water_cyanobacteria 2019-06-16T13:57:29.422195+0300 2019-06-17T13:57:29.422195+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 877 swimming_water_cyanobacteria 2019-06-16T17:53:02.260278+0300 2019-06-17T17:53:02.260278+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 885 swimming_water_cyanobacteria 2019-06-16T19:01:24.551603+0300 2019-06-17T19:01:24.551603+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 895 swimming_water_cyanobacteria 2019-06-17T09:04:14.096864+0300 2019-06-18T09:04:14.096864+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 901 swimming_water_cyanobacteria 2019-06-17T09:59:22.763374+0300 2019-06-18T09:59:22.763374+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 902 swimming_water_cyanobacteria 2019-06-17T10:04:00.803311+0300 2019-06-18T10:04:00.803311+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 908 swimming_water_cyanobacteria 2019-06-17T10:07:34.428232+0300 2019-06-18T10:07:34.428232+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 934 swimming_water_cyanobacteria 2019-06-17T13:59:41.167721+0300 2019-06-18T13:59:41.167721+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 936 swimming_water_cyanobacteria 2019-06-17T14:01:44.234876+0300 2019-06-18T14:01:44.234876+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 938 swimming_water_cyanobacteria 2019-06-17T14:05:16.961280+0300 2019-06-18T14:05:16.961280+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 952 swimming_water_cyanobacteria 2019-06-17T17:52:56.665844+0300 2019-06-18T17:52:56.665844+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 974 swimming_water_cyanobacteria 2019-06-18T09:14:44.385231+0300 2019-06-19T09:14:44.385231+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 981 swimming_water_cyanobacteria 2019-06-18T10:05:04.684092+0300 2019-06-19T10:05:04.684092+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 983 swimming_water_cyanobacteria 2019-06-18T10:07:47.333863+0300 2019-06-19T10:07:47.333863+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1003 swimming_water_cyanobacteria 2019-06-18T13:57:29.809081+0300 2019-06-19T13:57:29.809081+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1006 swimming_water_cyanobacteria 2019-06-18T14:03:14.340740+0300 2019-06-19T14:03:14.340740+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1016 swimming_water_cyanobacteria 2019-06-18T17:41:54.059959+0300 2019-06-19T17:41:54.059959+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1038 swimming_water_cyanobacteria 2019-06-19T10:00:26.305094+0300 2019-06-20T10:00:26.305094+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1041 swimming_water_cyanobacteria 2019-06-19T10:10:09.189838+0300 2019-06-20T10:10:09.189838+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1084 swimming_water_cyanobacteria 2019-06-19T13:56:46.993234+0300 2019-06-20T13:56:46.993234+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1090 swimming_water_cyanobacteria 2019-06-19T14:03:23.722331+0300 2019-06-20T14:03:23.722331+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1096 swimming_water_cyanobacteria 2019-06-19T17:35:00.848562+0300 2019-06-20T17:35:00.848562+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1098 swimming_water_cyanobacteria 2019-06-19T17:53:36.466152+0300 2019-06-20T17:53:36.466152+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 1117 swimming_water_cyanobacteria 2019-06-20T09:28:15.529503+0300 2019-06-21T09:28:15.529503+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39815 1131 swimming_water_cyanobacteria 2019-06-20T10:08:47.704164+0300 2019-06-21T10:08:47.704164+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
40950 1139 swimming_water_cyanobacteria 2019-06-20T10:14:39.114186+0300 2019-06-21T10:14:39.114186+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
41960 1146 swimming_water_cyanobacteria 2019-06-20T10:30:52.644142+0300 2019-06-21T10:30:52.644142+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1156 swimming_water_cyanobacteria 2019-06-20T11:10:42.343577+0300 2019-06-21T11:10:42.343577+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1181 swimming_water_cyanobacteria 2019-06-20T13:58:41.832594+0300 2019-06-21T13:58:41.832594+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39693 1183 swimming_water_cyanobacteria 2019-06-20T14:00:56.878850+0300 2019-06-21T14:00:56.878850+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1186 swimming_water_cyanobacteria 2019-06-20T14:07:52.466674+0300 2019-06-21T14:07:52.466674+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1189 swimming_water_cyanobacteria 2019-06-20T14:19:27.575905+0300 2019-06-21T14:19:27.575905+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39846 1190 swimming_water_cyanobacteria 2019-06-20T14:19:57.730331+0300 2019-06-21T14:19:57.730331+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1195 swimming_water_cyanobacteria 2019-06-20T17:48:38.752324+0300 2019-06-21T17:48:38.752324+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1202 swimming_water_cyanobacteria 2019-06-20T18:02:21.445164+0300 2019-06-21T18:02:21.445164+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39412 1356 swimming_water_cyanobacteria 2019-06-24T09:16:02.186464+0300 2019-06-25T09:16:02.186464+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1360 swimming_water_cyanobacteria 2019-06-24T10:07:58.914113+0300 2019-06-25T10:07:58.914113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1397 swimming_water_cyanobacteria 2019-06-24T10:33:36.584280+0300 2019-06-25T10:33:36.584280+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1425 swimming_water_cyanobacteria 2019-06-24T14:04:44.674751+0300 2019-06-25T14:04:44.674751+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1427 swimming_water_cyanobacteria 2019-06-24T14:13:55.769110+0300 2019-06-25T14:13:55.769110+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1444 swimming_water_cyanobacteria 2019-06-24T17:46:14.434426+0300 2019-06-25T17:46:14.434426+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1449 swimming_water_cyanobacteria 2019-06-24T17:52:10.527939+0300 2019-06-25T17:52:10.527939+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1460 swimming_water_cyanobacteria 2019-06-25T09:58:01.979120+0300 2019-06-26T09:58:01.979120+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1478 swimming_water_cyanobacteria 2019-06-25T10:21:59.737263+0300 2019-06-26T10:21:59.737263+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1505 swimming_water_cyanobacteria 2019-06-25T14:08:33.887406+0300 2019-06-26T14:08:33.887406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1507 swimming_water_cyanobacteria 2019-06-25T14:10:42.476694+0300 2019-06-26T14:10:42.476694+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1540 swimming_water_cyanobacteria 2019-06-25T18:03:56.606592+0300 2019-06-26T18:03:56.606592+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1544 swimming_water_cyanobacteria 2019-06-26T09:55:55.767975+0300 2019-06-27T09:55:55.767975+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1573 swimming_water_cyanobacteria 2019-06-26T13:52:26.906961+0300 2019-06-27T13:52:26.906961+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
40386 1611 swimming_water_cyanobacteria 2019-06-27T10:10:06.804037+0300 2019-06-28T10:10:06.804037+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
41601 1626 swimming_water_cyanobacteria 2019-06-27T10:28:17.661833+0300 2019-06-28T10:28:17.661833+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1628 swimming_water_cyanobacteria 2019-06-27T10:35:09.795856+0300 2019-06-28T10:35:09.795856+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1629 swimming_water_cyanobacteria 2019-06-27T10:37:00.225862+0300 2019-06-28T10:37:00.225862+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1635 swimming_water_cyanobacteria 2019-06-27T13:15:35.420984+0300 2019-06-28T13:15:35.420984+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39412 1663 swimming_water_cyanobacteria 2019-06-27T13:28:30.202989+0300 2019-06-28T13:28:30.202989+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1674 swimming_water_cyanobacteria 2019-06-27T14:05:18.368274+0300 2019-06-28T14:05:18.368274+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1701 swimming_water_cyanobacteria 2019-06-27T14:45:15.617184+0300 2019-06-28T14:45:15.617184+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1705 swimming_water_cyanobacteria 2019-06-27T16:24:47.173505+0300 2019-06-28T16:24:47.173505+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 1707 swimming_water_cyanobacteria 2019-06-27T17:48:31.873013+0300 2019-06-28T17:48:31.873013+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1721 swimming_water_cyanobacteria 2019-06-28T10:00:59.474031+0300 2019-06-29T10:00:59.474031+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
40386 1732 swimming_water_cyanobacteria 2019-06-28T10:21:15.991821+0300 2019-06-29T10:21:15.991821+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
41601 1749 swimming_water_cyanobacteria 2019-06-28T11:30:07.378078+0300 2019-06-29T11:30:07.378078+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1751 swimming_water_cyanobacteria 2019-06-28T12:08:08.786683+0300 2019-06-29T12:08:08.786683+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1761 swimming_water_cyanobacteria 2019-06-28T14:20:22.293684+0300 2019-06-29T14:20:22.293684+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1764 swimming_water_cyanobacteria 2019-06-28T14:21:32.390873+0300 2019-06-29T14:21:32.390873+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1778 swimming_water_cyanobacteria 2019-06-28T17:51:59.414157+0300 2019-06-29T17:51:59.414157+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1781 swimming_water_cyanobacteria 2019-06-28T17:57:40.958705+0300 2019-06-29T17:57:40.958705+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1806 swimming_water_cyanobacteria 2019-06-29T10:19:54.272740+0300 2019-06-30T10:19:54.272740+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1819 swimming_water_cyanobacteria 2019-06-29T10:37:54.320646+0300 2019-06-30T10:37:54.320646+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1838 swimming_water_cyanobacteria 2019-06-29T14:03:54.226123+0300 2019-06-30T14:03:54.226123+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 1844 swimming_water_cyanobacteria 2019-06-29T17:45:34.829653+0300 2019-06-30T17:45:34.829653+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1851 swimming_water_cyanobacteria 2019-06-29T18:21:58.029858+0300 2019-06-30T18:21:58.029858+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1857 swimming_water_cyanobacteria 2019-06-30T09:56:23.210698+0300 2019-07-01T09:56:23.210698+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1906 swimming_water_cyanobacteria 2019-06-30T14:00:14.623297+0300 2019-07-01T14:00:14.623297+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1926 swimming_water_cyanobacteria 2019-06-30T17:52:02.455156+0300 2019-07-01T17:52:02.455156+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
40157 1986 swimming_water_cyanobacteria 2019-07-01T10:26:06.682965+0300 2019-07-02T10:26:06.682965+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
53461 2026 swimming_water_cyanobacteria 2019-07-01T14:21:50.011953+0300 2019-07-02T14:21:50.011953+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
40950 2109 swimming_water_cyanobacteria 2019-07-03T10:05:42.313257+0300 2019-07-04T10:05:42.313257+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2141 swimming_water_cyanobacteria 2019-07-03T14:07:26.672705+0300 2019-07-04T14:07:26.672705+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2149 swimming_water_cyanobacteria 2019-07-03T17:49:17.748178+0300 2019-07-04T17:49:17.748178+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2169 swimming_water_cyanobacteria 2019-07-04T09:59:17.027506+0300 2019-07-05T09:59:17.027506+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39527 2196 swimming_water_cyanobacteria 2019-07-04T11:46:38.339957+0300 2019-07-05T11:46:38.339957+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39527 2223 swimming_water_cyanobacteria 2019-07-04T13:56:34.472065+0300 2019-07-05T13:56:34.472065+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 2236 swimming_water_cyanobacteria 2019-07-04T14:23:32.201446+0300 2019-07-05T14:23:32.201446+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2240 swimming_water_cyanobacteria 2019-07-04T14:32:02.920270+0300 2019-07-05T14:32:02.920270+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39583 2243 swimming_water_cyanobacteria 2019-07-04T17:36:14.460713+0300 2019-07-05T17:36:14.460713+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2247 swimming_water_cyanobacteria 2019-07-04T17:49:06.083747+0300 2019-07-05T17:49:06.083747+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory