Skip to content

bioepic-data/ecosim-agent / .agents/skills/ameriflux-bif-ecosim-mgmt

ameriflux-bif-ecosim-mgmt

Verified

Extract AmeriFlux BASE-BADM/BIF crop management records into EcoSIM-editable plant-management and soil-management Excel workbooks that can be converted to EcoSIM NetCDF files. Use when asked to derive EcoSIM planting, harvest, fertilizer, or tillage management inputs from AMF *_BIF_*.xlsx or BIF CSV files, especially for crop sites where management details live in GRP_DM_* records and DM_COMMENT fields.

AmeriFlux BIF To EcoSIM Management

Overview

Use this skill to convert AmeriFlux BADM/BIF management metadata into two editable EcoSIM workbooks:

  • *_plant_mgmt.xlsx, matching $ecosim-natural-plant-mgmt.
  • *_soil_mgmt.xlsx, matching $ecosim-soil-mgmt.

The extractor also writes companion JSON files and a *_management_extraction_review.xlsx workbook. Always review assumptions before converting the generated Excel files to NetCDF, because many AmeriFlux management quantities are stored in free-text comments.

Read references/mapping_rules.md when you need the exact parsing and default mapping rules.

Workflow

  1. Inspect the BIF workbook if needed. Prefer the AMF-BIF sheet. Select the requested SITE_ID before reconstructing or aggregating events. Pass --site-id for network workbooks; the extractor filters rows and rejects ambiguous multi-site input when no site is selected.
  2. Run the bundled extractor with the repo Python environment so it can read both XLSX and the PFT parameter NetCDF:
.venv-cmip6/bin/python \
  .agents/skills/ameriflux-bif-ecosim-mgmt/scripts/extract_bif_mgmt_to_ecosim_excel.py \
  /path/to/AMF_SITE_BIF_YYYYMMDD.xlsx \
  --site-id SITE \
  --pftpar-nc /path/to/ecosim_pftpar_YYYYMMDD.nc \
  --koppen-code 41 \
  --out-dir result/SITE/ecosim_mgmt_from_bif
  1. Open the review workbook and check:
    • crop-to-PFT mapping (corn=maiz41, soybean=soyb41 by default);
    • parsed planting populations from seed rates;
    • fertilizer N rates and product split among NH4Soil, NH3Soil, UreaSoil, and NO3Soil;
    • tillage depth/type defaults;
    • harvest defaults and FractionCut assumptions.
    • duplicated product entries, partial-field/resumed operations, and irrigation records omitted by the extractor. Its harvest-component defaults are zero: review actual removal/export against the consuming code before use.
  2. Edit the generated plant/soil Excel workbooks if needed.
  3. Convert reviewed workbooks to NetCDF using the existing bridge skills:
.venv-cmip6/bin/python .agents/skills/ecosim-natural-plant-mgmt/scripts/plant_mgmt_excel_bridge.py \
  xlsx-to-nc SITE_plant_mgmt.xlsx SITE_pft_mgmt.nc --json-output SITE_pft_mgmt.json

.venv-cmip6/bin/python .agents/skills/ecosim-soil-mgmt/scripts/soil_mgmt_excel_bridge.py \
  xlsx-to-nc SITE_soil_mgmt.xlsx SITE_soil_mgmt.nc --json-output SITE_soil_mgmt.json

Useful Options

  • --site-id: filter source rows to one site; a missing match is an error.
  • --start-year and --end-year: limit the output years.
  • --pftpar-nc: EcoSIM PFT parameter NetCDF used to validate pft_type against pfts.
  • --koppen-code: two-digit EcoSIM climate number used to compose <pfts_short><koppen>.
  • --crop-pft-map crop=pftcode: explicit crop mapping override, repeatable.
  • --planting-depth-m: default planting depth used when BIF only provides seed rate.
  • --topo NH1,NV1,NH2,NV2: set EcoSIM topo-unit bounds.
  • --default-fertilizer-n-g-m2: placeholder N rate when a fertilizer event lacks a parseable rate.
  • --tillage-depth-m and --tillage-type: placeholders for BIF tillage records.

Output Contract

The plant workbook has the exact sheets required by plant_mgmt_excel_bridge.py: control, topo_units, pft_years, and management.

The soil workbook has the exact sheets required by soil_mgmt_excel_bridge.py: control, topo_units, year_selectors, event_files, fertilizer, tillage, and irrigation.

The review workbook is not consumed by EcoSIM. It exists to protect unit consistency and mass-flow assumptions before NetCDF conversion.

deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall