h3_cells_to_multi_polygon_wkt error

[samlalwani]

On calling ST_GeomFromText over the column generated by h3_cells_to_multi_polygon_wkt ,
I see the following error : shapely.errors.GEOSException: IllegalArgumentException: Points of LinearRing do not form a closed linestring

[isaacbrodsky]

Thanks for reporting this. I am not able to immediately reproduce because using ST_GeomFromText within DuckDB is fine with the multipolygons not being closed. That being said, it looks like this function does indeed need to duplicate the first vertex to be compliant with how OGC wants the WKT. Please see #138

[samlalwani]

I was calling ST_GeomFromText within DuckDB , its strange you did not observe this issue. Will try to create a test dataset.

I moved this operation to geopandas using h3.cells_to_h3shape which works perfectly though I loose the processing/scalabale advantage of dudkdb.