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=767 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=767SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=421SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=767 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopoma' AND (junior_species='microphyllum' OR junior_species='microphyllum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinopoma' AND (species='microphyllum' OR species='microphyllum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopoma' AND (junior_species='microphyllum' OR junior_species='microphyllum')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='Rhinopoma' AND (species='microphyllum' OR species='microphyllum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopoma' 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='Rhinopoma' AND (species='hardwickii' OR species='hardwicki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinopoma' AND (species='hardwickii' OR species='hardwicki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopoma' 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='Rhinopoma' AND (species='hardwickii' OR species='hardwicki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='nudiventris' OR junior_species='nudiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taphozous' AND (species='nudiventris' OR species='nudiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taphozous' AND (species='nudiventris' OR species='nudiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='nudiventris' OR junior_species='nudiventris')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='Taphozous' AND (species='nudiventris' OR species='nudiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='perforates' OR junior_species='perforates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taphozous' AND (species='perforates' OR species='perforates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taphozous' AND (species='perforates' OR species='perforates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='perforates' OR junior_species='perforates')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='Taphozous' AND (species='perforates' OR species='perforates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='melanopogon' OR junior_species='melanopogon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taphozous' AND (species='melanopogon' OR species='melanopogon') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taphozous' AND (junior_species='melanopogon' OR junior_species='melanopogon')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='Taphozous' AND (species='melanopogon' OR species='melanopogon') 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 * FROM register WHERE sample_no=767
Reference:A. Purohit, P. Soni, A. Kaur, and H. Ram. 2013. Eco-status of chiropteran fauna in and around Barmer, India. International Journal of Conservation Science4(1):119-123 [ER 421]
Geography
Country: India
State: Rajasthan
Coordinate:25° 39' 29" N, 71° 23' 16" E
Coordinate basis: stated in text
•
Environment
Habitat: desert/xeric shrubland
Altered habitat: inhabited area
Protection: unprotected
Substrate: ground surface
WMT: 33.4
CMT: 16.7
MAP: 208.0
Habitat comments: "Thar desert" and specifically "an Ancent temple and surrounded by hills" within the city of Barmer
climate data based on station 41768 (Chor)
Methods
Life forms: bats
Sampling methods: no design,visual
Sample size: 4524 individuals
Years: 2011, 2012
Sampling comments: counts are maximum observed number of individuals across three different censuses of roosts
Metadata
Sample number: 767
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-04-07 11:52:54
Modified: 2020-01-14 05:26:14
Abundance distribution
6 species
0 singletons
total count 4524
extrapolated richness: 6.1
Fisher's α: 0.682
geometric series k: 0.3807
Hurlbert's PIE: 0.6058
Shannon's H: 1.1093
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.