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=2709 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2709SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2448SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2709 ORDER BY register_no ASCSELECT 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='polychroma' OR junior_species='polychroma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='polychroma' OR species='polychroma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='polychroma' OR species='polychroma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='polychroma' OR junior_species='polychroma')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='polychroma' OR species='polychroma') 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='allosticta' OR junior_species='allosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='allosticta' OR species='allosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='allosticta' OR species='allosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='allosticta' OR junior_species='allosticta')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='allosticta' OR species='allosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='bursigera' OR junior_species='bursigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='bursigera' OR species='bursigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='bursigera' OR species='bursigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='bursigera' OR junior_species='bursigera')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='bursigera' OR species='bursigera') 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='cybelia' OR junior_species='cybelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cybelia' OR species='cybelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cybelia' OR species='cybelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cybelia' OR junior_species='cybelia')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='cybelia' OR species='cybelia') 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='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='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='heterosticta' OR junior_species='heterosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='heterosticta' OR species='heterosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='heterosticta' OR species='heterosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='heterosticta' OR junior_species='heterosticta')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='heterosticta' OR species='heterosticta') 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='milenae' OR junior_species='milenae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='milenae' OR species='milenae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='milenae' OR species='milenae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='milenae' OR junior_species='milenae')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='milenae' OR species='milenae') 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='townsendi' OR junior_species='townsendii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='townsendi' OR species='townsendii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='townsendi' OR species='townsendii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='townsendi' OR junior_species='townsendii')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='townsendi' OR species='townsendii') 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='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=2709 The Ecological Register: La Gamba (ridge forest)
La Gamba (ridge forest)
Basic information
Sample name: La Gamba (ridge forest)

Sample aka: Piedras Blancas National Park

Reference: M. H. Gruber, L. Morawetz, and M. Wiemers. 2008. Diversity of Euglossini (Hymenoptera, Apidae) in primary and secondary lowland rainforests in south-western Costa Rica. Stapfia 80:257-266 [ER 2448]
Geography
Country: Costa Rica


Coordinate: 8° 42' N, 83° 12' W
Coordinate basis: based on nearby landmark

Geography comments: "in the Piedras Blancas National Park near the village of La Gamba" (coordinate based on Field Station La Gamba)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAP: 6000.0

Habitat comments: "tropical lowland rainforest... The average number of rainy days is 286.5 per year and the average annual rainfall is about 6000 mm... The mean monthly temperature averages 26.7°C in January and 27.3°C in February" (MAT unclear); sampling was at one site in primary "ridge forest"

Methods
Life forms: orchid bees

Sites: 1

Sampling methods: no design,other nets,baited

Sample size: 167 individuals

Sampling comments: "We used four different aromas which are present in orchid flower fragrances... The survey was carried out on sunny days from 27 to 31 January 2007... between 9:00 and 12:00 in the morning... At each sampling site, all four chemical baits were put at an average height of 2 m (scented napkins attached to branches with twine), at an average distance of about 4-5 m. The baits were monitored simultaneously and constantly, the sampling lasted one hour per sampling site... The attracted bees were captured with an insect net after visiting the baits and killed in a jar with ethyl acetate"

Metadata
Sample number: 2709

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 18:53:45

Modified: 2017-04-16 08:53:45

Abundance distribution
19 species
5 singletons
total count 167
extrapolated richness: 33.0
Fisher's α: 5.520
geometric series k: 0.8021
Hurlbert's PIE: 0.8374
Shannon's H: 2.2397
Good's u: 0.9703
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Eulaema meriana2
Eulaema polychroma1
Euglossa hansoni3
Euglossa allosticta1
Euglossa bursigera7
Euglossa championi15
Euglossa cybelia4
Euglossa dodsoni53
Euglossa flammea2
Euglossa gorgonensis16
Euglossa hemichlora4
Euglossa heterosticta2
Euglossa imperialis11
Euglossa milenae1
Euglossa mixta1
Euglossa sapphirina30
Euglossa townsendi5
Euglossa tridentata8
Exaerete smaragdina1