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=819 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=819SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=461SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=819 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')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='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='tricolor' OR species='tricolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='tricolor' OR species='tricolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='tricolor' OR junior_species='tricolor')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='tricolor' OR species='tricolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afronycteris' AND (junior_species='nanus' OR junior_species='nanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Afronycteris' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Afronycteris' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afronycteris' AND (junior_species='nanus' OR junior_species='nanus')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='Afronycteris' AND (species='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoromicia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoromicia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoromicia' AND (junior_species='capensis' OR junior_species='capensis')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='Neoromicia' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotophilus' AND (junior_species='dinganii' OR junior_species='dingani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotophilus' AND (species='dinganii' OR species='dingani') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotophilus' AND (junior_species='dinganii' OR junior_species='dingani')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='Scotophilus' AND (species='dinganii' OR species='dingani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadarida' AND (junior_species='aegyptiaca' OR junior_species='aegyptiaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tadarida' AND (species='aegyptiaca' OR species='aegyptiaca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadarida' AND (junior_species='aegyptiaca' OR junior_species='aegyptiaca')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='Tadarida' AND (species='aegyptiaca' OR species='aegyptiaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='clivosus' OR junior_species='clivosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='clivosus' OR species='clivosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='clivosus' OR junior_species='clivosus')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='clivosus' OR species='clivosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='caffer' OR junior_species='caffer')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='caffer' OR species='caffer') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=819 The Ecological Register: Ithala Game Reserve
Ithala Game Reserve
Basic information
Sample name: Ithala Game Reserve

Reference: E. C. J. Seamark and T. C. Kearney. 2004. Bats (Chiroptera) of Ithala Game Reserve, northern Kwazulu-Natal, South Africa. Durban Museum Novitates 29:1-4 [ER 461]
Geography
Country: South Africa

State: KwaZulu-Natal


Coordinate: 27° 29' S, 31° 15' E
Coordinate basis: stated in text

Geography comments: coordinate is midpoint of values given in text

•
Environment
Habitat: tropical/subtropical savanna

Protection: wildlife protected area

Substrate: ground surface

WMT: 24.6

CMT: 16.9

MAP: 1010.0

Habitat comments: climate based on station 68588 (Durban Airport)

Methods
Life forms: bats

Sites: 10

Sampling methods: no design,mist nets

Sample size: 44 individuals

Years: 1998

Days: 9

Metadata
Sample number: 819

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-17 20:41:09

Modified: 2014-04-24 07:22:23

Abundance distribution
8 species
0 singletons
total count 44
extrapolated richness: 10.6
Fisher's α: 2.861
geometric series k: 0.7654
Hurlbert's PIE: 0.8256
Shannon's H: 1.9170
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
Miniopterus schreibersii712.4 g insectivore
Myotis tricolor3
Afronycteris nanus5
"Neoromicia nanus"
Neoromicia capensis135.0 g insectivore
Scotophilus dinganii424.3 g insectivore
Tadarida aegyptiaca218.0 g
Rhinolophus clivosus716.8 g insectivore
Hipposideros caffer39.7 g insectivore