DuckDB-Postgis

A Rust Library for writing geospatial/non-geospatial data to Postgis using DuckDB.

Current Release v0.2.5

cargo add duckdb-postgis

• Reads in geospatial data file types (Geopackage, Shapefile, GeoJSON, Parquet) and automatically detects the file format using magic numbers and content analysis.
• Reads in non-geospatial data (CSV, Excel) with automatic header detection and error handling.
• Automatically detects coordinate pairs in CSV/Excel files by looking for common naming patterns (e.g., longitude/latitude, x/y, easting/northing) and converts them to geometry.
• Performs CRS transformation on the data if required - ensures the CRS is ESPG:4326 (WGS84) for consistent spatial operations.
• Loads the data into a PostGIS table with a correctly defined geometry column, handling both single and multi-geometry columns.
• Provides a clean interface for Rust applications.
• Uses DuckDB as an intermediate processing engine.

Future Improvements

• Allow users to specify a target CRS instead of defaulting to EPSG:4326
• Add support for more file formats and coordinate systems
• Improve error handling and logging
• Add support for batch processing multiple files
• Expand the range of file formats supported

Example usage

mod duckdb_load;
use duckdb_load::launch_process_file;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    launch_process_file(
        "[add_file_path]",
        "[add_table]",
        "postgresql://admin:password@localhost:5432/[add_db_name]",
        "[add_schema]"
    )?;
    Ok(())
}