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=2897 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2897SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2730SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2897 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='larvatus' OR junior_species='larvatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='larvatus' OR species='larvatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='larvatus' OR junior_species='larvatus')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='Hipposideros' AND (species='larvatus' OR species='larvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='diadema' OR junior_species='diadema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='diadema' OR species='diadema') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='diadema' OR junior_species='diadema')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='Hipposideros' AND (species='diadema' OR species='diadema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='spasma' OR junior_species='spasma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaderma' AND (species='spasma' OR species='spasma') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='spasma' OR junior_species='spasma')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='Megaderma' AND (species='spasma' OR species='spasma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='plicatus' OR junior_species='plicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaerephon' AND (species='plicatus' OR species='plicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaerephon' AND (species='plicatus' OR species='plicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaerephon' AND (junior_species='plicatus' OR junior_species='plicatus')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='Chaerephon' AND (species='plicatus' OR species='plicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='affinis' OR junior_species='affinis')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='Rhinolophus' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='muricola' OR junior_species='muricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='muricola' OR species='muricola') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='muricola' OR junior_species='muricola')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='muricola' OR species='muricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='sphinx' OR junior_species='sphinx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynopterus' AND (species='sphinx' OR species='sphinx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='sphinx' OR junior_species='sphinx')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='Cynopterus' AND (species='sphinx' OR species='sphinx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='brachyotis' OR junior_species='brachyotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynopterus' AND (species='brachyotis' OR species='brachyotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='brachyotis' OR junior_species='brachyotis')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='Cynopterus' AND (species='brachyotis' OR species='brachyotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaerops' AND (junior_species='niphanae' OR junior_species='niphanae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaerops' AND (species='niphanae' OR species='niphanae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaerops' AND (junior_species='niphanae' OR junior_species='niphanae')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='Megaerops' AND (species='niphanae' OR species='niphanae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2897 The Ecological Register: Sakaerat Biosphere Reserve
Sakaerat Biosphere Reserve
Basic information
Sample name: Sakaerat Biosphere Reserve

Reference: S. Aroon, J. G. Hill III, T. Artchawakom, S. Pinmongkholgul, S. Kupittayanant, and N. Thanee. 2015. Ectoparasites associated with bats in tropical forest of northeastern Thailand. Journal of Agricultural Technology 11(8):1781-1792 [ER 2730]
Geography
Country: Thailand


Coordinate: 14° 30' N, 101° 51' E
Coordinate basis: stated in text

Geography comments: "in Nakhon Ratchasima province... The elevation ranges from 250 to 762 m"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: biosphere reserve

Substrate: ground surface

MAT: 25.5

MAP: 1200.0

Habitat comments: "dry evergreen and dry dipterocarp forests"
average daily minimum and maximum are 16º and 35º C

Methods
Life forms: bats

Sampling methods: no design,mist nets

Sample size: 66 captures or sightings

Days: 36

Nets or traps: 4

Net or trap nights: 144

Sampling comments: "Bats were captured at eight sampling sites in SBR. At each sampling site, two mist nets (9.4 m long x 2.5 m high, 25 mm mesh size, 4 shelves) were set up at ground level (2.5 m high) and two more others were set up at a higher level (5 m high). Nets were... operated for six hours from 18.00 to 24.00 and checked every 30 minutes. Bats were captured from June 2013 to May 2014. The total trapping effort... was 81,216 meter hours" and there were 9.4 x 2.5 x 4 x 6 = 564 meter hours per night, so there were 144 net nights and 36 nights

Metadata
Sample number: 2897

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-04-21 10:25:17

Modified: 2018-04-21 00:25:17

Abundance distribution
9 species
0 singletons
total count 66
extrapolated richness: 11.5
Fisher's α: 2.816
geometric series k: 0.7369
Hurlbert's PIE: 0.8098
Shannon's H: 1.9247
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hipposideros larvatus2316.8 g insectivore
Hipposideros diadema446.1 g insectivore
Megaderma spasma624.2 g insectivore
Chaerephon plicatus3
"Chaerophon plicata"
Rhinolophus affinis512.9 g insectivore
Myotis muricola45.0 g insectivore
Cynopterus sphinx1048.8 g frugivore
Cynopterus brachyotis230.4 g frugivore-nectarivore
Megaerops niphanae925.1 g