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=1688 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1688SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1161SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1688 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petronia' AND (junior_species='dentata' OR junior_species='dentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petronia' AND (species='dentata' OR species='dentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petronia' AND (species='dentata' OR species='dentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petronia' AND (junior_species='dentata' OR junior_species='dentata')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='Petronia' AND (species='dentata' OR species='dentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camaroptera' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')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='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomela' AND (junior_species='familiaris' OR junior_species='familiaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercomela' AND (species='familiaris' OR species='familiaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercomela' AND (species='familiaris' OR species='familiaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomela' AND (junior_species='familiaris' OR junior_species='familiaris')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='Cercomela' AND (species='familiaris' OR species='familiaris') 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='Zosterops' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Zosterops' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporopipes' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporopipes' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporopipes' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporopipes' AND (junior_species='frontalis' OR junior_species='frontalis')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='Sporopipes' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Batis' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Batis' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='cucullatus' OR species='cucullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='cucullatus' OR species='cucullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='cucullatus' OR junior_species='cucullatus')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='Ploceus' AND (species='cucullatus' OR species='cucullatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1688
The Ecological Register: Ahmadu Bello University Farm
Reference:G. O. Ezeifeka, J. U. Umoh, C. D. Ezeokoli, and A. U. Ezealor. 1987. Prevalence of Ife virus infection in wild rodents and birds from Zaria, Nigeria. Journal of Wildlife Diseases23(4):663-665 [ER 1161]
Geography
Country: Nigeria
State: Kaduna
Coordinate:11° 4' N, 7° 42' E
Coordinate basis: based on nearby landmark
Geography comments: within Zaria (basis of coordinate)
•
Environment
Habitat: tropical/subtropical savanna
Altered habitat: cropland
Protection: unprotected
Substrate: ground surface
WMT: 33.5
CMT: 21.2
MAP: 851.0
Habitat comments: "northern Guinea savana"
climate data are for Zaria and are from Sawa and Buhari (2011, Research Journal of Applied Sciences, Engineering and Technology)
Methods
Life forms: birds
Sites: 1
Sampling methods: no design,mist nets
Sample size: 38 individuals
Years: 1985, 1986
Sampling comments: "live-trapped with mist traps"
Metadata
Sample number: 1688
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-07-07 11:02:58
Modified: 2020-01-14 07:26:21
Abundance distribution
8 species
0 singletons
total count 38
extrapolated richness: 10.6
Fisher's α: 3.093
geometric series k: 0.8203
Hurlbert's PIE: 0.8549
Shannon's H: 2.0138
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.