[PostGIS] #5596: ST_ASGeoJSONRow: cannot set id directly on feature

PostGIS trac at osgeo.org
Mon Oct 30 12:07:19 PDT 2023


#5596: ST_ASGeoJSONRow: cannot set id directly on feature
-------------------------+---------------------------
 Reporter:  jtojnar      |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.5.0
Component:  postgis      |    Version:  3.4.x
 Keywords:  json         |
-------------------------+---------------------------
 As per [https://www.rfc-editor.org/rfc/rfc7946#section-3.2 GeoJSON RFC],
 the id should go directly to the feature object rather than to properties:

     If a Feature has a commonly used identifier, that identifier SHOULD be
 included as a member of the Feature object with the name "id"

 But `ST_ASGeoJSONRow` does not support this so one needs to tediously
 build JSON object manually with `jsonb_build_object` as
 [https://postgis.net/docs/manual-3.4/ST_AsGeoJSON.html described in the
 manual).

 Ideally, there would be a new argument that would allow specifying which
 column to promote to id.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5596>
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