[postgis-tickets] [PostGIS] #5207: ST_Transform NAD27 --> WGS84 Inconsistencies

[PostGIS]

#5207: ST_Transform NAD27 --> WGS84 Inconsistencies
---------------------------+-------------------------------
  Reporter:  judsoncrouch  |      Owner:  pramsey
      Type:  defect        |     Status:  new
  Priority:  high          |  Milestone:  PostGIS Packaging
 Component:  postgis       |    Version:  3.2.x
Resolution:                |   Keywords:
---------------------------+-------------------------------
Changes (by robe):

 * milestone:  PostGIS 3.2.3 => PostGIS Packaging

Comment:

 Okay my answers deviate everywhere, kind of troubling.


 {{{
 SELECT ST_AsText(st_transform(st_setsrid(ST_POINT(-99.723991251,
 35.954241741), 4267), 4326));
 }}}


 On my Centos: {{ POSTGIS="3.1.6 cde4b6b" [EXTENSION] PGSQL="120"
 GEOS="3.9.2-CAPI-1.14.3" SFCGAL="1.3.1" PROJ="7.2.1" LIBXML="2.9.1"
 LIBJSON="0.11"}} from yum.postgresql.org


 {{{

  POINT(-99.72437633585803 35.95430452419984)

 }}}

 On my Ubuntu Jammy {{ POSTGIS="3.2.2 628da50" [EXTENSION] PGSQL="140"
 GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.1" GDAL="GDAL 3.4.1, released
 2021/12/27" LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3"
 WAGYU="0.5.0 (Internal)" RASTER}} from apt.postgresql.org
 # this agrees with docker and is most right I guess

 {{{
 POINT(-99.72438152583983 35.95428699761243)
 }}}


 and on my windows: {{{ POSTGIS="3.2.2 3.2.2" [EXTENSION] PGSQL="140"
 GEOS="3.10.3-CAPI-1.16.1" PROJ="7.2.1" LIBXML="2.9.9" LIBJSON="0.12"
 LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" }}}
 -- this is way different, but agreets with the CentOS PROJ 7.2.1 install,
 so might be nature of PROJ 7.2.1
 {{{
 POINT(-99.72437633585803 35.95430452419984)
 }}}


 I'll try to upgrade my centos 7 to latest to see if I get same answer as
 reporter.  The fact that both my current CentOS and my windows are running
 7.2.1 I assume is the issue with those.

 But anyrate, this is clearly not a PostGIS issue, so reset to PostGIS
 Packaging.

 Side note examples are not 10-12 feet apart. Even in my worsed case that
 is 6 ft (that of PROJ 7.2.1), and the one the reporter is using is 1.4 ft.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5207#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.