[Geoserver-users] Displacements coordinates.

GeoServer GeoServer User
1

Hi.
The question is about displacement coordinates: I'm doing a coordinate translation in PostGis from 23030 to 900913, this is the line in PostGis

st_transform(st_setsrid(oce_alojamientos.the_geom, 23030), 900913)

I retrieve these values with geoserver and openlayers, then I show this image over google, but the coordinates are displaced, as if I had working with another distinct projection.

Are there any corrections?

Thanks in advance.

Francisco.

2

Francisco Luis López ha scritto:

Hi.
The question is about displacement coordinates: I'm doing a coordinate translation in PostGis from 23030 to 900913, this is the line in PostGis

st_transform(st_setsrid(oce_alojamientos.the_geom, 23030), 900913)

I retrieve these values with geoserver and openlayers, then I show this image over google, but the coordinates are displaced, as if I had working with another distinct projection.

Are there any corrections?

None that I know of, but out of curiosity, why are you reprojecting
inside postgis? GeoServer can do the reprojection on the fly.
Often displacements in reprojection are due to either choosing
the wrong original projection code, or due to wrong
towgs84 parameter values (depending on how big the displacement is...
which you did not tell).

Cheers
Andrea