[I] Add Geography support for ST_ConvexHull and the geometry-collecting aggregate [sedona]

["jiayuasu (via GitHub)" <gi...@apache.org>]

jiayuasu opened a new issue, #3176:
URL: https://github.com/apache/sedona/issues/3176

   ## What's missing
   
   Neither `ST_ConvexHull` nor the aggregate that feeds it (`ST_Collect` / `ST_Collect_Agg` /
   `ST_Union_Agg`) accepts geography, so a grouped hull cannot be computed on the sphere.
   
   ```sql
   -- wanted
   SELECT ST_Area(ST_ConvexHull(ST_Collect(ARRAY_AGG(geog)))) FROM ... GROUP BY ...;  -- m^2
   ```
   
   ## Why
   
   Together these block the geography form of SpatialBench Q5, which takes the convex hull of
   each customer's monthly dropoff locations and reports its area. Under geography the hull is
   built from geodesic edges and the area is in m², so the number means something; the planar
   version reports square degrees.
   
   ## Reference
   
   SedonaDB implements `ST_ConvexHull(geography) -> geography`, and its `ST_Collect_Agg` accepts
   geography as well (undocumented there — apache/sedona-db#1087), so the combination works
   end to end today and can serve as a reference.
   
   Part of https://github.com/apache/sedona/issues/2830.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@sedona.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Add Geography support for ST_ConvexHull and the geometry-collecting aggregate [sedona]

["jiayuasu (via GitHub)" <gi...@apache.org>]

jiayuasu closed issue #3176: Add Geography support for ST_ConvexHull and the geometry-collecting aggregate
URL: https://github.com/apache/sedona/issues/3176


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@sedona.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org