how to plot multiple latitude and longitude from a flattened table?

[gauravphadke]

How do I plot multiple latitude and longitude values from a single row? 

Scenario: 

• I have a single flattened SHIPMENT table.
• There is unique row (record) for each TRIP within the SHIPMENT table. Every trip record has Pickup latitude and longitude as well as Delivery latitude and longitude.
• How do I plot Pickup and Delivery Lat Long for all the trips in SHIPMENT Table?

Please help me out here.

[v-yulgu-msft]

Hi @gauravphadke ,

Please elaborate your scenario with sample data and expected output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[gauravphadke]

Use Case:

I have a unique TRIP ID. One row in sample data represents one TRIP. One TRIP consist of multiple zones (loading zone, road zone, delivery zone, docking zone). Each and every zone has its own latitude and longitude values. I want to plot the latitude and longitude values of each and every zone on a map showing the entire trip (loading zone --> road zone --> delivery zone --> docking zone).  

Here is some sample data:

TRIP ID	Loading Zone	Loading zone start time	Loading Zone End Time	Loading Zone Latitude	Loading Zone Longitude	Road Zone	Road Entry Start Time	Road Entry End Time	Road Entry Latitude	Road Entry Longitude	Delivery Zone	Delivery Zone Start Time	Delivery Zone End Time	Delivery Zone Latitude	Delivery Zone Longitude	Docking Zone	Docking Zone Start Time	Docking Zone End Time	Docking Zone Latitude	Docking Zone Longitude
101	1	8:21 AM	8:26 AM	33.085502	-96.835599	1	8:27 AM	9:30 AM	-96.827218	33.084534	1	9:32 AM	9:58 AM	33.0826738	-96.8274369	1	10:00 AM	10:30 AM	33.084534	-96.826054
102	1	9:21 AM	9:52 AM	33.085502	-96.835599	1	10:20 AM	3:21 PM	-96.827218	33.084534	1	3:22 PM	4:14 PM	33.0826738	-96.8274369	1	4:30 PM	5:00 PM	33.084534	-96.826054
103	1	7:38 AM	7:45 AM	33.089125	-96.827218	1	8:27 AM	9:30 AM	-96.827218	33.084534	1	9:32 AM	9:58 AM	33.0826738	-96.8274369	1	10:00 AM	10:30 AM	33.089125	-96.827218

Expected Output:

I want to display different TRIPS on a map. Within one trip, individual zones will represent stops on a map.