write_geo: Write a spatial file with gdal

In duckdbfs: High Performance Remote File System, Database and 'Geospatial' Access Using 'duckdb'

Write a spatial file with gdal

Description

Write a spatial file with gdal

Usage

write_geo(
  dataset,
  path,
  conn = cached_connection(),
  driver = "GeoJSON",
  layer_creation_options = "WRITE_BBOX=YES"
)

Arguments

dataset	a remote tbl object from open_dataset, or an in-memory data.frame.
path	a local file path or S3 path with write credentials
conn	duckdbfs database connection
driver	driver, see https://duckdb.org/docs/stable/extensions/spatial/gdal
layer_creation_options	to GDAL, see https://duckdb.org/docs/stable/extensions/spatial/gdal

Details

NOTE: at this time, duckdb's pre-packaged GDAL does not support s3 writes, and will produce a "Error: Not implemented Error: GDAL Error (6): Seek not supported on writable /vsis3/ files". Use to_geojson() instead.

Examples

local_file <-  system.file("extdata/spatial-test.csv", package="duckdbfs")
load_spatial()
tbl <- open_dataset(local_file, format='csv')
write_geo(tbl, "spatial.geojson")

duckdbfs documentation built on Aug. 8, 2025, 6:57 p.m.