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=1952 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1952SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1750SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1952 ORDER BY register_no ASCSELECT 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='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='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='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')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='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1952 The Ecological Register: Capay
Capay
Basic information
Sample name: Capay

Reference: V. V. Derugin, J. G. Silveira, G. H. Golet, and G. LeBuhn. 2016. Response of medium- and large-sized terrestrial fauna to corridor restoration along the middle Sacramento River. Restoration Ecology 24(1):128-136 [ER 1750]
Geography
Country: United States

State: California


Coordinate: 38° 42' N, 122° 3' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate is based on Capay

•
Environment
Habitat: Mediterranean woodland

Substrate: ground surface

WMT: 25.3

CMT: 7.3

MAP: 484.0

Habitat comments: "The region occurs in a Mediterranean climate"; the habitat was "restored in 2003–2007" and consists of "native riparian forests"
climate data are apparently interpolated from data for Winters and Lake Berryessa and are from Major and Pyott (1966, Vegetatio)

Methods
Life forms: carnivores,ungulates

Sites: 1

Sampling methods: no design,baited,automatic cameras

Sample size: 52 captures or sightings

Years: 2010 - 2012

Nets or traps: 1

Net or trap nights: 165

Camera type: digital

Cameras paired: no

Sampling comments: "One camera was placed at each site near animal sign... The study spanned both cool (31 December–8 March) and warm (23 May–5 July) time periods over two consecutive years (2010–2012). We used three types of camera traps to detect mammals: Bushnell Trophy Cam... Moultrie Game Spy I45... Wildview EZ-Cam... all cameras were visited for general maintenance every 1 – 1.5 months... We mounted cameras approximately 2.1 m off the ground on trees... we applied Caven’s “Gusto” scent lure... mixed with tuna to a tree or large bush near each camera, to enhance trap effectiveness"
the entire study used 16 cameras and there were 2641 camera days in total, so the average of 165 is used

Metadata
Sample number: 1952

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-20 13:24:30

Modified: 2016-12-15 08:07:12

Abundance distribution
4 species
0 singletons
total count 52
extrapolated richness: 5.2
Fisher's α: 1.010
geometric series k: 0.3684
Hurlbert's PIE: 0.3756
Shannon's H: 0.7736
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
Procyon lotor45.5 kg carnivore-granivore
Canis latrans612 kg carnivore-insectivore
Lynx rufus29.0 kg carnivore
"Felis rufus"
Odocoileus hemionus columbianus4065 kg browser