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=1780 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1780SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1288SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1780 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='ciliolabrum' OR junior_species='ciliolabrum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='ciliolabrum' OR species='ciliolabrum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='ciliolabrum' OR junior_species='ciliolabrum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Myotis' AND (species='ciliolabrum' OR species='ciliolabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='evotis' OR junior_species='evotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='evotis' OR species='evotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='evotis' OR junior_species='evotis')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='Myotis' AND (species='evotis' OR species='evotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='lucifugus' OR junior_species='lucifugus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='lucifugus' OR species='lucifugus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='lucifugus' OR junior_species='lucifugus')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='Myotis' AND (species='lucifugus' OR species='lucifugus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='thysanodes' OR junior_species='thysanodes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='thysanodes' OR species='thysanodes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='thysanodes' OR junior_species='thysanodes')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='Myotis' AND (species='thysanodes' OR species='thysanodes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='volans' OR junior_species='volans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='volans' OR species='volans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='volans' OR junior_species='volans')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='Myotis' AND (species='volans' OR species='volans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eptesicus' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='fuscus' OR junior_species='fuscus')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='Eptesicus' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiurus' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiurus' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiurus' AND (junior_species='cinereus' OR junior_species='cinereus')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='Lasiurus' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycteris' AND (junior_species='noctivagans' OR junior_species='noctivagans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycteris' AND (species='noctivagans' OR species='noctivagans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycteris' AND (junior_species='noctivagans' OR junior_species='noctivagans')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='Lasionycteris' AND (species='noctivagans' OR species='noctivagans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynorhinus' AND (junior_species='townsendii' OR junior_species='townsendi')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corynorhinus' AND (species='townsendii' OR species='townsendi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corynorhinus' AND (species='townsendii' OR species='townsendi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynorhinus' AND (junior_species='townsendii' OR junior_species='townsendi')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Corynorhinus' AND (species='townsendii' OR species='townsendi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadarida' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tadarida' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadarida' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')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='Tadarida' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1780
Reference:R. A. Adams, S. C. Pedersen, K. M. Thibault, J. Jadin, and B. Petru. 2003. Calcium as a limiting resource to insectivorous bats: can water holes provide a supplemental mineral source?. Journal of Zoology260(2):189-194 [ER 1288]
Geography
Country: United States
State: Colorado
Coordinate:40° 2' N, 105° 15' W
Coordinate basis: based on nearby landmark
Geography comments: "84 km2 along the Front Range... immediately west of Boulder... The east to west elevation gradient was 539 m over a 6-km transect"
coordinate based on Boulder
•
Environment
Habitat: temperate coniferous forest
Substrate: ground surface
WMT: 20.2
CMT: -1.4
MAP: 579.0
Habitat comments: "2 vegetation zones, Ponderosa pine Pinus ponderosa and Douglas fir Pseudotsuga menziesii" with a transition at 1980 m; "riparian habitats consisted predominately of plains cottonwood Populus sargentii and mountain willow Salix monicola"
climate data are for Ponderosa on the Front Range immediately west of Boulder and are from
Methods
Life forms: bats
Sampling methods: no design,mist nets
Sample size: 1399 individuals
Years: 1996 - 2000
Seasons: spring,summer
Sampling comments: mist nets were "erected at 10 water holes... from May to August... an array of net sizes (7, 12 and 20 m) was used" but the number of nets is unclear and there is no other indication of collecting effort
Metadata
Sample number: 1780
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-09-27 08:19:38
Modified: 2018-04-13 11:11:28
Abundance distribution
10 species
1 singleton
total count 1399
extrapolated richness: 11.5
Fisher's α: 1.456
geometric series k: 0.5077
Hurlbert's PIE: 0.7912
Shannon's H: 1.7559
Good's u: 0.9993
Each square represents a species. Square sizes are proportional to counts.