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=736 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=736SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=394SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=736 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='davyi' OR junior_species='davyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronotus' AND (species='davyi' OR species='davyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='davyi' OR junior_species='davyii')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='davyi' OR species='davyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='microtis' OR junior_species='microtis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micronycteris' AND (species='microtis' OR species='microtis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='microtis' OR junior_species='microtis')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='Micronycteris' AND (species='microtis' OR species='microtis') 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='Leptonycteris' AND (junior_species='curasoae' OR junior_species='curasoae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptonycteris' AND (species='curasoae' OR species='curasoae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptonycteris' AND (junior_species='curasoae' OR junior_species='curasoae')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='Leptonycteris' AND (species='curasoae' OR species='curasoae') 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='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='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='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='Artibeus' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='intermedius' OR junior_species='intermedius')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='intermedius' OR species='intermedius') 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='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='Myotis' AND (junior_species='fortidens' OR junior_species='fortidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='fortidens' OR species='fortidens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='fortidens' OR junior_species='fortidens')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='fortidens' OR species='fortidens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=736 The Ecological Register: El Rancho (bats)
El Rancho (bats)
Basic information
Sample name: El Rancho (bats)

Reference: F. Barragán, C. Lorenzo, A. Morón, M. A. Briones-Salas, and S. López. 2010. Bat and rodent diversity in a fragmented landscape on the Isthmus of Tehuantepec, Oaxaca, Mexico. Tropical Conservation Science 3(1):1-16 [ER 394]
Geography
Country: Mexico

State: Oaxaca


Coordinate: 16° 24' N, 94° 38' W
Coordinate basis: estimated from map

Geography comments: altitude 50 to 150 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 27.6

MAP: 932.0

Habitat comments: "The climate is warm, subhumid, with rainfall between June and October, and a dry season from March through May"
this is the least disturbed (26% pasture) of four study areas, but also includes secondary vegetation (27%)
MAT and MAP given in text

Methods
Life forms: bats

Sampling methods: quadrat,mist nets

Sample size: 191 individuals

Years: 2006

Days: 6

Nets or traps: 3

Net or trap nights: 18

Sampling comments: capture-recapture protocol with "three 12-m-long mist nets" in the center of a quadrat checked for three consecutive nights during each of two periods
18 net nights (108 net hours)

Metadata
Sample number: 736

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-04 12:16:08

Modified: 2015-02-23 23:13:56

Abundance distribution
13 species
2 singletons
total count 191
extrapolated richness: 17.7
Fisher's α: 3.156
geometric series k: 0.7010
Hurlbert's PIE: 0.8036
Shannon's H: 2.0034
Good's u: 0.9896
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Pteronotus davyi18.1 g insectivore
Micronycteris microtis146.0 g insectivore
Phyllostomus discolor640.3 g nectarivore-frugivore
Leptonycteris curasoae722.6 g nectarivore
Choeroniscus godmani109.9 g nectarivore
Uroderma bilobatum1918.1 g frugivore
Vampyressa thyone58.0 g frugivore
Enchisthenes hartii115.5 g frugivore
Artibeus intermedius1554.4 g frugivore
Artibeus jamaicensis3248.0 g frugivore
Artibeus lituratus7168.5 g frugivore
Centurio senex819.0 g frugivore
Myotis fortidens25.4 g