[postgis-users] Working with multilinestring data - figuring out coordinates

[George Silva]

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 <martine at adobe.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
George R. C. Silva

Desenvolvimento em GIS
www.sextantegeo2.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090911/b273c9d6/attachment.html>