gaiaDb

Description

gaiaDb is the core data repository for the Gaia toolchain, implemented as a PostgreSQL/PostGIS database. It contains all geospatial data processing logic, SQL routines, and OMOP CDM integration functionality.

Key Features

  • PostgreSQL/PostGIS backend for spatial data storage and operations
  • SQL routines and PostGIS functions for geospatial analysis and exposure calculations
  • OMOP CDM integration via External_Exposure and Location_History tables
  • LinkML/JSON-LD metadata support for standardized data representation
  • Direct connections from R through gaiaCore, and an optional PostgREST API deployed by gaiaDocker

Architecture

gaiaDb uses a dual-schema approach: - backbone schema: Core LinkML-based metadata and data catalog - working schema: OMOP integration tables (external_exposure, location_history, location)

All data transformation, spatial operations, and exposure calculations are performed within the database using SQL and PostGIS functions.

Access

gaiaDb is accessed through: - gaiaCore: R package that connects directly and calls the database’s functions - Direct database connections: Standard PostgreSQL client connections - PostgREST API (optional): RESTful interface to database functions and tables, deployed by gaiaDocker