[postgis-tickets] [PostGIS] #5389: ST_Transform Broken with PROJ 9.2.0

[PostGIS]

#5389: ST_Transform Broken with PROJ 9.2.0
---------------------+---------------------------
 Reporter:  tjay     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.1.9
Component:  postgis  |    Version:  3.1.x
 Keywords:  proj     |
---------------------+---------------------------
 Hi,

 if PostGIS 3.x is compiled with PROJ 9.2.0 some Transformations are
 broken:

 postgis 3.1.8 with PROJ 9.1.1
 {{{


  select postgis_full_version();
 postgis_full_version
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.1.8 c5ebc1f" [EXTENSION] PGSQL="120" GEOS="3.11.2-CAPI-1.17.2"
 PROJ="9.1.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
 WAGYU="0.5.0 (Internal)"
 (1 row)

 postgres=# select ST_AsText(ST_Transform(ST_GeomFromText('POINT(343806.17
 5676555.69)',25832),5676),4);
             st_astext
 ----------------------------------
  POINT(2553378.3214 5676286.9204)
 (1 row)


 }}}


 postgis 3.1.8 with PROJ 9.2.0
 {{{

 postgres=# select postgis_full_version();
 postgis_full_version
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.1.8 c5ebc1f" [EXTENSION] PGSQL="120" GEOS="3.11.2-CAPI-1.17.2"
 PROJ="9.2.0" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
 WAGYU="0.5.0 (Internal)"
 (1 row)

 postgres=# select ST_AsText(ST_Transform(ST_GeomFromText('POINT(343806.17
 5676555.69)',25832),5676),4);
             st_astext
 ----------------------------------
  POINT(2553376.7567 5676287.3596)
 (1 row)

 }}}

 cs2cs PROJ 9.2.0
 {{{


 [root at d5929135c288 /]# cat proj_utm.csv
 343806.17       5676555.69 0.00


 [root at d5929135c288 /]# cs2cs +init=epsg:25832 +to +init=epsg:5676
 proj_utm.csv
 2553378.32      5676286.92 0.00

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5389>
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.