Skip to contents

End-to-End ETL Workflows

Complete spatial ETL workflows.

duck_io_esri()
End-to-end spatial ETL (ESRI ↔ DuckDB)

Storage Formats

Read and write spatial data between analytical storage formats.

write_sf_to_duckdb()
Write sf object to DuckDB using WKT geometry storage
read_sf_from_duckdb()
Read sf object from DuckDB using WKT geometry storage
write_sf_to_parquet()
Write sf object to Parquet using WKT geometry storage
read_sf_from_parquet()
Read sf object from Parquet using WKT geometry storage
write_sf_to_qs2()
Write sf object to qs2
read_sf_from_qs2()
Read sf object from qs2

ESRI Data Access

Read and write GIS formats.

read_esri_layer()
Read a spatial layer as sf
write_esri_layer()
Write an sf object to a spatial file format
guess_spatial_format()
Guess spatial file format
etl_list_gdb_layers()
List layers in a File Geodatabase
etl_check_layer()
Inspect a spatial layer before loading

DuckDB Registry and Utilities

Registry management and DuckDB helpers.

etl_duckdb_registry()
Inspect the etlspatial DuckDB registry
etl_duckdb_drop_tables()
Drop tables from DuckDB and remove them from the registry
etl_table_exists()
Check if a DuckDB table exists
etl_registry_check_duplicates()
Check for duplicate registry entries
etl_registry_similarity_check()
Check for likely similar DuckDB spatial tables

Quality Assurance

Spatial QA summaries and visual checks.

qa_spatial_summary()
Spatial QA summary
qa_spatial_plot()
Quick spatial QA plot