[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