Field Research · Amphibian Migration · Conservation

Documenting Amphibian Road Crossings

A historical data analysis of spring amphibian patrol records, using R to organize field observations and examine species composition, recorded condition, and variation among road transects.

📍 Thomas Road / TCAMP records🗓️ Historical observations: 2008 & 2011🧭 R · Data visualization · GIS direction
Amphibian migrationRoad mortalityField dataConservation technology
Project overview

Turning patrol records into ecological information

Seasonal amphibian movements can bring salamanders, frogs, and toads across roads as they move between terrestrial habitat and breeding areas. Volunteer patrols document these crossings and record whether animals are found alive or dead. This project revisits historical patrol records to make the information easier to inspect, summarize, and use in future conservation work.

The analysis focuses on two distinct historical sources: an individual encounter log from Thomas Road in spring 2008 and a 2011 crossing workbook organized by transect and time interval. I cleaned the records into analysis-ready tables and used R to summarize species counts and recorded condition. The two years are presented separately because the collection formats and sampling structures differ.

Research scope: These records describe animals documented by patrols. They are not a standardized estimate of the total amphibian population, migration volume, or road mortality rate across the landscape.
Research direction

Research question & objectives

What do historical amphibian patrol records reveal about the species documented during spring road crossings, their recorded condition, and differences among surveyed transects?

01 · Organize

Convert legacy spreadsheets into tidy observation and count tables while preserving original labels and uncertain entries.

02 · Describe

Summarize species composition and recorded alive/dead condition within each source year.

03 · Compare carefully

Explore differences among 2011 transects and time intervals without assuming equal survey effort.

04 · Prepare for GIS

Identify which missing spatial and survey fields would be needed for future crossing-hotspot analysis.

Source material

Datasets and structure

319Individual encounter records · 2008
6Species / identification groups · 2008
643Individuals in 2011 workbook summary
5Named 2011 transects in summary
SourceOrganizationWhat it can support
Thomas Road · Spring 2008Individual encounter rows with date, observers, time, species label, condition code, and location notes.Species composition, recorded condition, and date-level summaries.
Amphibian Crossing · April 4, 2011Transect sheets and time-interval counts, including alive/dead tallies by species.Species totals, recorded condition, and descriptive transect comparisons.
2025 TCAMP patrol datasheetBlank field form with route, weather, start/end time and temperature, traffic tally, species tallies, movement direction, notes, and fields for coordinates of major crossings or sick individuals.Documents the intended contemporary collection fields; it is not a completed observation dataset.
Data & methods

Cleaning and analysis workflow

1

Inspect the source workbooks

Review sheet layouts, headers, species rows, transect names, date/time fields, and ambiguous entries before combining data.

2

Reshape into tidy records

Store 2008 as one row per individual encounter. Store 2011 as one row per species, status, transect, and time interval with a count field.

3

Preserve uncertainty

Keep unknown or unspecified identifications visible rather than forcing them into a known species. Retain notes about ambiguous counts.

4

Summarize in R

Calculate species totals, alive/dead tallies, and transect summaries, then create reproducible high-resolution charts.

5

Audit totals against source summaries

Compare the tidy record sums with the printed workbook totals and document differences rather than silently adjusting values.

Current results

What the records show

2008 · Thomas Road encounter log

The 319 encounter records span three dates: March 31 (126 records), April 4 (104), and April 11 (89). Spotted Salamander is the largest recorded group with 165 encounters (51.7%), followed by Spring Peeper with 91 (28.5%) and Eastern Newt (red eft) with 55 (17.2%). The remaining six records are distributed across American Toad (6), Plethodon salamander (1), and Unknown frog (1).

177Recorded alive · 55.5%
142Recorded dead · 44.5%
165Spotted Salamander encounters
3Survey dates represented

The alive/dead split is a description of this encounter log, not a mortality rate for the road or a population-level survival estimate. The records are individual entries, and the source does not provide a denominator for all animals that attempted to cross.

2011 · April 4 transect workbook

The workbook summary reports 643 individuals: 532 alive and 111 dead. The cleaned species/status rows also sum to 643, but classify 529 as alive, 112 as dead, and 2 as unknown/unspecified. The two records coded as unknown/unspecified are shown separately in the cleaned table; this explains why the status subtotals differ from the workbook's printed alive/dead summary.

Spring Peeper dominates the species-level tally with 490 individuals (76.2% of the cleaned 643 total), followed by Spotted Salamander (75; 11.7%) and Red-spotted Newt (65; 10.1%). All remaining named and unspecified categories account for 13 individuals combined.

Interpretation: The 2011 workbook provides a much more count-heavy record than the 2008 encounter log. The percentages describe the composition of these recorded patrol tallies; they should not be interpreted as a direct comparison of abundance between years.

2011 · Differences among transects

The workbook's summary lists 189 individuals for Barn to Stream, 165 for Stream to Curve Sign, 61 for Curve Sign to Culvert, 57 for Mound to White, and 171 for Extreme North. The cleaned detailed rows contain 169 records assigned to Extreme North plus 2 records marked Other / unspecified at the all-transects level. The workbook's summary total is 643. These values are retained as reported rather than assigning the two unallocated records to a specific transect.

Visual documentation

Figures & exploratory summaries

These figures are deliberately larger so labels, counts, and differences can be read comfortably on a portfolio page. Each figure uses the same forest-green and muted-sage palette as the related biodiversity research page.

Large horizontal bar chart of Thomas Road 2008 amphibian encounters by species
Figure 1. Thomas Road, spring 2008 — recorded encounters by species.Spotted Salamander accounts for just over half of the 319 individual encounter records. Spring Peeper and Eastern Newt (red eft) are the next most frequently recorded groups.
Stacked horizontal bar chart of alive and dead records by species in 2008
Figure 2. 2008 — recorded condition by species.The stacked bars separate records classified as alive and dead within each species group. These are encounter counts, not species-specific mortality rates based on standardized exposure.
Large horizontal bar chart of 2011 amphibian counts by species
Figure 3. April 4, 2011 — recorded counts by species.Spring Peeper is the dominant category in the workbook's detailed species tally, contributing 490 of 643 records.
Stacked horizontal bar chart of 2011 alive and dead counts by species
Figure 4. 2011 — recorded condition by species.Alive, dead, and unspecified records are displayed separately. The detailed tally contains 529 alive, 112 dead, and 2 unspecified records.
Horizontal bar chart comparing amphibian counts by 2011 transect
Figure 5. 2011 — workbook summary by transect.The values use the workbook's five-transect summary: 189, 165, 61, 57, and 171. Extreme North's detailed rows account for 169, with two additional unspecified records not assigned to an individual transect.
Critical evaluation

Data limitations & interpretation

!

Different recording units

The 2008 file contains individual encounter rows, while 2011 uses grouped counts by species, status, transect, and interval. Raw totals should not be compared as if they came from identical sampling protocols.

!

Uneven survey effort

The supplied records do not consistently provide route length, patrol duration, weather, traffic, or observer effort in a form that supports standardized rates across all records.

!

Uncertain and unspecified entries

Some species labels and counts are ambiguous. Unknown or unspecified records remain visible and are not silently assigned to a taxon or transect.

!

Limited geographic information

The historical spreadsheets supplied for this analysis do not contain consistent coordinates suitable for mapping individual crossings or producing a defensible hotspot map.

2025 field-form opportunity: The blank TCAMP datasheet includes fields for route length, weather, temperature, traffic tally, movement direction, and coordinates for major crossings or sick-looking individuals. Consistently recording these fields would make future spatial and effort-adjusted analyses much stronger.
Continuing the research

From historical records to spatial conservation tools

  1. Standardize future patrol data: use consistent species names, explicit zero versus missing values, route identifiers, start/end times, weather, and observer fields.
  2. Collect georeferenced crossings: record coordinates for individual observations or at least for crossing clusters, with a clear method for recording location accuracy.
  3. Calculate comparable rates: where effort data are available, examine observations per mile or per patrol-hour rather than comparing raw totals alone.
  4. Build a GIS database: connect patrol observations to road segments, wetlands, streams, land cover, and potential crossing structures.
  5. Identify priority locations: once repeated georeferenced surveys exist, examine spatial clusters and candidate sites for mitigation.

The longer-term goal is a repeatable conservation data workflow that connects volunteer field observations with R, GIS, and clear public-facing visualizations.