servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40950 277 swimming_water_temperature 2019-06-08T10:42:23.679616+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 279 swimming_water_temperature 2019-06-08T10:42:31.568387+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 280 swimming_water_temperature 2019-06-08T10:42:39.967382+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40142 282 swimming_water_temperature 2019-06-08T10:56:28.697399+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39568 285 swimming_water_temperature 2019-06-08T11:04:03.917676+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39568 287 swimming_water_temperature 2019-06-08T11:04:17.424698+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40950 288 swimming_water_temperature 2019-06-08T13:50:00.248514+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 289 swimming_water_temperature 2019-06-08T14:07:46.413233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 293 swimming_water_temperature 2019-06-08T14:37:24.368764+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 296 swimming_water_temperature 2019-06-08T17:01:07.633245+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 298 swimming_water_temperature 2019-06-08T17:52:09.671494+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 301 swimming_water_temperature 2019-06-08T17:58:54.777603+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 303 swimming_water_temperature 2019-06-08T17:59:20.966316+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40921 310 swimming_water_temperature 2019-06-09T08:58:41.314672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41326 312 swimming_water_temperature 2019-06-09T08:59:01.215687+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40020 314 swimming_water_temperature 2019-06-09T08:59:13.060529+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40677 316 swimming_water_temperature 2019-06-09T08:59:50.077804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41907 318 swimming_water_temperature 2019-06-09T09:00:59.552292+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39910 320 swimming_water_temperature 2019-06-09T09:01:09.742957+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40798 322 swimming_water_temperature 2019-06-09T09:01:21.102140+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 324 swimming_water_temperature 2019-06-09T09:56:10.160415+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41601 326 swimming_water_temperature 2019-06-09T10:04:55.527909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 328 swimming_water_temperature 2019-06-09T10:07:57.806433+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 331 swimming_water_temperature 2019-06-09T10:13:45.481338+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40559 334 swimming_water_temperature 2019-06-09T10:15:07.789629+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 336 swimming_water_temperature 2019-06-09T10:15:16.605748+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 339 swimming_water_temperature 2019-06-09T10:21:42.793020+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40950 341 swimming_water_temperature 2019-06-09T10:22:13.251403+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 343 swimming_water_temperature 2019-06-09T10:23:07.028385+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40142 345 swimming_water_temperature 2019-06-09T10:31:49.644740+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40258 348 swimming_water_temperature 2019-06-09T10:45:11.049642+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 352 swimming_water_temperature 2019-06-09T12:28:43.832936+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40098 354 swimming_water_temperature 2019-06-09T12:28:44.344657+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 356 swimming_water_temperature 2019-06-09T13:56:38.214778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 366 swimming_water_temperature 2019-06-09T14:07:43.671307+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39693 368 swimming_water_temperature 2019-06-09T14:14:24.082178+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 371 swimming_water_temperature 2019-06-09T17:53:47.088974+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 374 swimming_water_temperature 2019-06-09T17:54:11.286114+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 376 swimming_water_temperature 2019-06-09T18:17:47.234884+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 377 swimming_water_temperature 2019-06-09T18:17:50.236158+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 381 swimming_water_temperature 2019-06-09T18:44:40.198426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 382 swimming_water_temperature 2019-06-10T08:15:53.628150+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 385 swimming_water_temperature 2019-06-10T10:00:34.828200+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41791 389 swimming_water_temperature 2019-06-10T10:01:18.592635+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39322 391 swimming_water_temperature 2019-06-10T10:01:21.612696+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40098 393 swimming_water_temperature 2019-06-10T10:07:48.757221+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41601 395 swimming_water_temperature 2019-06-10T10:13:27.071351+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 397 swimming_water_temperature 2019-06-10T10:18:09.001672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 400 swimming_water_temperature 2019-06-10T10:29:40.224791+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39267 402 swimming_water_temperature 2019-06-10T10:34:16.433547+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 403 swimming_water_temperature 2019-06-10T10:37:08.378059+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 405 swimming_water_temperature 2019-06-10T10:57:42.684782+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 408 swimming_water_temperature 2019-06-10T13:40:51.100444+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39322 410 swimming_water_temperature 2019-06-10T13:45:12.831410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39815 413 swimming_water_temperature 2019-06-10T13:46:34.972562+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 414 swimming_water_temperature 2019-06-10T13:56:59.031717+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 416 swimming_water_temperature 2019-06-10T14:11:28.424217+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 418 swimming_water_temperature 2019-06-10T14:52:12.889585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 421 swimming_water_temperature 2019-06-10T14:54:25.564905+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40258 423 swimming_water_temperature 2019-06-10T15:03:59.731489+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39322 424 swimming_water_temperature 2019-06-10T17:50:52.926026+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 426 swimming_water_temperature 2019-06-10T18:30:40.103809+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41031 429 swimming_water_temperature 2019-06-11T07:35:39.937460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41326 431 swimming_water_temperature 2019-06-11T07:35:54.816735+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41907 433 swimming_water_temperature 2019-06-11T07:36:03.716690+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40921 435 swimming_water_temperature 2019-06-11T07:36:19.863504+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 437 swimming_water_temperature 2019-06-11T07:36:30.314633+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 438 swimming_water_temperature 2019-06-11T07:36:37.529518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40677 440 swimming_water_temperature 2019-06-11T07:36:52.756253+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40020 442 swimming_water_temperature 2019-06-11T07:36:59.454932+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39910 444 swimming_water_temperature 2019-06-11T07:37:06.926794+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40993 446 swimming_water_temperature 2019-06-11T07:37:44.991784+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40356 448 swimming_water_temperature 2019-06-11T07:38:15.879350+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40386 450 swimming_water_temperature 2019-06-11T07:38:45.000109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40386 451 swimming_water_temperature 2019-06-11T07:38:49.711036+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39693 453 swimming_water_temperature 2019-06-11T09:16:02.376158+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 454 swimming_water_temperature 2019-06-11T09:16:09.387097+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 460 swimming_water_temperature 2019-06-11T09:50:53.764841+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39815 462 swimming_water_temperature 2019-06-11T09:52:59.453634+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 465 swimming_water_temperature 2019-06-11T10:03:10.490044+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 467 swimming_water_temperature 2019-06-11T10:05:11.341226+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40802 469 swimming_water_temperature 2019-06-11T10:05:21.394543+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 471 swimming_water_temperature 2019-06-11T10:06:22.076433+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 477 swimming_water_temperature 2019-06-11T10:10:30.491830+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 478 swimming_water_temperature 2019-06-11T10:10:55.622586+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 480 swimming_water_temperature 2019-06-11T10:14:49.301140+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39693 483 swimming_water_temperature 2019-06-11T10:21:09.542309+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 486 swimming_water_temperature 2019-06-11T10:26:20.184265+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 488 swimming_water_temperature 2019-06-11T10:41:02.674258+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41601 489 swimming_water_temperature 2019-06-11T10:53:12.365926+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41791 549 swimming_water_temperature 2019-06-11T12:44:05.760815+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39693 553 swimming_water_temperature 2019-06-11T13:43:38.386127+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 554 swimming_water_temperature 2019-06-11T13:45:44.348861+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 556 swimming_water_temperature 2019-06-11T13:54:53.119475+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 560 swimming_water_temperature 2019-06-11T14:00:08.545368+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40258 561 swimming_water_temperature 2019-06-11T16:53:54.604428+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39322 565 swimming_water_temperature 2019-06-11T17:52:45.689952+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 567 swimming_water_temperature 2019-06-11T17:56:58.976591+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 569 swimming_water_temperature 2019-06-11T18:08:16.960792+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 572 swimming_water_temperature 2019-06-12T10:04:11.081301+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40802 574 swimming_water_temperature 2019-06-12T10:06:27.423087+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown