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
  • RESTful API exposure via PostgREST for multi-language access

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: - PostgREST API: RESTful interface to database functions and tables - Direct database connections: Standard PostgreSQL client connections - gaiaCore connectors: Language-specific client libraries (R, Python, etc.)