bioepic-data/ecosim-agent / .agents/skills/ameriflux-bif-ecosim-mgmt
ameriflux-bif-ecosim-mgmt
VerifiedExtract 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.0 KB |
| agents/openai.yaml | config | 316 B |
| references/mapping_rules.md | markdown | 4.4 KB |
| scripts/extract_bif_mgmt_to_ecosim_excel.py | script | 45.3 KB |
| scripts/test_site_selection.py | script | 3.2 KB |
SKILL.md
View on GitHub---
name: ameriflux-bif-ecosim-mgmt
description: "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:
```bash
.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
```
3. 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.
4. Edit the generated plant/soil Excel workbooks if needed.
5. Convert reviewed workbooks to NetCDF using the existing bridge skills:
```bash
.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.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |