[postgis-users] st_geojson like st_mvt function

[Regina Obe]

This has come up in discussion before and we have a ticket for it.

 

https://trac.osgeo.org/postgis/ticket/1833

 

I've revised the title so intent is clearer and easier to find for any others looking for it.

 

I think Paul Ramsey intimated he may do it for PostGIS 2.5, but that's still an iffy for him since I think he's got higher priorities.

 

If enough interest it will probably happen in 2.5 since I think much of the logic can be patterned after ST_AsMVT.

 

Feel free to add your comments to the above ticket or provide a patch or garner funding for it.

 

Thanks,

Regina

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Rémi Desgrange
Sent: Tuesday, December 12, 2017 3:56 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] st_geojson like st_mvt function

 

Hi,

 

this is my first mail on this list, I didn't know if I should have posted on dev list or this one. Don't hesitate to correct.

 

With postgis 2.4 we now have the possibility to generate mvt format directly in SQL, what I really like is the ability to construct a mvt response with geometrie + data. The sql result is directly well formated and ready to use. When I need to use geojson in my app I need something like that :

 

{ "type": "Feature", 

  "geometry": 

      { 

        "type": "Point", 

        "coordinates": [125.6, 10.1] 

      }, 

      "properties": { "name": "Dinagat Islands" }

 }

 

In order to do that I do :

SELECT name, st_geojson(geom) as geom FROM mytable

 

And then I my code I manipulate "name" to put it in the json under "properties" there hack around to directly return geojson, but they're hack not actual solutions.

 

What I imagine is something like that :

 

SELECT st_geojson(x) FROM (SELECT name, geom FROM mytable) x

 

the signature would be :

 

text St_AsGeoJSON(anyelement set row)

 

I do not know if this question has already been asked, I found nothing when I googled. Do you think that this is a legitimate feature request ?

 

Thanks.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171213/61e132aa/attachment.html>