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=3247 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3247SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3016SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3247 ORDER BY register_no ASCSELECT 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='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='Sylvilagus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvilagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitis' AND (junior_species='macroura' OR junior_species='macroura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mephitis' AND (species='macroura' OR species='macroura') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitis' AND (junior_species='macroura' OR junior_species='macroura')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='Mephitis' AND (species='macroura' OR species='macroura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='leuconotus' OR junior_species='leuconotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conepatus' AND (species='leuconotus' OR species='leuconotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conepatus' AND (species='leuconotus' OR species='leuconotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='leuconotus' OR junior_species='leuconotus')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='Conepatus' AND (species='leuconotus' OR species='leuconotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='semistriatus' OR junior_species='semistriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conepatus' AND (species='semistriatus' OR species='semistriatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conepatus' AND (junior_species='semistriatus' OR junior_species='semistriatus')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='Conepatus' AND (species='semistriatus' OR species='semistriatus') 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='Sciurus' AND (junior_species='oculatus' OR junior_species='oculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='oculatus' OR species='oculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciurus' AND (species='oculatus' OR species='oculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='oculatus' OR junior_species='oculatus')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='oculatus' OR species='oculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='aureogaster' OR junior_species='aureogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='aureogaster' OR species='aureogaster') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='aureogaster' OR junior_species='aureogaster')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='aureogaster' OR species='aureogaster') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3247
The Ecological Register: Pico de Orizaba National Park
Reference:R. Serna-Lagunes, L. R. Alvarez-Oseguera, D. M. Avila-Nájera, O. R. Leyva-Ovalle, P. Andrés-Meza, and B. Tigar. 2019. Temporal overlap in the activity of Lynx rufus and Canis latrans and their potential prey in the Pico de Orizaba National Park, Mexico. Animal Biodiversity and Conservation42(1):153-161 [ER 3016]
Geography
Country: Mexico
State: Puebla
Coordinate:19° 3' N, 97° 17' W
Coordinate basis: estimated from map
Geography comments: "This park consists of 19,756 ha in the Tlachichuca, Chalchicomula de Sesma and Atzitzintla municipalities in Puebla State, and the Chalcahualco and La Perla municipalities in Veracruz State"
•
Environment
Habitat: montane grassland
Protection: national/state park
Substrate: ground surface
Disturbance: grazing,selective logging
Habitat comments: "at risk of overgrazing by livestock, forest fires, and deforestation due to illegal logging"
map indicates that traps were in the "subalpine vegetation" zone (above "pine forest" and below "mountain scrub") from 3000 to 4000 m
Methods
Life forms: carnivores,rodents,other large mammals,other small mammals
Sampling methods: no design,automatic cameras
Sample size: 190 captures or sightings
Nets or traps: 14
Net or trap nights: 5110
Camera type: digital
Trap spacing: 2
Sampling comments: "Fourteen passive infrared sensor cameras (Cuddeback 1231 and Black Flash E3®) were sited in areas where mammals had been seen in a pilot study... with a distance between 1–3 km one from another. The cameras operated 24 h/day for 12 months (January–December 2017). They were placed 40 cm above ground level on tree trunks"
28 indeterminate rodents were also photographed
Metadata
Sample number: 3247
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-03-08 21:19:50
Modified: 2019-03-08 10:20:33
Abundance distribution
9 species
1 singleton
total count 190
extrapolated richness: 11.4
Fisher's α: 1.964
geometric series k: 0.6214
Hurlbert's PIE: 0.8213
Shannon's H: 1.8400
Good's u: 0.9947
Each square represents a species. Square sizes are proportional to counts.