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=1051 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1051SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=726SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1051 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanomitra' AND (species='olivacea' OR species='olivacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanomitra' AND (species='olivacea' OR species='olivacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='olivacea' OR junior_species='olivacea')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='Cyanomitra' AND (species='olivacea' OR species='olivacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='virens' OR junior_species='virens')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='Andropadus' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT 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='Cryptospiza' AND (junior_species='reichenovii' OR junior_species='reichenovi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptospiza' AND (species='reichenovii' OR species='reichenovi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptospiza' AND (species='reichenovii' OR species='reichenovi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptospiza' AND (junior_species='reichenovii' OR junior_species='reichenovi')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='Cryptospiza' AND (species='reichenovii' OR species='reichenovi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='milanjensis' OR junior_species='milanjensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='milanjensis' OR species='milanjensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='milanjensis' OR species='milanjensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='milanjensis' OR junior_species='milanjensis')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='Andropadus' AND (species='milanjensis' OR species='milanjensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='barratti' OR junior_species='barrattii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradypterus' AND (species='barratti' OR species='barrattii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradypterus' AND (species='barratti' OR species='barrattii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='barratti' OR junior_species='barrattii')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='barratti' OR species='barrattii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='flavostriatus' OR junior_species='flavostriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='flavostriatus' OR species='flavostriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='flavostriatus' OR species='flavostriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='flavostriatus' OR junior_species='flavostriatus')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='flavostriatus' OR species='flavostriatus') 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='Trichastoma' AND (junior_species='rufipennis' OR junior_species='rufipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichastoma' AND (species='rufipennis' OR species='rufipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichastoma' AND (species='rufipennis' OR species='rufipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichastoma' AND (junior_species='rufipennis' OR junior_species='rufipennis')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='Trichastoma' AND (species='rufipennis' OR species='rufipennis') 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='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='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='tympanistria' OR species='tympanistria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')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='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='placidus' OR junior_species='placidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='placidus' OR species='placidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='placidus' OR species='placidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='placidus' OR junior_species='placidus')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='placidus' OR species='placidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandingoa' AND (junior_species='nitidula' OR junior_species='nitidula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mandingoa' AND (species='nitidula' OR species='nitidula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mandingoa' AND (species='nitidula' OR species='nitidula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandingoa' AND (junior_species='nitidula' OR junior_species='nitidula')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='Mandingoa' AND (species='nitidula' OR species='nitidula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smithornis' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smithornis' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' AND (junior_species='capensis' OR junior_species='capensis')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='Smithornis' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplopelia' AND (junior_species='larvata' OR junior_species='larvata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aplopelia' AND (species='larvata' OR species='larvata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aplopelia' AND (species='larvata' OR species='larvata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplopelia' AND (junior_species='larvata' OR junior_species='larvata')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='Aplopelia' AND (species='larvata' OR species='larvata') 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='Turdus' 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='Turdus' AND (species='gurneyi' OR species='gurneyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='gurneyi' OR species='gurneyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' 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='Turdus' AND (species='gurneyi' OR species='gurneyii') 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='Phyllastrephus' AND (junior_species='debilis' OR junior_species='debilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='debilis' OR species='debilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='debilis' OR species='debilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='debilis' OR junior_species='debilis')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='debilis' OR species='debilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sheppardia' AND (junior_species='sharpei' OR junior_species='sharpeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sheppardia' AND (species='sharpei' OR species='sharpeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sheppardia' AND (species='sharpei' OR species='sharpeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sheppardia' AND (junior_species='sharpei' OR junior_species='sharpeii')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='Sheppardia' AND (species='sharpei' OR species='sharpeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophaga' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophaga' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')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='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='abyssinicus' OR junior_species='abyssinicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='abyssinicus' OR species='abyssinicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='abyssinicus' OR species='abyssinicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='abyssinicus' OR junior_species='abyssinicus')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='Turdus' AND (species='abyssinicus' OR species='abyssinicus') 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='Modulatrix' AND (junior_species='orostruthus' OR junior_species='orostruthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Modulatrix' AND (species='orostruthus' OR species='orostruthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Modulatrix' AND (species='orostruthus' OR species='orostruthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Modulatrix' AND (junior_species='orostruthus' OR junior_species='orostruthus')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='orostruthus' OR species='orostruthus') 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 * FROM register WHERE sample_no=1051 The Ecological Register: Amani Site 10
Amani Site 10
Basic information
Sample name: Amani Site 10

Reference: W. D. Newmark. 1991. Tropical forest fragmentation and the local extinction of understory birds in the Eastern Usambara Mountains, Tanzania. Conservation Biology 5(1):67-78 [ER 726]
Geography
Country: Tanzania


Coordinate: 5° 5' S, 38° 40' E
Coordinate basis: based on nearby landmark

Geography comments: "on common land contiguous with the Amani West Forest Reserve to the west of Amani" (coordinate based on Amani Nature Reserve)
elevation 915 to 1030 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 20.6

MAP: 1919.0

Habitat comments: 571 ha forest area (certainly not a fragment)
climate data based on Hochkirch (1996)

Methods
Life forms: birds

Sites: 1

Sampling methods: mist nets

Sample size: 539 individuals

Years: 1987 - 1989

Nets or traps: 102

Sampling comments: "four lines of [12 m] nets consisting of 32, 16, 37, and 17 nets" (number of sampling days unclear)

Metadata
Sample number: 1051

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-17 20:57:54

Modified: 2015-02-23 23:50:33

Abundance distribution
26 species
4 singletons
total count 539
extrapolated richness: 34.8
Fisher's α: 5.703
geometric series k: 0.8353
Hurlbert's PIE: 0.9159
Shannon's H: 2.7517
Good's u: 0.9926
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cyanomitra olivacea902.8 g insectivore-nectarivore
"Nectarinia olivacea"
Andropadus virens535.0 g frugivore-granivore
Arizelocichla masukuensis76 frugivore-insectivore
"Andropadus masukuensis"
Cryptospiza reichenovii1012.4 g omnivore
Andropadus milanjensis1938.5 g
Bradypterus barratti1518.8 g insectivore
Phyllastrephus flavostriatus1631.8 g insectivore-frugivore
Pogonocichla stellata118.6 g insectivore-frugivore
Trichastoma rufipennis14
Batis mixta2812.2 g insectivore
Trochocercus albonotatus23
Turtur tympanistria18.6 g granivore-frugivore
Phyllastrephus placidus50 frugivore-insectivore
Mandingoa nitidula19.6 g granivore-insectivore
Smithornis capensis323.2 g insectivore
Aplopelia larvata3 granivore-frugivore
Alethe fuelleborni2652.0 g insectivore
Turdus gurneyi20
Phylloscopus ruficapillus157.7 g insectivore
"Phylloscopus ruficapilla"
Phyllastrephus debilis2715.4 g insectivore
Sheppardia sharpei1914.7 g insectivore
Spermophaga ruficapilla823.6 g granivore
Turdus abyssinicus168.0 g insectivore
Orthotomus metopias28.4 g
Modulatrix orostruthus1
Modulatrix stictigula230.5 g