[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Re: Reprojecting data to 4326
From:       Brent Wood <pcreso () pcreso ! com>
Date:       2005-09-28 13:32:13
Message-ID: 20050928133213.97931.qmail () web33215 ! mail ! mud ! yahoo ! com
[Download RAW message or body]



--- Wacek <wacek@adams.szczecin.pl> wrote:

> >>>> > I have some data from USA in 'NAD83 Nevada East' fromat (EPSG:32107 -
> >>>> > ?). I want to change it to WGS84 (EPSG:4326) using PostGIS. When I
> use:
> >>>> >
> >>>> > "select updategeometrysrid('table', 'the_geom', 4326);" resulting
> values
> >>>> > are'nt correct. What am I doing wrong?
> >>>> >


I believe updategeometrysrid simply changes the srid value, but does NOT
reproject the coordinate values. 

What you should be doing is "select transform(the_geom, 4326) from <table>;" 
or to physically change the values in the db:
"update <table> set the_geom=transform(the_geom,4326);"

transform is the function to reproject coordinates.


Brent Wood

[prev in list] [next in list] [prev in thread] [next in thread]