-
Notifications
You must be signed in to change notification settings - Fork 5
Expand file tree
/
Copy pathISS.kql
More file actions
39 lines (23 loc) · 791 Bytes
/
Copy pathISS.kql
File metadata and controls
39 lines (23 loc) · 791 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
//***********************************************************************************************************
//http://open-notify.org/Open-Notify-API/
//***********************************************************************************************************
ISS_Loc
| summarize max(Timestamp), min(Timestamp)
//total records
ISS_Loc
| count
// ISS latest tragectory
ISS_Loc
| top 20 by Timestamp
| project Longitude, Latitude, Timestamp
| render scatterchart with ( kind=map )
// ISS complete orbit
ISS_Loc
| where Timestamp > ago(90m)
| project Longitude, Latitude, Timestamp
| render scatterchart with ( kind=map )
// which humans are in space right now?
Astronauts
| top 1 by ['x-opt-enqueued-time']
| mv-expand people
| project Name= people.name, Craft=people.craft