Forum Discussion
road map segments using point locations
hello, I need to represent a segment (street or roadway) on a map based on a sequence of points (latitude and longitude), I attached a table so you can see an example of the data I'm working with, I don't know if there is any app in power bi to do it or if I have to use "R" to do it whatever the case I would like someone to show me. how to do it.
in the table, the first column "TMC_Code" works as a unique ID and will have a start point (latitude and longitude) and an endpoint (latitude and longitude), in case several "TMC-Code" have the same "Name_Segment" means that the (latitude and longitude) of each "TMC_Code" must be followed by each other.
In case you do not understand, I can give more details than I want.
Thanks a lot
| TMC_Code | Name_Segment | start_latitude | start_longitude | end_latitude | end_longitude | miles |
| 102-50531 | US-1/Biscayne Blvd to NW 3rd St | 25.7848 | -80.194 | 25.7846 | -80.2 | 0.35926 |
| 102-11346 | US-1/Biscayne Blvd to NW 3rd St | 25.7848 | -80.192 | 25.7848 | -80.194 | 0.10351 |
| 102-11347 | US-1/Biscayne Blvd to NW 3rd St | 25.7849 | -80.191 | 25.7848 | -80.192 | 0.10541 |
| 102-11348 | US-1/Biscayne Blvd to NW 3rd St | 25.7849 | -80.189 | 25.7849 | -80.191 | 0.0748 |
| 102P12299 | N Miami Ave to US-1/Biscayne | 25.7883 | -80.195 | 25.7883 | -80.194 | 0.0212 |
| 102+12300 | N Miami Ave to US-1/Biscayne | 25.7883 | -80.194 | 25.7883 | -80.19 | 0.29702 |
| 102P12300 | N Miami Ave to US-1/Biscayne | 25.7883 | -80.19 | 25.7883 | -80.189 | 0.02806 |
| 102N12300 | US-1/Biscayne to N Miami Ave | 25.7883 | -80.189 | 25.7883 | -80.19 | 0.02806 |
| 102-12299 | US-1/Biscayne to N Miami Ave | 25.7883 | -80.19 | 25.7883 | -80.194 | 0.29702 |
1 Reply
Hi AlexisGonzalez ,
I couldn't find any useful app or visual in Power BI App source.
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi
You might check about it, i could missed something.
Also check about creating custom visuals.
https://powerbi.microsoft.com/en-us/developers/custom-visualization/
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
