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=1516 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1516SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1022SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1516 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='angelicus' OR junior_species='angelicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='angelicus' OR species='angelicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='angelicus' OR species='angelicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='angelicus' OR junior_species='angelicus')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='Agapostemon' AND (species='angelicus' OR species='angelicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='melliventris' OR junior_species='melliventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='melliventris' OR species='melliventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='melliventris' OR species='melliventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='melliventris' OR junior_species='melliventris')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='Agapostemon' AND (species='melliventris' OR species='melliventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='californica' OR junior_species='californica')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='Anthophora' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' 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='Anthophora' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' 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='Anthophora' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apis' AND (species='mellifera' OR species='mellifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')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='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='persimilis' OR junior_species='persimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliopsis' AND (species='persimilis' OR species='persimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliopsis' AND (species='persimilis' OR species='persimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='persimilis' OR junior_species='persimilis')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='Calliopsis' AND (species='persimilis' OR species='persimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caupolicana' AND (junior_species='yarrowi' OR junior_species='yarrowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caupolicana' AND (species='yarrowi' OR species='yarrowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caupolicana' AND (species='yarrowi' OR species='yarrowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caupolicana' AND (junior_species='yarrowi' OR junior_species='yarrowii')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='Caupolicana' AND (species='yarrowi' OR species='yarrowii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='rhodopus' OR junior_species='rhodopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='rhodopus' OR species='rhodopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='rhodopus' OR species='rhodopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='rhodopus' OR junior_species='rhodopus')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='Centris' AND (species='rhodopus' OR species='rhodopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' 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='Exomalopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exomalopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' 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='Exomalopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='‘green’' OR junior_species='‘green’')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='‘green’' OR species='‘green’') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='‘green’' OR species='‘green’')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='‘green’' OR junior_species='‘green’')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='Lasioglossum' AND (species='‘green’' OR species='‘green’') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sisymbrii' OR junior_species='sisymbri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sisymbrii' OR species='sisymbri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sisymbrii' OR species='sisymbri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sisymbrii' OR junior_species='sisymbri')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='Lasioglossum' AND (species='sisymbrii' OR species='sisymbri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='‘red’' OR junior_species='‘red’')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='‘red’' OR species='‘red’') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='‘red’' OR species='‘red’')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='‘red’' OR junior_species='‘red’')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='Lasioglossum' AND (species='‘red’' OR species='‘red’') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' 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='Melissodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' 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='Melissodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tristis' OR junior_species='tristis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='tristis' OR species='tristis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='tristis' OR species='tristis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tristis' OR junior_species='tristis')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='Melissodes' AND (species='tristis' OR species='tristis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomia' AND (junior_species='tetrazonata' OR junior_species='tetrazonata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomia' AND (species='tetrazonata' OR species='tetrazonata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomia' AND (species='tetrazonata' OR species='tetrazonata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomia' AND (junior_species='tetrazonata' OR junior_species='tetrazonata')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='Nomia' AND (species='tetrazonata' OR species='tetrazonata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='larreae' OR junior_species='larreae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='larreae' OR species='larreae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='larreae' OR species='larreae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='larreae' OR junior_species='larreae')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='Perdita' AND (species='larreae' OR species='larreae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='semiceruleae' OR junior_species='semiceruleae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='semiceruleae' OR species='semiceruleae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='semiceruleae' OR species='semiceruleae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='semiceruleae' OR junior_species='semiceruleae')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='Perdita' AND (species='semiceruleae' OR species='semiceruleae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoxaea' AND (junior_species='gloriosa' OR junior_species='gloriosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protoxaea' AND (species='gloriosa' OR species='gloriosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protoxaea' AND (species='gloriosa' OR species='gloriosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoxaea' AND (junior_species='gloriosa' OR junior_species='gloriosa')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='Protoxaea' AND (species='gloriosa' OR species='gloriosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylocopa' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylocopa' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylocopa' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylocopa' AND (junior_species='californica' OR junior_species='californica')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='Xylocopa' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1516 The Ecological Register: Cienega Ranch
Cienega Ranch
Basic information
Sample name: Cienega Ranch

Reference: J. H. Cane, L. J. Kervin, and R. McKinley. 2013. Sensitivity of systematic net sampling for detecting shifting patterns of incidence and abundance in a floral guild of bees at Larrea tridentata. Journal of the Kansas Entomological Society 86(2):171-180 [ER 1022]
Geography
Country: United States

State: Arizona


Coordinate: 32.012° N, -109.050° W
Coordinate basis: stated in text

Geography comments: "near Community Road on Cienega Ranch in the San Simon Valley"

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

Habitat comments: "a large and homogeneous 'flat’' of creosote bush"

Methods
Life forms: bees

Sites: 1

Site length: 100

Site width: 100

Sampling methods: quadrat,other nets

Sample size: 1247 individuals

Years: 1997

Days: 8

Sampling comments: sampling was conducted with "aerial nets" by three people for "five hrs every other morning, beginning at dawn, from 25 August to 5 September 1997"

Metadata
Sample number: 1516

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-04-26 17:00:17

Modified: 2015-04-26 07:00:17

Abundance distribution
20 species
2 singletons
total count 1247
extrapolated richness: 27.2
Fisher's α: 3.383
geometric series k: 0.7325
Hurlbert's PIE: 0.7851
Shannon's H: 1.8078
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
Register