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=1961 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1961SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1757SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1961 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='uncia' OR junior_species='uncia')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='uncia' OR species='uncia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='uncia' OR junior_species='uncia')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Panthera' AND (species='uncia' OR species='uncia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')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='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='picticaudata' OR junior_species='picticaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procapra' AND (species='picticaudata' OR species='picticaudata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='picticaudata' OR junior_species='picticaudata')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='Procapra' AND (species='picticaudata' OR species='picticaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='ammon' OR junior_species='ammon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='ammon' OR species='ammon') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='ammon' OR junior_species='ammon')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='Ovis' AND (species='ammon' OR species='ammon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='hanglu' OR junior_species='hanglu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='hanglu' OR species='hanglu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervus' AND (species='hanglu' OR species='hanglu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='hanglu' OR junior_species='hanglu')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='Cervus' AND (species='hanglu' OR species='hanglu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='albirostris' OR species='albirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervus' AND (species='albirostris' OR species='albirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cervus' AND (species='albirostris' OR species='albirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='ferrilata' OR junior_species='ferrilata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='ferrilata' OR species='ferrilata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='ferrilata' OR junior_species='ferrilata')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='Vulpes' AND (species='ferrilata' OR species='ferrilata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='oiostolus' OR junior_species='oiostolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='oiostolus' OR species='oiostolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='oiostolus' OR junior_species='oiostolus')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='Lepus' AND (species='oiostolus' OR species='oiostolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='lupus' OR species='lupus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1961
Reference:A. Xu, Z. Jiang, C. Li, J. Guo, S. Da, Q. Cui, S. Yu, and G. Wu. 2008. Status and conservation of the snow leopard Panthera uncia in the Gouli Region, Kunlun Mountains, China. Oryx42(3):460-463 [ER 1757]
Geography
Country: China
State: Qinghai
Coordinate:36° 18' N, 98° 5' E
Coordinate basis: based on nearby landmark
Geography comments: "in the south of Dulan County, Qinghai Province... a part of East Burhanbuda Mountain in the Kunlun Mountains" (coordinate based on Dulan County)
altitude 4000 to 4700 m
•
Environment
Habitat: montane grassland
Substrate: ground surface
MAT: 3.5
WMT: 15.2
CMT: -9.4
MAP: 218.0
Habitat comments: "The climate is typical continental, characterized by dry, cold winters, frequent strong winds, strong solar radiation, and a short frost-free period. Dominant vegetation is alpine meadow and steppe"
climate data are for Dulan and are from Yin et al. (2016, Trees)
Methods
Life forms: carnivores,ungulates,other small mammals
Focal species: Panthera uncia
Sampling methods: no design,automatic cameras
Sample size: 1667 captures or sightings
Years: 2006
Days: 76
Nets or traps: 6
Camera type: unclear
Cameras paired: unclear
Sampling comments: "During 1 March–15 May 2006 we conducted an extensive field survey... We used 10 auto-triggered cameras of which only six functioned" (trap nights not stated and it is not 100% clear that cameras were in operation throughout the survey, but this is assumed)
Metadata
Sample number: 1961
Contributor: John Alroy
Enterer: John Alroy
Created: 2016-01-20 21:00:18
Modified: 2016-12-15 10:20:07
Abundance distribution
9 species
1 singleton
total count 1667
extrapolated richness: 10.6
Fisher's α: 1.251
geometric series k: 0.4055
Hurlbert's PIE: 0.3148
Shannon's H: 0.7340
Good's u: 0.9994
Each square represents a species. Square sizes are proportional to counts.