Feature: add GEO data type

[david542542]

It seems DuckDB supports all the main data types with the exception of the GEO data type. A couple references:

• Postgres GEO
• MySQL GEO
• MonetDB GEO

It would be great to add support for this data type either directly or through a plugin (though I'm guessing a plugin would need to have access to that data type in storage).

[lnkuiper]

I believe structs would already cover a large part of the GEO data type, so you can probably do much of this yourself (structs can be stored). Although it should not be very difficult to add native GEO support considering we already have structs.

Custom functions on structs can be defined using macro's.

[david542542]

Thanks for the response. As an aside to the GEO feature: How can you store a named STRUCT? Is it possible to do something similar to named data types in postgres with a struct in DuckDB?

[david542542]

@lnkuiper @Mytherin oh cool is this related to this that was just pushed with the CREATE TYPE ? Just noticed that from the logs but haven't yet seen it in the docs.

e1a1bc5

[mattijn]

Related: #1149

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[Mytherin]

The geo type is supported in the spatial extension now