GeoJSON from DuckDB

duckdb_geojson.sql

WITH geodata AS (
SELECT
	ROW_NUMBER() OVER () AS OBJECTID,
    *
FROM
    read_parquet('~/Downloads/IRL.parquet') LIMIT 1000)
select json_object(
'type', 'FeatureCollection',
    'features', array_agg(
        json_object(
            'type', 'Feature',
            'geometry', ST_AsGeoJSON(geometry),
            'properties', json_object(
            'bf_source', bf_source,
            'boundary_id', boundary_id,
            'confidence', confidence,
            'area_in_meters', area_in_meters,
            's2_id', s2_id,
            'country_iso', country_iso,
            'geohash', geohash,
            'OBJECTID', OBJECTID
            )
        )
        )
) AS geojson_featurecollection
FROM geodata;