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=2696 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2696SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2446SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2696 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='schmidtiana' OR junior_species='schmidtiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesia' AND (species='schmidtiana' OR species='schmidtiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesia' AND (species='schmidtiana' OR species='schmidtiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='schmidtiana' OR junior_species='schmidtiana')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='Eufriesia' AND (species='schmidtiana' OR species='schmidtiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='championi' OR junior_species='championii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='championi' OR species='championii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='championi' OR species='championii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='championi' OR junior_species='championii')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='Euglossa' AND (species='championi' OR species='championii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cognata' OR junior_species='cognata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cognata' OR species='cognata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cognata' OR species='cognata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cognata' OR junior_species='cognata')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='Euglossa' AND (species='cognata' OR species='cognata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dissimila' OR junior_species='dissimila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dissimila' OR species='dissimila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dissimila' OR species='dissimila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dissimila' OR junior_species='dissimila')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='Euglossa' AND (species='dissimila' OR species='dissimila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dodsoni' OR junior_species='dodsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dodsoni' OR species='dodsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dodsoni' OR species='dodsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dodsoni' OR junior_species='dodsonii')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='Euglossa' AND (species='dodsoni' OR species='dodsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='erythrochlora' OR junior_species='erythrochlora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='erythrochlora' OR species='erythrochlora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='erythrochlora' OR species='erythrochlora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='erythrochlora' OR junior_species='erythrochlora')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='Euglossa' AND (species='erythrochlora' OR species='erythrochlora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='flammea' OR junior_species='flammea')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='Euglossa' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='gorgonensis' OR junior_species='gorgonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='gorgonensis' OR species='gorgonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='gorgonensis' OR species='gorgonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='gorgonensis' OR junior_species='gorgonensis')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='Euglossa' AND (species='gorgonensis' OR species='gorgonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='imperialis' OR junior_species='imperialis')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='Euglossa' AND (species='imperialis' OR species='imperialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='mixta' OR junior_species='mixta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='mixta' OR species='mixta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='mixta' OR species='mixta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='mixta' OR junior_species='mixta')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='Euglossa' AND (species='mixta' OR species='mixta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='sapphirina' OR junior_species='sapphirina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='sapphirina' OR species='sapphirina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='sapphirina' OR species='sapphirina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='sapphirina' OR junior_species='sapphirina')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='Euglossa' AND (species='sapphirina' OR species='sapphirina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='tridentata' OR junior_species='tridentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='tridentata' OR species='tridentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='tridentata' OR species='tridentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='tridentata' OR junior_species='tridentata')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='Euglossa' AND (species='tridentata' OR species='tridentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='villosiventris' OR junior_species='villosiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='villosiventris' OR species='villosiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='villosiventris' OR species='villosiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='villosiventris' OR junior_species='villosiventris')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='Euglossa' AND (species='villosiventris' OR species='villosiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombiformis' OR junior_species='bombiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='bombiformis' OR species='bombiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='bombiformis' OR species='bombiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombiformis' OR junior_species='bombiformis')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='Eulaema' AND (species='bombiformis' OR species='bombiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='cingulata' OR junior_species='cingulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='cingulata' OR species='cingulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='cingulata' OR species='cingulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='cingulata' OR junior_species='cingulata')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='Eulaema' AND (species='cingulata' OR species='cingulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='meriana' OR junior_species='meriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='meriana' OR species='meriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='meriana' OR species='meriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='meriana' OR junior_species='meriana')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='Eulaema' AND (species='meriana' OR species='meriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' 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='Exaerete' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exaerete' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' 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='Exaerete' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='smaragdina' OR junior_species='smaragdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exaerete' AND (species='smaragdina' OR species='smaragdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exaerete' AND (species='smaragdina' OR species='smaragdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='smaragdina' OR junior_species='smaragdina')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='Exaerete' AND (species='smaragdina' OR species='smaragdina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2696 The Ecological Register: Corcovado National Park (4 August 1977)
Corcovado National Park (4 August 1977)
Basic information
Sample name: Corcovado National Park (4 August 1977)

Reference: D. H. Janzen, P. J. DeVries, M. L. Higgins, and L. S. Kimsey. 1982. Seasonal and site variation in Costa Rican euglossine bees at chemical baits in lowland deciduous and evergreen forests. Ecology 63(1):66-74 [ER 2446]
Geography
Country: Costa Rica


Coordinate: 8° 33' N, 83° 35' W
Coordinate basis: based on nearby landmark

Geography comments: "on the Pacific side of the Osa Peninsua... All six of the Corcovado census sites lie in an elongate rectangle ~2 km long and 1 km wide" (coordinate based on Corcovado National Park)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Protection: national/state park

Substrate: ground surface

Habitat comments: "Six sites were censused in the vicinity of the Park Headquarters at Sirena... pen grass pasture at the west end of the headquarters building; mangrove-al-cornoque (Mora megistosperma) forest on the east bank of the estuary of the Rio Sirena 200 m inland from the ocean at Boca Sirena; selectively degraded flatland forest 100 m west of the Sirena airstrip along the trail to the estuary of the Rio Sirena (-3-m elevation); edge of flatland virgin forest at the east end of the proposed airstrip east of Casa Marenco near the Rio Pavo (5-m elevation); Rio Cameronal creekbed in lightly degraded foothill forest where the Park Headquarters' water supply originates (-20-m elevation); and lightly disturbed ridgetop forest ~300 m northeast of the Rio Cameronal (-80-m elevation)... m. All of the original vegetation was evergreen rain forest,"

Methods
Life forms: orchid bees

Sites: 6

Sampling methods: line transect,baited,other traps

Sample size: 170 individuals

Years: 1977

Seasons: wet or monsoon

Nets or traps: 5

Sampling comments: "Cineole, eugenol, methyl cinnamate, benzyl acetate, and methyl salicylate were selected as the baits... 16-cm2 squares of heavy blotter paper were soaked in a compound and each square placed individually in a small plastic bag that was then knotted shut. At the census site, each of the five bags was pinned to a different tree trunk in shade - 1.5 m above the ground. The five trees were chosen so as to be about eight to 15 paces apart and arranged in a roughly straight line or shallow arc"

Metadata
Sample number: 2696

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 14:25:25

Modified: 2017-04-16 07:54:10

Abundance distribution
18 species
5 singletons
total count 170
extrapolated richness: 31.6
Fisher's α: 5.087
geometric series k: 0.7816
Hurlbert's PIE: 0.7977
Shannon's H: 2.0940
Good's u: 0.9707
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Eufriesia schmidtiana1
Euglossa championi5
Euglossa cognata11
Euglossa dissimila3
Euglossa dodsoni12
Euglossa erythrochlora2
Euglossa flammea1
Euglossa gorgonensis8
Euglossa imperialis66
Euglossa mixta3
Euglossa sapphirina11
Euglossa tridentata1
Euglossa villosiventris1
Eulaema bombiformis10
Eulaema cingulata1
Eulaema meriana29
Exaerete frontalis2
Exaerete smaragdina3