With spatial extension, writing file raise a GDAL error (only in wasm)

[TomBor]

What happens?

Writing a file with the spatial extension in duckbb wasm raise a GDAL error (IO Error: GDAL Error (3): Cannot write feature).

COPY table TO 'polygon.geojson' WITH (FORMAT 'GDAL', DRIVER 'GeoJSON');

I also wrote a similar issue in the spatial repo #363

To Reproduce

See this reproductible example in the shell

Browser/Environment:

Chrome 128

Device:

MacBook Pro 2019

DuckDB-Wasm Version:

duckdb-wasm@1.28.1-dev258.0

DuckDB-Wasm Deployment:

shell.duckdb.org

Full Name:

Thomas Ansart

Affiliation:

Sciences Po

[alexkreidler]

I'm getting the same error in https://www.quackdb.com/, another DuckDB WASM environment

[jdoig]

This will get you round the issue in the mean time:

await db.registerFileHandle('tmp_results.geojson', new Uint8Array(), 0, true);  // Duck/Spatial needs this but can't create is for some reason?
await db.registerFileHandle('results.geojson', new Uint8Array(), 0, true); // The file name you want to use without the 'tmp_' prefix

await connection.query(`
  copy (
    select * 
    from 'area_data.parquet'
  ) to 'results.geojson'
  with (
    FORMAT GDAL, DRIVER 'GeoJSON', LAYER_CREATION_OPTIONS 'WRITE_BBOX=YES'
  );`
);
const geojson_buffer = await db.copyFileToBuffer('results.geojson');
const link = URL.createObjectURL(new Blob([geojson_buffer]));
console.log("geojson url: ", link);

[tonydattolo]

same issue here in MotherDuck. ref: https://duckdb.org/docs/extensions/spatial/overview.html, https://motherduck.com/docs/troubleshooting/faq/#what-duckdb-extensions-are-available