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=1919 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1919SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1722SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1919 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiops' AND (junior_species='swinhoei' OR junior_species='swinhoeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamiops' AND (species='swinhoei' OR species='swinhoeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tamiops' AND (species='swinhoei' OR species='swinhoeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiops' AND (junior_species='swinhoei' OR junior_species='swinhoeii')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='Tamiops' AND (species='swinhoei' OR species='swinhoeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogopterus' AND (junior_species='xanthipes' OR junior_species='xanthipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogopterus' AND (species='xanthipes' OR species='xanthipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogopterus' AND (species='xanthipes' OR species='xanthipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogopterus' AND (junior_species='xanthipes' OR junior_species='xanthipes')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='Trogopterus' AND (species='xanthipes' OR species='xanthipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niviventer' AND (junior_species='confucianus' OR junior_species='confucianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niviventer' AND (species='confucianus' OR species='confucianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niviventer' AND (junior_species='confucianus' OR junior_species='confucianus')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='Niviventer' AND (species='confucianus' OR species='confucianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')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='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='thibetana' OR junior_species='thibetana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotona' AND (species='thibetana' OR species='thibetana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='thibetana' OR species='thibetana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='thibetana' OR junior_species='thibetana')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='Ochotona' AND (species='thibetana' OR species='thibetana') 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='Ailuropoda' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ailuropoda' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuropoda' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')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='Ailuropoda' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')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='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctonyx' AND (junior_species='albogularis' OR junior_species='albogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctonyx' AND (species='albogularis' OR species='albogularis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctonyx' AND (junior_species='albogularis' OR junior_species='albogularis')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='Arctonyx' AND (species='albogularis' OR species='albogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')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='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='sibirica' OR junior_species='sibirica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='sibirica' OR species='sibirica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='sibirica' OR junior_species='sibirica')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='Mustela' AND (species='sibirica' OR species='sibirica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='altaica' OR junior_species='altaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='altaica' OR species='altaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustela' AND (species='altaica' OR species='altaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='altaica' OR junior_species='altaica')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='Mustela' AND (species='altaica' OR species='altaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paguma' AND (junior_species='larvata' OR junior_species='larvata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paguma' AND (species='larvata' OR species='larvata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paguma' AND (junior_species='larvata' OR junior_species='larvata')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='Paguma' AND (species='larvata' OR species='larvata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')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='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' AND (junior_species='berezovskii' OR junior_species='berezovski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moschus' AND (species='berezovskii' OR species='berezovski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moschus' AND (species='berezovskii' OR species='berezovski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' AND (junior_species='berezovskii' OR junior_species='berezovski')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='Moschus' AND (species='berezovskii' OR species='berezovski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Budorcas' AND (junior_species='taxicolor' OR junior_species='taxicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Budorcas' AND (species='taxicolor' OR species='taxicolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Budorcas' AND (junior_species='taxicolor' OR junior_species='taxicolor')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='Budorcas' AND (species='taxicolor' OR species='taxicolor') 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='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')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='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naemorhedus' AND (junior_species='goral' OR junior_species='goral')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naemorhedus' AND (species='goral' OR species='goral') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naemorhedus' AND (junior_species='goral' OR junior_species='goral')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='Naemorhedus' AND (species='goral' OR species='goral') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1919 The Ecological Register: Wanglang National Nature Reserve
Wanglang National Nature Reserve
Basic information
Sample name: Wanglang National Nature Reserve

Reference: S. Li, W. J. McShea, D. Wang, J. Huang, and L. Shao. 2012. A direct comparison of camera-trapping and sign transects for monitoring wildlife in the Wanglang National Nature Reserve, China. Wildlife Society Bulletin 36(3):538-545 [ER 1722]
Geography
Country: China

State: Sichuan


Coordinate: 32° 56' N, 104° 3' E
Coordinate basis: stated in text

Geography comments: "in northwest Sichuan Province"
elevation 2400 to 4980 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: nature reserve

Substrate: ground surface

MAT: 14.7

MAP: 867.0

Habitat comments: "Along an increasing elevation gradient, the major vegetation types are deciduous forest, conifer–deciduous mixed forest, conifer forest, subalpine scrub, and alpine meadow"
climate data are for the Wanglang National Nature Reserve and are from Xu et al. (2015, J. Mt. Sci.)

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

Site area: 11800

Sampling methods: no design,automatic cameras

Sample size: 226 captures or sightings

Years: 2004, 2005

Net or trap nights: 3793

Camera type: analog

Cameras paired: no

Sampling comments: surveying was "from September 2004 through October 2005. We divided the entire reserve into 1-km2 blocks... only 118 (of the original 131) forest blocks below tree-line could be included in this analysis. We placed one camera unit in each block for 1 month, and all sampling sites were separated from each other by >300 m. We used two models of passive infrared-triggered camera units: Ten DeerCamTM units... and 20 units locally manufactured... ISO 400 negative films were used... We set all the units to work 24 hours/day"

Metadata
Sample number: 1919

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-13 19:40:04

Modified: 2016-12-14 09:28:59

Abundance distribution
21 species
1 singleton
total count 226
extrapolated richness: 27.7
Fisher's α: 5.657
geometric series k: 0.8409
Hurlbert's PIE: 0.9129
Shannon's H: 2.6578
Good's u: 0.9957
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Tamiops swinhoei8
Trogopterus xanthipes7
Niviventer confucianus251.0 g granivore
Hystrix brachyura13
Ochotona thibetana5
Lepus oiostolus22.3 kg
Ailuropoda melanoleuca796 kg browser
Ursus thibetanus263 kg browser-frugivore
Arctonyx albogularis298.3 kg
"Arctonyx collaris"
Martes flavigula172.8 kg carnivore
Mustela sibirica32557 g carnivore-invertivore
Mustela altaica1 carnivore
Paguma larvata74.0 kg frugivore-carnivore
Prionailurus bengalensis173.4 kg carnivore
Sus scrofa354 kg herbivore
Elaphodus cephalophus1319 kg
Moschus berezovskii2
Budorcas taxicolor24237 kg browser
Pseudois nayaur333 kg grazer-browser
Capricornis sumatraensis28
"Capricornis milneedwardsii"
Naemorhedus goral425 kg