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=1168 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1168SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=819SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1168 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='curius' OR junior_species='curius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamproptera' AND (species='curius' OR species='curius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamproptera' AND (species='curius' OR species='curius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamproptera' AND (junior_species='curius' OR junior_species='curius')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='Lamproptera' AND (species='curius' OR species='curius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='chaon' OR junior_species='chaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='chaon' OR species='chaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='chaon' OR species='chaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='chaon' OR junior_species='chaon')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='chaon' OR species='chaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='aeacus' OR junior_species='aeacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troides' AND (species='aeacus' OR species='aeacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troides' AND (species='aeacus' OR species='aeacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='aeacus' OR junior_species='aeacus')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='Troides' AND (species='aeacus' OR species='aeacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='nadina' OR junior_species='nadina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cepora' AND (species='nadina' OR species='nadina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cepora' AND (species='nadina' OR species='nadina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='nadina' OR junior_species='nadina')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='Cepora' AND (species='nadina' OR species='nadina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='thestylis' OR junior_species='thestylis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prioneris' AND (species='thestylis' OR species='thestylis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prioneris' AND (species='thestylis' OR species='thestylis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='thestylis' OR junior_species='thestylis')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='Prioneris' AND (species='thestylis' OR species='thestylis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='mulciber' OR species='mulciber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='mulciber' OR species='mulciber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')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='mulciber' OR species='mulciber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='sita' OR junior_species='sita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='sita' OR species='sita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='sita' OR species='sita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='sita' OR junior_species='sita')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='Parantica' AND (species='sita' OR species='sita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='gemina' OR junior_species='gemina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='gemina' OR species='gemina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='gemina' OR species='gemina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='gemina' OR junior_species='gemina')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='Lethe' AND (species='gemina' OR species='gemina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='naga' OR junior_species='naga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='naga' OR species='naga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='naga' OR species='naga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='naga' OR junior_species='naga')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='Lethe' AND (species='naga' OR species='naga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='syrcis' OR junior_species='syrcis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='syrcis' OR species='syrcis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='syrcis' OR species='syrcis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='syrcis' OR junior_species='syrcis')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='Lethe' AND (species='syrcis' OR species='syrcis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='vindhya' OR junior_species='vindhya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='vindhya' OR species='vindhya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='vindhya' OR species='vindhya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='vindhya' OR junior_species='vindhya')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='Lethe' AND (species='vindhya' OR species='vindhya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malsarida' OR junior_species='malsarida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='malsarida' OR species='malsarida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='malsarida' OR species='malsarida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malsarida' OR junior_species='malsarida')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='malsarida' OR species='malsarida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='nicotia' OR junior_species='nicotia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='nicotia' OR species='nicotia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='nicotia' OR species='nicotia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='nicotia' OR junior_species='nicotia')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='nicotia' OR species='nicotia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neope' AND (species='muirheadi' OR species='muirheadii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')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='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthema' AND (junior_species='lisarda' OR junior_species='lisarda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penthema' AND (species='lisarda' OR species='lisarda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Penthema' AND (species='lisarda' OR species='lisarda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthema' AND (junior_species='lisarda' OR junior_species='lisarda')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='Penthema' AND (species='lisarda' OR species='lisarda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ragadia' AND (junior_species='crisilda' OR junior_species='crisilda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ragadia' AND (species='crisilda' OR species='crisilda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ragadia' AND (species='crisilda' OR species='crisilda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ragadia' AND (junior_species='crisilda' OR junior_species='crisilda')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='Ragadia' AND (species='crisilda' OR species='crisilda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='aerope' OR junior_species='aerope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faunis' AND (species='aerope' OR species='aerope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faunis' AND (species='aerope' OR species='aerope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='aerope' OR junior_species='aerope')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='Faunis' AND (species='aerope' OR species='aerope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalma' AND (junior_species='suffusa' OR junior_species='suffusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stichophthalma' AND (species='suffusa' OR species='suffusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stichophthalma' AND (species='suffusa' OR species='suffusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalma' AND (junior_species='suffusa' OR junior_species='suffusa')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='Stichophthalma' AND (species='suffusa' OR species='suffusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='risa' OR junior_species='risa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersonesia' AND (species='risa' OR species='risa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersonesia' AND (species='risa' OR species='risa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='risa' OR junior_species='risa')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='Chersonesia' AND (species='risa' OR species='risa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='inachus' OR junior_species='inachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallima' AND (species='inachus' OR species='inachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='inachus' OR species='inachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='inachus' OR junior_species='inachus')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='Kallima' AND (species='inachus' OR species='inachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='nicea' OR junior_species='nicea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stibochiona' AND (species='nicea' OR species='nicea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stibochiona' AND (species='nicea' OR species='nicea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='nicea' OR junior_species='nicea')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='Stibochiona' AND (species='nicea' OR species='nicea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vindula' AND (junior_species='erota' OR junior_species='erota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vindula' AND (species='erota' OR species='erota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vindula' AND (species='erota' OR species='erota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vindula' AND (junior_species='erota' OR junior_species='erota')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='Vindula' AND (species='erota' OR species='erota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='fylla' OR junior_species='fylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abisara' AND (species='fylla' OR species='fylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abisara' AND (species='fylla' OR species='fylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='fylla' OR junior_species='fylla')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='Abisara' AND (species='fylla' OR species='fylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zemeros' AND (species='flegyas' OR species='flegyas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zemeros' AND (species='flegyas' OR species='flegyas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')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='Zemeros' AND (species='flegyas' OR species='flegyas') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1168 The Ecological Register: Tam Dao Mountains Nature Reserve (transect 1, forest)
Tam Dao Mountains Nature Reserve (transect 1, forest)
Basic information
Sample name: Tam Dao Mountains Nature Reserve (transect 1, forest)

Reference: K. Spitzer, J. Jaros, J. Havelka, and J. Leps. 1997. Effect of small-scale disturbance on butterfly communities of an Indochinese montane rainforest. Biological Conservation 80(1):9-15 [ER 819]
Geography
Country: Vietnam


Coordinate: 21° 30' N, 105° 40' E
Coordinate basis: stated in text

Geography comments: "75 km north of Hanoi"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: nature reserve

Substrate: ground surface

MAT: 23.7

MAP: 2100.0

Habitat comments: "evergreen montane cloud rainforest"
climate data based on sample 1138

Methods
Life forms: butterflies

Site length: 138

Sampling methods: line transect,visual

Sample size: 187 individuals

Years: 1995

Sampling comments: Pollard walk method with butterflies recorded "in a belt c. 20-40 m wide"

Metadata
Sample number: 1168

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-23 17:30:18

Modified: 2014-09-23 07:30:46

Abundance distribution
24 species
8 singletons
total count 187
extrapolated richness: 52.9
Fisher's α: 7.319
geometric series k: 0.8270
Hurlbert's PIE: 0.7367
Shannon's H: 1.9399
Good's u: 0.9576
Each square represents a species. Square sizes are proportional to counts.
Register