servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
53710 6015 ski_trail_maintenance 2019-11-08T14:21:00.052967+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6018 ski_trail_maintenance 2019-11-09T23:47:01.036909+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6047 ski_trail_maintenance 2019-11-16T01:05:56.223240+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6119 ski_trail_maintenance 2019-11-25T14:06:25.226345+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6125 ski_trail_maintenance 2019-11-26T08:37:51.926400+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6160 ski_trail_maintenance 2019-11-27T10:12:39.120372+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6200 ski_trail_maintenance 2019-12-01T11:09:04.755950+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6205 ski_trail_maintenance 2019-12-02T07:12:42.393218+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6236 ski_trail_maintenance 2019-12-04T08:14:21.041850+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6251 ski_trail_maintenance 2019-12-05T06:47:02.298313+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6288 ski_trail_maintenance 2019-12-07T22:30:27.408710+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6320 ski_trail_maintenance 2019-12-10T11:54:29.446483+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6338 ski_trail_maintenance 2019-12-11T08:55:58.890711+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6342 ski_trail_maintenance 2019-12-11T09:08:19.813530+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6380 ski_trail_maintenance 2019-12-13T13:57:33.341521+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6387 ski_trail_maintenance 2019-12-14T10:38:45.600268+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6395 ski_trail_maintenance 2019-12-15T07:39:59.437880+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6417 ski_trail_maintenance 2019-12-16T12:25:51.151374+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6441 ski_trail_maintenance 2019-12-19T07:45:54.212502+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6445 ski_trail_maintenance 2019-12-19T08:26:13.707965+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6455 ski_trail_maintenance 2019-12-20T00:04:26.555249+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6463 ski_trail_maintenance 2019-12-20T08:45:19.352442+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6470 ski_trail_maintenance 2019-12-21T10:07:09.645066+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6475 ski_trail_maintenance 2019-12-21T22:15:08.210428+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6477 ski_trail_maintenance 2019-12-22T00:04:11.782017+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6488 ski_trail_maintenance 2019-12-23T06:55:35.440364+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6492 ski_trail_maintenance 2019-12-23T08:26:52.872679+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6511 ski_trail_maintenance 2019-12-25T06:24:02.901542+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6513 ski_trail_maintenance 2019-12-25T08:50:10.732707+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6519 ski_trail_maintenance 2019-12-26T08:21:36.458645+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6529 ski_trail_maintenance 2019-12-27T08:13:48.995474+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6547 ski_trail_maintenance 2019-12-28T06:39:35.545330+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6567 ski_trail_maintenance 2019-12-29T08:51:39.970376+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6580 ski_trail_maintenance 2019-12-29T11:19:37.341758+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6584 ski_trail_maintenance 2019-12-30T07:13:10.054466+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6600 ski_trail_maintenance 2019-12-31T07:42:35.781015+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6609 ski_trail_maintenance 2019-12-31T21:31:32.314416+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6611 ski_trail_maintenance 2020-01-01T07:44:18.918301+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6615 ski_trail_maintenance 2020-01-02T07:13:32.980528+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6617 ski_trail_maintenance 2020-01-02T07:22:42.310049+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6631 ski_trail_maintenance 2020-01-02T10:00:45.665837+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6633 ski_trail_maintenance 2020-01-03T06:51:07.389426+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6649 ski_trail_maintenance 2020-01-03T21:53:02.260982+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6651 ski_trail_maintenance 2020-01-03T22:18:01.255784+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6653 ski_trail_maintenance 2020-01-04T07:42:49.854593+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6666 ski_trail_maintenance 2020-01-05T07:46:19.292266+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6670 ski_trail_maintenance 2020-01-05T08:32:29.955758+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6679 ski_trail_maintenance 2020-01-05T09:21:07.649472+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6686 ski_trail_maintenance 2020-01-06T06:07:14.197337+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6698 ski_trail_maintenance 2020-01-07T07:08:38.379249+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6701 ski_trail_maintenance 2020-01-07T07:38:14.369933+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6720 ski_trail_maintenance 2020-01-08T09:04:22.736449+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6765 ski_trail_maintenance 2020-01-11T12:21:06.555406+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6776 ski_trail_maintenance 2020-01-12T08:19:17.928143+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6778 ski_trail_maintenance 2020-01-12T08:35:32.650176+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6798 ski_trail_maintenance 2020-01-13T07:34:01.597104+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6805 ski_trail_maintenance 2020-01-13T08:52:44.529606+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6811 ski_trail_maintenance 2020-01-13T13:43:32.263283+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6818 ski_trail_maintenance 2020-01-14T08:01:43.100199+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6828 ski_trail_maintenance 2020-01-14T13:13:58.104888+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6852 ski_trail_maintenance 2020-01-16T07:42:51.652733+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6855 ski_trail_maintenance 2020-01-16T07:55:35.906710+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6860 ski_trail_maintenance 2020-01-16T10:45:40.686359+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6869 ski_trail_maintenance 2020-01-17T06:35:55.553872+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6874 ski_trail_maintenance 2020-01-17T07:46:21.549817+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6876 ski_trail_maintenance 2020-01-17T08:15:49.872372+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6888 ski_trail_maintenance 2020-01-17T13:29:49.942021+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6894 ski_trail_maintenance 2020-01-18T00:51:56.860643+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 6896 ski_trail_maintenance 2020-01-18T07:25:32.604944+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6900 ski_trail_maintenance 2020-01-18T07:57:33.829939+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6916 ski_trail_maintenance 2020-01-19T07:47:33.094254+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6946 ski_trail_maintenance 2020-01-20T07:34:37.896855+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 6990 ski_trail_maintenance 2020-01-21T21:41:41.750505+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 6997 ski_trail_maintenance 2020-01-22T08:56:38.405788+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7011 ski_trail_maintenance 2020-01-23T06:19:06.249894+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7033 ski_trail_maintenance 2020-01-24T09:53:57.359809+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7036 ski_trail_maintenance 2020-01-24T09:55:53.390561+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7043 ski_trail_maintenance 2020-01-24T13:46:09.733827+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7050 ski_trail_maintenance 2020-01-25T06:53:50.789786+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7067 ski_trail_maintenance 2020-01-25T20:40:57.050343+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7069 ski_trail_maintenance 2020-01-25T23:04:35.866730+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7071 ski_trail_maintenance 2020-01-26T00:17:23.849306+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7087 ski_trail_maintenance 2020-01-27T07:34:59.593960+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7089 ski_trail_maintenance 2020-01-27T07:50:48.053429+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7096 ski_trail_maintenance 2020-01-27T08:18:31.264213+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7102 ski_trail_maintenance 2020-01-27T12:39:03.568980+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7114 ski_trail_maintenance 2020-01-28T09:57:20.669282+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7130 ski_trail_maintenance 2020-01-29T08:03:32.880807+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7132 ski_trail_maintenance 2020-01-29T08:05:06.716643+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7153 ski_trail_maintenance 2020-01-30T08:52:29.583774+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7168 ski_trail_maintenance 2020-01-31T08:00:26.192021+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7181 ski_trail_maintenance 2020-01-31T22:24:26.862505+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7197 ski_trail_maintenance 2020-02-02T00:02:33.014238+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7199 ski_trail_maintenance 2020-02-02T06:54:03.673970+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7215 ski_trail_maintenance 2020-02-03T07:08:32.944135+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7222 ski_trail_maintenance 2020-02-03T08:38:45.078520+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7232 ski_trail_maintenance 2020-02-04T02:45:55.867748+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
53710 7273 ski_trail_maintenance 2020-02-05T06:45:12.655449+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7308 ski_trail_maintenance 2020-02-05T10:38:46.614074+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
57401 7314 ski_trail_maintenance 2020-02-05T14:17:02.699575+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
60871 7323 ski_trail_maintenance 2020-02-06T00:24:34.490282+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown