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=3291 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3291SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3041SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3291 ORDER BY register_no ASCSELECT 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='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='Bos' AND (species='taurus' OR species='taurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meleagris' AND (species='gallopavo' OR species='gallopavo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')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='Meleagris' AND (species='gallopavo' OR species='gallopavo') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='niger' OR junior_species='niger')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='niger' OR species='niger') 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='Lynx' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')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='Lynx' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')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='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3291 The Ecological Register: Blue Grass Army Depot
Blue Grass Army Depot
Basic information
Sample name: Blue Grass Army Depot

Reference: T. W. Morgan and C. L. Elliott. 2011. Comparison of remotely-triggered cameras vs. howling surveys for estimating coyote (Canis latrans) abundance in central Kentucky. Journal of the Kentucky Academy of Science 72(2):84-90 [ER 3041]
Geography
Country: United States

State: Kentucky


Coordinate: 37.68° N, -84.25° W
Coordinate basis: based on nearby landmark

Geography comments: "a 59,076 ha tract of federally-owned land located 11 km south-southeast of Richmond" (coordinate based on Blue Grass Army Depot)

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: pasture

Protection: unprotected

Substrate: ground surface

Habitat comments: "mainly open fields and forested woodlots that range in size from 1 to 50 ha... a multiple-use military installation which incorporates grazing, hay production, silviculture, and management of wildlife resources"

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

Focal species: Canis latrans

Sampling methods: no design,baited,automatic cameras

Sample size: 1729 captures or sightings

Years: 2007, 2008

Net or trap nights: 3234

Camera type: digital

Cameras paired: no

Trap spacing: 1.5

Sampling comments: "Ten remotely-triggered digital cameras (Game Spy 200...) were deployed from May 2007 to May 2008... cameras were placed ≥1.5 km apart to minimize the possibility of double sampling" of coyotes and "We attached cameras... approximately 40 cm above the ground... we employed the use of a scent attractant... From 9 May 2007 to 14 May 2008, a total of 3234 camera-trap nights were accumulated"
counts are of photographs, not events

Metadata
Sample number: 3291

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-21 21:31:37

Modified: 2019-03-21 10:31:37

Abundance distribution
8 species
1 singleton
total count 1729
extrapolated richness: 11.6
Fisher's α: 1.085
geometric series k: 0.3695
Hurlbert's PIE: 0.5195
Shannon's H: 0.8923
Good's u: 0.9994
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Odocoileus virginianus106475 kg herbivore
Bos taurus540337 kg
Meleagris gallopavo1097.8 kg omnivore
Canis latrans812 kg carnivore-insectivore
Sciurus niger3750 g
Procyon lotor25.5 kg carnivore-granivore
Lynx rufus19.0 kg carnivore
Sylvilagus floridanus21.1 kg herbivore