On 19/01/2010, at 1:23 , Oscar Zamudio wrote: > Hi everybody. > I had no success with any of the recipes received here.
Did you try setting the srid when you imported the data ? > Could it be that a table with data loaded without SRID explicit value has no > chance of being updated later to the right one? > Regards, > Oscar > > > On Sun, Jan 17, 2010 at 1:08 PM, Oscar Zamudio <[email protected]> wrote: > Ben, > I tried your intruction: > > UPDATE mypoints SET the_geom = ST_SetSRID(the_geom,4326); > > But I got: > > ERROR: Operation on two GEOMETRIES with different SRIDs > > Regards, > Oscar > > On Sat, Jan 16, 2010 at 10:48 PM, Ben Madin <[email protected]> > wrote: > Oscar, > > you have a couple of options as I see it. In Postgres you could just update > the geometries first. > > > UPDATE mytable SET the_geom = ST_SetSRID(the_geom,4326); > > > And for next time, assuming your data originally had some sort of coordinate > system (and it must have if it was spatial data), you can / should use the -s > flag in shp2pgsql to provide 'SRID awareness' > > In your case, I would suggest -s 4326. > > ie (using -d to drop and replace existing table > > $ shp2pgsql -s 4326 -d myshapefile myoldtablename | psql mydatabase _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
