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 : [email protected] [mailto:[email protected]] De la part de Marco Lechner - FOSSGIS e.V. Envoyé : mardi 30 mars 2010 9:00 À : [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
