servicemap

Custom SQL query returning 54 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
54335 50960 ski_trail_condition 2021-01-04T14:34:56.015492+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51027 50961 ski_trail_condition 2021-01-04T14:36:44.599207+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53848 50965 ski_trail_condition 2021-01-04T14:43:06.276472+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54047 50966 ski_trail_condition 2021-01-04T14:43:16.810816+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54039 50967 ski_trail_condition 2021-01-04T14:43:20.288124+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54339 50968 ski_trail_condition 2021-01-04T14:43:57.629744+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53836 50969 ski_trail_condition 2021-01-04T14:43:59.446018+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54038 50970 ski_trail_condition 2021-01-04T14:45:19.517881+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54338 50971 ski_trail_condition 2021-01-04T14:45:41.911663+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54048 50972 ski_trail_condition 2021-01-04T14:45:44.327526+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56073 50973 ski_trail_condition 2021-01-04T14:45:52.322167+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56073 50974 ski_trail_condition 2021-01-04T14:46:09.214924+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53965 50975 ski_trail_condition 2021-01-04T14:46:23.057837+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53965 50976 ski_trail_condition 2021-01-04T14:46:31.646547+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54425 50977 ski_trail_condition 2021-01-04T14:46:37.795169+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53974 50978 ski_trail_condition 2021-01-04T14:46:53.284804+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53974 50979 ski_trail_condition 2021-01-04T14:47:02.778233+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53975 50980 ski_trail_condition 2021-01-04T14:47:09.055552+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53979 50981 ski_trail_condition 2021-01-04T14:47:27.319271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54430 50982 ski_trail_condition 2021-01-04T14:47:41.171183+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53978 50983 ski_trail_condition 2021-01-04T14:47:52.323610+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54424 50984 ski_trail_condition 2021-01-04T14:48:06.703494+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54419 50985 ski_trail_condition 2021-01-04T14:48:26.140649+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54423 50986 ski_trail_condition 2021-01-04T14:48:40.455129+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54421 50987 ski_trail_condition 2021-01-04T14:48:55.953820+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53850 50988 ski_trail_condition 2021-01-04T14:49:05.672860+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56076 50989 ski_trail_condition 2021-01-04T14:49:20.568691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56076 50990 ski_trail_condition 2021-01-04T14:49:24.388646+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53989 50991 ski_trail_condition 2021-01-04T14:49:29.724999+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53989 50992 ski_trail_condition 2021-01-04T14:49:32.745566+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54411 50993 ski_trail_condition 2021-01-04T14:49:50.423708+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53994 50995 ski_trail_condition 2021-01-04T14:50:18.997488+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54422 50996 ski_trail_condition 2021-01-04T14:51:14.835828+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54010 50997 ski_trail_condition 2021-01-04T14:51:15.716497+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54005 50998 ski_trail_condition 2021-01-04T14:51:17.456305+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 50999 ski_trail_condition 2021-01-04T14:51:29.569064+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54422 51000 ski_trail_condition 2021-01-04T14:51:30.228840+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 51001 ski_trail_condition 2021-01-04T14:51:30.349763+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 51002 ski_trail_condition 2021-01-04T14:51:42.092474+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54004 51003 ski_trail_condition 2021-01-04T14:51:52.886263+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53916 51004 ski_trail_condition 2021-01-04T14:52:08.106885+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53916 51005 ski_trail_condition 2021-01-04T14:52:08.546026+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53987 51006 ski_trail_condition 2021-01-04T14:52:20.237052+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56077 51007 ski_trail_condition 2021-01-04T14:52:30.628271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54429 51008 ski_trail_condition 2021-01-04T14:52:38.853550+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53984 51009 ski_trail_condition 2021-01-04T14:52:51.476691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53867 51010 ski_trail_condition 2021-01-04T14:53:00.119822+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54013 51011 ski_trail_condition 2021-01-04T14:53:08.057325+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54009 51012 ski_trail_condition 2021-01-04T14:53:17.596112+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54011 51013 ski_trail_condition 2021-01-04T14:53:31.623027+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54002 51014 ski_trail_condition 2021-01-04T14:53:43.857194+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53919 51015 ski_trail_condition 2021-01-04T14:53:51.142907+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53985 51016 ski_trail_condition 2021-01-04T14:54:04.231259+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51027 51112 ski_trail_condition 2021-01-04T19:09:22.296673+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable