[postgis-users] Re: Reprojecting data to 4326

[Brent Wood]

--- Wacek <wacek at 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