servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
60871 7323 ski_trail_maintenance 2020-02-06T00:24:34.490282+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7327 ski_trail_maintenance 2020-02-06T08:00:16.857249+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7353 ski_trail_maintenance 2020-02-06T13:58:35.149930+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7372 ski_trail_maintenance 2020-02-07T05:49:26.323084+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7422 ski_trail_maintenance 2020-02-07T18:58:45.551149+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7426 ski_trail_maintenance 2020-02-08T06:44:59.727346+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7443 ski_trail_maintenance 2020-02-08T09:55:15.643443+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7450 ski_trail_maintenance 2020-02-08T11:11:04.440142+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7455 ski_trail_maintenance 2020-02-08T13:16:51.022202+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7459 ski_trail_maintenance 2020-02-08T16:26:09.418862+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7477 ski_trail_maintenance 2020-02-09T08:14:29.411644+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7491 ski_trail_maintenance 2020-02-09T11:09:37.721240+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7521 ski_trail_maintenance 2020-02-10T08:36:42.291038+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7551 ski_trail_maintenance 2020-02-11T06:17:52.833501+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7565 ski_trail_maintenance 2020-02-11T13:44:17.099742+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7581 ski_trail_maintenance 2020-02-12T07:50:36.634179+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7607 ski_trail_maintenance 2020-02-13T07:59:42.417578+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7609 ski_trail_maintenance 2020-02-13T08:16:01.120662+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7616 ski_trail_maintenance 2020-02-13T13:16:02.728670+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7618 ski_trail_maintenance 2020-02-13T13:23:18.835539+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7633 ski_trail_maintenance 2020-02-14T09:26:42.848904+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7636 ski_trail_maintenance 2020-02-14T09:55:48.094355+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7641 ski_trail_maintenance 2020-02-14T13:44:15.553657+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7647 ski_trail_maintenance 2020-02-15T03:43:44.409406+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
54329 7649 ski_trail_maintenance 2020-02-15T03:44:25.849912+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7653 ski_trail_maintenance 2020-02-15T06:45:32.218884+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7655 ski_trail_maintenance 2020-02-15T07:09:46.017331+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7742 ski_trail_maintenance 2020-02-19T07:58:28.133899+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7745 ski_trail_maintenance 2020-02-19T08:09:24.405837+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7769 ski_trail_maintenance 2020-02-19T22:42:28.908174+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7771 ski_trail_maintenance 2020-02-20T00:52:20.900814+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7849 ski_trail_maintenance 2020-02-24T22:14:31.815186+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7866 ski_trail_maintenance 2020-02-25T09:47:38.728329+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
51086 7871 ski_trail_maintenance 2020-02-25T12:03:44.898028+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7927 ski_trail_maintenance 2020-02-28T04:52:34.368224+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7944 ski_trail_maintenance 2020-02-28T15:31:54.435420+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7951 ski_trail_maintenance 2020-02-29T06:46:24.181772+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7953 ski_trail_maintenance 2020-02-29T07:17:20.026242+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7966 ski_trail_maintenance 2020-02-29T13:43:59.514229+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7974 ski_trail_maintenance 2020-02-29T15:04:04.897212+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7984 ski_trail_maintenance 2020-03-01T07:53:48.833028+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7991 ski_trail_maintenance 2020-03-01T09:36:09.384585+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8006 ski_trail_maintenance 2020-03-02T07:54:35.921101+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8009 ski_trail_maintenance 2020-03-02T09:19:20.582421+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8014 ski_trail_maintenance 2020-03-02T10:26:49.134372+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8016 ski_trail_maintenance 2020-03-02T12:56:01.941416+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8029 ski_trail_maintenance 2020-03-02T22:36:06.751040+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8034 ski_trail_maintenance 2020-03-03T07:47:51.051472+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8040 ski_trail_maintenance 2020-03-03T09:10:10.738725+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8042 ski_trail_maintenance 2020-03-03T12:24:11.435003+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8052 ski_trail_maintenance 2020-03-04T09:19:56.446391+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8071 ski_trail_maintenance 2020-03-05T08:38:49.705571+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8078 ski_trail_maintenance 2020-03-05T13:52:03.963809+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8083 ski_trail_maintenance 2020-03-06T08:08:53.044979+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8102 ski_trail_maintenance 2020-03-06T12:41:40.542658+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8104 ski_trail_maintenance 2020-03-06T13:38:25.245857+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8111 ski_trail_maintenance 2020-03-07T00:40:29.937266+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8124 ski_trail_maintenance 2020-03-07T16:13:54.098929+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8128 ski_trail_maintenance 2020-03-08T07:49:30.428948+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8131 ski_trail_maintenance 2020-03-08T08:23:49.721343+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8138 ski_trail_maintenance 2020-03-08T10:38:22.987654+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8147 ski_trail_maintenance 2020-03-09T07:05:19.199434+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8166 ski_trail_maintenance 2020-03-10T07:08:25.482086+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8181 ski_trail_maintenance 2020-03-10T13:37:33.621502+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8194 ski_trail_maintenance 2020-03-12T08:49:57.146671+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8202 ski_trail_maintenance 2020-03-12T12:41:52.934489+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8212 ski_trail_maintenance 2020-03-13T08:30:55.333394+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8229 ski_trail_maintenance 2020-03-14T11:15:26.033939+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8238 ski_trail_maintenance 2020-03-15T02:03:02.603783+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8242 ski_trail_maintenance 2020-03-15T09:23:58.613945+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8261 ski_trail_maintenance 2020-03-16T09:27:58.359621+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8265 ski_trail_maintenance 2020-03-16T12:44:48.974622+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8270 ski_trail_maintenance 2020-03-16T15:04:03.490018+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8279 ski_trail_maintenance 2020-03-17T07:42:43.043355+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8281 ski_trail_maintenance 2020-03-17T08:46:21.661452+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8285 ski_trail_maintenance 2020-03-17T09:26:03.990867+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8287 ski_trail_maintenance 2020-03-17T11:55:16.286272+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8291 ski_trail_maintenance 2020-03-17T13:28:13.865996+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8295 ski_trail_maintenance 2020-03-18T07:51:46.366764+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8297 ski_trail_maintenance 2020-03-18T08:15:55.392234+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8306 ski_trail_maintenance 2020-03-19T08:00:34.196525+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8315 ski_trail_maintenance 2020-03-20T06:26:03.690872+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8324 ski_trail_maintenance 2020-03-21T08:22:42.718269+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8328 ski_trail_maintenance 2020-03-21T11:40:11.499262+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 8332 ski_trail_maintenance 2020-03-22T01:20:40.714734+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8336 ski_trail_maintenance 2020-03-22T08:19:37.199729+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 8340 ski_trail_maintenance 2020-03-22T10:44:49.506667+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 8342 ski_trail_maintenance 2020-03-22T21:11:42.745322+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 41917 ski_trail_maintenance 2020-12-11T16:09:15.450515+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 42518 ski_trail_maintenance 2020-12-13T12:42:55.526175+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 42722 ski_trail_maintenance 2020-12-14T04:43:27.140083+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 42724 ski_trail_maintenance 2020-12-14T04:43:32.329164+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 42873 ski_trail_maintenance 2020-12-14T15:40:19.068128+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 43235 ski_trail_maintenance 2020-12-15T18:15:22.964565+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 43350 ski_trail_maintenance 2020-12-16T02:58:58.706463+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 43414 ski_trail_maintenance 2020-12-16T07:11:33.976982+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 43744 ski_trail_maintenance 2020-12-17T07:03:20.878325+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 43778 ski_trail_maintenance 2020-12-17T09:08:00.553888+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 43849 ski_trail_maintenance 2020-12-17T13:50:28.864271+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 44066 ski_trail_maintenance 2020-12-18T06:41:50.663424+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 44127 ski_trail_maintenance 2020-12-18T10:10:18.986324+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown