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=1307 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1307SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=673SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1307 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')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='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='almana' OR species='almana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='almana' OR species='almana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')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='Junonia' AND (species='almana' OR species='almana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotrioena' AND (junior_species='medus' OR junior_species='medus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orsotrioena' AND (species='medus' OR species='medus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orsotrioena' AND (species='medus' OR species='medus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotrioena' AND (junior_species='medus' OR junior_species='medus')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='Orsotrioena' AND (species='medus' OR species='medus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='baldus' OR species='baldus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')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='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pomona' OR junior_species='pomona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsila' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsila' AND (species='pomona' OR species='pomona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pomona' OR junior_species='pomona')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='Catopsila' AND (species='pomona' OR species='pomona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='core' OR junior_species='core')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='core' OR species='core') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='core' OR species='core')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='core' OR junior_species='core')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='Euploea' AND (species='core' OR species='core') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='hylas' OR species='hylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')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='Neptis' AND (species='hylas' OR species='hylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='atlites' OR species='atlites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='atlites' OR species='atlites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')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='Junonia' AND (species='atlites' OR species='atlites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polytes' OR species='polytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polytes' OR species='polytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')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='Papilio' AND (species='polytes' OR species='polytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='huebneri' OR junior_species='huebnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='huebneri' OR species='huebnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='huebneri' OR species='huebnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='huebneri' OR junior_species='huebnerii')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='Ypthima' AND (species='huebneri' OR species='huebnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pyranthe' OR junior_species='pyranthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsila' AND (species='pyranthe' OR species='pyranthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsila' AND (species='pyranthe' OR species='pyranthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pyranthe' OR junior_species='pyranthe')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='Catopsila' AND (species='pyranthe' OR species='pyranthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='karsandra' OR junior_species='karsandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizeeria' AND (species='karsandra' OR species='karsandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizeeria' AND (species='karsandra' OR species='karsandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='karsandra' OR junior_species='karsandra')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='Zizeeria' AND (species='karsandra' OR species='karsandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')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='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demoleus' OR junior_species='demoleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='demoleus' OR species='demoleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='demoleus' OR species='demoleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demoleus' OR junior_species='demoleus')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='Papilio' AND (species='demoleus' OR species='demoleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantoporia' AND (species='hordonia' OR species='hordonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantoporia' AND (species='hordonia' OR species='hordonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')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='Pantoporia' AND (species='hordonia' OR species='hordonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hierta' OR junior_species='hierta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='hierta' OR species='hierta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='hierta' OR species='hierta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hierta' OR junior_species='hierta')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='Junonia' AND (species='hierta' OR species='hierta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='aristochiae' OR junior_species='aristochiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atrophaneura' AND (species='aristochiae' OR species='aristochiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atrophaneura' AND (species='aristochiae' OR species='aristochiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='aristochiae' OR junior_species='aristochiae')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='Atrophaneura' AND (species='aristochiae' OR species='aristochiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='nephelus' OR junior_species='nephelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='nephelus' OR species='nephelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='nephelus' OR species='nephelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='nephelus' OR junior_species='nephelus')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='Papilio' AND (species='nephelus' OR species='nephelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='otis' OR junior_species='otis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizina' AND (species='otis' OR species='otis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizina' AND (species='otis' OR species='otis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='otis' OR junior_species='otis')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='Zizina' AND (species='otis' OR species='otis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malaya' OR junior_species='malaya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='malaya' OR species='malaya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='malaya' OR species='malaya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malaya' OR junior_species='malaya')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='Mycalesis' AND (species='malaya' OR species='malaya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Udaspes' AND (junior_species='folus' OR junior_species='folus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Udaspes' AND (species='folus' OR species='folus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Udaspes' AND (species='folus' OR species='folus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Udaspes' AND (junior_species='folus' OR junior_species='folus')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='Udaspes' AND (species='folus' OR species='folus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spalgis' AND (junior_species='epius' OR junior_species='epius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spalgis' AND (species='epius' OR species='epius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spalgis' AND (species='epius' OR species='epius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spalgis' AND (junior_species='epius' OR junior_species='epius')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='Spalgis' AND (species='epius' OR species='epius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='blanda' OR junior_species='blanda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='blanda' OR species='blanda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='blanda' OR species='blanda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='blanda' OR junior_species='blanda')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='Eurema' AND (species='blanda' OR species='blanda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnara' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnara' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnara' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnara' AND (junior_species='guttata' OR junior_species='guttata')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='Parnara' AND (species='guttata' OR species='guttata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1307 The Ecological Register: Trishna Wildlife Sanctuary IV
Trishna Wildlife Sanctuary IV
Basic information
Sample name: Trishna Wildlife Sanctuary IV

Reference: J. Majumder, R. Lodh, and B. K. Agarwala. 2012. Variation in butterfly diversity and unique species richness along different habitats in Trishna Wildlife Sanctuary, Tripura, northeast India. Check List 8(3):432-436 [ER 673]
Geography
Country: India

State: Tripura


Coordinate: 23° 16' 33" N, 91° 23' 1" E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: pasture

Protection: wildlife protected area

Substrate: ground surface

MAT: 22.2

MAP: 2559.0

Habitat comments: "tropical semi-evergreen forest, East Himalayan lower Bhabar Sal, moist mixed deciduous forest, and savannah woodland... Annual average rainfall is 255.89 mm [apparently meaning 2558.9]. Temperatures vary from 6.8°C in January to 37.7°C in June"; the transect is specifically in a "grassland of exotic species (Pennisetum purpureum Schumach) along with small Cashew nut plantation"

Methods
Life forms: butterflies

Sites: 1

Site length: 1000

Site width: 5

Sampling methods: belt transect,butterfly nets

Sample size: 174 captures or sightings

Years: 2010

Sampling comments: methods not completely clear, but at least some individuals were "collected" (presumably using nets)

Metadata
Sample number: 1307

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-20 14:41:31

Modified: 2015-02-20 03:41:31

Abundance distribution
24 species
0 singletons
total count 174
extrapolated richness: 29.4
Fisher's α: 7.546
geometric series k: 0.9089
Hurlbert's PIE: 0.9459
Shannon's H: 3.0423
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register