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
