cafi-2019-data

Mo’orea Coral Reef CAFI Field Experiments (2019-2021)

Coral Associated Fishes and Invertebrates (CAFI) Communities in Coral Reef Ecosystems

Trapezia guard crab on coral

Status Data Quality Files


📖 About This Dataset

This repository contains complete, publication-ready data from two field experiments and one observational survey investigating how cryptic invertebrate communities affect coral reef ecosystems in Mo’orea, French Polynesia (2019-2021).

What are CAFI? Coral Associated Fishes and Invertebrates are organisms (crabs, shrimp, worms, snails, fish) that live hidden within coral branches. These cryptic communities can significantly influence coral health and growth.

Key Features:

Principal Investigators:

Research Team:

Funding:


🗂️ Repository Structure

moorea-cafi-data/
├── README.md                          # This file - START HERE
├── BCO_DMO_FILE_DESCRIPTIONS.csv      # BCO-DMO dataset organization
├── BCO_DMO_SUBMISSION_CHECKLIST.md    # Submission status and checklist
├── CLAUDE.md                          # Repository context for AI assistants
├── CITATION.cff                       # Citation information
├── DATA_DICTIONARY.md                 # Column descriptions for all files
├── DATA_INTRODUCTION.html             # Interactive data introduction
├── DOI_AND_VERSIONING.md              # DOI and versioning guide
├── GETTING_STARTED.md                 # Quick start guide
├── LICENSE                            # CC-BY-4.0 license
├── data/                              # 23 data files (CSV + Excel)
│   ├── maatea_size_*                 # Maatea Size experiment (8 files)
│   ├── moorea_survey_*               # Mo'orea Survey (5 files)
│   └── mrb_amount_*                  # MRB Amount experiment (10 files)
├── metadata/                          # 24 metadata files
│   ├── README_*_project_overview.txt # Method overviews (5 .txt files)
│   ├── README_*_metadata_v*.xlsx     # Data dictionaries (8 .xlsx files)
│   ├── README_*_metadata_v*.csv      # BCO-DMO parameter definitions (8 .csv)
│   ├── site_locations.csv            # GPS coordinates
│   └── personnel.csv                 # Research team details
└── images/                            # Species photos and figures

🚀 Quick Start

For First-Time Users:

  1. Start with GETTING_STARTED.md
    • Overview of the three experiments
    • Which files to use for your analysis
    • Common workflows
  2. Check DATA_DICTIONARY.md
    • Descriptions of every column in every file
    • Data types and units
    • Special codes and categories
  3. Choose your data files from data/

For R Users:

# Example: Load CAFI taxonomy data
cafi_data <- read.csv("data/maatea_size_cafi_taxonomy_merged_2019_2021_v2.csv")

# Use original column for viewing
head(cafi_data$cafi_size_mm)  # Shows: "5.2", "<5", "L", etc.

# Use _numeric column for analysis
mean(cafi_data$cafi_size_mm_numeric, na.rm=TRUE)  # Calculates mean

For Python Users:

import pandas as pd

# Example: Load CAFI taxonomy data
cafi_data = pd.read_csv("data/maatea_size_cafi_taxonomy_merged_2019_2021_v2.csv")

# Use original column for viewing
print(cafi_data['cafi_size_mm'].head())  # Shows: "5.2", "<5", "L", etc.

# Use _numeric column for analysis
cafi_data['cafi_size_mm_numeric'].mean()  # Calculates mean

📊 Two Experiments + One Survey

1. Maatea Size Experiment (8 files)

Question: Does coral colony size affect CAFI communities?

Location: Maatea backreef, Mo’orea (17.6°S, 149.8°W) Years: 2019-2021 Coral colonies: 60 Pocillopora colonies Treatments: Different colony sizes with/without CAFI removal

Key files:

2. MRB Amount Experiment (10 files)

Question: Does coral habitat density affect CAFI community assembly?

Location: MRB north shore backreef, Mo’orea (17.5°S, 149.8°W) Years: 2019-2021 Coral colonies: 54 Pocillopora colonies Treatments: Low (solitary), Medium (groups of 3), High (groups of 6) density

Key files:

3. Mo’orea Survey (5 files)

Question: What are natural CAFI communities like across Mo’orea?

Location: Multiple sites around Mo’orea (17.5°S, 149.8°W) Year: 2019 Coral colonies: 114 Pocillopora colonies surveyed Time Zone: All data collected in Tahiti Time (UTC-10)

Key files:


📏 File Naming Convention

All files follow this pattern:

{experiment}_{datatype}_{temporal}_{version}.{ext}

Examples:


⚠️ IMPORTANT: Understanding Columns

Many files have BOTH original and numeric columns:

Original columns (e.g., cafi_size_mm):

Numeric columns (e.g., cafi_size_mm_numeric):

Example:

Row 1:  cafi_size_mm = "8.5"     cafi_size_mm_numeric = 8.5
Row 2:  cafi_size_mm = "<5"      cafi_size_mm_numeric = NA
Row 3:  cafi_size_mm = "L"       cafi_size_mm_numeric = NA
Row 4:  cafi_size_mm = "12.3"    cafi_size_mm_numeric = 12.3

Why both columns?


🔍 Data Codes and Categories

Common CAFI Size Codes:

Missing Data (BCO-DMO Compliant):

All missing data is represented by blank/empty cells. This dataset does NOT use placeholder codes like NA, ., or - for missing values.

Timezone:

All dates and times are in Tahiti Time (UTC-10).

Date Format:

All dates are in ISO 8601 format (YYYY-MM-DD).

Coral ID Format:


📐 Measurement Methods

CAFI (Coral Associated Fishes and Invertebrates):

Coral Photogrammetry:

Coral Physiology:


🗃️ Complete File List

Maatea Size Experiment (8 files):

  1. maatea_size_cafi_taxonomy_merged_2019_2021_v2.csv - 8,965 rows
  2. maatea_size_colony_measurements_wide_2019_2021_v1.csv - 60 rows
  3. maatea_size_experimental_treatments_v1.csv - 945 rows
  4. maatea_size_fish_surveys_2019_2021_v1.csv - 4,581 rows
  5. maatea_size_genetic_samples_metadata_v3.xlsx - 60 rows
  6. maatea_size_photogrammetry_2019_2021_v1.csv - 117 rows (combined Dec 2019 + May 2021)
  7. maatea_size_photogrammetry_summer_2019_v1.xlsx - 60 rows (supplemental)
  8. maatea_size_physiology_master_long_2019_2021_v3.csv - 118 rows

Mo’orea Survey (5 files):

  1. moorea_survey_cafi_taxonomy_summer_2019_v5.csv - 3,989 rows
  2. moorea_survey_coral_characteristics_merged_2019_v2.csv - 114 rows
  3. moorea_survey_physiology_master_2019_v3.csv - 108 rows
  4. moorea_survey_tip_stump_comparison_dec_2019_v1.xlsx - 21 rows (supplemental)
  5. moorea_survey_tip_stump_zoox_counts_dec_2019_v1.xlsx - 108 rows (supplemental)

MRB Amount Experiment (10 files):

  1. mrb_amount_cafi_field_experiment_summer_2021_v4.csv - 4,119 rows
  2. mrb_amount_coral_growth_surface_area_change_filtered_v1.csv - 44 rows (supplemental QC)
  3. mrb_amount_coral_growth_surface_area_change_v1.csv - 54 rows
  4. mrb_amount_coral_id_position_treatment_v1.csv - 54 rows (supplemental)
  5. mrb_amount_experimental_treatments_v1.csv - 54 rows
  6. mrb_amount_fish_surveys_may_2021_v1.csv - 999 rows
  7. mrb_amount_manual_colony_measurements_2019_2021_v1.xlsx - 54 rows (supplemental)
  8. mrb_amount_photogrammetry_200k_mesh_2019_2021_v1.csv - 264 rows (supplemental raw)
  9. mrb_amount_photogrammetry_measures_2019_2021_v1.csv - 108 rows
  10. mrb_amount_physiology_master_2019_2021_v5.csv - 53 rows

Total: 23 data files


🎯 Common Analysis Workflows

1. Analyze CAFI Community Composition

# Load data
cafi <- read.csv("data/maatea_size_cafi_taxonomy_merged_2019_2021_v2.csv")

# Summarize by family
library(dplyr)
cafi %>%
  filter(!is.na(family)) %>%
  group_by(family) %>%
  summarize(
    count = n(),
    mean_size = mean(cafi_size_mm_numeric, na.rm=TRUE)
  ) %>%
  arrange(desc(count))

2. Compare Coral Growth Between Treatments

# Load data
growth <- read.csv("data/mrb_amount_coral_growth_surface_area_change_v1.csv")
treatments <- read.csv("data/mrb_amount_experimental_treatments_v1.csv")

# Merge and analyze
library(dplyr)
merged <- growth %>%
  left_join(treatments, by="coral_id") %>%
  group_by(treatment) %>%
  summarize(
    mean_growth = mean(delta_surface_area, na.rm=TRUE),
    se = sd(delta_surface_area, na.rm=TRUE)/sqrt(n())
  )
# Load both datasets
cafi <- read.csv("data/maatea_size_cafi_taxonomy_merged_2019_2021_v2.csv")
phys <- read.csv("data/maatea_size_physiology_master_long_2019_2021_v3.csv")

# Count CAFI per colony
cafi_counts <- cafi %>%
  group_by(coral_id, time_point) %>%
  summarize(cafi_count = n())

# Merge with physiology
library(dplyr)
merged <- phys %>%
  left_join(cafi_counts, by=c("coral_id", "time_point"))

# Analyze relationship
cor.test(merged$cafi_count, merged$protein_mg_cm2)

📚 Additional Documentation

Quick Reference Guides

Detailed Methods (metadata/ folder)

Plain text overviews (.txt files):

Data dictionaries (.xlsx and .csv files):


📄 Citation

If you use this data, please cite:

Stier, A.C. and Osenberg, C.W. (2025). Mo'orea Coral Reef CAFI Field
Experiments Data Package (2019-2021). Dataset.
https://github.com/stier-lab/moorea-cafi-data

📧 Contact

Questions about the data?

Technical issues with this repository?


📜 License

This data is released under CC-BY-4.0 (Creative Commons Attribution 4.0 International)

You are free to:

Under these terms:


✅ Data Quality & BCO-DMO Compliance


🔄 Version History


📋 DOI and Versioning

For information about:

See DOI_AND_VERSIONING.md


🚀 BCO-DMO Submission

Ready to submit to BCO-DMO?

See BCO_DMO_SUBMISSION_CHECKLIST.md for:


Last Updated: 2025-01-03 Current Version: v2.6 (BCO-DMO Compliant) Repository Maintained By: Stier Lab, UC Santa Barbara