Why is this creek reading blank? A codebook for volunteer field sheets
· SPCWC editorial team · Worked example and worksheet
Tuesday’s field sheet has an empty temperature box beside Willow Footbridge. A note that the meter would not switch on explains the blank. Without a note, the coordinator still has to ask the crew what happened. The sheet needs a place for each of those answers.
1. Give each expected reading a place
Start with the visit plan. Write one row for each site, visit and measurement that was due. If the team scheduled water temperature only, there is no missing nitrate result for that visit. The creek monitoring records guide covers the site and method details that let another volunteer find the right sheet.
Keep the numeric value in its own column. Beside it, allow space for a status, a source reference and a short explanation. Use the original wording from a field note or lab report when it matters. A local status gives the coordinator something to filter without changing what the source said.
2. Match the status to what someone documented
These labels belong to this practice sheet. A project with an approved codebook should use its own definitions.
- Visit cancelled. The coordinator’s dated note calls off the visit. A missing field sheet alone gives you no basis for this entry.
- Instrument failed. The crew recorded an attempt and described the fault. A meter that would not power on supports this label. An empty display in a photograph leaves more questions open.
- Report pending. A receipt links the sample to the visit and the tracking note says a report is still outstanding. Save the receipt number so the coordinator knows where to look.
- Reason unresolved. The plan calls for a measurement, the value is blank, and the available records give no explanation. That is enough to open a question.
Keep a numeric result status for a documented value and a qualified result status for a report that gives a condition instead of a number. For example, EPA’s WQX detection-limits guide shows a preferred example in Table 5 with a blank result value, a “Not Detected” condition, and a separate limit type, value and unit. A lab has delivered a result in that example. Chasing a missing report would waste everyone’s time.
3. Count what the five blanks actually represent
The Willow Footbridge practice sheet contains six fictional planned readings. Filter for blank numeric values and five rows appear. Read across before calling anyone.
- W01 contains a recorded water temperature of 12.4 °C. W02 has a cancellation note, and W03 has a field note describing the failed meter.
- W04 has a lab receipt and an outstanding report. W05 already has a reported condition and its method detection level. The 0.02 mg/L on W05 belongs in the limit column.
- W06 has only a scheduled temperature check and an empty field. Ask for the original sheet before assigning a cause.
Two rows contain results, one numeric and one qualified. Of the four other rows, two have documented reasons the crew could not supply a reading, one awaits the laboratory and one needs an explanation. Use that tally to decide which records to chase. Keep the temperature and nitrate results separate when you summarize the measurements.
4. Give the next person a specific question
For W04, ask whether the lab has issued a report for the receipt on file. For W06, ask the visit lead whether there is a dated note or instrument record. If a missing record turns up, preserve the original sheet and log the new status, evidence and review date. Leave an unresolved row open when nobody can establish what happened.
A project may have a second record to consult. In the USGS Equus Beds monitoring plan, PDF page 18 describes checking for gaps in gage-height data and using backup logger data where available. A volunteer crew with a handheld meter may have only its handwritten notes. Before the next visit, use the observer and sampler briefing to name who keeps those notes and who can follow up on a sample.