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=1369 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1369SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=911SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1369 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulacorhynchus' AND (junior_species='prasinus' OR junior_species='prasinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulacorhynchus' AND (species='prasinus' OR species='prasinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulacorhynchus' AND (species='prasinus' OR species='prasinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulacorhynchus' AND (junior_species='prasinus' OR junior_species='prasinus')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='Aulacorhynchus' AND (species='prasinus' OR species='prasinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='melanogenys' OR junior_species='melanogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='melanogenys' OR species='melanogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='melanogenys' OR species='melanogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='melanogenys' OR junior_species='melanogenys')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='Basileuterus' AND (species='melanogenys' OR species='melanogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylopterus' AND (junior_species='hemileucurus' OR junior_species='hemileucurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylopterus' AND (species='hemileucurus' OR species='hemileucurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylopterus' AND (species='hemileucurus' OR species='hemileucurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylopterus' AND (junior_species='hemileucurus' OR junior_species='hemileucurus')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='Campylopterus' AND (species='hemileucurus' OR species='hemileucurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='frantzii' OR junior_species='frantzi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='frantzii' OR species='frantzi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='frantzii' OR species='frantzi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='frantzii' OR junior_species='frantzi')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='Catharus' AND (species='frantzii' OR species='frantzi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorospingus' AND (junior_species='pileatus' OR junior_species='pileatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorospingus' AND (species='pileatus' OR species='pileatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorospingus' AND (species='pileatus' OR species='pileatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorospingus' AND (junior_species='pileatus' OR junior_species='pileatus')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='Chlorospingus' AND (species='pileatus' OR species='pileatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flavescens' OR junior_species='flavescens')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='Empidonax' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampornis' AND (junior_species='cinereicauda' OR junior_species='cinereicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampornis' AND (species='cinereicauda' OR species='cinereicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampornis' AND (species='cinereicauda' OR species='cinereicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampornis' AND (junior_species='cinereicauda' OR junior_species='cinereicauda')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='Lampornis' AND (species='cinereicauda' OR species='cinereicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarornis' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margarornis' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margarornis' AND (species='rubiginosus' OR species='rubiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarornis' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')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='Margarornis' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='melanops' OR junior_species='melanops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myadestes' AND (species='melanops' OR species='melanops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myadestes' AND (species='melanops' OR species='melanops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='melanops' OR junior_species='melanops')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='Myadestes' AND (species='melanops' OR species='melanops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myioborus' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myioborus' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='torquatus' OR junior_species='torquatus')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='Myioborus' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pezopetes' AND (junior_species='capitalis' OR junior_species='capitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pezopetes' AND (species='capitalis' OR species='capitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pezopetes' AND (species='capitalis' OR species='capitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pezopetes' AND (junior_species='capitalis' OR junior_species='capitalis')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='Pezopetes' AND (species='capitalis' OR species='capitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='villosus' OR junior_species='villosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='villosus' OR species='villosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='villosus' OR species='villosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='villosus' OR junior_species='villosus')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='Picoides' AND (species='villosus' OR species='villosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pselliophrus' AND (junior_species='tibialis' OR junior_species='tibialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pselliophrus' AND (species='tibialis' OR species='tibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pselliophrus' AND (species='tibialis' OR species='tibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pselliophrus' AND (junior_species='tibialis' OR junior_species='tibialis')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='Pselliophrus' AND (species='tibialis' OR species='tibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thripadectes' AND (junior_species='rufobrunneus' OR junior_species='rufobrunneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thripadectes' AND (species='rufobrunneus' OR species='rufobrunneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thripadectes' AND (species='rufobrunneus' OR species='rufobrunneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thripadectes' AND (junior_species='rufobrunneus' OR junior_species='rufobrunneus')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='Thripadectes' AND (species='rufobrunneus' OR species='rufobrunneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='ochraceus' OR junior_species='ochraceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='ochraceus' OR species='ochraceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='ochraceus' OR species='ochraceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='ochraceus' OR junior_species='ochraceus')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='Troglodytes' AND (species='ochraceus' OR species='ochraceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='plebejus' OR junior_species='plebejus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='plebejus' OR species='plebejus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='plebejus' OR species='plebejus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='plebejus' OR junior_species='plebejus')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='plebejus' OR species='plebejus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pusilla' OR junior_species='pusilla')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='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1369 The Ecological Register: Savegre Lodge (primary forest)
Savegre Lodge (primary forest)
Basic information
Sample name: Savegre Lodge (primary forest)

Sample aka: San Gerardo de Dota

Reference: J. Price. 2006. Gauging the ecological health of a Costa Rican cloud forest: birds as bio-indicators. Eukaryon 2:104-109 [ER 911]
Geography
Country: Costa Rica


Coordinate: 9° 34' N, 83° 43' W
Coordinate basis: stated in text

Geography comments: "situated closely to San Gerardo de Dota"
coordinate stated in the text is 9° 34' N, 81° 43' W, which is certainly wrong
correct coordinate appears to be 9° 34' N, 83° 43' W
elevation 2300 to 2500 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 13.2

MAP: 2550.0

Habitat comments: "mainly oak forests with both bamboo and shrubs"
MAP 2100 to 3000 mm, MAT 12 to 14.5 "depending on altitude" in the nearby Los Santos Forest Reserve and Tapantí-Río Macho National Park (ten Hoopen and Kappelle 2006)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 80 captures or sightings

Years: 2003, 2005

Sampling comments: no clear indication of sampling effort

Metadata
Sample number: 1369

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-24 13:40:34

Modified: 2021-07-11 05:28:16

Abundance distribution
17 species
4 singletons
total count 80
extrapolated richness: 29.7
Fisher's α: 6.606
geometric series k: 0.8479
Hurlbert's PIE: 0.8978
Shannon's H: 2.5118
Good's u: 0.9506
Each square represents a species. Square sizes are proportional to counts.
Register