Hello everybody. I use GeoMap and PostgreSQL.
I have coordinates and I can display them in GeoMap. But I ran into such a problem that I don’t know how to display the coil number, provided that the tables in PostgreSQL cannot be changed.
How it looks in GeoMap (When you hover over a coordinate point, it turns out to display the time and coordinates):
My SQL query in QueryBuilder is the following:
SELECT time AS "time", l, b FROM test_table1 equator_id in (SELECT id from test_table2 WHERE '$O_s' <= orbit_num AND orbit_num <= '$O_end' and id in (SELECT id from test_table3 WHERE id='$app'))
How do I correctly write a request so that the number of the coil 1, 2, 3, 4… is visible?
That is, when hovering over a point, I should have seen the following:
Time: ‘time’
l: ‘l’
b: ‘b’
Num: 1 or 2 or 3
and welcome to the forum,