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=2710 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2710SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2449SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2710 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cordata' OR junior_species='cordata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cordata' OR species='cordata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cordata' OR species='cordata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cordata' OR junior_species='cordata')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='cordata' OR species='cordata') 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='Eufriesea' AND (junior_species='violascens' OR junior_species='violascens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesea' AND (species='violascens' OR species='violascens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesea' AND (species='violascens' OR species='violascens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesea' AND (junior_species='violascens' OR junior_species='violascens')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='violascens' OR species='violascens') 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=2710 The Ecological Register: Säo Carlos
Säo Carlos
Basic information
Sample name: Säo Carlos

Reference: M. M. López-Uribe, C. A. Oi, and M. A. del Lama. 2008. Nectar-foraging behavior of Euglossine bees (Hymenoptera: Apidae) in urban areas. Apidologie 39:410-418 [ER 2449]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: 22° 1' S, 47° 53' W
Coordinate basis: based on nearby landmark

Geography comments: "inside the urban area of the city of Säo Carlos (SP-Brazil) located between 21º30’S 47º30’W and 22º30’S 48º30’W... All sites were found on street sidewalks within the urban perimeter" (this range is very large, so the coordinate is based on Säo Carlos)

•
Environment
Habitat: tropical/subtropical savanna

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

MAP: 1400.0

Habitat comments: "The climate of the region is bimodal, with dry winters (April–September), wet summers (October–May)... The native vegetation of the area was mainly composed of savannas, arboreal savannas and riparian forests, but it is currently very fragmented, with only 7% of its original coverage remaining"

Methods
Life forms: orchid bees

Sites: 12

Sampling methods: no design,hand capture

Sample size: 878 individuals

Years: 2005, 2006

Sampling comments: "Twelve sites of T. peruviana trees were sampled, located at linear distances ranging from 0.24– 5.45 km apart... For four months in 2005 (Feb–Mar; Nov, Nov– Dec) and seven months in 2006 (Jan–Jul), every site was sampled at least once every two weeks for a two-hour period... Euglossines were collected in plastic bags while visiting T. peruviana flowers... The vials were then opened until the bees found their way out and flew away"

Metadata
Sample number: 2710

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 20:34:53

Modified: 2020-01-14 05:09:34

Abundance distribution
4 species
0 singletons
total count 878
extrapolated richness: 4.6
Fisher's α: 0.541
geometric series k: 0.1666
Hurlbert's PIE: 0.3895
Shannon's H: 0.6195
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Euglossa cordata649
Eulaema nigrita221
Eufriesea violascens5
Exaerete smaragdina3