feat(duckdb): add geospatial operations

[wybert]

Is your feature request related to a problem?

DuckDB has spatial extension, I would like to see DuckDB spatial support in ibis

Describe the solution you'd like

support all the functions like for PostGIS and HevayAIfunctions

What version of ibis are you running?

5.1

What backend(s) are you using, if any?

DuckDB

Code of Conduct

• I agree to follow this project's Code of Conduct

[cpcloud]

@wybert Welcome! 👋🏻

Thanks for the issue. This has definitely been in the back of our minds for a bit 🙂

I think we were just waiting for someone to ask for it before doing the work!

I'm not sure this will make it into 6.0, and if not, then we should be able to get it in for the follow-up feature release (6.1).

[NickCrews]

Is this implemented? It's not on the list of dtypes. I also don't understand how to construct these values (casting from strings, directly from binary files).

[jcrist]

Is this implemented? It's not on the list of dtypes.

Ibis has had geospatial support for a long time, this issue is for adding that support to duckdb. I'm not sure I fully understand your question, but the geospatial dtypes are in that list in the docs (e.g. LineString, Point, ...).

[NickCrews]

e.g. LineString, Point

Ah, I didn't see those. I thought there was a singular GeoSpatialValue type based on the API list, and I didn't see that in the dtype list. I get it now.

this issue is for adding that support to duckdb

I get it now, TODO is just to add the translation stuff in backends/duckdb/registry.py (or similar). I thought those above dtypes and operations were added post-this-issue, and the docs and this issue just weren't updated. Sorry for the noise.

[cpcloud]

Update on this: we're interested in adding support for geospatial, but we have a sizable refactor of the duckdb backend underway (#6996) that needs to land (to avoid relegating @gforsyth to rebase hell) before we can make progress on any new feature work for the duckdb backend.

[ncclementi]

/take

[cboettig]

🎉 are there updated docs showing this new awesomeness in action?

[cpcloud]

Not yet, but we have a blog post in PR!