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.fawc...@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.fawc...@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@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- Richard W. Greenwood, PLS www.greenwoodmap.com
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users