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=1259 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1259SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=881SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1259 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='sinalis' OR junior_species='sinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='sinalis' OR species='sinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='sinalis' OR species='sinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='sinalis' OR junior_species='sinalis')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='Sorex' AND (species='sinalis' OR species='sinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eozapus' AND (junior_species='setchuanus' OR junior_species='setchuanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eozapus' AND (species='setchuanus' OR species='setchuanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eozapus' AND (species='setchuanus' OR species='setchuanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eozapus' AND (junior_species='setchuanus' OR junior_species='setchuanus')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='Eozapus' AND (species='setchuanus' OR species='setchuanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='limnophilus' OR junior_species='limnophilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='limnophilus' OR species='limnophilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alexandromys' AND (species='limnophilus' OR species='limnophilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='limnophilus' OR junior_species='limnophilus')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='Alexandromys' AND (species='limnophilus' OR species='limnophilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetulus' AND (junior_species='longicaudatus' OR junior_species='longicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetulus' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cricetulus' AND (species='longicaudatus' OR species='longicaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetulus' AND (junior_species='longicaudatus' OR junior_species='longicaudatus')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='Cricetulus' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tscherskia' AND (junior_species='triton' OR junior_species='triton')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tscherskia' AND (species='triton' OR species='triton') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tscherskia' AND (species='triton' OR species='triton')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tscherskia' AND (junior_species='triton' OR junior_species='triton')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='Tscherskia' AND (species='triton' OR species='triton') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='agrarius' OR junior_species='agrarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='agrarius' OR species='agrarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='agrarius' OR species='agrarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='agrarius' OR junior_species='agrarius')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='Apodemus' AND (species='agrarius' OR species='agrarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='draco' OR junior_species='draco')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='draco' OR species='draco') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='draco' OR junior_species='draco')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='Apodemus' AND (species='draco' OR species='draco') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='peninsulae' OR junior_species='peninsulae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='peninsulae' OR species='peninsulae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='peninsulae' OR species='peninsulae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='peninsulae' OR junior_species='peninsulae')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='Apodemus' AND (species='peninsulae' OR species='peninsulae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')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='Mus' AND (species='musculus' OR species='musculus') 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='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 * FROM register WHERE sample_no=1259 The Ecological Register: Zhang County
Zhang County
Basic information
Sample name: Zhang County

Reference: P. Giraudoux, J.-P. Quéré, P. Delattre, G. Bao, X. Wang, D. Shi, D. Vuitton, and P. S. Craig. 1998. Distribution of small mammals along a deforestation gradient in southern Gansu, central China. Acta Theriologica 43(4):349-362 [ER 881]
Geography
Country: China

State: Gansu


Coordinate: 34° 33' N, 104° 30' E
Coordinate basis: stated in text

Geography comments: three communes "in the south of Zhang County" (coordinate is the midpoint of three stated values)
elevation 2300 to 2500 m

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

WMT: 20.0

CMT: -6.7

MAP: 375.0

Habitat comments: climate data are for Zhang City
there are six habitat types in the study area and trapping was across a gradient ranging from "forest to ploughed fields"

Methods
Life forms: rodents,other small mammals

Sampling methods: line transect,cage traps,snap traps

Sample size: 196 individuals

Years: 1994, 1995, 1996

Sampling comments: most sampling was done in July 1996 using 77 lines of INRA live traps and "small break-back traps"; bait was "a mixture of flour, oil, and water"

Metadata
Sample number: 1259

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-17 17:27:07

Modified: 2015-02-17 06:27:07

Abundance distribution
11 species
3 singletons
total count 196
extrapolated richness: 17.1
Fisher's α: 2.519
geometric series k: 0.6577
Hurlbert's PIE: 0.8017
Shannon's H: 1.8400
Good's u: 0.9847
Each square represents a species. Square sizes are proportional to counts.
Register