[postgis-users] Working with multilinestring data - figuring out coordinates
georger.silva at gmail.com
Fri Sep 11 12:51:31 PDT 2009
Just placing some shapefile into a geographic SRID will not convert it to
What you need to is:
UPDATE foo_table SET the_geometry_field =
On Fri, Sep 11, 2009 at 4:34 PM, Mac Martine <martine at adobe.com> wrote:
> 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
> I'd really appreciate some guidance. I've googled all kinds of things
> and am not figuring it out.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
George R. C. Silva
Desenvolvimento em GIS
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users