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=3254 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3254SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3020SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3254 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='erythraeus' OR junior_species='erythraeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callosciurus' AND (species='erythraeus' OR species='erythraeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='erythraeus' OR junior_species='erythraeus')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='Callosciurus' AND (species='erythraeus' OR species='erythraeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiops' AND (junior_species='maritimus' OR junior_species='maritimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamiops' AND (species='maritimus' OR species='maritimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tamiops' AND (species='maritimus' OR species='maritimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiops' AND (junior_species='maritimus' OR junior_species='maritimus')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='maritimus' OR species='maritimus') 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='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='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='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='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='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='Muntiacus' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='reevesi' OR species='reevesii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='reevesi' OR junior_species='reevesii')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='Muntiacus' AND (species='reevesi' OR species='reevesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='crinifrons' OR junior_species='crinifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='crinifrons' OR species='crinifrons') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='crinifrons' OR junior_species='crinifrons')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='Muntiacus' AND (species='crinifrons' OR species='crinifrons') 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='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='mulatta' OR species='mulatta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')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='Macaca' AND (species='mulatta' OR species='mulatta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' 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='Macaca' AND (species='thibetana' OR species='thibetana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' 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='Macaca' AND (species='thibetana' OR species='thibetana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3254
The Ecological Register: Huangshan Mountain Scenic Area
Reference:K. Liu, J. He, J. Zhang, J. Feng, Q. Yu, C. Gu, and H. Wu. 2017. Mammal resource status in the mountain forest ecosystems of southern Anhui Province based on camera trap data. Biodiversity Science25(8):896-903 [ER 3020]
Habitat comments: mostly subtropical evergreen and deciduous broad-leaved forest
subtropical humid monsoon climate with MAP 1200 to 1700 mm and MAT 15.4 to 16.3 ÂșC in the general area
Methods
Life forms: carnivores,primates,rodents,ungulates
Sampling methods: quadrat,automatic cameras
Sample size: 474 captures or sightings
Years: 2015
Nets or traps: 36
Net or trap nights: 2019
Camera type: digital
Cameras paired: unclear
Trap spacing: 1
Sampling comments: surveyed from May to October 2015
cameras were placed on a 1 x 1 km grid at lesat 300 m apart at a height of 0.3 to 0.4 m
Ltl-6210MC digital cameras were used
photos were considered independent if 30 minutes apart
474 photos were counted; counts are given as a percentage of this total
Metadata
Sample number: 3254
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-03-09 20:44:51
Modified: 2019-03-09 09:47:48
Abundance distribution
14 species
1 singleton
total count 474
extrapolated richness: 17.5
Fisher's α: 2.707
geometric series k: 0.6768
Hurlbert's PIE: 0.7844
Shannon's H: 1.8641
Good's u: 0.9979
Each square represents a species. Square sizes are proportional to counts.