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=2822 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2822SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2517SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2822 ORDER BY register_no ASCSELECT 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='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='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')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='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoura' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoura' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoura' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')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='Anoura' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choeroniscus' AND (junior_species='godmani' OR junior_species='godmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choeroniscus' AND (species='godmani' OR species='godmanii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choeroniscus' AND (junior_species='godmani' OR junior_species='godmanii')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='Choeroniscus' AND (species='godmani' OR species='godmanii') 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='Glossophaga' AND (junior_species='morenoi' OR junior_species='morenoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glossophaga' AND (species='morenoi' OR species='morenoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glossophaga' AND (species='morenoi' OR species='morenoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='morenoi' OR junior_species='morenoii')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='morenoi' OR species='morenoii') 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='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='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='Artibeus' AND (junior_species='toltecus' OR junior_species='toltecus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='toltecus' OR species='toltecus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='toltecus' OR junior_species='toltecus')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='toltecus' OR species='toltecus') 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='Chiroderma' AND (junior_species='salvini' OR junior_species='salvinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiroderma' AND (species='salvini' OR species='salvinii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroderma' AND (junior_species='salvini' OR junior_species='salvinii')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='Chiroderma' AND (species='salvini' OR species='salvinii') 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='Sturnira' AND (junior_species='hondurensis' OR junior_species='hondurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnira' AND (species='hondurensis' OR species='hondurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnira' AND (species='hondurensis' OR species='hondurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='hondurensis' OR junior_species='hondurensis')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='Sturnira' AND (species='hondurensis' OR species='hondurensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='parvidens' OR junior_species='parvidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnira' AND (species='parvidens' OR species='parvidens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='parvidens' OR junior_species='parvidens')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='Sturnira' AND (species='parvidens' OR species='parvidens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2822 The Ecological Register: El Chorro (mist nets)
El Chorro (mist nets)
Basic information
Sample name: El Chorro (mist nets)

Sample aka: El Carrizal de Galeana

Reference: C. García-Estrada, Y. A. Peña-Sánchez, and H. Colín-Martínez. 2015. Diversidad de mamíferos pequeños en dos sitios con diferente grado de alteración en la Sierra Sur, Oaxaca, México. Revista Mexicana de Biodiversidad 86:1014-1023 [ER 2517]
Geography
Country: Mexico

State: Oaxaca


Coordinate: 16° 52' 6" N, 97° 53' 37" W
Coordinate basis: stated in text

Geography comments: "en la localidad de El Carrizal de Galeana, municipio de Putla, Villa de Guerrero, distrito de Putla, en la Sierra Sur de Oaxaca"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 24.2

MAP: 2331.0

Dry months: 7

Habitat comments: "El ârea se caracteriza por una estación de lluvias entre junio y octubre (> 100 mm de precipitación por mes), y por un periodo de sequía, con los meses mâs secos marzo y abril (< 50 mm por mes; Sânchez-Cordero 2001)... se consideró la selva mediana subcaducifolia... la ùnica alteracíon fue causada por el cultivo de café en 1958, el cual sustituyó solo el sotobosque; sin embargo, el cultivo fue abandonadao en 1996"

Methods
Life forms: bats

Sampling methods: line transect,mist nets

Sample size: 368 captures or sightings

Years: 2009, 2010

Days: 22

Nets or traps: 4

Net or trap nights: 88

Sampling comments: "El trabajo de campo se llevó a cabo durante un año, de junio de 2009 a mayo de 2010 durante 2 días cada mes... se utilizaron 4 redes de niebla de 9 m de largo por 2.5 m alto, las cuales se colocaron en un transecto do 100 m entre la vegetación, con una separación de 25 m entre cada red. Las redes se abrieron antes de anochecer y se mantuvieron abiertas durante 5 horas"
there were "19,800 m2 de red-hora" over the two sites and there were 22 field nights, which works out to 22 x 4 x 9 x 2.5 x 5 = 9900, as implied

Metadata
Sample number: 2822

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-11-30 12:49:48

Modified: 2017-11-30 01:49:48

Abundance distribution
17 species
3 singletons
total count 368
extrapolated richness: 23.5
Fisher's α: 3.685
geometric series k: 0.7271
Hurlbert's PIE: 0.7672
Shannon's H: 2.0140
Good's u: 0.9919
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Pteronotus parnellii519.1 g insectivore
Carollia subrufa1715.4 g frugivore
Desmodus rotundus1233.5 g sanguinivore
Anoura geoffroyi312.8 g nectarivore
Choeroniscus godmani19.9 g nectarivore
Glossophaga commissarisi109.3 g nectarivore
Glossophaga morenoi2 nectarivore
Glossophaga soricina3410.5 g frugivore-nectarivore
Artibeus jamaicensis3848.0 g frugivore
Artibeus lituratus2168.5 g frugivore
Artibeus phaeotis1413.1 g frugivore
"Dermanura phaeotis"
Artibeus toltecus1916.3 g frugivore
"Dermanura tolteca"
Centurio senex119.0 g frugivore
Chiroderma salvini928.2 g frugivore
Vampyressa thyone18.0 g frugivore
Sturnira hondurensis17
Sturnira parvidens16416.5 g