Invalid building polygon geometries

[StephanGeorg]

Some building data (2024-09-18.0) from OpenStreetMap in Italy seams to have invalid geometries.

D select st_geometrytype("geometry"), count(1) from it_buildings where source = 'OpenStreetMap' group by st_geometrytype("geometry");
┌───────────────────────────┬──────────┐
│ st_geometrytype(geometry) │ count(1) │
│       geometry_type       │  int64   │
├───────────────────────────┼──────────┤
│ POLYGON                   │ 15169443 │
│ MULTIPOLYGON              │     1122 │
└───────────────────────────┴──────────┘

when trying to calculate centroids of these polygons an error is thrown:

D select st_centroid("geometry") from it_buildings where source = 'OpenStreetMap' and st_geometrytype("geometry") = 'POLYGON';
Invalid Input Error: IllegalArgumentException: Points of LinearRing do not form a closed linestring

At the moment I'm not sure if this is a DuckDB spatial issue so i did a cross post

duckdb/duckdb-spatial#406

[StephanGeorg]

It looks like there was a problem loading the data with DuckDB. A second attempt with re-imported data was successful. A bit strange but ok.