Geographic Information Systems Asked on January 6, 2022
I have a table containing a column geom loaded from a shape file which was defined in lambert II system (27582), but when I loaded it I specified that I want to work in lambert 93 (2154).
Unfortunately when I load it in QGIS the coordinates are always in lambert II.
Is there a function allowing me to convert these coordinates and make them pass from lambert II (27582) to lambert 93 (2154)?
I would like to work only in lambert 93.
Go back and repeat the load using EPSG:27582 or use ST_SetSRID
to set the correct CRS - then use the ST_Transform
function to convert them to be in EPSG:2154 if that is what you require.
UPDATE table SET geom = ST_Transform(ST_SetSRID(geom, 27582), 2154);
Though QGIS is quite capable of reprojecting on the fly for you once the correct SRID is set using just:
UPDATE table SET geom = ST_SetSRID(geom, 27582);
Answered by Ian Turton on January 6, 2022
If your question is regarding PostGIS functions:
the ST_Transform
function is what you are looking for. Something like this should do the trick:
UPDATE table
SET geom = ST_Transform(geom, 2154)
On the other hand, if your question is refering to a QGIS operation. You can change the SRID of your layer or the whole project from its properties.
Answered by ramiroaznar on January 6, 2022
0 Asked on April 17, 2021 by ejobrien
1 Asked on April 17, 2021
0 Asked on April 17, 2021
0 Asked on April 17, 2021 by carpenter
0 Asked on April 16, 2021
1 Asked on April 16, 2021
3 Asked on April 16, 2021 by thrushjacket
google earth engine javascript sentinel 1 synthetic aperture radar
2 Asked on April 16, 2021
1 Asked on April 16, 2021 by matt-a
1 Asked on April 16, 2021 by pablo-herreros-cantis
2 Asked on April 16, 2021
0 Asked on April 16, 2021 by shraddha-sharma
1 Asked on April 16, 2021
0 Asked on April 16, 2021 by skew_t_pie
Get help from others!
Recent Questions
Recent Answers
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir