servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
52959 680 swimming_water_cyanobacteria 2019-06-13T14:04:24.716882+0300 2019-06-14T14:04:24.716882+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 682 swimming_water_cyanobacteria 2019-06-13T14:06:23.422071+0300 2019-06-14T14:06:23.422071+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  
39568 688 swimming_water_cyanobacteria 2019-06-13T16:33:43.907634+0300 2019-06-14T16:33:43.907634+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 691 swimming_water_cyanobacteria 2019-06-13T18:02:43.040796+0300 2019-06-14T18:02:43.040796+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39568 693 swimming_water_cyanobacteria 2019-06-13T18:16:59.277736+0300 2019-06-14T18:16:59.277736+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  
39823 698 swimming_water_cyanobacteria 2019-06-14T07:39:11.855315+0300 2019-06-15T07:39:11.855315+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
53461 700 swimming_water_cyanobacteria 2019-06-14T07:52:58.907547+0300 2019-06-15T07:52:58.907547+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39606 702 swimming_water_cyanobacteria 2019-06-14T08:04:22.205335+0300 2019-06-15T08:04:22.205335+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39902 704 swimming_water_cyanobacteria 2019-06-14T08:14:40.620870+0300 2019-06-15T08:14:40.620870+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39875 706 swimming_water_cyanobacteria 2019-06-14T08:29:48.158864+0300 2019-06-15T08:29:48.158864+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39713 708 swimming_water_cyanobacteria 2019-06-14T08:44:33.769724+0300 2019-06-15T08:44:33.769724+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  
39412 712 swimming_water_cyanobacteria 2019-06-14T09:53:18.309847+0300 2019-06-15T09:53:18.309847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 715 swimming_water_cyanobacteria 2019-06-14T09:54:34.311727+0300 2019-06-15T09:54:34.311727+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
41960 719 swimming_water_cyanobacteria 2019-06-14T10:02:54.075070+0300 2019-06-15T10:02:54.075070+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39267 721 swimming_water_cyanobacteria 2019-06-14T10:05:35.446913+0300 2019-06-15T10:05:35.446913+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
40802 723 swimming_water_cyanobacteria 2019-06-14T10:09:24.570033+0300 2019-06-15T10:09:24.570033+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
52959 725 swimming_water_cyanobacteria 2019-06-14T10:11:35.804338+0300 2019-06-15T10:11:35.804338+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 728 swimming_water_cyanobacteria 2019-06-14T10:25:27.495194+0300 2019-06-15T10:25:27.495194+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 732 swimming_water_cyanobacteria 2019-06-14T10:29:59.856384+0300 2019-06-15T10:29:59.856384+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 735 swimming_water_cyanobacteria 2019-06-14T10:34:07.496242+0300 2019-06-15T10:34:07.496242+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 737 swimming_water_cyanobacteria 2019-06-14T10:42:22.036517+0300 2019-06-15T10:42:22.036517+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 741 swimming_water_cyanobacteria 2019-06-14T14:07:56.224571+0300 2019-06-15T14:07:56.224571+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39693 750 swimming_water_cyanobacteria 2019-06-14T18:02:15.473684+0300 2019-06-15T18:02:15.473684+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 754 swimming_water_cyanobacteria 2019-06-15T10:01:41.993410+0300 2019-06-16T10:01:41.993410+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41960 756 swimming_water_cyanobacteria 2019-06-15T10:01:44.545282+0300 2019-06-16T10:01:44.545282+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
41791 760 swimming_water_cyanobacteria 2019-06-15T10:05:51.819768+0300 2019-06-16T10:05:51.819768+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 762 swimming_water_cyanobacteria 2019-06-15T10:11:27.935990+0300 2019-06-16T10:11:27.935990+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 765 swimming_water_cyanobacteria 2019-06-15T10:16:16.253353+0300 2019-06-16T10:16:16.253353+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40258 773 swimming_water_cyanobacteria 2019-06-15T10:52:30.641758+0300 2019-06-16T10:52:30.641758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 776 swimming_water_cyanobacteria 2019-06-15T10:55:02.791724+0300 2019-06-16T10:55:02.791724+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 778 swimming_water_cyanobacteria 2019-06-15T12:20:16.464612+0300 2019-06-16T12:20:16.464612+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 781 swimming_water_cyanobacteria 2019-06-15T13:44:11.537883+0300 2019-06-16T13:44:11.537883+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 783 swimming_water_cyanobacteria 2019-06-15T13:49:52.772080+0300 2019-06-16T13:49:52.772080+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39693 788 swimming_water_cyanobacteria 2019-06-15T14:04:53.274329+0300 2019-06-16T14:04:53.274329+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39527 792 swimming_water_cyanobacteria 2019-06-15T15:56:26.559779+0300 2019-06-16T15:56:26.559779+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 795 swimming_water_cyanobacteria 2019-06-15T17:59:28.788313+0300 2019-06-16T17:59:28.788313+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
41031 800 swimming_water_cyanobacteria 2019-06-16T08:24:10.222166+0300 2019-06-17T08:24:10.222166+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41326 802 swimming_water_cyanobacteria 2019-06-16T08:24:19.151081+0300 2019-06-17T08:24:19.151081+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41907 804 swimming_water_cyanobacteria 2019-06-16T08:24:24.540430+0300 2019-06-17T08:24:24.540430+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40798 806 swimming_water_cyanobacteria 2019-06-16T08:24:31.219659+0300 2019-06-17T08:24:31.219659+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39910 808 swimming_water_cyanobacteria 2019-06-16T08:24:51.994758+0300 2019-06-17T08:24:51.994758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40921 810 swimming_water_cyanobacteria 2019-06-16T08:25:15.052868+0300 2019-06-17T08:25:15.052868+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40020 816 swimming_water_cyanobacteria 2019-06-16T08:26:10.578011+0300 2019-06-17T08:26:10.578011+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40993 818 swimming_water_cyanobacteria 2019-06-16T08:26:25.457563+0300 2019-06-17T08:26:25.457563+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40677 820 swimming_water_cyanobacteria 2019-06-16T08:26:35.516847+0300 2019-06-17T08:26:35.516847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
52959 822 swimming_water_cyanobacteria 2019-06-16T09:16:17.039314+0300 2019-06-17T09:16:17.039314+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 824 swimming_water_cyanobacteria 2019-06-16T09:48:16.661376+0300 2019-06-17T09:48:16.661376+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  
41960 835 swimming_water_cyanobacteria 2019-06-16T10:11:37.127515+0300 2019-06-17T10:11:37.127515+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 837 swimming_water_cyanobacteria 2019-06-16T10:12:19.971699+0300 2019-06-17T10:12:19.971699+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40950 842 swimming_water_cyanobacteria 2019-06-16T10:14:06.351951+0300 2019-06-17T10:14:06.351951+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 844 swimming_water_cyanobacteria 2019-06-16T10:20:05.332453+0300 2019-06-17T10:20:05.332453+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40802 846 swimming_water_cyanobacteria 2019-06-16T10:23:41.932085+0300 2019-06-17T10:23:41.932085+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 849 swimming_water_cyanobacteria 2019-06-16T10:25:01.096932+0300 2019-06-17T10:25:01.096932+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 851 swimming_water_cyanobacteria 2019-06-16T10:32:35.162427+0300 2019-06-17T10:32:35.162427+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 855 swimming_water_cyanobacteria 2019-06-16T11:26:45.823624+0300 2019-06-17T11:26:45.823624+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40258 857 swimming_water_cyanobacteria 2019-06-16T12:13:08.571645+0300 2019-06-17T12:13:08.571645+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 861 swimming_water_cyanobacteria 2019-06-16T13:38:17.003734+0300 2019-06-17T13:38:17.003734+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 864 swimming_water_cyanobacteria 2019-06-16T13:55:10.297721+0300 2019-06-17T13:55:10.297721+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39568 875 swimming_water_cyanobacteria 2019-06-16T14:18:40.192923+0300 2019-06-17T14:18:40.192923+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39815 880 swimming_water_cyanobacteria 2019-06-16T17:54:47.460698+0300 2019-06-17T17:54:47.460698+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39568 882 swimming_water_cyanobacteria 2019-06-16T18:15:21.339903+0300 2019-06-17T18:15:21.339903+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39713 887 swimming_water_cyanobacteria 2019-06-17T07:41:17.000271+0300 2019-06-18T07:41:17.000271+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39875 889 swimming_water_cyanobacteria 2019-06-17T08:06:45.742388+0300 2019-06-18T08:06:45.742388+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39902 891 swimming_water_cyanobacteria 2019-06-17T08:24:43.470303+0300 2019-06-18T08:24:43.470303+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39606 893 swimming_water_cyanobacteria 2019-06-17T08:37:26.441842+0300 2019-06-18T08:37:26.441842+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
53461 897 swimming_water_cyanobacteria 2019-06-17T09:16:33.034954+0300 2019-06-18T09:16:33.034954+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39823 899 swimming_water_cyanobacteria 2019-06-17T09:34:09.734799+0300 2019-06-18T09:34:09.734799+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
39412 905 swimming_water_cyanobacteria 2019-06-17T10:05:21.419065+0300 2019-06-18T10:05:21.419065+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40802 910 swimming_water_cyanobacteria 2019-06-17T10:16:55.530860+0300 2019-06-18T10:16:55.530860+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 912 swimming_water_cyanobacteria 2019-06-17T10:31:50.180847+0300 2019-06-18T10:31:50.180847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 914 swimming_water_cyanobacteria 2019-06-17T10:42:14.993300+0300 2019-06-18T10:42:14.993300+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 916 swimming_water_cyanobacteria 2019-06-17T10:52:19.847758+0300 2019-06-18T10:52:19.847758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 919 swimming_water_cyanobacteria 2019-06-17T10:58:25.195607+0300 2019-06-18T10:58:25.195607+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39527 921 swimming_water_cyanobacteria 2019-06-17T11:16:58.025091+0300 2019-06-18T11:16:58.025091+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 925 swimming_water_cyanobacteria 2019-06-17T13:05:46.817394+0300 2019-06-18T13:05:46.817394+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40950 941 swimming_water_cyanobacteria 2019-06-17T15:02:38.139510+0300 2019-06-18T15:02:38.139510+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good