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=2711 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2711SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2450SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2711 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='chocoana' OR junior_species='chocoana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='chocoana' OR species='chocoana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='chocoana' OR species='chocoana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='chocoana' OR junior_species='chocoana')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='chocoana' OR species='chocoana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombifrons' OR junior_species='bombifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='bombifrons' OR species='bombifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='bombifrons' OR species='bombifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombifrons' OR junior_species='bombifrons')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='bombifrons' OR species='bombifrons') 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='Euglossa' AND (junior_species='ignita' OR junior_species='ignita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='ignita' OR species='ignita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='ignita' OR species='ignita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='ignita' OR junior_species='ignita')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='ignita' OR species='ignita') 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='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='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='deceptrix' OR junior_species='deceptrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='deceptrix' OR species='deceptrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='deceptrix' OR species='deceptrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='deceptrix' OR junior_species='deceptrix')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='deceptrix' OR species='deceptrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dressleri' OR junior_species='dresslerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dressleri' OR species='dresslerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dressleri' OR species='dresslerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dressleri' OR junior_species='dresslerii')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='dressleri' OR species='dresslerii') 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='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='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='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesea' AND (junior_species='pulcra' OR junior_species='pulcra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesea' AND (species='pulcra' OR species='pulcra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesea' AND (species='pulcra' OR species='pulcra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesea' AND (junior_species='pulcra' OR junior_species='pulcra')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='Eufriesea' AND (species='pulcra' OR species='pulcra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2711 The Ecological Register: Buenaventura (farmland)
Buenaventura (farmland)
Basic information
Sample name: Buenaventura (farmland)

Reference: J. C. Sandino. 2004. Are there any agricultural effects on the capture rates of male euglossine bees (Apidae: Euglossini)?. Revista de Biología Tropical 52(1):115-118 [ER 2450]
Geography
Country: Colombia


Coordinate: 3° 53' N, 77° 2' W
Coordinate basis: based on nearby landmark

Geography comments: "Buenaventura" (basis of coordinate)

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: "on the plains and lower slopes of the central Chocó biogeographic region... a typical diversified farmland along the riverbanks of the Anchicayâ river" (moist forest based on biogeography)

Methods
Life forms: orchid bees

Sampling methods: line transect,baited,hand capture,visual

Sample size: 309 individuals

Years: 1995

Sampling comments: "During April and May 1995 male euglossine bees were sampled... four sampling sites were established by placing trap sets every 200 m... Trap sets at each site, consisted of three non-lethal traps, respectively baited with cineol, methyl salicilate and skatol. The homemade traps had the bait at the bottom part, hanging under an inverted funnel... The traps remained installed 4 hours from 0800/0830 to 1200/1230... Male euglossines were identified on the site; dubious specimens and vouchers were collected and deposited at the Museo de Entomología... bees were wing-marked with indelible ink"

Metadata
Sample number: 2711

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-17 08:09:16

Modified: 2017-04-16 22:15:03

Abundance distribution
15 species
4 singletons
total count 309
extrapolated richness: 24.9
Fisher's α: 3.296
geometric series k: 0.7041
Hurlbert's PIE: 0.7127
Shannon's H: 1.6433
Good's u: 0.9871
Each square represents a species. Square sizes are proportional to counts.
Register