search

isaacbrodsky / h3-duckdb

Bindings for H3 to DuckDB
Apache License 2.0
173 stars 9 forks source link

crash on compact_cells of a polygon #123

Open isaacbrodsky opened 2 months ago

isaacbrodsky commented 2 months ago 
In [18]: c.query("""COPY(
    ...:     select site_id, unnest(h3_compact_cells(h3_cell_group)) as h3_cell fr
    ...: om (select site_id, array_agg(h3_cell) as h3_cell_group from dftocompact
    ...: group by site_id))
    ...:     to 'natura2000_h3_compact.parquet' (FORMAT 'parquet');""")
zsh: bus error  .../bin/ipython

Seems like compacting a group of cells from a polyfill is harder than intended