servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40950 342 swimming_water_cyanobacteria 2019-06-09T10:22:30.603308+0300 2019-06-10T10:22:30.603308+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 344 swimming_water_cyanobacteria 2019-06-09T10:23:09.627366+0300 2019-06-10T10:23:09.627366+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 346 swimming_water_cyanobacteria 2019-06-09T10:31:52.689274+0300 2019-06-10T10:31:52.689274+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40258 349 swimming_water_cyanobacteria 2019-06-09T10:45:17.109611+0300 2019-06-10T10:45:17.109611+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 353 swimming_water_cyanobacteria 2019-06-09T12:28:44.046330+0300 2019-06-10T12:28:44.046330+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40098 355 swimming_water_cyanobacteria 2019-06-09T12:28:44.546780+0300 2019-06-10T12:28:44.546780+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 357 swimming_water_cyanobacteria 2019-06-09T13:56:42.913548+0300 2019-06-10T13:56:42.913548+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  
39693 370 swimming_water_cyanobacteria 2019-06-09T14:14:29.120574+0300 2019-06-10T14:14:29.120574+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 373 swimming_water_cyanobacteria 2019-06-09T17:53:48.981656+0300 2019-06-10T17:53:48.981656+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  
39693 383 swimming_water_cyanobacteria 2019-06-10T08:15:56.422459+0300 2019-06-11T08:15:56.422459+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 386 swimming_water_cyanobacteria 2019-06-10T10:00:37.594878+0300 2019-06-11T10:00:37.594878+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 390 swimming_water_cyanobacteria 2019-06-10T10:01:21.412341+0300 2019-06-11T10:01:21.412341+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  
40098 394 swimming_water_cyanobacteria 2019-06-10T10:08:31.654594+0300 2019-06-11T10:08:31.654594+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 396 swimming_water_cyanobacteria 2019-06-10T10:13:31.326147+0300 2019-06-11T10:13:31.326147+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 398 swimming_water_cyanobacteria 2019-06-10T10:18:11.463679+0300 2019-06-11T10:18:11.463679+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 401 swimming_water_cyanobacteria 2019-06-10T10:29:44.114543+0300 2019-06-11T10:29:44.114543+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 404 swimming_water_cyanobacteria 2019-06-10T10:37:20.987688+0300 2019-06-11T10:37:20.987688+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41960 406 swimming_water_cyanobacteria 2019-06-10T10:58:00.377675+0300 2019-06-11T10:58:00.377675+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  
39815 411 swimming_water_cyanobacteria 2019-06-10T13:46:23.888435+0300 2019-06-11T13:46:23.888435+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 417 swimming_water_cyanobacteria 2019-06-10T14:11:32.609062+0300 2019-06-11T14:11:32.609062+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 419 swimming_water_cyanobacteria 2019-06-10T14:52:41.206758+0300 2019-06-11T14:52:41.206758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 422 swimming_water_cyanobacteria 2019-06-10T14:54:29.068159+0300 2019-06-11T14:54:29.068159+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  
39693 427 swimming_water_cyanobacteria 2019-06-10T18:30:43.704157+0300 2019-06-11T18:30:43.704157+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41031 430 swimming_water_cyanobacteria 2019-06-11T07:35:42.220978+0300 2019-06-12T07:35:42.220978+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41326 432 swimming_water_cyanobacteria 2019-06-11T07:35:56.656586+0300 2019-06-12T07:35:56.656586+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41907 434 swimming_water_cyanobacteria 2019-06-11T07:36:05.845510+0300 2019-06-12T07:36:05.845510+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40921 436 swimming_water_cyanobacteria 2019-06-11T07:36:23.152748+0300 2019-06-12T07:36:23.152748+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40798 439 swimming_water_cyanobacteria 2019-06-11T07:36:41.929412+0300 2019-06-12T07:36:41.929412+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40677 441 swimming_water_cyanobacteria 2019-06-11T07:36:54.529471+0300 2019-06-12T07:36:54.529471+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40020 443 swimming_water_cyanobacteria 2019-06-11T07:37:01.114405+0300 2019-06-12T07:37:01.114405+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39910 445 swimming_water_cyanobacteria 2019-06-11T07:37:08.591196+0300 2019-06-12T07:37:08.591196+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40993 447 swimming_water_cyanobacteria 2019-06-11T07:37:46.831194+0300 2019-06-12T07:37:46.831194+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40356 449 swimming_water_cyanobacteria 2019-06-11T07:38:17.423789+0300 2019-06-12T07:38:17.423789+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40386 452 swimming_water_cyanobacteria 2019-06-11T07:38:51.782632+0300 2019-06-12T07:38:51.782632+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 455 swimming_water_cyanobacteria 2019-06-11T09:16:16.519724+0300 2019-06-12T09:16:16.519724+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  
39815 463 swimming_water_cyanobacteria 2019-06-11T09:53:01.371030+0300 2019-06-12T09:53:01.371030+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 466 swimming_water_cyanobacteria 2019-06-11T10:03:18.853097+0300 2019-06-12T10:03:18.853097+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 468 swimming_water_cyanobacteria 2019-06-11T10:05:14.243595+0300 2019-06-12T10:05:14.243595+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40802 470 swimming_water_cyanobacteria 2019-06-11T10:05:23.903992+0300 2019-06-12T10:05:23.903992+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 472 swimming_water_cyanobacteria 2019-06-11T10:06:26.307959+0300 2019-06-12T10:06:26.307959+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  
40157 479 swimming_water_cyanobacteria 2019-06-11T10:10:58.231946+0300 2019-06-12T10:10:58.231946+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 481 swimming_water_cyanobacteria 2019-06-11T10:14:53.978415+0300 2019-06-12T10:14:53.978415+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 484 swimming_water_cyanobacteria 2019-06-11T10:21:13.353548+0300 2019-06-12T10:21:13.353548+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41960 487 swimming_water_cyanobacteria 2019-06-11T10:26:22.358050+0300 2019-06-12T10:26:22.358050+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 490 swimming_water_cyanobacteria 2019-06-11T10:53:15.152961+0300 2019-06-12T10:53:15.152961+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 500 swimming_water_cyanobacteria 2019-06-11T11:59:42.856179+0300 2019-06-12T11:59:42.856179+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 550 swimming_water_cyanobacteria 2019-06-11T12:44:10.021123+0300 2019-06-12T12:44:10.021123+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  
39815 557 swimming_water_cyanobacteria 2019-06-11T13:54:55.773598+0300 2019-06-12T13:54:55.773598+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
40258 562 swimming_water_cyanobacteria 2019-06-11T16:54:12.388740+0300 2019-06-12T16:54:12.388740+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  
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  
39815 570 swimming_water_cyanobacteria 2019-06-11T18:08:21.431872+0300 2019-06-12T18:08:21.431872+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  
40802 575 swimming_water_cyanobacteria 2019-06-12T10:06:32.496663+0300 2019-06-13T10:06:32.496663+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41960 577 swimming_water_cyanobacteria 2019-06-12T10:08:24.015560+0300 2019-06-13T10:08:24.015560+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 579 swimming_water_cyanobacteria 2019-06-12T10:11:37.359100+0300 2019-06-13T10:11:37.359100+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 582 swimming_water_cyanobacteria 2019-06-12T10:12:32.121792+0300 2019-06-13T10:12:32.121792+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 584 swimming_water_cyanobacteria 2019-06-12T10:20:30.910174+0300 2019-06-13T10:20:30.910174+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 589 swimming_water_cyanobacteria 2019-06-12T10:42:01.871360+0300 2019-06-13T10:42:01.871360+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  
40142 593 swimming_water_cyanobacteria 2019-06-12T10:48:04.357717+0300 2019-06-13T10:48:04.357717+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40098 596 swimming_water_cyanobacteria 2019-06-12T10:52:27.404247+0300 2019-06-13T10:52:27.404247+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 599 swimming_water_cyanobacteria 2019-06-12T11:38:13.717303+0300 2019-06-13T11:38:13.717303+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 604 swimming_water_cyanobacteria 2019-06-12T12:38:43.950684+0300 2019-06-13T12:38:43.950684+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  
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  
39693 610 swimming_water_cyanobacteria 2019-06-12T14:12:19.625168+0300 2019-06-13T14:12:19.625168+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 613 swimming_water_cyanobacteria 2019-06-12T14:28:56.682025+0300 2019-06-13T14:28:56.682025+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 618 swimming_water_cyanobacteria 2019-06-12T17:47:24.638151+0300 2019-06-13T17:47:24.638151+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  
39815 623 swimming_water_cyanobacteria 2019-06-12T18:06:28.230122+0300 2019-06-13T18:06:28.230122+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39527 628 swimming_water_cyanobacteria 2019-06-12T19:05:56.364310+0300 2019-06-13T19:05:56.364310+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39713 631 swimming_water_cyanobacteria 2019-06-13T07:47:31.268741+0300 2019-06-14T07:47:31.268741+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39875 635 swimming_water_cyanobacteria 2019-06-13T08:05:36.869605+0300 2019-06-14T08:05:36.869605+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39902 637 swimming_water_cyanobacteria 2019-06-13T08:21:56.972791+0300 2019-06-14T08:21:56.972791+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39606 639 swimming_water_cyanobacteria 2019-06-13T08:33:05.309793+0300 2019-06-14T08:33:05.309793+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
53461 641 swimming_water_cyanobacteria 2019-06-13T09:33:43.191169+0300 2019-06-14T09:33:43.191169+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39823 643 swimming_water_cyanobacteria 2019-06-13T09:47:43.757012+0300 2019-06-14T09:47:43.757012+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40559 645 swimming_water_cyanobacteria 2019-06-13T10:01:59.965195+0300 2019-06-14T10:01:59.965195+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 648 swimming_water_cyanobacteria 2019-06-13T10:03:35.039828+0300 2019-06-14T10:03:35.039828+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  
41601 656 swimming_water_cyanobacteria 2019-06-13T10:09:21.718986+0300 2019-06-14T10:09:21.718986+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40802 658 swimming_water_cyanobacteria 2019-06-13T10:12:32.746326+0300 2019-06-14T10:12:32.746326+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 661 swimming_water_cyanobacteria 2019-06-13T10:26:07.891348+0300 2019-06-14T10:26:07.891348+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41960 663 swimming_water_cyanobacteria 2019-06-13T10:30:05.838495+0300 2019-06-14T10:30:05.838495+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 665 swimming_water_cyanobacteria 2019-06-13T10:50:07.350226+0300 2019-06-14T10:50:07.350226+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
52959 670 swimming_water_cyanobacteria 2019-06-13T10:50:38.943623+0300 2019-06-14T10:50:38.943623+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40150 672 swimming_water_cyanobacteria 2019-06-13T11:20:04.091525+0300 2019-06-14T11:20:04.091525+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 674 swimming_water_cyanobacteria 2019-06-13T11:38:22.437978+0300 2019-06-14T11:38:22.437978+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39412 676 swimming_water_cyanobacteria 2019-06-13T12:30:11.239602+0300 2019-06-14T12:30:11.239602+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39368 678 swimming_water_cyanobacteria 2019-06-13T12:55:23.748073+0300 2019-06-14T12:55:23.748073+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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