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=1290 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1290SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=420SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1290 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='leschenaultii' OR junior_species='leschenaulti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rousettus' AND (species='leschenaultii' OR species='leschenaulti') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='leschenaultii' OR junior_species='leschenaulti')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='Rousettus' AND (species='leschenaultii' OR species='leschenaulti') 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='Sphaerias' AND (junior_species='blanfordi' OR junior_species='blanfordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaerias' AND (species='blanfordi' OR species='blanfordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaerias' AND (species='blanfordi' OR species='blanfordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaerias' AND (junior_species='blanfordi' OR junior_species='blanfordii')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='Sphaerias' AND (species='blanfordi' OR species='blanfordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='lyra' OR junior_species='lyra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaderma' AND (species='lyra' OR species='lyra') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='lyra' OR junior_species='lyra')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='lyra' OR species='lyra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='paradoxolophus' OR junior_species='paradoxolophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='paradoxolophus' OR species='paradoxolophus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinolophus' AND (species='paradoxolophus' OR species='paradoxolophus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='paradoxolophus' OR junior_species='paradoxolophus')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='paradoxolophus' OR species='paradoxolophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='macrotis' OR junior_species='macrotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='macrotis' OR species='macrotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='macrotis' OR junior_species='macrotis')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='macrotis' OR species='macrotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='pearsonii' OR junior_species='pearsoni')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='pearsonii' OR species='pearsoni') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='pearsonii' OR junior_species='pearsoni')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='pearsonii' OR species='pearsoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='yunanensis' OR junior_species='yunanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='yunanensis' OR species='yunanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinolophus' AND (species='yunanensis' OR species='yunanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='yunanensis' OR junior_species='yunanensis')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='yunanensis' OR species='yunanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='pusillus' OR junior_species='pusillus')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='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='stheno' OR junior_species='stheno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='stheno' OR species='stheno') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='stheno' OR junior_species='stheno')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='stheno' OR species='stheno') 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='Hipposideros' AND (junior_species='pomona' OR junior_species='pomona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='pomona' OR junior_species='pomona')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='pomona' OR species='pomona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='cineraceus' OR junior_species='cineraceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='cineraceus' OR species='cineraceus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='cineraceus' OR junior_species='cineraceus')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='cineraceus' OR species='cineraceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='lylei' OR junior_species='lyleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='lylei' OR species='lyleii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='lylei' OR junior_species='lyleii')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='lylei' OR species='lyleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='armiger' OR junior_species='armiger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='armiger' OR species='armiger') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='armiger' OR junior_species='armiger')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='armiger' OR species='armiger') ORDER BY year,last_namesSELECT 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='Aselliscus' AND (junior_species='stoliczkanus' OR junior_species='stoliczkanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aselliscus' AND (species='stoliczkanus' OR species='stoliczkanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aselliscus' AND (species='stoliczkanus' OR species='stoliczkanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aselliscus' AND (junior_species='stoliczkanus' OR junior_species='stoliczkanus')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='Aselliscus' AND (species='stoliczkanus' OR species='stoliczkanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='chinensis' OR junior_species='chinensis')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='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='siligorensis' OR junior_species='siligorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='siligorensis' OR species='siligorensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='siligorensis' OR junior_species='siligorensis')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='siligorensis' OR species='siligorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='ater' OR species='ater') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='ater' OR species='ater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsugo' AND (junior_species='pulveratus' OR junior_species='pulveratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsugo' AND (species='pulveratus' OR species='pulveratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsugo' AND (species='pulveratus' OR species='pulveratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsugo' AND (junior_species='pulveratus' OR junior_species='pulveratus')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='Hypsugo' AND (species='pulveratus' OR species='pulveratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='cyclotis' OR junior_species='cyclotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murina' AND (species='cyclotis' OR species='cyclotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='cyclotis' OR junior_species='cyclotis')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='Murina' AND (species='cyclotis' OR species='cyclotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='eleryi' OR junior_species='eleryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murina' AND (species='eleryi' OR species='eleryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Murina' AND (species='eleryi' OR species='eleryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='eleryi' OR junior_species='eleryii')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='Murina' AND (species='eleryi' OR species='eleryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpiocephalus' AND (junior_species='harpia' OR junior_species='harpia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpiocephalus' AND (species='harpia' OR species='harpia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpiocephalus' AND (junior_species='harpia' OR junior_species='harpia')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='Harpiocephalus' AND (species='harpia' OR species='harpia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='hardwickii' OR junior_species='hardwicki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='hardwickii' OR species='hardwicki') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='hardwickii' OR junior_species='hardwicki')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='Kerivoula' AND (species='hardwickii' OR species='hardwicki') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1290 The Ecological Register: Kim Hy Nature Reserve (agriculture/degraded forest)
Kim Hy Nature Reserve (agriculture/degraded forest)
Basic information
Sample name: Kim Hy Nature Reserve (agriculture/degraded forest)

Reference: N. M. Furey, I. J. Mackie, and P. A. Racey. 2010. Bat diversity in Vietnamese limestone karst areas and the implications of forest degradation. Biodiversity and Conservation 19:1821-1838 [ER 420]
Geography
Country: Vietnam

State: Bac Kan


Coordinate: 22° 16' 17" N, 106° 3' 0" E
Coordinate basis: stated in text

Geography comments: coordinates based on ranges given in text
elevation 440 to 582 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: cropland

Protection: nature reserve

Substrate: ground surface

Disturbance: selective logging

MAT: 20.1

WMT: 28.7

CMT: 12.8

MAP: 1593.0

Habitat comments: originally "seasonal broadleaved evergreen forests over limestone" but now covered with "paddy rice" plus some "heavily degraded forests... on ridgetops"
MAT and MAP given in text; CMT and WMT based on station 59431 (Nanning)

Methods
Life forms: bats

Sites: 1

Sampling methods: no design,harp nets,mist nets

Sample size: 149 individuals

Years: 2006, 2007

Net or trap nights: 140

Sampling comments: "240 net nights and 180 harp trap nights" and 39,994 trap hours spread evenly across three sites in three different environments
recaptures are excluded from the counts

Metadata
Sample number: 1290

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-18 15:30:16

Modified: 2015-02-18 04:30:16

Abundance distribution
25 species
10 singletons
total count 149
extrapolated richness: 55.6
Fisher's α: 8.594
geometric series k: 0.8603
Hurlbert's PIE: 0.8767
Shannon's H: 2.5170
Good's u: 0.9333
Each square represents a species. Square sizes are proportional to counts.
Register