duckdb_spatial icon indicating copy to clipboard operation
duckdb_spatial copied to clipboard

Big geojson

Open nshiab opened this issue 9 months ago • 2 comments

Hi!

I am trying to open a large and complex GeoJSON. I get an error message suggesting that I should use the OGR_GEOJSON_MAX_OBJ_SIZE option.

CREATE OR REPLACE TABLE urban AS SELECT * FROM ST_Read('./data/Urban.json',open_options=['OGR_GEOJSON_MAX_OBJ_SIZE=0']);

But when I do, nothing seems to change.

Is this option implemented?

Thank you!

nshiab avatar Mar 28 '25 15:03 nshiab

I just ran into the same issue. My understanding is that your solution does not work because OGR_GEOJSON_MAX_OBJ_SIZE is not an "open option" but rather a "configuration option" which DuckDB does not support.

I have yet to find a work around. In the meantime, you can check this out: GDAL GeoJson Driver

justsparsh avatar May 26 '25 02:05 justsparsh

Thank you, @justsparsh ! We'll see if it gets implemented at some point.

nshiab avatar May 26 '25 14:05 nshiab