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
Huangshan Mountain Scenic Area
Basic information
Sample name: 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 Science 25(8):896-903 [ER 3020]
Geography
Country: China

State: Anhui


Coordinate: 30° 9' 30" N, 118° 9' 0" E
Coordinate basis: stated in text as range

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: other protected area

Substrate: ground surface

MAT: 15.8

MAP: 1450.0

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.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Callosciurus erythraeus42366 g frugivore
Tamiops maritimus3
Hystrix brachyura hodgsoni6
"Hystrix hodgsoni"
Prionailurus bengalensis23.4 kg carnivore
Martes flavigula72.8 kg carnivore
Mustela sibirica4557 g carnivore-invertivore
Arctonyx albogularis218.3 kg
"Arctonyx collaris"
Paguma larvata204.0 kg frugivore-carnivore
Sus scrofa5154 kg herbivore
Muntiacus reevesi16011 kg browser
Muntiacus crinifrons2224 kg
Capricornis sumatraensis1
"Capricornis milneedwardsii"
Macaca mulatta58.0 kg folivore-frugivore
Macaca thibetana13015 kg