servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
60871 6851 ski_trail_condition 2020-01-15T21:21:28.793075+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6858 ice_skating_field_condition 2020-01-16T08:09:20.082547+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 6863 ice_skating_field_condition 2020-01-16T13:52:38.421614+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6865 ice_skating_field_condition 2020-01-16T15:08:15.261424+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6881 ice_skating_field_condition 2020-01-17T09:13:00.754676+0200     Suljettu   Stängd 1 Closed closed unusable  
50354 6899 ice_skating_field_condition 2020-01-18T07:51:14.309712+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 6918 ice_skating_field_condition 2020-01-19T08:22:55.706889+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6921 ice_skating_field_condition 2020-01-19T08:31:10.128243+0200     Suljettu   Stängd 1 Closed closed unusable  
41657 6935 ice_skating_field_condition 2020-01-19T13:34:29.227140+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 6944 ski_trail_condition 2020-01-20T07:28:16.861669+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 6968 ski_trail_condition 2020-01-21T07:42:56.154863+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6971 ice_skating_field_condition 2020-01-21T09:08:36.185373+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6972 ice_skating_field_condition 2020-01-21T09:08:44.924513+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 7004 ski_trail_condition 2020-01-22T11:52:35.516849+0200     Suljettu   Stängd 1 Closed closed unusable  
40934 7021 ice_skating_field_condition 2020-01-23T15:07:39.964446+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7104 ice_skating_field_condition 2020-01-27T14:19:12.423830+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7119 ice_skating_field_condition 2020-01-28T13:56:36.796520+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7140 ice_skating_field_condition 2020-01-29T18:59:51.397113+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 7148 ski_trail_condition 2020-01-30T07:53:16.005259+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7156 ice_skating_field_condition 2020-01-30T08:58:13.900949+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7160 ice_skating_field_condition 2020-01-30T14:21:30.384386+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 7162 ice_skating_field_condition 2020-01-30T16:14:18.685081+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 7163 ice_skating_field_condition 2020-01-30T16:14:33.202367+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7196 ice_skating_field_condition 2020-02-01T12:45:31.872249+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 7214 ski_trail_condition 2020-02-03T06:17:34.357296+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 7247 ice_skating_field_condition 2020-02-04T10:55:36.173488+0200     Suljettu   Stängd 1 Closed closed unusable  
40201 7268 ice_skating_field_condition 2020-02-04T21:12:54.628677+0200     Suljettu   Stängd 1 Closed closed unusable  
40934 7270 ice_skating_field_condition 2020-02-04T21:36:43.132410+0200     Suljettu   Stängd 1 Closed closed unusable  
61464 7277 ice_skating_field_condition 2020-02-05T07:51:41.382102+0200     Suljettu   Stängd 1 Closed closed unusable  
42593 7302 ice_skating_field_condition 2020-02-05T09:34:51.084462+0200     Suljettu   Stängd 1 Closed closed unusable  
42413 7416 ice_skating_field_condition 2020-02-07T13:53:20.364195+0200     Suljettu   Stängd 1 Closed closed unusable  
42641 7417 ice_skating_field_condition 2020-02-07T13:53:46.748597+0200     Suljettu   Stängd 1 Closed closed unusable  
40252 7425 ice_skating_field_condition 2020-02-08T06:44:07.569203+0200     Suljettu   Stängd 1 Closed closed unusable  
42249 7457 ice_skating_field_condition 2020-02-08T15:16:27.259281+0200     Suljettu   Stängd 1 Closed closed unusable  
40040 7458 ice_skating_field_condition 2020-02-08T16:26:05.952896+0200     Suljettu   Stängd 1 Closed closed unusable  
42034 7468 ice_skating_field_condition 2020-02-08T18:10:04.844933+0200     Suljettu   Stängd 1 Closed closed unusable  
40814 7469 ice_skating_field_condition 2020-02-08T18:10:41.279521+0200     Suljettu   Stängd 1 Closed closed unusable  
41568 7471 ice_skating_field_condition 2020-02-08T18:26:42.258658+0200     Suljettu   Stängd 1 Closed closed unusable  
40013 7472 ice_skating_field_condition 2020-02-09T06:44:58.861667+0200     Suljettu   Stängd 1 Closed closed unusable  
50354 7474 ice_skating_field_condition 2020-02-09T07:02:02.233897+0200     Suljettu   Stängd 1 Closed closed unusable  
40455 7475 ice_skating_field_condition 2020-02-09T07:05:06.325443+0200     Suljettu   Stängd 1 Closed closed unusable  
40934 7480 ice_skating_field_condition 2020-02-09T09:03:04.306886+0200     Suljettu   Stängd 1 Closed closed unusable  
42825 7488 ice_skating_field_condition 2020-02-09T10:39:37.330025+0200     Suljettu   Stängd 1 Closed closed unusable  
41994 7498 ice_skating_field_condition 2020-02-09T13:16:01.654370+0200     Suljettu   Stängd 1 Closed closed unusable  
40218 7499 ice_skating_field_condition 2020-02-09T13:16:31.790813+0200     Suljettu   Stängd 1 Closed closed unusable  
40059 7509 ice_skating_field_condition 2020-02-09T20:44:37.212732+0200     Suljettu   Stängd 1 Closed closed unusable  
50354 7514 ice_skating_field_condition 2020-02-10T07:20:56.678885+0200     Suljettu   Stängd 1 Closed closed unusable  
42111 7518 ice_skating_field_condition 2020-02-10T08:04:14.945553+0200     Suljettu   Stängd 1 Closed closed unusable  
51451 7519 ice_skating_field_condition 2020-02-10T08:04:50.180581+0200     Suljettu   Stängd 1 Closed closed unusable  
40402 7527 ice_skating_field_condition 2020-02-10T10:26:03.712300+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 7528 ice_skating_field_condition 2020-02-10T10:41:49.511748+0200     Suljettu   Stängd 1 Closed closed unusable  
41096 7529 ice_skating_field_condition 2020-02-10T10:45:41.521804+0200     Suljettu   Stängd 1 Closed closed unusable  
50605 7530 ice_skating_field_condition 2020-02-10T11:46:57.854857+0200     Suljettu   Stängd 1 Closed closed unusable  
40970 7531 ice_skating_field_condition 2020-02-10T11:47:32.575793+0200     Suljettu   Stängd 1 Closed closed unusable  
42241 7532 ice_skating_field_condition 2020-02-10T11:52:50.276109+0200     Suljettu   Stängd 1 Closed closed unusable  
42128 7533 ice_skating_field_condition 2020-02-10T11:53:27.994054+0200     Suljettu   Stängd 1 Closed closed unusable  
42511 7539 ice_skating_field_condition 2020-02-10T14:35:09.110896+0200     Suljettu   Stängd 1 Closed closed unusable  
42920 7540 ice_skating_field_condition 2020-02-10T14:36:28.919266+0200     Suljettu   Stängd 1 Closed closed unusable  
41398 7541 ice_skating_field_condition 2020-02-10T16:40:32.214934+0200     Suljettu   Stängd 1 Closed closed unusable  
40026 7542 ice_skating_field_condition 2020-02-10T16:40:56.385667+0200     Suljettu   Stängd 1 Closed closed unusable  
41617 7543 ice_skating_field_condition 2020-02-10T16:41:39.413935+0200     Suljettu   Stängd 1 Closed closed unusable  
61464 7550 ice_skating_field_condition 2020-02-10T20:16:20.584999+0200     Suljettu   Stängd 1 Closed closed unusable  
61464 7554 ice_skating_field_condition 2020-02-11T07:37:36.431449+0200     Suljettu   Stängd 1 Closed closed unusable  
42076 7567 ice_skating_field_condition 2020-02-11T14:53:46.513110+0200     Suljettu   Stängd 1 Closed closed unusable  
41494 7568 ice_skating_field_condition 2020-02-11T14:54:02.901830+0200     Suljettu   Stängd 1 Closed closed unusable  
41527 7569 ice_skating_field_condition 2020-02-11T14:54:32.505840+0200     Suljettu   Stängd 1 Closed closed unusable  
39911 7570 ice_skating_field_condition 2020-02-11T14:55:43.652887+0200     Suljettu   Stängd 1 Closed closed unusable  
40493 7580 ice_skating_field_condition 2020-02-12T07:21:42.458448+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7583 ice_skating_field_condition 2020-02-12T07:58:36.734738+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7584 ice_skating_field_condition 2020-02-12T07:58:42.334287+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 7671 ice_skating_field_condition 2020-02-15T16:05:18.362810+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7673 ice_skating_field_condition 2020-02-15T16:58:10.155059+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7674 ice_skating_field_condition 2020-02-15T16:58:18.127596+0200     Suljettu   Stängd 1 Closed closed unusable  
61464 7678 ice_skating_field_condition 2020-02-16T07:58:42.108605+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7679 ice_skating_field_condition 2020-02-16T08:14:05.972075+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7680 ice_skating_field_condition 2020-02-16T08:14:15.342173+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 7695 ice_skating_field_condition 2020-02-16T16:05:00.082781+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7701 ice_skating_field_condition 2020-02-17T07:25:20.559373+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 7702 ice_skating_field_condition 2020-02-17T07:25:28.272144+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7703 ice_skating_field_condition 2020-02-17T07:38:13.856107+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7704 ice_skating_field_condition 2020-02-17T07:38:29.423526+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 7705 ski_trail_condition 2020-02-17T08:07:04.921319+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7710 ice_skating_field_condition 2020-02-17T11:02:52.531067+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7715 ice_skating_field_condition 2020-02-18T07:42:22.813577+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7716 ice_skating_field_condition 2020-02-18T07:43:07.778862+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 7717 ice_skating_field_condition 2020-02-18T07:49:11.647081+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7718 ice_skating_field_condition 2020-02-18T07:49:17.858157+0200     Suljettu   Stängd 1 Closed closed unusable  
54329 7722 ski_trail_condition 2020-02-18T08:59:23.362541+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7765 ice_skating_field_condition 2020-02-19T14:26:27.440425+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7766 ice_skating_field_condition 2020-02-19T14:42:41.284687+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7799 ice_skating_field_condition 2020-02-21T08:46:46.916180+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7800 ice_skating_field_condition 2020-02-21T08:48:24.353486+0200     Suljettu   Stängd 1 Closed closed unusable  
61464 7809 ice_skating_field_condition 2020-02-22T07:29:15.403732+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 7811 ice_skating_field_condition 2020-02-22T08:04:02.130767+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 7812 ice_skating_field_condition 2020-02-22T08:04:27.427321+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 7813 ice_skating_field_condition 2020-02-22T08:09:46.238559+0200     Suljettu   Stängd 1 Closed closed unusable  
40402 7822 ice_skating_field_condition 2020-02-22T11:23:22.408975+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 7823 ice_skating_field_condition 2020-02-22T13:48:52.545599+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 7824 ice_skating_field_condition 2020-02-22T13:48:58.557258+0200     Suljettu   Stängd 1 Closed closed unusable  
40493 7825 ice_skating_field_condition 2020-02-22T15:06:38.671792+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 7826 ice_skating_field_condition 2020-02-22T17:01:06.969604+0200     Suljettu   Stängd 1 Closed closed unusable