16.7.2020 |

Selecting (geo)json from postgis

Postgis does not support selecting feature collections, thus I had to build one on my own. This is the resulting query I used:

SELECT json_build_object(
    'type', 'FeatureCollection',
    'properties', json_build_object(),
    'features', json_agg(st_asgeojson(field.geometry)::json)
           )
FROM field
WHERE farm_id = 'XYZ';

Useful postgis functions here are json_build_object() which creates a new object and json_agg() which creates a new array. Other json operations can be found in the postgres documentation.

Zur Übersicht
Sven Röttering

Mehr vom Devsquad...

Jan Sauer

Automate All The Things with Zapier

Jonathan Zbick

Customizing "Nicht planbar" in moco

Hallo, ich bin Jörg Herbst!

Ich bin der CEO von newcubator und freue mich über jede Nachricht!

* Pflichtfeld