Eric Darchis edarchis
brambow
/ postgis-to-geojson-feature-collection.sql
Last active
April 25, 2023 15:44
PostGIS query to build a GeoJSON FeatureCollection
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT json_build_object( | |
| 'type', 'FeatureCollection', | |
| 'crs', json_build_object( | |
| 'type', 'name', | |
| 'properties', json_build_object( | |
| 'name', 'EPSG:4326' | |
| ) | |
| ), | |
| 'features', json_agg( | |
| json_build_object( |