SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=3275 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3275SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3030SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3275 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciurus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sciurus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='virginiana' OR species='virginiana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Didelphis' AND (species='virginiana' OR species='virginiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peromyscus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peromyscus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='latrans' OR species='latrans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canis' AND (species='latrans' OR species='latrans') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3275 The Ecological Register: Daniel Boone Field Station (riparian)
Daniel Boone Field Station (riparian)
Basic information
Sample name: Daniel Boone Field Station (riparian)

Reference: C. S. Cloyed, L. R. Cappelli, D. A. Tilson, J. A. Crawford, and A. I. Dell. 2018. Using camera traps to assess mammal and bird assemblages in a midwestern forest. Journal of Fish and Wildlife Management 9(2):496-506 [ER 3030]
Geography
Country: United States

State: Missouri


Coordinate: 38° 49' 10" N, 90° 51' 16" W
Coordinate basis: stated in text

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: unprotected

Substrate: ground surface

Habitat comments: "This 400-ha field station maintains an annually harvested, 6.5-ha hay field embedded within a 280-ha mixed deciduous forest dominated by black oak"

Methods
Life forms: carnivores,rodents,ungulates,other large mammals,other small mammals

Sampling methods: no design,automatic cameras

Sample size: 214 captures or sightings

Years: 2015

Days: 32

Seasons: summer

Nets or traps: 3

Cameras paired: yes

Sampling comments: "camera traps were used... along two 300-m transects... The first transect (termed agricultural) ran from the edge of the 6.5-ha hay field north into the surrounding upland forest, whereas the second transect (termed riparian) ran from a small wetland (~125 m2) east into the surrounding forest... We monitored each transect over a 32-d period (from 8 June to 10 July 2015). In total, we monitored 42 randomly determined locations (plots) along each transect, each for 48 or 72 h (depending on access to field site), with a total of 3 plots monitored simulta- neously on each transect... we positioned three infrared (IR) motion-sensor game cameras (Browning model BTC-5...)... We attached two of the cameras to the same tree, one 20 cm and the other 50 cm above the substrate, with both cameras pointing in the same direction; the third camera was placed 1–5 m away on a tree at 50 cm above the ground... We aimed all cameras parallel to the ground... In total, 18 cameras were deployed simultaneously, with 9 each on the agricultural and riparian transects... We considered images of the same species (or genus for Sciurus and Peromyscus) taken within 10 min of each other at the same plot as representing the same individual, unless this was obviously untrue"
18 "birds" are also reported

Metadata
Sample number: 3275

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-12 22:17:57

Modified: 2019-03-12 11:17:57

Abundance distribution
7 species
0 singletons
total count 214
extrapolated richness: 7.8
Fisher's α: 1.388
geometric series k: 0.5400
Hurlbert's PIE: 0.6302
Shannon's H: 1.3529
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sciurus spp.121
Odocoileus virginianus3875 kg herbivore
Didelphis virginiana192.2 kg insectivore-carnivore
Peromyscus spp.13
Procyon lotor145.5 kg carnivore-granivore
Dasypus novemcinctus64.4 kg invertivore
Canis latrans312 kg carnivore-insectivore