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=1260 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1260SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=882SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1260 ORDER BY register_no ASCSELECT 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='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicanthis' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')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='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmomys' AND (junior_species='harringtoni' OR junior_species='harringtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmomys' AND (species='harringtoni' OR species='harringtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmomys' AND (species='harringtoni' OR species='harringtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmomys' AND (junior_species='harringtoni' OR junior_species='harringtonii')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='Desmomys' AND (species='harringtoni' OR species='harringtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastomys' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastomys' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='natalensis' OR junior_species='natalensis')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='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='erythroleucus' OR junior_species='erythroleucus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastomys' AND (species='erythroleucus' OR species='erythroleucus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='erythroleucus' OR junior_species='erythroleucus')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='erythroleucus' OR species='erythroleucus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocephalemys' AND (junior_species='albipes' OR junior_species='albipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocephalemys' AND (species='albipes' OR species='albipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocephalemys' AND (species='albipes' OR species='albipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocephalemys' AND (junior_species='albipes' OR junior_species='albipes')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='Stenocephalemys' AND (species='albipes' OR species='albipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='cahirinus' OR junior_species='cahirinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='cahirinus' OR species='cahirinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='cahirinus' OR species='cahirinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='cahirinus' OR junior_species='cahirinus')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='cahirinus' OR species='cahirinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='wilsoni' OR junior_species='wilsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='wilsoni' OR species='wilsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='wilsoni' OR species='wilsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='wilsoni' OR junior_species='wilsonii')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='wilsoni' OR species='wilsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='cineraceus' OR junior_species='cineraceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='cineraceus' OR species='cineraceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='cineraceus' OR species='cineraceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='cineraceus' OR junior_species='cineraceus')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='cineraceus' OR species='cineraceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='robustus' OR junior_species='robustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerbilliscus' AND (species='robustus' OR species='robustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerbilliscus' AND (species='robustus' OR species='robustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='robustus' OR junior_species='robustus')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='Gerbilliscus' AND (species='robustus' OR species='robustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='validus' OR junior_species='validus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerbilliscus' AND (species='validus' OR species='validus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerbilliscus' AND (species='validus' OR species='validus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='validus' OR junior_species='validus')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='Gerbilliscus' AND (species='validus' OR species='validus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='phillipsi' OR junior_species='phillipsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerbilliscus' AND (species='phillipsi' OR species='phillipsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerbilliscus' AND (species='phillipsi' OR species='phillipsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='phillipsi' OR junior_species='phillipsii')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='Gerbilliscus' AND (species='phillipsi' OR species='phillipsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muridae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muridae' AND (junior_species='indet.' OR junior_species='indet.')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='Muridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muridae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muridae' AND (junior_species='indet.' OR junior_species='indet.')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='Muridae' AND (species='indet.' OR species='indet.') 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='Mus' AND (junior_species='tenellus' OR junior_species='tenellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='tenellus' OR species='tenellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='tenellus' OR species='tenellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='tenellus' OR junior_species='tenellus')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='tenellus' OR species='tenellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='flavescens' OR junior_species='flavescens')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='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='turba' OR junior_species='turba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='turba' OR species='turba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='turba' OR species='turba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='turba' OR junior_species='turba')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='turba' OR species='turba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='fumosa' OR junior_species='fumosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='fumosa' OR species='fumosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='fumosa' OR species='fumosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='fumosa' OR junior_species='fumosa')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='fumosa' OR species='fumosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='smithii' OR junior_species='smithi')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='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atelerix' AND (junior_species='albiventris' OR junior_species='albiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atelerix' AND (species='albiventris' OR species='albiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atelerix' AND (species='albiventris' OR species='albiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atelerix' AND (junior_species='albiventris' OR junior_species='albiventris')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='Atelerix' AND (species='albiventris' OR species='albiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxerus' AND (junior_species='erythropus' OR junior_species='erythropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxerus' AND (species='erythropus' OR species='erythropus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxerus' AND (species='erythropus' OR species='erythropus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxerus' AND (junior_species='erythropus' OR junior_species='erythropus')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='Euxerus' AND (species='erythropus' OR species='erythropus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1260 The Ecological Register: Alatish National Park (wooded grassland)
Alatish National Park (wooded grassland)
Basic information
Sample name: Alatish National Park (wooded grassland)

Reference: T. Habtamu and A. Bekele. 2008. Habitat association of insectivores and rodents of Alatish National Park, northwestern Ethiopia. Tropical Ecology 49(1):1-11 [ER 882]
Geography
Country: Ethiopia


Coordinate: 12° 12' N, 35° 34' E
Coordinate basis: stated in text

Geography comments: five sites scattered througout the northern half of the park
coordinate is the midpoint of those for the five sites
elevation 528 to 654 m

•
Environment
Habitat: tropical/subtropical savanna

Protection: national/state park

Substrate: ground surface

MAT: 27.0

MAP: 800.0

Habitat comments: "a tropical semi-arid zone" with "a low diversity of vegetation dominated by few species of deciduous trees... and few tall annual grasses"
MAP 600 to 1000; min 13.6 to 19.2, max 34.0 to 41.1 (grand mean 26.975)

Methods
Life forms: rodents,other small mammals

Sites: 5

Sampling methods: quadrat,baited,Sherman traps,hand capture

Sample size: 176 individuals

Years: 2004, 2005

Nets or traps: 250

Sampling comments: at each site there were 50 small, medium, and large Sherman traps spaced 10 m apart on a grid and baited with "peanut butter mixed with corn flour"; large rodents were caught with "local rodent snares" and "extreme trap shy rodents were excavated"

Metadata
Sample number: 1260

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-17 18:58:45

Modified: 2015-02-17 07:58:45

Abundance distribution
23 species
5 singletons
total count 176
extrapolated richness: 40.1
Fisher's α: 7.067
geometric series k: 0.8379
Hurlbert's PIE: 0.8439
Shannon's H: 2.3638
Good's u: 0.9720
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Arvicanthis dembeensis49
Arvicanthis niloticus4390.6 g
Desmomys harringtoni12
Mastomys natalensis10
Mastomys erythroleucus528.1 g
Stenocephalemys albipes6
Acomys cahirinus10
Acomys wilsoni5
Acomys cineraceus5
Acomys sp. A1
Gerbilliscus robustus2
"Tatera robusta"
Gerbilliscus validus2
"Tatera valida"
Gerbilliscus phillipsi3
"Tatera phillipsi"
Muridae indet. A1
Muridae indet. B2
Mus musculus117.6 g
Mus tenellus1
Crocidura flavescens7
Crocidura turba4
Crocidura fumosa2
Crocidura smithii2
"Crocidura smithi"
Atelerix albiventris2
Euxerus erythropus1