Just placing some shapefile into a geographic SRID will not convert it to correct coordinates.
What you need to is: UPDATE foo_table SET the_geometry_field = ST_TRANSFORM(the_geometry_field,NEW_SRID); Att George On Fri, Sep 11, 2009 at 4:34 PM, Mac Martine <[email protected]> wrote: > Hello- > I'm a total newbie with this stuff so bare with me. I have a shape > files that I got into Postgres. Now I'm pulling it out and it's giving > me MULTILINESTRINGS with numbers that look like: > 7509930.12510756 776667.642310877,7509924.12502675 776694.329928875 > > Now, I get the feeling those are correct, but that I need to convert > them to Longitude and Latitude, and that's where I'm stuck. > > I'm pretty sure it's SRID 4326 but I can't find any info on doing > conversions from here. Maybe I'm wrong. I also found this info which > may be of help. > > +proj=lcc +lat_1=44.33333333333334 +lat_2=46 +lat_0=43.66666666666666 > +lon_0=-120.5 +x_0=2500000 +y_0=0 +ellps=GRS80 +to_meter=0.3048 > +no_defs > > I'd really appreciate some guidance. I've googled all kinds of things > and am not figuring it out. > Thanks! > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- George R. C. Silva Desenvolvimento em GIS www.sextantegeo2.blogspot.com
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
