30 Days of Maps Day 5 - A journey

Today is day 5 of the #30DayMapChallenge.

The theme for today's map is a journey - Map any journey. Personal or not. Trace a journey—this could be a daily commute, a long-distance trip, or something from history. The key is to map movement from one place to another.

The data for today's map comes from aircraft flying above my house. I capture the transponder transmissions using a Raspberry PI with an antenna and push these into Microsoft Fabric's Realtime Intelligence workload. I've included a morning's worth of captured data from November 1st, and animated it using the Play Axis custom visual.

The data captured includes the longitude and latitude information for each aircraft - these are stored on a separate row in the dataset. I then use the CONCATENATEX function in DAX to generate a Well-Known Text (WKT) linestring. Using the aircraft's unique ID as the ID field in Icon Map Pro, and then the DAX measure, it create a WKT linestring for each aircraft. I'm showing the last 10 minutes worth of history for each aircraft - so you'll see planes not moving for a while after I stop detecting data for them. At the end of each linestring, I'm displaying an SVG image of an aircraft - different images for each category of plane. These images are rotated within Icon Map Pro to point in the direction of travel.

If you'd like to see how the report was built, you can download it here.