duckdb_spatial icon indicating copy to clipboard operation
duckdb_spatial copied to clipboard

what is ST_Envelope_Agg ?

Open cboettig opened this issue 2 years ago • 2 comments

The web docs mention aggregation functions including ST_Envelope_Agg (which shows a :duck: native implementation). How is this defined? I don't see it in the GitHub README either. I'd be very interested in aggregation functions.

cboettig avatar Oct 12 '23 20:10 cboettig

Sorry about that, we're working on updating the docs and the readme here on GitHub properly.

The ST_Envelope_Agg basically returns a bounding box (as a polygon) containing the bounding box of all the input geometries. The signature is GEOMETRY ST_Envelope_Agg(GEOMETRY). The source is here

Maxxen avatar Oct 12 '23 20:10 Maxxen

Hmm, come to think of it it should probably be changed/aliased to ST_Extent, like in PostGIS

Maxxen avatar Oct 12 '23 20:10 Maxxen