[postgis-tickets] [PostGIS] #5378: SRID of geography is lost during ST_Buffer(geography..) operation

PostGIS trac at osgeo.org
Wed Apr 26 16:29:03 PDT 2023


#5378: SRID of geography is lost during ST_Buffer(geography..) operation
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.1.9
Component:  postgis  |    Version:  3.3.x
 Keywords:           |
---------------------+---------------------------
 I tested this on a PostGIS 3.1.7 RDS system as well as my POSTGIS="3.3.2
 3.3.2" [EXTENSION] PGSQL="150" GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1"
 LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"

 and the behavior is the same:


 {{{
 SELECT ST_SRID( ST_Buffer(ST_GeomFromText('POINT(-94 29.53)',
 4269)::geography, 12)::geometry )
 }}}


 The answer here is 4326 instead of the expected 4269.  This works fine


 {{{
 SELECT ST_SRID(ST_GeomFromText('POINT(-94 29.53)',
 4269)::geography::geometry)
 }}}

 the SRID returned is 4269, so seems to be something going on in the
 ST_Buffer geography function that is losing the original SRID
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5378>
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.


More information about the postgis-tickets mailing list