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

[Richard Greenwood]

You're going from NAD27 to NAD83. Do you have the "nad27" and "nad83" datum
files installed in /usr/share/proj?

Rich

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

> 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.
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Richard W. Greenwood, PLS
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150605/fc9af483/attachment.html>