MAP & route

[YannRC]

Hello, I would like your help. I have this type of data with a single route, an order in which deliveries are made, and X and Y coordinates. I can of course plot points on a map, but I would like to connect these points to form a route. I’m not quite sure how to do it. I mainly use Visual Analytics. Could you explain how I should proceed?

HI, 

[sbxkoenk]

Create a GeoMap with nodes and lines

https://communities.sas.com/t5/SAS-Visual-Analytics/Create-a-GeoMap-with-nodes-and-lines/td-p/391449

Geographical visualizations in SAS Visual Analytics

https://communities.sas.com/t5/SAS-Communities-Library/Geographical-visualizations-in-SAS-Visual-Ana...

( see the section at the bottom named "Routing, drivetime and geographic area" )

BR,

Koen

[YannRC]

Hi Koen, thanks for this answer. It confirms that it's possible but I don't really have the solution to do it. I think that the solution is the polyline. But how to create a polyline

[sbxkoenk]

Maybe you find it here:

• Create geo-line geography roles
  https://communities.sas.com/t5/SAS-Visual-Analytics/Create-geo-line-geography-roles/td-p/866733
  
• SAS Help Center: Working with Geo Maps (Geographic Objects)

                         In the bottom you find:

Otherwise @FalkoSchulz and/or @GregTreiman can help you out.

Ciao,
Koen

[FalkoSchulz]

Yes, that is correct! For your use case, you will want to use the Geo Line object, which takes polyline data as its input.

To make this work, you need to configure your geo data item to use a custom geo data provider linked to your polyline data. You can find detailed instructions on configuring a geo provider in the SAS documentation, but if you get stuck, just reply here and we’ll be happy to help!

Here is the high-level process:

1. Upload your data: Load your polyline data into a shared CAS library in SAS Viya.

2. Create a new provider: Open Visual Analytics (VA) and configure your geo data item. Change its type to "Geographical data provider" and create a new provider. (Note: You need admin privileges to do this).

3. Map your IDs: Select your uploaded data table and ensure the selected ID column matches the values in your geo data item. Each unique ID (e.g., route_1, route_2) represents a series of data points that make up your route. Because of this, your report's main data source only needs to contain the actual ID values.

4. Assign the visual: Once your custom data provider is created, apply it to your geo data item and verify the corresponding ID column is selected. Finally, assign that data item to the Geo Line object in your report.

Hope this helps!

Falko

[YannRC]

Wonderful !!!

Thanks a lot. On last question.

I choose Polyline. Based on my route base

ID column : In my dataset. It's Tournee_ID. A unique ID far all points. Right?

Segment Column : it's what you say. I must have a unique ID for each point of my route

And after, it's X and Y 

If you can confirm it

[YannRC]

This is actually one last question, just to make sure I’m filling in the correct fields when creating a geographical coordinate point. Could you please confirm?