+1 for this APE
On Sat, Aug 2, 2025 at 12:11 AM Wail Alkowaileet <wael....@gmail.com> wrote: > > +1 for that! > > Since this touches the spatial aspect, what do you think of supporting h3 > <https://h3geo.org/> indexing in AsterixDB? I stumbled into this > <https://www.architecture-performance.fr/ap_blog/spatial-queries-in-duckdb-with-r-tree-and-h3-indexing/> > article and I find it interesting. > > On Fri, Aug 1, 2025 at 9:28 PM Mike Carey <dtab...@gmail.com> wrote: > > > Looks very good at this point IMO! > > > > On 8/1/25 9:57 AM, Suryaa Charan Shivakumar wrote: > > > Hello AsterixDB Dev Community, > > > > > > I hope you’re all doing well. I wanted to share a quick update on our > > > ongoing efforts to integrate Coordinate Reference System (CRS) support > > into > > > AsterixDB, tracked under JIRA epic *ASTERIXDB-3542* > > > <https://issues.apache.org/jira/browse/ASTERIXDB-3542> > > > > > > We’ve made some progress in refining how CRS metadata is represented and > > > managed within the system. More details are available in the APE: APE 17: > > > Spatial CRS Support in AsterixDB > > > < > > https://cwiki.apache.org/confluence/display/ASTERIXDB/APE+17%3A++Coordinate+Reference+System+%28CRS%29+support+for+Spatial+Data+in+AsterixDB > > > > > > > > > The overarching objective remains the same: *To make AsterixDB spatially > > > aware in a real-world sense enabling geospatial queries and analytics > > that > > > respect map projections, distance accuracy, and cross-CRS > > interoperability.* > > > > > > As always, we welcome your feedback and thoughts to ensure we’re building > > > this in a robust and community aligned way. > > > > > > Best regards, > > > Suryaa Charan > > > > > > On Thu, Jan 9, 2025 at 5:06 PM Mike Carey<dtab...@gmail.com> wrote: > > > > > >> +1 for this work - nice APE! I added a comment with one question and > > >> one suggestion on the APE wiki. > > >> > > >> On 1/9/25 4:25 PM, Suryaa Charan Shivakumar wrote: > > >>> Hello AsterixDB Dev Community, > > >>> > > >>> I hope this message finds you well. I am pleased to share a proposal > > for > > >>> adding *Coordinate Reference System (CRS) support* for spatial data in > > >>> AsterixDB, tracked under JIRA epic *ASTERIXDB-3542* and targeted for > > the > > >>> 9.10.0 release. > > >>> > > >>> Key Motivations: > > >>> > > >>> 1. Improved Spatial Data Handling: Enable accurate, CRS-aware > > spatial > > >>> operations, including transformations and validations. Currently, > > >> spatial > > >>> data in AsterixDB resides in a Euclidean space, which means > > spatial > > >>> analysis using the provided functions may not yield precise > > results. > > >>> Integrating CRS is critical to ensure accurate, real-world spatial > > >>> operations by accounting for the Earth's curvature and coordinate > > >>> transformations. > > >>> 2. Enhanced Interoperability: Ensure compatibility with external > > >> systems > > >>> by supporting standard (e.g., EPSG) and custom CRS definitions. > > >>> > > >>> APE - > > >>> > > >> > > https://cwiki.apache.org/confluence/display/ASTERIXDB/APE+17%3A+Spatial+CRS > > >>> We invite your feedback on this proposal to ensure we address potential > > >>> impacts and refine the implementation plan. > > >>> > > >>> Thank you for your collaboration. > > >>> > > >>> Best regards, > > >>> Suryaa Charan > > >>> > > > > -- > > *Regards,* > Wail Alkowaileet