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=2699 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2699SELECT 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=2699 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='azureoviridis' OR junior_species='azureoviridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='azureoviridis' OR species='azureoviridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='azureoviridis' OR species='azureoviridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='azureoviridis' OR junior_species='azureoviridis')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='azureoviridis' OR species='azureoviridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hansoni' OR junior_species='hansonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='hansoni' OR species='hansonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='hansoni' OR species='hansonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hansoni' OR junior_species='hansonii')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='hansoni' OR species='hansonii') ORDER BY year,last_namesSELECT 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='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='Eulaema' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='nigrita' OR species='nigrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='nigrita' OR species='nigrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='nigrita' OR junior_species='nigrita')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='nigrita' OR species='nigrita') 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=2699 The Ecological Register: Santa Rosa National Park (upland, 1 June 1979)
Santa Rosa National Park (upland, 1 June 1979)
Basic information
Sample name: Santa Rosa National Park (upland, 1 June 1979)

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" (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: " 50-100 yr old secondary regenerating deciduous forest near the bat cave along the nature trail by the Casona; in the semievergreen forest on the escarpment -3 km northeast of the main administration area (selectively logged in the 1940's); and in the oak forest-grassland edge at the top of the escarpment looking northwest over a large deciduous forest 1 km north of the semievergreen forest... annual rainfall ranges from 1400 mm to 2200 mm, with a mean of -2000 mm... The last days of rainfall usually occur in late December and the first rains fall sometime between the last week of April and the middle of May"

Methods
Life forms: orchid bees

Sites: 6

Sampling methods: line transect,baited,other traps

Sample size: 174 individuals

Years: 1979

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: 2699

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 14:37:30

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

Abundance distribution
11 species
2 singletons
total count 174
extrapolated richness: 17.9
Fisher's α: 2.610
geometric series k: 0.6175
Hurlbert's PIE: 0.4704
Shannon's H: 1.1333
Good's u: 0.9886
Each square represents a species. Square sizes are proportional to counts.
Register