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=703 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=703SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=370SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=703 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balionycteris' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balionycteris' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balionycteris' AND (junior_species='maculata' OR junior_species='maculata')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='Balionycteris' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironax' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chironax' AND (species='melanocephalus' OR species='melanocephalus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironax' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')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='Chironax' AND (species='melanocephalus' OR species='melanocephalus') 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='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='Eonycteris' AND (junior_species='spelaea' OR junior_species='spelaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eonycteris' AND (species='spelaea' OR species='spelaea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eonycteris' AND (junior_species='spelaea' OR junior_species='spelaea')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='Eonycteris' AND (species='spelaea' OR species='spelaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macroglossus' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macroglossus' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macroglossus' AND (junior_species='minimus' OR junior_species='minimus')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='Macroglossus' AND (species='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthetor' AND (junior_species='lucasi' OR junior_species='lucasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penthetor' AND (species='lucasi' OR species='lucasii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthetor' AND (junior_species='lucasi' OR junior_species='lucasii')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='Penthetor' AND (species='lucasi' OR species='lucasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='amplexicaudatus' OR junior_species='amplexicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rousettus' AND (species='amplexicaudatus' OR species='amplexicaudatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='amplexicaudatus' OR junior_species='amplexicaudatus')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='amplexicaudatus' OR species='amplexicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='cervinus' OR junior_species='cervinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='cervinus' OR species='cervinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='cervinus' OR junior_species='cervinus')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='cervinus' OR species='cervinus') 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='Hipposideros' AND (junior_species='dyacorum' OR junior_species='dyacorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='dyacorum' OR species='dyacorum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='dyacorum' OR junior_species='dyacorum')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='dyacorum' OR species='dyacorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glischropus' AND (junior_species='tylopus' OR junior_species='tylopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glischropus' AND (species='tylopus' OR species='tylopus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glischropus' AND (junior_species='tylopus' OR junior_species='tylopus')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='Glischropus' AND (species='tylopus' OR species='tylopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperoptenus' 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='Hesperoptenus' AND (species='blanfordi' OR species='blanfordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperoptenus' AND (species='blanfordi' OR species='blanfordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperoptenus' 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='Hesperoptenus' AND (species='blanfordi' OR species='blanfordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philetor' AND (junior_species='brachypterus' OR junior_species='brachypterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philetor' AND (species='brachypterus' OR species='brachypterus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philetor' AND (junior_species='brachypterus' OR junior_species='brachypterus')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='Philetor' AND (species='brachypterus' OR species='brachypterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipistrellus' AND (junior_species='tenuis' OR junior_species='tenuis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipistrellus' AND (species='tenuis' OR species='tenuis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipistrellus' AND (junior_species='tenuis' OR junior_species='tenuis')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='Pipistrellus' AND (species='tenuis' OR species='tenuis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='borneensis' OR junior_species='borneensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='borneensis' OR species='borneensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='borneensis' OR junior_species='borneensis')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='borneensis' OR species='borneensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='sedulus' OR junior_species='sedulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='sedulus' OR species='sedulus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='sedulus' OR junior_species='sedulus')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='sedulus' OR species='sedulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='trifoliatus' OR junior_species='trifoliatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='trifoliatus' OR species='trifoliatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='trifoliatus' OR junior_species='trifoliatus')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='trifoliatus' OR species='trifoliatus') 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 * FROM register WHERE sample_no=703 The Ecological Register: Lambir Hills National Park (primary forests)
Lambir Hills National Park (primary forests)
Basic information
Sample name: Lambir Hills National Park (primary forests)

Reference: D. Fukuda, O. Braken Tisen, K. Momose, and S. Sakai. 2009. Bat diversity in the vegetation mosaic around a lowland dipterocarp forest of Borneo. Raffles Bulletin of Zoology 57(1):213-221 [ER 370]
Geography
Country: Malaysia

State: Sarawak


Coordinate: 4° 2' N, 113° 50' E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 27.0

MAP: 2600.0

Habitat comments: climate data given by Kishimoto-Yamada et al. (2011)

Methods
Life forms: bats

Sampling methods: harp nets,mist nets

Sample size: 129 captures or sightings

Years: 2005, 2006

Sampling comments: "two to four [mist] nets" per net night and "occasionally harp traps"; total number of net nights is unclear but apparently five days per net and four days per trap during each of four surveys

Metadata
Sample number: 703

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-02 14:01:37

Modified: 2014-04-25 01:18:38

Abundance distribution
19 species
4 singletons
total count 129
extrapolated richness: 32.6
Fisher's α: 6.149
geometric series k: 0.8249
Hurlbert's PIE: 0.8674
Shannon's H: 2.3799
Good's u: 0.9696
Each square represents a species. Square sizes are proportional to counts.
Register