smallsats_items.sql

smallsats_dump.sql

SELECT
    jsonb_build_object(
        'id', items.id,
        'datetime', items.datetime,
        'collection', items.collection,
        'geometry', public.st_asgeojson(items.geometry)::jsonb,
        'properties', items.properties,
        'assets', items.assets,
        'links', items.links
    ) AS content
FROM items;