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=1037 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1037SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=717SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1037 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='martinica' OR junior_species='martinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetura' AND (species='martinica' OR species='martinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetura' AND (species='martinica' OR species='martinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='martinica' OR junior_species='martinica')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='Chaetura' AND (species='martinica' OR species='martinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulampis' AND (junior_species='jugularis' OR junior_species='jugularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulampis' AND (species='jugularis' OR species='jugularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulampis' AND (species='jugularis' OR species='jugularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulampis' AND (junior_species='jugularis' OR junior_species='jugularis')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='Eulampis' AND (species='jugularis' OR species='jugularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericotes' AND (junior_species='holosericeus' OR junior_species='holosericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericotes' AND (species='holosericeus' OR species='holosericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericotes' AND (species='holosericeus' OR species='holosericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericotes' AND (junior_species='holosericeus' OR junior_species='holosericeus')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='Sericotes' AND (species='holosericeus' OR species='holosericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthorhyncus' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthorhyncus' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthorhyncus' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthorhyncus' AND (junior_species='cristatus' OR junior_species='cristatus')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='Orthorhyncus' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='stolidus' OR junior_species='stolidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='stolidus' OR species='stolidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='stolidus' OR species='stolidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='stolidus' OR junior_species='stolidus')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='Myiarchus' AND (species='stolidus' OR species='stolidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='martinica' OR junior_species='martinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='martinica' OR species='martinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='martinica' OR species='martinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='martinica' OR junior_species='martinica')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='Elaenia' AND (species='martinica' OR species='martinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarops' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margarops' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margarops' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarops' AND (junior_species='fuscus' OR junior_species='fuscus')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='Margarops' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='petechia' OR species='petechia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='petechia' OR species='petechia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')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='Setophaga' AND (species='petechia' OR species='petechia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coereba' AND (junior_species='flaveola' OR junior_species='flaveola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coereba' AND (species='flaveola' OR species='flaveola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coereba' AND (species='flaveola' OR species='flaveola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coereba' AND (junior_species='flaveola' OR junior_species='flaveola')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='Coereba' AND (species='flaveola' OR species='flaveola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxigilla' AND (junior_species='noctis' OR junior_species='noctis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxigilla' AND (species='noctis' OR species='noctis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxigilla' AND (species='noctis' OR species='noctis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxigilla' AND (junior_species='noctis' OR junior_species='noctis')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='Loxigilla' AND (species='noctis' OR species='noctis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiaris' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiaris' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='bicolor' OR junior_species='bicolor')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='Tiaris' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1037 The Ecological Register: Bayac Estate
Bayac Estate
Basic information
Sample name: Bayac Estate

Reference: R. P. Prys-Jones. 1982. Molt and weight of some land-birds on Dominica, West Indies. Journal of Field Ornithology 53(4):352-362 [ER 717]
Geography
Country: Dominica


Coordinate: 15° 20' N, 61° 20' W
Coordinate basis: based on nearby landmark

Geography comments: "off the Roseau-Laudat road on the west side of the island" (coordinate based on Laudat)

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

WMT: 27.5

CMT: 24.9

MAP: 2096.0

Habitat comments: "an area of fruit orchards and garden surrounded by extensive secondary forest"
climate data based on station 78925 (Martinique airport)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 222 individuals

Years: 1978

Days: 12

Sampling comments: number of nets unclear

Metadata
Sample number: 1037

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-17 10:38:57

Modified: 2014-08-22 03:46:31

Abundance distribution
11 species
2 singletons
total count 222
extrapolated richness: 15.0
Fisher's α: 2.431
geometric series k: 0.6444
Hurlbert's PIE: 0.7931
Shannon's H: 1.8522
Good's u: 0.9910
Each square represents a species. Square sizes are proportional to counts.
Register