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=2833 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2833SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2522SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2833 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liomys' AND (junior_species='irroratus' OR junior_species='irroratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liomys' AND (species='irroratus' OR species='irroratus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liomys' AND (junior_species='irroratus' OR junior_species='irroratus')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='Liomys' AND (species='irroratus' OR species='irroratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='difficilis' OR junior_species='difficilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='difficilis' OR species='difficilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='difficilis' OR junior_species='difficilis')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='Peromyscus' AND (species='difficilis' OR species='difficilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='levipes' OR junior_species='levipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='levipes' OR species='levipes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='levipes' OR junior_species='levipes')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='Peromyscus' AND (species='levipes' OR species='levipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='maniculatus' OR species='maniculatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')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='Peromyscus' AND (species='maniculatus' OR species='maniculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='melanotis' OR junior_species='melanotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='melanotis' OR species='melanotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='melanotis' OR junior_species='melanotis')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='Peromyscus' AND (species='melanotis' OR species='melanotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Peromyscus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reithrodontomys' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')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='Reithrodontomys' AND (species='megalotis' OR species='megalotis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2833 The Ecological Register: Libres-Oriental Valley (natural vegetation)
Libres-Oriental Valley (natural vegetation)
Basic information
Sample name: Libres-Oriental Valley (natural vegetation)

Reference: L. Jiménez-García, G. Sánchez-Rojas, O. Villarreal, H. Bernal, and D. Jiménez-García. 2014. Agroecosystems management and biodiversity loss in an intensification gradient in traditional agriculture in Mexico. American-Eurasian Journal of Agricultural & Environmental Sciences 14(5):407-420 [ER 2522]
Geography
Country: Mexico

State: Puebla


Coordinate: 19° 28' N, 97° 41' W
Coordinate basis: based on political unit

Geography comments: coordinate is based on the municipality of Libres

•
Environment
Habitat: tropical/subtropical coniferous forest

Substrate: ground surface

MAT: 14.0

MAP: 590.0

Habitat comments: "a semidry and mild temperate climate... the rainy season spanding from the months of April to October, with August and September being the rainiest months, with maximum measurements of 50 to 140 mm"
the "natural area" is "composed of coniferous forest, pinus and tazcate forest"

Methods
Life forms: rodents

Sampling methods: baited,Sherman traps

Sample size: 91 individuals

Years: 2013

Seasons: dry,wet or monsoon

Nets or traps: 41

Net or trap nights: 1640

Sampling comments: there were "five sampling sites... with four replicas of each of the five sampling sites during the dry season (February, March and May 2013) and rainy (August, September and October, 2013)... all sites were sampled during 2 consecutive days. A total of 41 traps were placed at each site in the form of asterisk with five traps for each of the lines that make up the asterisk [60] each one of the traps was separated five meters apart. 1640 Sherman traps were baited with a mixture of oats, vanilla extract and peanut butter"

Metadata
Sample number: 2833

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-12-01 19:28:51

Modified: 2017-12-01 08:28:51

Abundance distribution
7 species
0 singletons
total count 91
extrapolated richness: 8.1
Fisher's α: 1.767
geometric series k: 0.6776
Hurlbert's PIE: 0.7872
Shannon's H: 1.7170
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Liomys irroratus1444.9 g
Peromyscus difficilis1028.6 g
Peromyscus levipes425.9 g
Peromyscus maniculatus3119.1 g
Peromyscus melanotis1919.4 g
Peromyscus mexicanus1041.3 g
Reithrodontomys megalotis310.3 g