Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
zudar
Post Patron
Post Patron

Mapping longitude/latitude coordinates into custom zones

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! 🙂 

7 REPLIES 7
PhilipTreacy
Super User
Super User

@zudar 

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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.

Synoptic Panel - OKVIZ

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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.

 

 

PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.