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=790 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=790SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=438SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=790 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyacopterus' AND (junior_species='spadiceus' OR junior_species='spadiceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyacopterus' AND (species='spadiceus' OR species='spadiceus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyacopterus' AND (junior_species='spadiceus' OR junior_species='spadiceus')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='Dyacopterus' AND (species='spadiceus' OR species='spadiceus') ORDER BY year,last_namesSELECT 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='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='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='Emballonura' AND (junior_species='monticola' OR junior_species='monticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emballonura' AND (species='monticola' OR species='monticola') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emballonura' AND (junior_species='monticola' OR junior_species='monticola')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='Emballonura' AND (species='monticola' OR species='monticola') 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='Nycteris' AND (junior_species='tragata' OR junior_species='tragata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nycteris' AND (species='tragata' OR species='tragata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nycteris' AND (junior_species='tragata' OR junior_species='tragata')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='Nycteris' AND (species='tragata' OR species='tragata') 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='Rhinolophus' AND (junior_species='luctus' OR junior_species='luctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='luctus' OR species='luctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='luctus' OR junior_species='luctus')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='luctus' OR species='luctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='ridleyi' OR junior_species='ridleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='ridleyi' OR species='ridleyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='ridleyi' OR junior_species='ridleyii')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='ridleyi' OR species='ridleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='doriae' OR junior_species='doriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='doriae' OR species='doriae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='doriae' OR junior_species='doriae')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='doriae' OR species='doriae') 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='Myotis' AND (junior_species='hasseltii' OR junior_species='hasselti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='hasseltii' OR species='hasselti') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='hasseltii' OR junior_species='hasselti')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='hasseltii' OR species='hasselti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='suilla' OR junior_species='suilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murina' AND (species='suilla' OR species='suilla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='suilla' OR junior_species='suilla')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='suilla' OR species='suilla') 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='rozendaali' OR junior_species='rozendaalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murina' AND (species='rozendaali' OR species='rozendaalii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='rozendaali' OR junior_species='rozendaalii')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='rozendaali' OR species='rozendaalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murina' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murina' AND (junior_species='aenea' OR junior_species='aenea')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='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='minuta' OR junior_species='minuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='minuta' OR species='minuta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='minuta' OR junior_species='minuta')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='minuta' OR species='minuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='intermedia' OR junior_species='intermedia')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='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kerivoula' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kerivoula' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='pellucida' OR junior_species='pellucida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kerivoula' AND (species='pellucida' OR species='pellucida') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kerivoula' AND (junior_species='pellucida' OR junior_species='pellucida')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='pellucida' OR species='pellucida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoniscus' AND (junior_species='atrox' OR junior_species='atrox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoniscus' AND (species='atrox' OR species='atrox') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoniscus' AND (junior_species='atrox' OR junior_species='atrox')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='Phoniscus' AND (species='atrox' OR species='atrox') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=790 The Ecological Register: Camp Leakey Study Area
Camp Leakey Study Area
Basic information
Sample name: Camp Leakey Study Area

Sample aka: Tanjung Puting National Park

Reference: M. J. Struebig, B. M. F. Galdikas, and . Suatma. 2006. Bat diversity in oligotrophic forests of southern Borneo. Oryx 40(4):447-455 [ER 438]
Geography
Country: Indonesia

State: Central Kalimantan


Coordinate: 2° 56' 7" S, 112° 2' 25" E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Tanjung Puting National Park

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

WMT: 26.9

CMT: 25.4

MAP: 4392.0

Habitat comments: "a heath forest that is swampy in parts"
climate based on station 96413 (Kuching)

Methods
Life forms: bats

Sampling methods: no design,harp nets,mist nets

Sample size: 548 captures or sightings

Years: 2004

Net or trap nights: 245

Sampling comments: 245 dusk to dawn harp trap nights, 16 mist net hours, and 42 canopy net hours
all individuals were released

Metadata
Sample number: 790

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-12 21:45:02

Modified: 2014-04-24 09:46:53

Abundance distribution
25 species
6 singletons
total count 548
extrapolated richness: 39.9
Fisher's α: 5.400
geometric series k: 0.7912
Hurlbert's PIE: 0.7155
Shannon's H: 1.9200
Good's u: 0.9891
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Dyacopterus spadiceus175.7 g frugivore
Balionycteris maculata1513.1 g frugivore
Cynopterus brachyotis830.4 g frugivore-nectarivore
Macroglossus minimus117.0 g frugivore
Emballonura monticola125.2 g insectivore
Megaderma spasma224.2 g insectivore
Nycteris tragata816.2 g insectivore
Rhinolophus sedulus407.8 g insectivore
Rhinolophus trifoliatus5813.6 g insectivore
Rhinolophus luctus231.3 g insectivore
Hipposideros ridleyi59.1 g insectivore
Hipposideros doriae14.6 g
Myotis muricola15.0 g insectivore
Myotis hasseltii17.4 g insectivore
Murina suilla183.9 g insectivore
Murina cyclotis29.0 g insectivore
Murina rozendaali34.2 g insectivore
Murina aenea17.1 g insectivore
Kerivoula minuta102.7 g insectivore
Kerivoula intermedia2763.0 g insectivore
Kerivoula sp. papillosa small7
K.lenis
Kerivoula sp. papillosa large54
Kerivoula hardwickii105.5 g insectivore
Kerivoula pellucida96.5 g insectivore
Phoniscus atrox34.7 g insectivore