[postgis-users] How to change srid

[Nicolas Gillet - MARKET-IP]

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
  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100330/cb8f2400/attachment.html>