servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40950 146 swimming_water_temperature 2019-06-06T10:43:25.862374+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 147 swimming_water_temperature 2019-06-06T10:43:25.994094+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40950 148 swimming_water_temperature 2019-06-06T10:43:26.123955+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40950 149 swimming_water_temperature 2019-06-06T10:43:26.250756+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41601 150 swimming_water_temperature 2019-06-06T11:02:33.045041+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41601 151 swimming_water_cyanobacteria 2019-06-06T11:02:35.952682+0300 2019-06-07T11:02:35.952682+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 152 swimming_water_temperature 2019-06-06T11:07:55.044976+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40258 153 swimming_water_temperature 2019-06-06T11:12:03.138542+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40258 154 swimming_water_cyanobacteria 2019-06-06T11:12:15.839226+0300 2019-06-07T11:12:15.839226+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40258 155 notice 2019-06-06T11:12:51.462661+0300   Valvonta rannalla klo 10-20                
40258 156 notice 2019-06-06T11:12:54.305655+0300   Valvonta rannalla klo 10-20                
40258 157 notice 2019-06-06T11:12:59.825480+0300   Valvonta rannalla klo 10-20                
40386 158 swimming_water_temperature 2019-06-06T11:16:25.589048+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40386 159 swimming_water_cyanobacteria 2019-06-06T11:16:25.743543+0300 2019-06-07T11:16:25.743543+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40098 160 swimming_water_temperature 2019-06-06T11:16:25.883143+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40098 161 swimming_water_cyanobacteria 2019-06-06T11:16:26.025466+0300 2019-06-07T11:16:26.025466+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 162 swimming_water_temperature 2019-06-06T11:16:26.153952+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39815 163 swimming_water_cyanobacteria 2019-06-06T11:16:26.291071+0300 2019-06-07T11:16:26.291071+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 164 notice 2019-06-06T11:16:26.425912+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 17cº                
39583 165 notice 2019-06-06T11:16:26.561632+0300   Kesän 2018 uimavalvontakausi on päättynyt! Uimavalvonta alkaa 24.6.2019                
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 167 notice 2019-06-06T11:41:52.730227+0300                    
40993 168 swimming_water_cyanobacteria 2019-06-06T12:51:31.368644+0300 2019-06-07T12:51:31.368644+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40993 169 swimming_water_temperature 2019-06-06T12:51:31.517274+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40993 170 swimming_water_temperature 2019-06-06T12:51:31.651501+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40993 171 notice 2019-06-06T12:51:31.778077+0300   Nyt kelpaa tulla rannalle!                
40993 172 notice 2019-06-06T12:51:31.922245+0300   Nyt kelpaa tulla rannalle!                
39267 173 swimming_water_temperature 2019-06-06T12:51:32.063938+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39693 174 swimming_water_cyanobacteria 2019-06-06T13:43:56.339090+0300 2019-06-07T13:43:56.339090+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 175 notice 2019-06-06T13:44:06.992427+0300   Vesi 18ºC                
39693 176 notice 2019-06-06T13:44:08.786185+0300   Vesi 18ºC                
39693 177 notice 2019-06-06T13:58:01.816849+0300   Veden lämpötila 20 astetta                
39693 178 notice 2019-06-06T13:58:21.565949+0300   Veden lämpötila 20 astetta                
39693 179 notice 2019-06-06T13:58:31.449750+0300   Veden lämpötila 20 astetta                
39267 180 swimming_water_temperature 2019-06-06T14:10:39.608279+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
40950 182 swimming_water_temperature 2019-06-06T14:10:39.914760+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39815 183 notice 2019-06-06T15:18:31.776116+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 19ºC                
39815 184 swimming_water_temperature 2019-06-06T15:18:31.932506+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
39815 185 swimming_water_cyanobacteria 2019-06-06T15:18:32.085266+0300 2019-06-07T15:18:32.085266+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40386 186 swimming_water_temperature 2019-06-06T15:18:32.220657+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 187 swimming_water_temperature 2019-06-06T17:51:51.799967+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 188 swimming_water_cyanobacteria 2019-06-06T17:51:56.490257+0300 2019-06-07T17:51:56.490257+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 189 swimming_water_temperature 2019-06-06T19:43:24.985518+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 190 swimming_water_cyanobacteria 2019-06-06T19:43:29.756550+0300 2019-06-07T19:43:29.756550+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 191 notice 2019-06-06T19:43:40.879925+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 19ºC                
39815 192 swimming_water_temperature 2019-06-07T08:30:29.052361+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 193 swimming_water_cyanobacteria 2019-06-07T08:30:31.141466+0300 2019-06-08T08:30:31.141466+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 194 notice 2019-06-07T08:30:53.437773+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 20ºC                
39693 195 swimming_water_temperature 2019-06-07T09:40:40.293487+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 196 swimming_water_cyanobacteria 2019-06-07T09:40:44.456354+0300 2019-06-08T09:40:44.456354+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39527 197 swimming_water_temperature 2019-06-07T09:44:25.167317+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39527 198 swimming_water_cyanobacteria 2019-06-07T09:44:25.383206+0300 2019-06-08T09:44:25.383206+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39527 199 notice 2019-06-07T09:44:25.598278+0300   Kesän 2019 uimavalvontakausi on alkanut!                
39527 200 notice 2019-06-07T09:44:25.795468+0300   Kesän 2019 uimavalvontakausi on alkanut!                
39815 201 swimming_water_temperature 2019-06-07T09:58:44.666515+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 202 swimming_water_cyanobacteria 2019-06-07T09:58:46.944319+0300 2019-06-08T09:58:46.944319+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39527 203 notice 2019-06-07T10:00:53.010960+0300   Kesän 2019 uimavalvontakausi on alkanut!                
40802 204 swimming_water_temperature 2019-06-07T10:02:44.386293+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40802 205 swimming_water_cyanobacteria 2019-06-07T10:02:46.586267+0300 2019-06-08T10:02:46.586267+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40950 206 swimming_water_temperature 2019-06-07T10:09:54.471137+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41601 207 swimming_water_temperature 2019-06-07T10:14:41.514036+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 208 swimming_water_cyanobacteria 2019-06-07T10:14:43.966094+0300 2019-06-08T10:14:43.966094+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41601 209 notice 2019-06-07T10:16:31.947231+0300   Puh. 0504013590Sisäpukukopit suljetaan 1730Ulkosuihku, - pukukoppi ja bajamaja käytössä kellon ympäri                
41601 210 notice 2019-06-07T10:17:00.874242+0300   Puh. 0504013590 /Sisäpukukopit suljetaan 1730 /Ulkosuihku, - pukukoppi ja bajamaja käytössä kellon ympäri                
41791 211 swimming_water_temperature 2019-06-07T10:24:59.111664+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 212 swimming_water_temperature 2019-06-07T10:25:44.452775+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 213 swimming_water_temperature 2019-06-07T10:26:07.112503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40150 214 swimming_water_temperature 2019-06-07T10:35:30.790678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40150 215 swimming_water_cyanobacteria 2019-06-07T10:35:31.010497+0300 2019-06-08T10:35:31.010497+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40157 216 swimming_water_temperature 2019-06-07T10:35:43.267632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 217 swimming_water_cyanobacteria 2019-06-07T10:35:47.192802+0300 2019-06-08T10:35:47.192802+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 218 swimming_water_temperature 2019-06-07T11:22:11.956190+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
40142 219 swimming_water_cyanobacteria 2019-06-07T11:22:19.144470+0300 2019-06-08T11:22:19.144470+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
40142 220 notice 2019-06-07T11:22:30.692790+0300   Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa.                
40142 221 notice 2019-06-07T11:22:34.578216+0300   Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa.                
39322 222 swimming_water_temperature 2019-06-07T11:23:40.887777+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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 224 swimming_water_temperature 2019-06-07T11:35:37.055471+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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 226 swimming_water_temperature 2019-06-07T11:35:37.494252+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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 228 swimming_water_temperature 2019-06-07T11:35:37.963596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
40559 230 swimming_water_temperature 2019-06-07T12:33:44.310597+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 231 swimming_water_cyanobacteria 2019-06-07T12:33:46.546318+0300 2019-06-08T12:33:46.546318+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
41791 232 swimming_water_temperature 2019-06-07T13:42:22.858744+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 233 notice 2019-06-07T13:42:34.258751+0300                    
41791 234 notice 2019-06-07T13:42:36.560646+0300                    
41791 235 swimming_water_temperature 2019-06-07T13:45:23.030764+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
41791 236 swimming_water_cyanobacteria 2019-06-07T13:45:35.883926+0300 2019-06-08T13:45:35.883926+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 237 swimming_water_cyanobacteria 2019-06-07T13:53:20.573133+0300 2019-06-08T13:53:20.573133+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39693 238 swimming_water_temperature 2019-06-07T13:53:24.595690+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 239 notice 2019-06-07T13:53:42.721581+0300   Veden lämpötila 21º astetta                
39815 240 swimming_water_temperature 2019-06-07T14:12:33.987424+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 241 swimming_water_cyanobacteria 2019-06-07T14:12:36.283058+0300 2019-06-08T14:12:36.283058+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
39815 242 notice 2019-06-07T14:12:53.667506+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 22°C                
39815 243 notice 2019-06-07T14:12:55.238468+0300   Kesän 2019 uimavalvontakausi on Alkanut! Vesi 22°C                
39322 244 swimming_water_temperature 2019-06-07T15:15:49.773357+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 245 swimming_water_temperature 2019-06-07T15:17:51.123747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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