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 The Ecological Register: West of Boulder
West of Boulder
Basic information
Sample name: West of Boulder

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 Zoology 260(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.
Register
Myotis ciliolabrum1023.7 g insectivore
Myotis evotis1646.5 g insectivore
Myotis lucifugus4467.4 g insectivore
Myotis thysanodes1576.7 g insectivore
Myotis volans1297.4 g insectivore
Eptesicus fuscus36117.2 g insectivore
Lasiurus cinereus1820.7 g insectivore
Lasionycteris noctivagans910.0 g insectivore
Corynorhinus townsendii12 insectivore
Tadarida brasiliensis111.3 g insectivore