I have a PostGIS-Point-Vector-Layer with labels. I moved these directly at the points beacuse they were to close.
To connect label and point, I created a line vector layer which was made with a query in the DB-Manager (see below).
If a point is not visible because it's outside of the QGIS-Windos but the label were still inside, the label is not visible anymore. But, unfortunately, these lines are still visible. What do I have to add to the query to enable these lines if their origin is not visible?
Query:
SELECT id, ST_Makeline(St_setSRID((geom),2056), St_setSRID(St_Point("X"::numeric, "Y"::numeric),2056)) as "geom"FROM"database"."table"WHERE "X" IS NOT NULL AND "Y" IS NOT NULL
أكثر...
To connect label and point, I created a line vector layer which was made with a query in the DB-Manager (see below).
If a point is not visible because it's outside of the QGIS-Windos but the label were still inside, the label is not visible anymore. But, unfortunately, these lines are still visible. What do I have to add to the query to enable these lines if their origin is not visible?
Query:
SELECT id, ST_Makeline(St_setSRID((geom),2056), St_setSRID(St_Point("X"::numeric, "Y"::numeric),2056)) as "geom"FROM"database"."table"WHERE "X" IS NOT NULL AND "Y" IS NOT NULL
أكثر...