I could use some advice on how to label longitude/latitude coordinates into a certain custom-defined area.
My data is for a specific airport and I want to relate coordinates to a certain terminal.
The way I see it, I have to define areas and perform a lookup, so that a certain combination of latitude and longitude corresponds to a 'label' or area. But I don't think it's realistic to do this by hand: I have to have some sort of visual reference of, for example, Google Maps, where I can draw the outlines of each area.
Are there any (preferably free) tools that can give me such a visual reference and lookup table I can use to label my coordinates?
I'm using PowerBI Report Server Version 1.10.7698.27886 (January 2021).
Thank you! 🙂
So when you say you want to label Lat/Long co-ords what exactly do you mean? Please provide an example of what you want as a result.
Do you want a new column that contains a text string that identifies a particular lat/long as 'Terminal A'?
Please provide some data and examples of your expected outcomes.
I'm looking for a way to define a custom area on a map so that lat/lang co-ords that fall into that area are labeled the way I want.
My guess is that it's not practical to define al possible co-ords and add labels to them by hand without any visual reference. That's what I meant with a lookup table. I guess there must be a better way..
In the end, I'm not even looking to visualize this data into a map (it would be a nice extra bonus though), but just to summarize my data per 'custom area'.
Does this make more sense?
I don't think it is what I'm after.
I want to do analysis on GPS-data in a meaningful way, by labeling custom areas and GPS coordinates that fall into those custom areas with a 'name'.
Let me give an example..
If you had to show a table of Airport Terminals, with a total number of lat/long co-ord inputs based on data below.. what would you do?
GPS-ID = 1, lat. = 24.5234, long = 10.3245
GPS-ID = 2, lat. = 24.5495, long = 10.1029
GPS-ID = 3, lat. = 24.5532, long = 10.8247
Let's say GPS-ID 1 & 2 fall into the area of Terminal A. And GPS-ID 3 is Terminal B.
Desired end result:
Terminal = A, Number of inputs = 2
Terminal = B, Number of inputs = 1
The Synoptic Panel is just a visualization where you can join your data through the 'label'. The problem is that my source data is raw GPS data without information about which Terminal it belongs to. I have to (somehow) do that myself.
I'm not sure what you mean by having to do a lookup? Or to label Lat/Long co-ords?
If you have Lat/Long then you can plot this on a standard Map visual.
Maybe a Filled Map is what you are after?
I don't want to visualize the data on a map, I want to label certain locations (lat/long co-ords) with a label, so I can do further analysis per airport terminal. The problem is I have no idea how to tell PowerBI that coordinates in a certain area should be labeled with, for example, 'Terminal A'. I imagine a lookup should happen in the background that looks for a long/lat combination and a corresponding label, and return the correct label in the result set.
I was searching the forum and was looking to do this exact thing...label certain coordinates according to location. I found this post, but it seems it is about a year old and there was never a solution. Thought I'd give it a bump.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.