Hi, UpdateGeometrySRID() http://postgis.refractions.net/documentation/manual-1.5/UpdateGeometrySRID.html
Fred 2010/3/30 Marko Čubranić <[email protected]> > thank you, > > i think this will help me. > > Marko > > 2010/3/30 Nicolas Gillet - MARKET-IP <[email protected]> > > 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 >> >> > > _______________________________________________ > 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
