How to change SRID of geometry column?
Posted
by Z77
on Stack Overflow
See other posts from Stack Overflow
or by Z77
Published on 2010-06-10T08:16:52Z
Indexed on
2010/06/10
8:22 UTC
Read the original article
Hit count: 280
postgresql
|postgis
I have table where the one of columns is geometry column the_geom for polygons with SRID. I added new column in the same table with exactly the same geometry data as in the_geom. This another column has name the_geom4258 because I want here to set up another SRID=4258. So what is the procedure to set up another SRID geometry to be changed (in another coord.system)? Is just enough to apply following query:
UPDATE table SET the_geom4258=ST_SetSRID(the_geom4258,4258);
© Stack Overflow or respective owner