connection map visualization required data structure

[gilgi]

Hi All, 

We have business events in a structure similar to the following: {

    "tripname": "ger-to-uk",

    "src_latitude": 38.1,

   "src_longitue": -26,

   "target_latitude": 50.1,

   "target_longitude": 31,

   "people": 5

}
The purpose is to show on the connection map visualization the routes from source to target. It is not clear from the documentation sample how source and target coordinates should be handled in order to draw such lines correctly.
The end goal is to try and even highlight routes with more people.

[marco_irmer · Accepted solution]

You can examine the underlying data structure by plugging an example from the documentation into a new Notebook and then selecting the 'Record list' visualization. Doing so with the example in the docs shows the below:

What we can see here is that each record needs to have the an array for the latitude and longitude. Each array contains two values, representing one end of the line (either latitude or longitude). You'll want to craft your DQL query to output records in that format.