The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Please help...
I've got two tables. One table has the locations of certain buildings (lon and lat). Second table has geo areas (list of lon and lat). How do I determine which geo area the record in table 1 is within (or closest to)?
Appreciate the help. Thanks.
Solved! Go to Solution.
In my opinion, you can convert your table into a GeoJson and feed it as insput to azure maps or icon map visual.
https://learn.microsoft.com/en-us/azure/azure-maps/how-to-dataset-geojson
then you can plot your buildings (lat and long) on top of the area highlighted by the Geo Json.
I understand that it wont give the exact distnace between the building and the locations in table 2. However the representation on the map will give good visual representation. If you want to calculate the distatance between two geo locations you. have to use Haversine formula
Connect on LinkedIn
|
Hi @RT3308 ,
Thank you for the helpful responses @tharunkumarRTK and @lbendlin !
The provided answer is accurate and may help you to resolve the query.Have you got an opportunity to review the information provided by community members?If it resolved, consider accepting their answer as solution.
Thank you.
Regards,
Pallavi.
In my opinion, you can convert your table into a GeoJson and feed it as insput to azure maps or icon map visual.
https://learn.microsoft.com/en-us/azure/azure-maps/how-to-dataset-geojson
then you can plot your buildings (lat and long) on top of the area highlighted by the Geo Json.
I understand that it wont give the exact distnace between the building and the locations in table 2. However the representation on the map will give good visual representation. If you want to calculate the distatance between two geo locations you. have to use Haversine formula
Connect on LinkedIn
|
That is an extremely complex topic, far beyond the capabilities of Power BI.
Geofencing – Determining Whether a Point Is Inside of a Polygon | Baeldung on Computer Science
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
13 | |
13 | |
8 | |
8 |