[postgis-tickets] [PostGIS] #4618: ST_Buffer(geography) issue

PostGIS trac at osgeo.org
Mon Jan 13 01:05:36 PST 2020


#4618: ST_Buffer(geography) issue
----------------------+---------------------------
  Reporter:  olehz    |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.1
 Component:  postgis  |    Version:  3.0.x
Resolution:           |   Keywords:  ST_Buffer
----------------------+---------------------------

Comment (by olehz):

 {{{
 WITH params AS (
     SELECT ST_GeographyFromText('POINT(10.715 59.940)') AS c, 2407600 AS
 dist
 )


 SELECT 'blue' AS color, ST_Buffer(c, dist, 90) AS geom FROM params
 UNION
 SELECT
     'red' AS color, ST_MakePolygon(ST_MakeLine(points || points[1])) AS
 geom
 FROM (
     SELECT
         ARRAY_AGG(p) points
     FROM params,
         generate_series(0, 359, 1) deg,
         Geometry(ST_Project(c, dist, RADIANS(deg))) p
 ) z
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4618#comment:1>
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