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=740 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=740SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=397SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=740 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccopteryx' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saccopteryx' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccopteryx' AND (junior_species='bilineata' OR junior_species='bilineata')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='Saccopteryx' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='personatus' OR junior_species='personatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronotus' AND (species='personatus' OR species='personatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='personatus' OR junior_species='personatus')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='Pteronotus' AND (species='personatus' OR species='personatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='parnellii' OR junior_species='parnelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronotus' AND (species='parnellii' OR species='parnelli') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='parnellii' OR junior_species='parnelli')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='Pteronotus' AND (species='parnellii' OR species='parnelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='hastatus' OR junior_species='hastatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllostomus' AND (species='hastatus' OR species='hastatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='hastatus' OR junior_species='hastatus')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='Phyllostomus' AND (species='hastatus' OR species='hastatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')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='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')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='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='commissarisi' OR junior_species='commissarisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glossophaga' AND (species='commissarisi' OR species='commissarisii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='commissarisi' OR junior_species='commissarisii')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='Glossophaga' AND (species='commissarisi' OR species='commissarisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchophylla' AND (junior_species='concava' OR junior_species='concava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchophylla' AND (species='concava' OR species='concava') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchophylla' AND (junior_species='concava' OR junior_species='concava')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='Lonchophylla' AND (species='concava' OR species='concava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')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='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='castanea' OR junior_species='castanea')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='Carollia' AND (species='castanea' OR species='castanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='subrufa' OR junior_species='subrufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='subrufa' OR species='subrufa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='subrufa' OR junior_species='subrufa')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='Carollia' AND (species='subrufa' OR species='subrufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')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='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='helleri' OR junior_species='hellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='helleri' OR species='hellerii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='helleri' OR junior_species='hellerii')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='Platyrrhinus' AND (species='helleri' OR species='hellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyressa' AND (junior_species='thyone' OR junior_species='thyone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vampyressa' AND (species='thyone' OR species='thyone') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyressa' AND (junior_species='thyone' OR junior_species='thyone')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='Vampyressa' AND (species='thyone' OR species='thyone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyriscus' AND (junior_species='nymphaea' OR junior_species='nymphaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vampyriscus' AND (species='nymphaea' OR species='nymphaea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyriscus' AND (junior_species='nymphaea' OR junior_species='nymphaea')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='Vampyriscus' AND (species='nymphaea' OR species='nymphaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')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='Artibeus' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='lituratus' OR junior_species='lituratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='lituratus' OR species='lituratus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='lituratus' OR junior_species='lituratus')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='Artibeus' AND (species='lituratus' OR species='lituratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' 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='Artibeus' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' 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='Artibeus' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='phaeotis' OR junior_species='phaeotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='phaeotis' OR species='phaeotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='phaeotis' OR junior_species='phaeotis')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='Artibeus' AND (species='phaeotis' OR species='phaeotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enchisthenes' AND (junior_species='hartii' OR junior_species='harti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enchisthenes' AND (species='hartii' OR species='harti') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enchisthenes' AND (junior_species='hartii' OR junior_species='harti')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='Enchisthenes' AND (species='hartii' OR species='harti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurio' AND (junior_species='senex' OR junior_species='senex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centurio' AND (species='senex' OR species='senex') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurio' AND (junior_species='senex' OR junior_species='senex')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='Centurio' AND (species='senex' OR species='senex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='leporinus' OR junior_species='leporinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctilio' AND (species='leporinus' OR species='leporinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='leporinus' OR junior_species='leporinus')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='Noctilio' AND (species='leporinus' OR species='leporinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='labialis' OR junior_species='labialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctilio' AND (species='labialis' OR species='labialis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='labialis' OR junior_species='labialis')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='Noctilio' AND (species='labialis' OR species='labialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossus' AND (junior_species='ater' OR junior_species='ater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molossus' AND (species='ater' OR species='ater') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossus' AND (junior_species='ater' OR junior_species='ater')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='Molossus' AND (species='ater' OR species='ater') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=740 The Ecological Register: Rincón de Osa
Rincón de Osa
Basic information
Sample name: Rincón de Osa

Reference: M. A. Mares and D. E. Wilson. 1971. Bat reproduction during the Costa Rican dry season. BioScience 21(10):471-477 [ER 397]
Geography
Country: Costa Rica

State: Puntarenas


Coordinate: 8° 33' N, 83° 30' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Osa Peninsula

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 25.0

MAP: 6000.0

Habitat comments: "Pacific Wet Lowlands"
text stats that precip is "more than" 4500 mm; this figure greatly exceeds precip at the nearest climate station (78762), so MAT and MAP are based on Carrilllo et al. (2000, Conservation Biology)

Methods
Life forms: bats

Sampling methods: no design,mist nets,hand capture

Sample size: 310 individuals

Years: 1968, 1970

Sampling comments: bats were shot or "netted" (presumably mist netted)

Metadata
Sample number: 740

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-04 17:20:39

Modified: 2014-04-24 22:45:59

Abundance distribution
24 species
9 singletons
total count 310
extrapolated richness: 46.0
Fisher's α: 6.073
geometric series k: 0.8313
Hurlbert's PIE: 0.8832
Shannon's H: 2.4362
Good's u: 0.9710
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Saccopteryx bilineata17.9 g insectivore
Pteronotus personatus18.0 g insectivore
"Chilonycteris psilotis"
Pteronotus parnellii119.1 g insectivore
Phyllostomus hastatus1100 g nectarivore-frugivore
Phyllostomus discolor4440.3 g nectarivore-frugivore
Glossophaga soricina210.5 g frugivore-nectarivore
Glossophaga commissarisi39.3 g nectarivore
Lonchophylla concava258.1 g
Carollia perspicillata3819.6 g frugivore
Carollia castanea1511.9 g frugivore
Carollia subrufa7015.4 g frugivore
Uroderma bilobatum1218.1 g frugivore
Platyrrhinus helleri1815.6 g frugivore
"Vampyrops helleri"
Vampyressa thyone18.0 g frugivore
Vampyriscus nymphaea1213.8 g frugivore
"Vampyressa nymphaea"
Artibeus jamaicensis2248.0 g frugivore
Artibeus lituratus668.5 g frugivore
Artibeus cinereus3011.1 g frugivore
Artibeus phaeotis113.1 g frugivore
Enchisthenes hartii115.5 g frugivore
"Artibeus hartii"
Centurio senex219.0 g frugivore
Noctilio leporinus163.3 g insectivore-piscivore
Noctilio labialis229.6 g insectivore
Molossus ater134.7 g insectivore