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=2703 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2703SELECT 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=2703 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hemichlora' OR junior_species='hemichlora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='hemichlora' OR species='hemichlora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='hemichlora' OR species='hemichlora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hemichlora' OR junior_species='hemichlora')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='hemichlora' OR species='hemichlora') 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='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='viridissima' OR junior_species='viridissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='viridissima' OR species='viridissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='viridissima' OR species='viridissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='viridissima' OR junior_species='viridissima')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='viridissima' OR species='viridissima') 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='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=2703 The Ecological Register: Santa Rosa National Park (lowland, 5 August 1977)
Santa Rosa National Park (lowland, 5 August 1977)
Basic information
Sample name: Santa Rosa National Park (lowland, 5 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

State: Guanacaste


Coordinate: 10° 53' 1" N, 85° 46' 30" W
Coordinate basis: based on nearby landmark

Geography comments: "25 km south of La Cruz in northwestern Guanacaste Province between the Pan-American highway and the ocean... All three sites are within 8 km of each other and their general location is 12 km from the three upland sites" (coordinate based on Santa Rosa National Park)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

MAP: 2000.0

Habitat comments: three sites "in the semidegraded forests 100-200 m inland from the thin band of mangroves backing Playa Naranjo" (nature of disturbance unclear) with the first "in thoroughly deciduous vegetation", the second in "deciduous to semievergreen" forest, and the third "in deciduous forest"; "the annual rainfall ranges from 1400 mm to 2200 mm, with a mean of -2000 mm"

Methods
Life forms: orchid bees

Sites: 6

Sampling methods: line transect,baited,other traps

Sample size: 105 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: 2703

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 15:15:25

Modified: 2017-04-16 07:55:09

Abundance distribution
6 species
1 singleton
total count 105
extrapolated richness: 9.3
Fisher's α: 1.381
geometric series k: 0.4142
Hurlbert's PIE: 0.3675
Shannon's H: 0.8073
Good's u: 0.9907
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Euglossa hemichlora12
Euglossa imperialis2
Euglossa tridentata5
Euglossa viridissima82
Eulaema cingulata1
Exaerete smaragdina3