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=1194 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1194SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=843SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1194 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')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='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammomys' AND (junior_species='dolichurus' OR junior_species='dolichurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammomys' AND (species='dolichurus' OR species='dolichurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammomys' AND (species='dolichurus' OR species='dolichurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammomys' AND (junior_species='dolichurus' OR junior_species='dolichurus')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='Grammomys' AND (species='dolichurus' OR species='dolichurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beamys' AND (junior_species='hindei' OR junior_species='hindeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beamys' AND (species='hindei' OR species='hindeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beamys' AND (species='hindei' OR species='hindeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beamys' AND (junior_species='hindei' OR junior_species='hindeii')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='Beamys' AND (species='hindei' OR species='hindeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')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='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphiurus' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphiurus' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphiurus' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphiurus' AND (junior_species='murinus' OR junior_species='murinus')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='Graphiurus' AND (species='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='rattus' OR species='rattus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')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='Rattus' AND (species='rattus' OR species='rattus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='hirta' OR junior_species='hirta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='hirta' OR species='hirta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='hirta' OR species='hirta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='hirta' OR junior_species='hirta')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='hirta' OR species='hirta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1194 The Ecological Register: Zaraninge Forest (dry season)
Zaraninge Forest (dry season)
Basic information
Sample name: Zaraninge Forest (dry season)

Reference: H. Y. D. Kiwia. 2006. Species richness and abundance estimates of small mammals in Zaraninge Coastal Forest in Tanzania. Tanzania Journal of Science 32(2):51-60 [ER 843]
Geography
Country: Tanzania


Coordinate: 6° 8' 30" S, 38° 38' 30" E
Coordinate basis: stated in text as range

Geography comments: coordinate based on midpoint of ranges stated in text
elevation 0 to 300 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAP: 1150.0

Habitat comments: "Zaraninge Dry Evergreen Coastal Forest" with "short rains... between October and December and long rains... between April and June"; MAP 900 to 1400
commercially logged "between 1950s and 1980s" but logging ended in 1985

Methods
Life forms: rodents,other small mammals

Sampling methods: line transect,Sherman traps,snap traps,Tomahawk traps

Sample size: 159 individuals

Years: 1994 - 1996

Days: 57

Seasons: dry

Nets or traps: 121

Net or trap nights: 6897

Sampling comments: ten "1 m line transects" each sampled with 62 snap traps, 40 Sherman traps, and 18 to 20 Tomahawk traps; stations were separated by 5 m and included one trap each, and trapping was done over 57 days

Metadata
Sample number: 1194

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-13 16:34:43

Modified: 2015-02-13 09:06:47

Abundance distribution
7 species
2 singletons
total count 159
extrapolated richness: 10.2
Fisher's α: 1.497
geometric series k: 0.4950
Hurlbert's PIE: 0.7298
Shannon's H: 1.5015
Good's u: 0.9874
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cricetomys gambianus291.4 kg frugivore-granivore
Grammomys dolichurus68
Beamys hindei29
Petrodromus tetradactylus16
Graphiurus murinus15
Rattus rattus1121 g
Crocidura hirta1