New answers tagged update
0
votes
Is there any way to link the current map scale in the print layout to a text box?
If you ever need to place the scale in the table you can use this (change 'Map 1' to the name of your map)
'1:'||round(map_get(item_variables('Map 1'),'map_scale'),0)
This if pasted into a table ...
4
votes
How to Append a POINT to a MULTIPOINT column
To wrap this up:
UPDATE
<table>
SET
geom = ST_Multi(ST_Union(geom, 'SRID=4326;POINT(<lon|x>, <lat|y>)'))
WHERE
id = <id>
;
All covered.
- 29.3k
0
votes
How to Append a POINT to a MULTIPOINT column
The query I am using is correct. The issue is that the coordinate I was trying to add was exactly identical to the only other coordiante inside the multipoint column.
This throws the error.
- 161
Top 50 recent answers are included