Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
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! 🙂
I'm going to Grave Dig this up because in 2024 I have this exact same problem,
I have a Region with 5 Zones, on a Shape Map, my Data includes Specific Lat and Long(GPS Data) however I need to populate the into those 5 zones without populating the specific locations.
Accoding to the documentation I've read I need to create a new column and assign each of the records with my GPS with an Identifier that matches the Zones on my map. since I I have 22 million records manually assigning zones is not possible.
I was able to get the zones and their polygon GPS Location I also have the GEO Json file for my zones.
how to I take specific GPS Data and add my zone information to each row of my data? any recomendations or suggestions would be great
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.
Regards
Phil
Proud to be a Super User!
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?
HI @zudar
Maybe this Synoptic Panel visual is what you are after. It allows you to create custom maps/areas.
Regards
Phil
Proud to be a Super User!
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?
Data example:
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.
Hi @zudar
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?
regards
Phil
Proud to be a Super User!
Hi @PhilipTreacy,
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |