duckdb_spatial icon indicating copy to clipboard operation
duckdb_spatial copied to clipboard

Published 20 hours ago • verified publisher icon duckdb

Kernel crash when ingesting multiple shapefiles in a for loop

Open giswqs opened this issue 2 years ago • 2 comments

What's the recommended way to ingest all shapefiles under a directory into the database, creating a new table for each shapefile. The Jupyter notebook kernel crashes when trying to ingest multiple files in a for loop, but it works fine if ingesting them one by one.

Sample dataset: nyc_data.zip

image

giswqs avatar Oct 22 '23 03:10 giswqs

It works fine after converting all shapefiles to GeoJSON format. Not sure if there is bug with the shapefile reader.

image

giswqs avatar Oct 22 '23 04:10 giswqs

Hello! Thanks for raising this issue (and providing the data!). I suspect this is a problem with our filesystem layer but I'm going to look into it.

Maxxen avatar Oct 23 '23 12:10 Maxxen