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=364 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=364SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=163SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=364 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptolalax' AND (junior_species='pelodytoides' OR junior_species='pelodytoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptolalax' AND (junior_species='pelodytoides' OR junior_species='pelodytoides')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='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophrys' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenophrys' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenophrys' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophrys' AND (junior_species='major' OR junior_species='major')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='Xenophrys' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='gyldenstolpei' OR junior_species='gyldenstolpeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='gyldenstolpei' OR junior_species='gyldenstolpeii')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='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='kuhlii' OR junior_species='kuhli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='kuhlii' OR species='kuhli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='kuhlii' OR species='kuhli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='kuhlii' OR junior_species='kuhli')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='Limnonectes' AND (species='kuhlii' OR species='kuhli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limborgi' OR junior_species='limborgii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='limborgi' OR species='limborgii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='limborgi' OR species='limborgii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limborgi' OR junior_species='limborgii')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='Limnonectes' AND (species='limborgi' OR species='limborgii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='cubitalis' OR junior_species='cubitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='cubitalis' OR species='cubitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='cubitalis' OR species='cubitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='cubitalis' OR junior_species='cubitalis')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='Hylarana' AND (species='cubitalis' OR species='cubitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='nigrovittata' OR junior_species='nigrovittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='nigrovittata' OR species='nigrovittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='nigrovittata' OR species='nigrovittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='nigrovittata' OR junior_species='nigrovittata')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='Hylarana' AND (species='nigrovittata' OR species='nigrovittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='taipehensis' OR junior_species='taipehensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='taipehensis' OR species='taipehensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='taipehensis' OR species='taipehensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='taipehensis' OR junior_species='taipehensis')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='Hylarana' AND (species='taipehensis' OR species='taipehensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='aureola' OR junior_species='aureola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odorrana' AND (species='aureola' OR species='aureola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odorrana' AND (species='aureola' OR species='aureola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='aureola' OR junior_species='aureola')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='Odorrana' AND (species='aureola' OR species='aureola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='chloronota' OR junior_species='chloronota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odorrana' AND (species='chloronota' OR species='chloronota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odorrana' AND (species='chloronota' OR species='chloronota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='chloronota' OR junior_species='chloronota')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='Odorrana' AND (species='chloronota' OR species='chloronota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquixalus' AND (junior_species='bisacculus' OR junior_species='bisacculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquixalus' AND (species='bisacculus' OR species='bisacculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquixalus' AND (species='bisacculus' OR species='bisacculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquixalus' AND (junior_species='bisacculus' OR junior_species='bisacculus')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='Aquixalus' AND (species='bisacculus' OR species='bisacculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philautus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philautus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='parvulus' OR junior_species='parvulus')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='Philautus' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='leucomystax' OR species='leucomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')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='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')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='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micryletta' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micryletta' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micryletta' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micryletta' AND (junior_species='inornata' OR junior_species='inornata')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='Micryletta' AND (species='inornata' OR species='inornata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=364 The Ecological Register: Nam San Noi (950 m)
Nam San Noi (950 m)
Basic information
Sample name: Nam San Noi (950 m)

Sample aka: Phuluang Wildlife Sanctuary

Reference: R. Phochayavanich, H. K. Voris, W. Khonsue, S. Thunhikorn, and K. Thirakhupt. 2010. Comparison of stream frog assemblages at three elevations in an evergreen forest, north-central Thailand. Zoological Studies 49(5):632-639 [ER 163]
Geography
Country: Thailand


Coordinate: 17° 13' 30" N, 101° 18' 30" E
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: wildlife protected area

Substrate: ground surface

WMT: 31.7

CMT: 24.3

MAP: 1229.0

Habitat comments: "tropical evergreen forest"
MAP stated in text; CMT and WMT based on station 48378 (Nai Mueang), which is almost at the same altitude and has almost the same MAP

Methods
Life forms: frogs

Site length: 100

Sampling methods: line transect,visual

Sample size: 1285 individuals

Years: 2006, 2007

Sampling comments: "visual encounter surveys on 100 m transects"

Metadata
Sample number: 364

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-13 16:05:02

Modified: 2014-05-04 06:30:10

Abundance distribution
15 species
4 singletons
total count 1285
extrapolated richness: 23.3
Fisher's α: 2.384
geometric series k: 0.6249
Hurlbert's PIE: 0.6302
Shannon's H: 1.3816
Good's u: 0.9969
Each square represents a species. Square sizes are proportional to counts.
Register