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=930 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=930SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=627SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=930 ORDER BY register_no ASCSELECT 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='Tonatia' AND (junior_species='saurophila' OR junior_species='saurophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tonatia' AND (species='saurophila' OR species='saurophila') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tonatia' AND (junior_species='saurophila' OR junior_species='saurophila')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='Tonatia' AND (species='saurophila' OR species='saurophila') 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='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='fimbriatus' OR junior_species='fimbriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='fimbriatus' OR species='fimbriatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='fimbriatus' OR junior_species='fimbriatus')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='fimbriatus' OR species='fimbriatus') 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='Platyrrhinus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='lineatus' OR junior_species='lineatus')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='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='recifinus' OR junior_species='recifinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='recifinus' OR species='recifinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='recifinus' OR junior_species='recifinus')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='recifinus' OR species='recifinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='magnirostrum' OR junior_species='magnirostrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroderma' AND (species='magnirostrum' OR species='magnirostrum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='magnirostrum' OR junior_species='magnirostrum')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='magnirostrum' OR species='magnirostrum') 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='Eumops' AND (junior_species='auripendulus' OR junior_species='auripendulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumops' AND (species='auripendulus' OR species='auripendulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumops' AND (species='auripendulus' OR species='auripendulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumops' AND (junior_species='auripendulus' OR junior_species='auripendulus')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='Eumops' AND (species='auripendulus' OR species='auripendulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossus' AND (junior_species='molossus' OR junior_species='molossus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molossus' AND (species='molossus' OR species='molossus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossus' AND (junior_species='molossus' OR junior_species='molossus')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='molossus' OR species='molossus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiurus' AND (junior_species='blossevillii' OR junior_species='blossevilli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiurus' AND (species='blossevillii' OR species='blossevilli') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiurus' AND (junior_species='blossevillii' OR junior_species='blossevilli')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='blossevillii' OR species='blossevilli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='nigricans' OR junior_species='nigricans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='nigricans' OR species='nigricans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='nigricans' OR junior_species='nigricans')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='nigricans' OR species='nigricans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='riparius' OR junior_species='riparius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='riparius' OR species='riparius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='riparius' OR junior_species='riparius')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='riparius' OR species='riparius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=930 The Ecological Register: Praia das Neves
Praia das Neves
Basic information
Sample name: Praia das Neves

Reference: J. L. Luz, L. M. Costa, E. C. Lourenço, L. A. C. Gomes, and C. E. L. Esbérard. 2009. Bats from the Restinga of Praia das Neves, state of Espírito Santo, Southeastern Brazil. Check List 5(2):364-369 [ER 627]
Geography
Country: Brazil

State: Espírito Santo


Coordinate: 21° 15' S, 40° 58' W
Coordinate basis: stated in text

Geography comments: "on the riverbank of the Itabapoana river, Presidente Kennedy municipality"

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

WMT: 27.6

CMT: 21.1

MAP: 903.0

Habitat comments: coastal sand dunes (restinga) and specifically "swamp, restinga forest, orchard, shrubs with Clusia, shrubs without Clusia, and underbrush vegetation"
climate based on station 83698 (Campos)

Methods
Life forms: bats

Sampling methods: no design,mist nets

Sample size: 99 captures or sightings

Years: 2008

Days: 10

Net or trap nights: 125

Sampling comments: ten sampling nights over three months with 10 to 16 9 x 2.5 m nets used at a time for a total of 77.5 sampling hours and 21,847.5 net meter hours, which works out to 971 net hours and therefore 12.53 nets per night

Metadata
Sample number: 930

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-05-17 15:50:41

Modified: 2014-05-17 05:50:41

Abundance distribution
16 species
7 singletons
total count 99
extrapolated richness: 38.4
Fisher's α: 5.403
geometric series k: 0.7820
Hurlbert's PIE: 0.7738
Shannon's H: 1.9482
Good's u: 0.9299
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Phyllostomus discolor240.3 g nectarivore-frugivore
Glossophaga soricina510.5 g frugivore-nectarivore
Tonatia saurophila227.1 g insectivore
Carollia perspicillata1319.6 g frugivore
Artibeus cinereus711.1 g frugivore
Artibeus fimbriatus362.3 g frugivore
Artibeus lituratus4068.5 g frugivore
Platyrrhinus lineatus1822.7 g frugivore
Platyrrhinus recifinus117.7 g frugivore
Uroderma magnirostrum116.6 g frugivore
Noctilio leporinus163.3 g insectivore-piscivore
Eumops auripendulus1 insectivore
Molossus molossus212.9 g insectivore
Lasiurus blossevillii18.1 g insectivore
Myotis nigricans15.1 g insectivore
Myotis cf. riparius15.9 g insectivore