duckdb / duckdb/duckdb-spatial

Specify layer name for writing to FileGDB?

Open
#265 7 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
708
Forks
96
Avg merge
1d 21h
Merged PRs (30d)
5

Description

Hey there -

Is it possible to specify a layer name (feature class or table) when writing to a file geodatabase?

The following code creates a file geodatabase named "testing" and a feature class named "testing".
```
COPY
(SELECT ST_Point(1,2) as geom, 10 as i)
TO
'./testing.gdb'
WITH (FORMAT 'GDAL',
DRIVER 'OpenFileGDB',
GEOMETRY_TYPE 'POINT',
LAYER_CREATION_OPTIONS 'LAYER_ALIAS=alias');
```

It appears, based on the [OpenFileGDB driver documentation](https://gdal.org/drivers/vector/openfilegdb.html) from GDAL, that you can specify the file geodatabase and feature class name when copying.

Thanks!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.