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=1106 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1106SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=764SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1106 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')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='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='formosa' OR junior_species='formosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipreola' AND (species='formosa' OR species='formosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipreola' AND (species='formosa' OR species='formosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='formosa' OR junior_species='formosa')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='formosa' OR species='formosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syndactyla' AND (junior_species='guttulata' OR junior_species='guttulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syndactyla' AND (species='guttulata' OR species='guttulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syndactyla' AND (species='guttulata' OR species='guttulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syndactyla' AND (junior_species='guttulata' OR junior_species='guttulata')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='Syndactyla' AND (species='guttulata' OR species='guttulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='albigularis' OR junior_species='albigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='albigularis' OR species='albigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='albigularis' OR species='albigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='albigularis' OR junior_species='albigularis')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='Sclerurus' AND (species='albigularis' OR species='albigularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocolaptes' AND (junior_species='picumnus' OR junior_species='picumnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocolaptes' AND (species='picumnus' OR species='picumnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocolaptes' AND (species='picumnus' OR species='picumnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocolaptes' AND (junior_species='picumnus' OR junior_species='picumnus')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='Dendrocolaptes' AND (species='picumnus' OR species='picumnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')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='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='arthus' OR junior_species='arthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='arthus' OR species='arthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='arthus' OR species='arthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='arthus' OR junior_species='arthus')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='Tangara' AND (species='arthus' OR species='arthus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='gyrola' OR junior_species='gyrola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='gyrola' OR species='gyrola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='gyrola' OR species='gyrola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='gyrola' OR junior_species='gyrola')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='Tangara' AND (species='gyrola' OR species='gyrola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='rufigenis' OR junior_species='rufigenis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='rufigenis' OR species='rufigenis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='rufigenis' OR species='rufigenis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='rufigenis' OR junior_species='rufigenis')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='Tangara' AND (species='rufigenis' OR species='rufigenis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='xanthogaster' OR junior_species='xanthogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='xanthogaster' OR species='xanthogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='xanthogaster' OR species='xanthogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='xanthogaster' OR junior_species='xanthogaster')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='Euphonia' AND (species='xanthogaster' OR species='xanthogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophanes' AND (junior_species='spiza' OR junior_species='spiza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorophanes' AND (species='spiza' OR species='spiza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorophanes' AND (species='spiza' OR species='spiza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophanes' AND (junior_species='spiza' OR junior_species='spiza')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='Chlorophanes' AND (species='spiza' OR species='spiza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanerpes' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanerpes' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanerpes' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanerpes' AND (junior_species='caeruleus' OR junior_species='caeruleus')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='Cyanerpes' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorospingus' AND (junior_species='ophthalmicus' OR junior_species='ophthalmicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorospingus' AND (species='ophthalmicus' OR species='ophthalmicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorospingus' AND (species='ophthalmicus' OR species='ophthalmicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorospingus' AND (junior_species='ophthalmicus' OR junior_species='ophthalmicus')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='ophthalmicus' OR species='ophthalmicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivater' OR junior_species='olivater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='olivater' OR species='olivater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='olivater' OR species='olivater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivater' OR junior_species='olivater')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='olivater' OR species='olivater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='albicollis' OR junior_species='albicollis')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='albicollis' OR species='albicollis') 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='Tiaris' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiaris' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiaris' AND (species='fuliginosus' OR species='fuliginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')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='fuliginosus' OR species='fuliginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='linearis' OR junior_species='linearis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrygon' AND (species='linearis' OR species='linearis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrygon' AND (species='linearis' OR species='linearis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='linearis' OR junior_species='linearis')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='Geotrygon' AND (species='linearis' OR species='linearis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='erythrocephala' OR junior_species='erythrocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='erythrocephala' OR species='erythrocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='erythrocephala' OR species='erythrocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='erythrocephala' OR junior_species='erythrocephala')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='Pipra' AND (species='erythrocephala' OR species='erythrocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='olivaceus' OR junior_species='olivaceus')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='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')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='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicarius' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicarius' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')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='Formicarius' AND (species='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeza' AND (junior_species='campanisona' OR junior_species='campanisona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaeza' AND (species='campanisona' OR species='campanisona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaeza' AND (species='campanisona' OR species='campanisona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeza' AND (junior_species='campanisona' OR junior_species='campanisona')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='Chamaeza' AND (species='campanisona' OR species='campanisona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='triangularis' OR junior_species='triangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='triangularis' OR species='triangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='triangularis' OR species='triangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='triangularis' OR junior_species='triangularis')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='Xiphorhynchus' AND (species='triangularis' OR species='triangularis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1106 The Ecological Register: Paso de Portachuelo
Paso de Portachuelo
Basic information
Sample name: Paso de Portachuelo

Sample aka: Henri Pittier National Park

Reference: A. Mijares, R. Rosales, and A. Silva-Iturriza. 2012. Hemosporidian parasites in forest birds from Venezuela: genetic lineage analyses. Avian Diseases 56(3):583-588 [ER 764]
Geography
Country: Venezuela

State: Aragua


Coordinate: 10° 25' 47" N, 67° 38' 0" W
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

WMT: 27.1

CMT: 24.1

MAP: 876.0

Habitat comments: climate data based on station 80413 (Aeropuerto Nacional Florencio Gomez)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 47 individuals

Sampling comments: sampling was "in October" usign mist nets; no other details are given

Metadata
Sample number: 1106

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-26 17:35:14

Modified: 2014-08-26 07:35:14

Abundance distribution
24 species
13 singletons
total count 47
extrapolated richness: 86.8
Fisher's α: 19.650
geometric series k: 0.9089
Hurlbert's PIE: 0.9255
Shannon's H: 2.9241
Good's u: 0.7288
Each square represents a species. Square sizes are proportional to counts.
Register