Skip to main content

Source: ebisu/index.md | ✏️ Edit on GitHub

Ebisu Database - Maritime Intelligence Platform

Standalone PostgreSQL-based intelligence platform for maritime domain awareness with comprehensive fisheries and vessel data.

Overview​

Ebisu is an intelligence platform for maritime domain awareness, not just a vessel database. It treats multiple reports of the same vessel as valuable confirmations that increase confidence, not duplicates to be removed.

Key Principles​

  • Intelligence-first architecture: Multiple confirmations increase trust scores
  • Source tracking: All data includes provenance and confidence metrics
  • Conflict resolution: Systematic handling of contradictory information
  • Reference data: WoRMS taxonomy, ASFIS species, vessel registries

Architecture​

@oceanid (ETL + ML Pipeline - Staging)
           ↓ Promotion (audited)
@ebisu (GlobalDB - Production)
  - Intelligence Platform
  - Vessel entities
  - Cross-source confirmations
  - Conflict tracking
  - Trust scoring

Quick Start​

Prerequisites​

  • Docker Desktop installed

Start Database​

docker-compose -f docker/docker-compose.yml up -d

This creates a PostgreSQL 17 database named "ebisu" with all schemas and reference data.

Key Features​

  • Vessel Intelligence: Multi-source vessel data with trust scoring
  • Reference Data: WoRMS taxonomy, ASFIS species lists, country profiles
  • Data Import Pipeline: Automated processing from authoritative sources
  • Schema Viewer: Web-based PostgreSQL schema documentation

Documentation​

  • Architecture: /docs/INTELLIGENCE_ARCHITECTURE.md - Intelligence platform design
  • Data Storage: /docs/DATA_STORAGE_ARCHITECTURE.md - Database schema and patterns
  • Import Guide: /docs/IMPORT_ARCHITECTURE.md - Data import processes
  • ADRs: /docs/adr/ - Architecture decision records

Repository Structure​

  • backend/: Core database logic, scripts, import sources
  • data/: Raw and processed data files (excluded from git)
  • tools/: PostgreSQL schema viewer and utilities
  • docs/: Documentation, ADRs, guides
  • docker/: Docker Compose configuration

Data Sources​

  • WoRMS: World Register of Marine Species taxonomy
  • ASFIS: FAO species list for fishery statistics
  • Vessel Registries: SEAFO, CCAMLR, SPRFMO, and other RFMOs
  • Country Profiles: Maritime jurisdiction and regulatory data