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=817 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=817SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=459SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=817 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalinolobus' AND (junior_species='gouldii' OR junior_species='gouldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalinolobus' AND (species='gouldii' OR species='gouldi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalinolobus' AND (junior_species='gouldii' OR junior_species='gouldi')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='Chalinolobus' AND (species='gouldii' OR species='gouldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalinolobus' AND (junior_species='morio' OR junior_species='morio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalinolobus' AND (species='morio' OR species='morio') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalinolobus' AND (junior_species='morio' OR junior_species='morio')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='Chalinolobus' AND (species='morio' OR species='morio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='darlingtoni' OR junior_species='darlingtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vespadelus' AND (species='darlingtoni' OR species='darlingtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vespadelus' AND (species='darlingtoni' OR species='darlingtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='darlingtoni' OR junior_species='darlingtonii')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='Vespadelus' AND (species='darlingtoni' OR species='darlingtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='regulus' OR junior_species='regulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vespadelus' AND (species='regulus' OR species='regulus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='regulus' OR junior_species='regulus')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='Vespadelus' AND (species='regulus' OR species='regulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='vulturnus' OR junior_species='vulturnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vespadelus' AND (species='vulturnus' OR species='vulturnus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespadelus' AND (junior_species='vulturnus' OR junior_species='vulturnus')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='Vespadelus' AND (species='vulturnus' OR species='vulturnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctophilus' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctophilus' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctophilus' AND (junior_species='geoffroyi' OR junior_species='geoffroyii')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='Nyctophilus' AND (species='geoffroyi' OR species='geoffroyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctophilus' AND (junior_species='gouldi' OR junior_species='gouldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctophilus' AND (species='gouldi' OR species='gouldii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctophilus' AND (junior_species='gouldi' OR junior_species='gouldii')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='Nyctophilus' AND (species='gouldi' OR species='gouldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mormopterus' AND (junior_species='planiceps' OR junior_species='planiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mormopterus' AND (species='planiceps' OR species='planiceps') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mormopterus' AND (junior_species='planiceps' OR junior_species='planiceps')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='Mormopterus' AND (species='planiceps' OR species='planiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falsistrellus' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falsistrellus' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falsistrellus' AND (species='tasmaniensis' OR species='tasmaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falsistrellus' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')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='Falsistrellus' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='adversus' OR junior_species='adversus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='adversus' OR species='adversus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='adversus' OR junior_species='adversus')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='adversus' OR species='adversus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotorepens' AND (junior_species='balstoni' OR junior_species='balstonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotorepens' AND (species='balstoni' OR species='balstonii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotorepens' AND (junior_species='balstoni' OR junior_species='balstonii')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='Scotorepens' AND (species='balstoni' OR species='balstonii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=817
Reference:J. R. Speakman, L. F. Lumsden, and G. C. Hays. 1994. Predation rates on bats released to fly during daylight in south-eastern Australia. Journal of Zoology233:318-321 [ER 459]
Geography
Country: Australia
State: Victoria
Coordinate:37° 5' S, 144° 13' E
Coordinate basis: based on nearby landmark
Geography comments: "the majority" of bats were captured "in the Central Highlands, a large forested area to the east of Melbourne" (coordinate based on Central Highlands)
•
Environment
Habitat: temperate broadleaf/mixed forest
Substrate: ground surface
WMT: 19.2
CMT: 9.6
MAP: 544.0
Habitat comments: climate based on station 94865 (Hoppers Crossing)
Methods
Life forms: bats
Sampling methods: no design,harp nets
Sample size: 997 captures or sightings
Years: 1989, 1990
Metadata
Sample number: 817
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-04-17 19:57:40
Modified: 2014-04-24 07:25:19
Abundance distribution
11 species
1 singleton
total count 997
extrapolated richness: 13.7
Fisher's α: 1.730
geometric series k: 0.5666
Hurlbert's PIE: 0.8036
Shannon's H: 1.7890
Good's u: 0.9990
Each square represents a species. Square sizes are proportional to counts.