The good news: #DuckDB now includes #Geometry as a built-in type, a major step forwards for this #database engine.
The bad news: it stores #Geographic #Coordinates backwards, with #longitude first. Beware of interoperability with other software.

Geometry Data Type
Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type in DuckDB v1.5. Most of the benefits of having GEOMETRY as a built-in type (e.g., storage optimizations, statistics, etc.) are therefore only available in databases using storage version v1.5 and above. However, almost all of the associated functions for working with geometries (e.g., calculating distances, areas, intersections) are still part of spatial. Types of Geometries Conceptually, the GEOMETRY type follows the core…





