topic Re: connection map visualization required data structure in Open Q&A

connection map visualization required data structure

gilgi — Thu, 10 Apr 2025 11:57:33 GMT

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.

Re: connection map visualization required data structure

marco_irmer — Fri, 25 Apr 2025 20:19:19 GMT

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.