Re: Future of the Spatial Type Extension

2023-03-07 Thread Julian Hyde
> On Mar 6, 2023, at 3:37 PM, Bertil Chapuis wrote: > > Thank you for your answers and for the pointers. > >> PS Regarding which specification we choose to implement. The four principles >> you outline sound good to me. It’s always better to follow the standard. If >> leading implementation

Re: Future of the Spatial Type Extension

2023-03-06 Thread Bertil Chapuis
Thank you for your answers and for the pointers. > PS Regarding which specification we choose to implement. The four principles > you outline sound good to me. It’s always better to follow the standard. If > leading implementations (e.g. PostGIS and H2GIS) diverge from the standard, > we can ma

Re: Future of the Spatial Type Extension

2023-02-06 Thread Julian Hyde
PS Regarding which specification we choose to implement. The four principles you outline sound good to me. It’s always better to follow the standard. If leading implementations (e.g. PostGIS and H2GIS) diverge from the standard, we can make a note, and possibly support them as secondary implemen

Re: Future of the Spatial Type Extension

2023-02-06 Thread Julian Hyde
Similar issues have come up with non-GIS functions. For example, the DATEDIFF function [1]. Snowflake and MSSQL have ‘DATEDIFF(timeUnit, datetime, datetime2)’, whereas MySQL has ‘DATEDIFF(date, date2)’. We document which specification we implement, and potentially we could implement both specif

Future of the Spatial Type Extension

2023-02-06 Thread Bertil Chapuis
Hello Everyone, I continue to make progress on the implementation of the Spatial Type (ST_) extension for calcite [1] and wanted to exchange about the current design. When implementing spatial functions, we usually refer to the OpenGIS Simple Features Implementation Specification for SQL [2] or