[PostGIS] #5775: ST_AsGeoJSONAgg which is aggregate version of ST_AsGeoJSON

PostGIS trac at osgeo.org
Mon Sep 16 09:19:50 PDT 2024


#5775: ST_AsGeoJSONAgg which is aggregate version of ST_AsGeoJSON
----------------------+-----------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS Fund Me
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+-----------------------------
Comment (by robe):

 Replying to [comment:6 mdavis]:
 > But I do see Paul's point that Postgres already has good support for
 converting rows to JSON, so this code would be duplicating that
 functionality.

 Yah I wasn't thinking of getting rid of geom.  Just hate having to
 remember that json_build_object nonsense.  It's even more annoying than
 the ST_SetSRID(ST_Point(1,2), 4326)  that necessitated us to add srid as
 an extra arg to ST_Point.  About as annoying as that thing we used to do
 before we had ST_MakeEnvelope.  It just irks me that I have never had a
 need for using ST_AsGeoJSON (passing in a row) except for case where I
 want to aggregate. But it can wait I guess and perhaps not a great idea.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5775#comment:7>
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