6 ms·
At the SQL level, the ST_AsGeoJSON(record) variant will convert a tuple that includes a geometry and any combination of other columns into a GeoJSON output.
by pramsey 4mo ago
At the SQL level, the ST_AsGeoJSON(record) variant will convert a tuple that includes a geometry and any combination of other columns into a GeoJSON output.
- steve-chavez 4mo agoMany thanks for your work pramsey. We use that exact function [1], do you have any plans for a similar function for TopoJSON? One that also has a record parameter? [2]. [1]: https://github.com/PostgREST/postgrest/blob/f1d0e8ea2266077d2b57144927dea08bd8f74579/src/PostgREST/Query/SqlFragment.hs#L224 https://github.com/PostgREST/postgrest/blob/f1d0e8ea2266077d... [2]: PostGIS has https://postgis.net/docs/AsTopoJSON.html https://postgis.net/docs/AsTopoJSON.html but it doesn't take a record.