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=1153 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1153SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=806SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1153 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arizelocichla' AND (junior_species='masukuensis' OR junior_species='masukuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arizelocichla' AND (species='masukuensis' OR species='masukuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arizelocichla' AND (species='masukuensis' OR species='masukuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arizelocichla' AND (junior_species='masukuensis' OR junior_species='masukuensis')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='Arizelocichla' AND (species='masukuensis' OR species='masukuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='cabanisi' OR junior_species='cabanisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='cabanisi' OR species='cabanisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='cabanisi' OR species='cabanisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='cabanisi' OR junior_species='cabanisii')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='Phyllastrephus' AND (species='cabanisi' OR species='cabanisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonocichla' AND (junior_species='stellata' OR junior_species='stellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonocichla' AND (species='stellata' OR species='stellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonocichla' AND (species='stellata' OR species='stellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonocichla' AND (junior_species='stellata' OR junior_species='stellata')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='Pogonocichla' AND (species='stellata' OR species='stellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='fuelleborni' OR junior_species='fuellebornii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alethe' AND (species='fuelleborni' OR species='fuellebornii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alethe' AND (species='fuelleborni' OR species='fuellebornii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='fuelleborni' OR junior_species='fuellebornii')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='Alethe' AND (species='fuelleborni' OR species='fuellebornii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='gurneyi' OR junior_species='gurneyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoothera' AND (species='gurneyi' OR species='gurneyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoothera' AND (species='gurneyi' OR species='gurneyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='gurneyi' OR junior_species='gurneyii')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='Zoothera' AND (species='gurneyi' OR species='gurneyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Modulatrix' AND (junior_species='stictigula' OR junior_species='stictigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Modulatrix' AND (species='stictigula' OR species='stictigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Modulatrix' AND (species='stictigula' OR species='stictigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Modulatrix' AND (junior_species='stictigula' OR junior_species='stictigula')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='Modulatrix' AND (species='stictigula' OR species='stictigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='lopezi' OR junior_species='lopezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradypterus' AND (species='lopezi' OR species='lopezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradypterus' AND (species='lopezi' OR species='lopezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='lopezi' OR junior_species='lopezii')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='Bradypterus' AND (species='lopezi' OR species='lopezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='ruficapillus' OR junior_species='ruficapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='ruficapillus' OR species='ruficapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='ruficapillus' OR species='ruficapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='ruficapillus' OR junior_species='ruficapillus')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='Phylloscopus' AND (species='ruficapillus' OR species='ruficapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='metopias' OR junior_species='metopias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthotomus' AND (species='metopias' OR species='metopias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthotomus' AND (species='metopias' OR species='metopias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='metopias' OR junior_species='metopias')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='Orthotomus' AND (species='metopias' OR species='metopias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='thoracica' OR junior_species='thoracica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apalis' AND (species='thoracica' OR species='thoracica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalis' AND (species='thoracica' OR species='thoracica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='thoracica' OR junior_species='thoracica')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='Apalis' AND (species='thoracica' OR species='thoracica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='mixta' OR junior_species='mixta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Batis' AND (species='mixta' OR species='mixta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Batis' AND (species='mixta' OR species='mixta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='mixta' OR junior_species='mixta')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='Batis' AND (species='mixta' OR species='mixta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')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='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochocercus' AND (junior_species='albonotatus' OR junior_species='albonotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trochocercus' AND (species='albonotatus' OR species='albonotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trochocercus' AND (species='albonotatus' OR species='albonotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochocercus' AND (junior_species='albonotatus' OR junior_species='albonotatus')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='Trochocercus' AND (species='albonotatus' OR species='albonotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoalcippe' AND (junior_species='abyssinica' OR junior_species='abyssinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoalcippe' AND (junior_species='abyssinica' OR junior_species='abyssinica')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='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='loveridgei' OR junior_species='loveridgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='loveridgei' OR species='loveridgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='loveridgei' OR species='loveridgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='loveridgei' OR junior_species='loveridgeii')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='Cinnyris' AND (species='loveridgei' OR species='loveridgeii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1153 The Ecological Register: Uluguru South Forest Reserve Basecamp 3
Uluguru South Forest Reserve Basecamp 3
Basic information
Sample name: Uluguru South Forest Reserve Basecamp 3

Sample aka: Nyingwa

Reference: C. Bracebridge. 2005. Results of fauna. Uluguru Component Biodiversity Survey 2005 (Volume II): Uluguru South Forest Reserve 36-52 [ER 806]
Geography
Country: Tanzania


Coordinate: 7° 6' 30" S, 37° 40' 30" E
Coordinate basis: stated in text as range

Geography comments: "near top of pass to Lumba Juu from Lanzi"
coordinate is the midpoint of ranges stated in the text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

MAT: 18.5

MAP: 2500.0

Habitat comments: "bamboo zone, upper montane forest"
MAT is the mean of max and min ranges given in the text; MAP is a probable minimum

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 119 individuals

Sampling comments: no details of sampling effort are given

Metadata
Sample number: 1153

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-06 13:13:30

Modified: 2014-09-14 06:59:25

Abundance distribution
15 species
2 singletons
total count 119
extrapolated richness: 22.4
Fisher's α: 4.541
geometric series k: 0.7632
Hurlbert's PIE: 0.8166
Shannon's H: 2.1507
Good's u: 0.9835
Each square represents a species. Square sizes are proportional to counts.
Register