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=1338 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1338SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=893SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1338 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='awashensis' OR junior_species='awashensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastomys' AND (species='awashensis' OR species='awashensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastomys' AND (species='awashensis' OR species='awashensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='awashensis' OR junior_species='awashensis')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='Mastomys' AND (species='awashensis' OR species='awashensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='dembeensis' OR junior_species='dembeensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicanthis' AND (species='dembeensis' OR species='dembeensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicanthis' AND (species='dembeensis' OR species='dembeensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='dembeensis' OR junior_species='dembeensis')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='Arvicanthis' AND (species='dembeensis' OR species='dembeensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='spp.' OR junior_species='spp.')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='Acomys' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='olivieri' OR junior_species='olivierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='olivieri' OR species='olivierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='olivieri' OR species='olivierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='olivieri' OR junior_species='olivierii')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='Crocidura' AND (species='olivieri' OR species='olivierii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1338 The Ecological Register: Hagere Selam (low stone bund density)
Hagere Selam (low stone bund density)
Basic information
Sample name: Hagere Selam (low stone bund density)

Reference: Y. Meheretu, V. Sluydts, K. Welegerima, H. Bauer, M. Teferi, G. Yirga, L. Mulungu, M. Haile, J. Nyssen, J. Deckers, R. Makundi, and H. Leirs. 2014. Rodent abundance, stone bund density and its effects on crop damage in the Tigray highlands, Ethiopia. Crop Protection 55:61-67 [ER 893]
Geography
Country: Ethiopia


Coordinate: 13° 40' N, 39° 10' E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical savanna

Altered habitat: cropland

Substrate: ground surface

WMT: 19.0

CMT: 12.0

MAP: 762.0

Habitat comments: "four rainfed crop fields... The remaining native vegetation is largely dominated by Acacia etbaica (Schweinf.) and Euclea schimperi (A.DC.) Dandy"; the main crops were wheat, barley, and teff
CMT and WMT are based on Taye et al. (2013, Physical Geography)

Methods
Life forms: rodents,other small mammals

Sites: 2

Site length: 120

Site width: 60

Sampling methods: quadrat,baited,Sherman traps

Sample size: 487 individuals

Years: 2007 - 2011

Nets or traps: 98

Net or trap nights: 13818

Sampling comments: two "permanent square grids (60 x 60 m)... situated more than 200 m apart... Each grid consisted of seven parallel lines, 10 m apart, with trapping stations also 10 m apart (i.e. a total of 49 trapping stations per grid). Trapping was conducted with Sherman LFA live traps... baited with peanut butter"; there were 27,636 trap nights total across two treatments, so half are assumed to apply to this one

Metadata
Sample number: 1338

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-22 16:46:19

Modified: 2015-10-04 22:19:31

Abundance distribution
5 species
0 singletons
total count 487
extrapolated richness: 5.4
Fisher's α: 0.776
geometric series k: 0.3564
Hurlbert's PIE: 0.3852
Shannon's H: 0.7583
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
Mastomys awashensis372
Arvicanthis dembeensis82
Acomys spp.12
Mus (Nannomys) spp.15
Crocidura olivieri6