[postgis-users] Different results in datum transform pg v2 vs pg v1

[David Fawcett]

I forgot to include the full version info.

 SELECT Postgis_Full_Version();

Old Server:
"POSTGIS="1.3.6" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
2009" USE_STATS"

New Server
"POSTGIS="2.1.1 r12113" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6"
LIBJSON="UNKNOWN" RASTER"

On Fri, Jun 5, 2015 at 10:55 AM, David Fawcett <david.fawcett at gmail.com>
wrote:

> We are finally able to retire one of our older servers running an old
> version of PostGIS and we are migrating everything over to a new install.
>
> One thing that I am noticing is that I am getting different behavior
> between the two versions when transforming some values from 4267 to 4326.
>
> The Old Server:
>
> SELECT Postgis_Version();
> 1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>
> SELECT
> ST_Y(ST_Transform(ST_SetSRID(ST_Point(-94.884720995369,47.4732852509464),4267),4326))
> AS lat,
>
> ST_X(ST_Transform(ST_SetSRID(ST_Point(-94.884720995369,47.4732852509464),4267),4326))
> AS lon;
>
> 47.4732375024506 | -94.8849980111078
>
>
>
> The New Server
> SELECT Postgis_Version();
> 2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>
> SELECT
> ST_Y(ST_Transform(ST_SetSRID(ST_Point(-94.884720995369,47.4732852509464),4267),4326))
> AS lat,
>
> ST_X(ST_Transform(ST_SetSRID(ST_Point(-94.884720995369,47.4732852509464),4267),4326))
> AS lon;
>
> 47.4732852509464 | -94.884720995369
>
> This issue feels familiar, but I couldn't find anything about it when
> searching.  Can anyone shed some light?
>
> Thanks,
>
> David.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150605/457ef53e/attachment.html>