[postgis-users] How to change srid

[Marko Čubranić]

thank you,

i think this will help me.

Marko

2010/3/30 Nicolas Gillet - MARKET-IP <nicolas.gillet at market-ip.com>

>  Hello,
>
>
>
> Editing the geometry_column table is half part of the job.
>
>
>
> You have to update the geometries too.
>
>
>
> UPDATE table SET the_geom  = ST_SetSRID(the_geom, 4326).
>
>
>
> Usually the SRID is -1 when you forget to set the srid when you import a
> shape file.
>
>
>
> Hope this helps.
>
>
>
> Nicolas.
>
>
>
> *De :* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *De la part de* Marco
> Lechner - FOSSGIS e.V.
> *Envoyé :* mardi 30 mars 2010 9:00
> *À :* postgis-users at postgis.refractions.net
> *Objet :* Re: [postgis-users] How to change srid
>
>
>
> change the SRID in the geometry_columns table. There should be a
> corresponding recordset defining the SRID, geometry type, geometry column
> and so on of your table.
>
> Marco
>
> Am 30.03.2010 08:53, schrieb Marko Čubranić:
>
> dear,
>
> iv loaded data to postgis and for all geometry srid  is -1.
> if i want to change srid without doing and transformations, can i do that
> and how?
>
> Thank you,
>
> Marko Cubranic
>
>
>
>
>
> _______________________________________________
>
> postgis-users mailing list
>
> postgis-users at postgis.refractions.net
>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100330/18bc6e45/attachment.html>