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=1703 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1703SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1172SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1703 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='syrmatophorus' OR junior_species='syrmatophorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='syrmatophorus' OR species='syrmatophorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='syrmatophorus' OR species='syrmatophorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='syrmatophorus' OR junior_species='syrmatophorus')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='Phaethornis' AND (species='syrmatophorus' OR species='syrmatophorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='exortis' OR junior_species='exortis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliangelus' AND (species='exortis' OR species='exortis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliangelus' AND (species='exortis' OR species='exortis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='exortis' OR junior_species='exortis')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='Heliangelus' AND (species='exortis' OR species='exortis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' 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='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' 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='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='torquata' OR junior_species='torquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeligena' AND (species='torquata' OR species='torquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeligena' AND (species='torquata' OR species='torquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='torquata' OR junior_species='torquata')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='Coeligena' AND (species='torquata' OR species='torquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boissonneaua' 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='Boissonneaua' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boissonneaua' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boissonneaua' 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='Boissonneaua' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='personatus' OR junior_species='personatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='personatus' OR species='personatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='personatus' OR species='personatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='personatus' OR junior_species='personatus')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='Trogon' AND (species='personatus' OR species='personatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='aequatorialis' OR junior_species='aequatorialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Momotus' AND (species='aequatorialis' OR species='aequatorialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Momotus' AND (species='aequatorialis' OR species='aequatorialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='aequatorialis' OR junior_species='aequatorialis')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='Momotus' AND (species='aequatorialis' OR species='aequatorialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='striaticollis' OR junior_species='striaticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='striaticollis' OR species='striaticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='striaticollis' OR species='striaticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='striaticollis' OR junior_species='striaticollis')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='Mionectes' AND (species='striaticollis' OR species='striaticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='riefferii' OR junior_species='riefferi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipreola' AND (species='riefferii' OR species='riefferi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipreola' AND (species='riefferii' OR species='riefferi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='riefferii' OR junior_species='riefferi')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='Pipreola' AND (species='riefferii' OR species='riefferi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='ralloides' OR junior_species='ralloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myadestes' AND (species='ralloides' OR species='ralloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myadestes' AND (species='ralloides' OR species='ralloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='ralloides' OR junior_species='ralloides')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='ralloides' OR species='ralloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='fuscater' OR species='fuscater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='fuscater' OR species='fuscater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')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='fuscater' OR species='fuscater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='serranus' OR junior_species='serranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='serranus' OR species='serranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='serranus' OR species='serranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='serranus' OR junior_species='serranus')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='serranus' OR species='serranus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' 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='Hemispingus' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemispingus' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' 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='Hemispingus' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='sittoides' OR junior_species='sittoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='sittoides' OR species='sittoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='sittoides' OR species='sittoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='sittoides' OR junior_species='sittoides')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='Diglossa' AND (species='sittoides' OR species='sittoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='albilatera' OR junior_species='albilatera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='albilatera' OR species='albilatera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='albilatera' OR species='albilatera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='albilatera' OR junior_species='albilatera')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='Diglossa' AND (species='albilatera' OR species='albilatera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='cyanea' OR junior_species='cyanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='cyanea' OR species='cyanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='cyanea' OR species='cyanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='cyanea' OR junior_species='cyanea')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='Diglossa' AND (species='cyanea' OR species='cyanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='brunneinucha' OR junior_species='brunneinucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='brunneinucha' OR species='brunneinucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='brunneinucha' OR junior_species='brunneinucha')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='Arremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' 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='Arremon' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' 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='Arremon' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1703 The Ecological Register: Reserva Forestal Protectora Bosques de la CHEC (bosque secundario)
Reserva Forestal Protectora Bosques de la CHEC (bosque secundario)
Basic information
Sample name: Reserva Forestal Protectora Bosques de la CHEC (bosque secundario)

Reference: L. F. Salazar-Ramírez, D. M. Pineda-Gómez, J. V. E. Varón, and G. J. Castaño-Villa. 2014. Riqueza y abundancia de aves frugívoras y nectarívoras en una plantación de aliso (Alnus acuminata) y un bosque secundario en los Andes centrales de Colombia. Boletin Cientifico del Centro de Museos 18(1):67-77 [ER 1172]
Geography
Country: Colombia


Coordinate: 5° 1' N, 75° 24' W
Coordinate basis: stated in text

Geography comments: "parte de la cuenca alta y media del río Chinchinâ, departamento de Caldas"
elevation 2400 to 3800 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Protection: forest reserve

Substrate: ground surface

MAT: 13.0

MAP: 2500.0

Habitat comments: "cuatro parches de bosque secundario nativo"

Methods
Life forms: birds

Sites: 8

Sampling methods: no design,mist nets

Sample size: 95 individuals

Years: 2008, 2009

Nets or traps: 8

Net or trap nights: 285

Sampling comments: "En cada punto de captura se extendieron en línea cuatro redes de neblina (12 m x 2,5 m x 36 mm) durante 56 horas por mes (entre las 0600 y 1700 h), para un esfuerzo total de muestreo de 3.136 horas red-1 en cada hâbitat" (i.e., eight nets used once a month over seven months for 56 hours a month = about 285 net days)

Metadata
Sample number: 1703

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-09 16:16:04

Modified: 2015-07-09 06:16:04

Abundance distribution
18 species
6 singletons
total count 95
extrapolated richness: 33.9
Fisher's α: 6.575
geometric series k: 0.8410
Hurlbert's PIE: 0.8928
Shannon's H: 2.4877
Good's u: 0.9371
Each square represents a species. Square sizes are proportional to counts.
Register
Phaethornis syrmatophorus75.8 g nectarivore-insectivore
Heliangelus exortis44.8 g nectarivore-insectivore
Adelomyia melanogenys192.3 g nectarivore-insectivore
Coeligena torquata37.3 g nectarivore-insectivore
Boissonneaua flavescens18.2 g nectarivore-insectivore
Trogon personatus163.4 g frugivore-insectivore
Momotus aequatorialis1158 g frugivore-insectivore
Mionectes striaticollis515.0 g insectivore-frugivore
Pipreola riefferii549.3 g frugivore
Myadestes ralloides329.1 g frugivore
Turdus fuscater2143 g insectivore-frugivore
Turdus serranus1084.9 g frugivore-insectivore
Hemispingus frontalis1117.0 g frugivore-insectivore
Diglossa sittoides19.0 g nectarivore
Diglossa albilatera110.2 g frugivore-insectivore
Diglossa cyanea1 frugivore-insectivore
Arremon brunneinucha14
Arremon torquatus6