Hello once again,
It is possible that I am either mistaken or simply lack knowledge, but here is my point of view and my "problem".
I have databases containing gps position data. All of the databases of this type I have seen always contain 2 separate columns for both of the coordinates (latitude and longitude).
I wanted to visualise these databases. The best (if not "the only") solution for fabrik is the googlemap element and further the googlemap visualisation. However, this element contains the latitude and longitude data in one "column", so to say. Its format is "xx.xxxx, yy.yyyy". So, in order to use the googlemap element, the database needs to be reformatted. I would like to avoid reformatting.
And here comes my question: is there any way to keep the latitude and longitude columns separatelly in the database and point the googlemap visualisation to these columns as the coordinates for visualisation?
As I mentioned, to me the "separate columns" method is the most natural one and I do not know the reasons for putting these two together in the googlemap element.
If this is also natural to more of you, maybe the next version of googlemap element could give such an option? Maybe splitting the element into googlemap_lat and googlemap_long could be possible? Or simply add a new functionality to the googlemap visualisation, where after specifying the connection and the database to be used one could select the "latitude" and "longitude" column?
Many thanks in advance for the answer!
Oh, one more thing: this concerns both Fabrik 2.0 and 3.0.
Regards
Kordian
It is possible that I am either mistaken or simply lack knowledge, but here is my point of view and my "problem".
I have databases containing gps position data. All of the databases of this type I have seen always contain 2 separate columns for both of the coordinates (latitude and longitude).
I wanted to visualise these databases. The best (if not "the only") solution for fabrik is the googlemap element and further the googlemap visualisation. However, this element contains the latitude and longitude data in one "column", so to say. Its format is "xx.xxxx, yy.yyyy". So, in order to use the googlemap element, the database needs to be reformatted. I would like to avoid reformatting.
And here comes my question: is there any way to keep the latitude and longitude columns separatelly in the database and point the googlemap visualisation to these columns as the coordinates for visualisation?
As I mentioned, to me the "separate columns" method is the most natural one and I do not know the reasons for putting these two together in the googlemap element.
If this is also natural to more of you, maybe the next version of googlemap element could give such an option? Maybe splitting the element into googlemap_lat and googlemap_long could be possible? Or simply add a new functionality to the googlemap visualisation, where after specifying the connection and the database to be used one could select the "latitude" and "longitude" column?
Many thanks in advance for the answer!
Oh, one more thing: this concerns both Fabrik 2.0 and 3.0.
Regards
Kordian