You check the King's River box in early April and find eleven eggs with a female sitting tight. You log it, move to the next site. Three weeks later, you check the same box and find two unhatched eggs and evidence of a partial predation event. If your records from the first visit are a scrawled note on a waterproof card, the connection between those two visits takes effort to reconstruct. If they're structured records in the same database, the box's history is already there.
The Problem with Informal Nest Box Records
Goosander nest box programs are long-term monitoring commitments. The conservation value comes from longitudinal data — knowing whether fledgling success at the Upper Lake box has improved since the box was repositioned, knowing whether the St. Saviour's Larch site is consistently occupied or sporadic, knowing which boxes require maintenance before the season starts. That value only materializes if the records are consistent year over year.
The common failure mode is that visit data lives in different formats across different seasons — notebooks, photos, spreadsheets that someone set up and then slightly changed the column headers on. By the time you want to calculate box occupancy rates across the network or compare productivity between riparian and woodland nest sites, you're manually reconciling years of inconsistent data.
Nineteen named boxes across the template — from Ballard Oak and Coronation to Glendasan and Carrigroe — represent a substantial monitoring network. Each one needs the same data captured at each visit, in the same format, every time.
What Gets Captured Per Visit
Box Checked selects the specific named site — no ambiguity about which box the record applies to. Date of Visit creates the time axis for filtering by season or comparing equivalent calendar dates across years.
Action Taken distinguishes between a cleaned-out box visit (typically pre-season) and a nest check (in-season monitoring) — these produce different interpretable data, and conflating them muddies productivity calculations. Condition of box with its Good / Needs attention radio is the maintenance tracking that prevents the frustration of arriving at a box mid-season to find it needs repair work you weren't prepared for.
Box used, Eggs in box, and Number of eggs in box establish the occupancy and clutch status for the visit. Female sitting is the incubation confirmation — an occupied box with eggs and a sitting female has a very different prognosis from one with eggs and no female present for consecutive visits. Female ringed with its three-state choice (Yes / No / Unknown) tracks individual bird returns without forcing a definitive call when visibility was poor and the female flushed before a ring could be confirmed.
What the Season Totals Tell You
Hatched eggs in box and Number of hatched eggs are where productivity data is generated. Cross-referencing the clutch count from the final incubation check against the hatched egg count from the post-fledging check gives fledgling success per box per season. At nineteen boxes over five seasons, that's the dataset that answers whether the program is actually working.
The Details field appears twice in the template — once adjacent to Action Taken and once adjacent to Condition of box. This allows separate narrative notes for what was done during the visit versus what physical state the box was in. A box that has wasp nest remnants from the previous year occupying the cavity, but no structural damage, needs that noted under condition details, not under action taken.
Other comments carries anything that doesn't fit the structured fields: a territorial male seen on the river below the box, a Grey Squirrel that flushed from the site, an unusual egg coloration worth noting for downstream analysis.
Filtered across a full season, every box has a timestamped visit sequence. Every box where Female ringed: Yes was recorded becomes a data point for individual female site fidelity analysis. Every Condition: Needs attention record becomes a pre-season maintenance checklist without a separate list needing to be maintained.