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=459 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=459SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=223SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=459 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercaspis' AND (junior_species='carinatus' OR junior_species='carinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercaspis' AND (species='carinatus' OR species='carinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercaspis' AND (species='carinatus' OR species='carinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercaspis' AND (junior_species='carinatus' OR junior_species='carinatus')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='Cercaspis' AND (species='carinatus' OR species='carinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodon' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycodon' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycodon' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodon' AND (junior_species='striatus' OR junior_species='striatus')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='Lycodon' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligodon' AND (junior_species='sublineatus' OR junior_species='sublineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligodon' AND (species='sublineatus' OR species='sublineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligodon' AND (species='sublineatus' OR species='sublineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligodon' AND (junior_species='sublineatus' OR junior_species='sublineatus')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='Oligodon' AND (species='sublineatus' OR species='sublineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligodon' AND (junior_species='arnensis' OR junior_species='arnensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligodon' AND (species='arnensis' OR species='arnensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligodon' AND (species='arnensis' OR species='arnensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligodon' AND (junior_species='arnensis' OR junior_species='arnensis')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='Oligodon' AND (species='arnensis' OR species='arnensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='braminus' OR junior_species='braminus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='braminus' OR species='braminus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='braminus' OR species='braminus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='braminus' OR junior_species='braminus')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='Ramphotyphlops' AND (species='braminus' OR species='braminus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrophis' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cylindrophis' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cylindrophis' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrophis' AND (junior_species='maculata' OR junior_species='maculata')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='Cylindrophis' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnale' AND (junior_species='hypnale' OR junior_species='hypnale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypnale' AND (species='hypnale' OR species='hypnale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypnale' AND (species='hypnale' OR species='hypnale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnale' AND (junior_species='hypnale' OR junior_species='hypnale')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='Hypnale' AND (species='hypnale' OR species='hypnale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='liolepis' OR junior_species='liolepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calotes' AND (species='liolepis' OR species='liolepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calotes' AND (species='liolepis' OR species='liolepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='liolepis' OR junior_species='liolepis')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='Calotes' AND (species='liolepis' OR species='liolepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocryptis' AND (junior_species='wiegmanni' OR junior_species='wiegmannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otocryptis' AND (species='wiegmanni' OR species='wiegmannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otocryptis' AND (species='wiegmanni' OR species='wiegmannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocryptis' AND (junior_species='wiegmanni' OR junior_species='wiegmannii')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='Otocryptis' AND (species='wiegmanni' OR species='wiegmannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophora' AND (junior_species='aspera' OR junior_species='aspera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratophora' AND (species='aspera' OR species='aspera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratophora' AND (species='aspera' OR species='aspera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophora' AND (junior_species='aspera' OR junior_species='aspera')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='Ceratophora' AND (species='aspera' OR species='aspera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='carinata' OR junior_species='carinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='carinata' OR junior_species='carinata')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='Mabuya' AND (species='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessia' AND (junior_species='bertoni' OR junior_species='bertonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nessia' AND (species='bertoni' OR species='bertonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nessia' AND (species='bertoni' OR species='bertonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessia' AND (junior_species='bertoni' OR junior_species='bertonii')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='Nessia' AND (species='bertoni' OR species='bertonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='gansi' OR junior_species='gansii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lankascincus' AND (species='gansi' OR species='gansii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lankascincus' AND (species='gansi' OR species='gansii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='gansi' OR junior_species='gansii')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='Lankascincus' AND (species='gansi' OR species='gansii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lankascincus' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lankascincus' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='fallax' OR junior_species='fallax')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='Lankascincus' AND (species='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichthyophis' AND (junior_species='glutinosus' OR junior_species='glutinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ichthyophis' AND (species='glutinosus' OR species='glutinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ichthyophis' AND (species='glutinosus' OR species='glutinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichthyophis' AND (junior_species='glutinosus' OR junior_species='glutinosus')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='Ichthyophis' AND (species='glutinosus' OR species='glutinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='atukoralei' OR junior_species='atukoraleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='atukoralei' OR species='atukoraleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='atukoralei' OR species='atukoraleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='atukoralei' OR junior_species='atukoraleii')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='Bufo' AND (species='atukoralei' OR species='atukoraleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limnocaris' OR junior_species='limnocaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='limnocaris' OR species='limnocaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='limnocaris' OR species='limnocaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limnocaris' OR junior_species='limnocaris')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='limnocaris' OR species='limnocaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='corrugatus' OR junior_species='corrugatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='corrugatus' OR species='corrugatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='corrugatus' OR species='corrugatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='corrugatus' OR junior_species='corrugatus')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='corrugatus' OR species='corrugatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philautus' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philautus' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='variabilis' OR junior_species='variabilis')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='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='aurantiaca' OR species='aurantiaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')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='Rana' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=459 The Ecological Register: Kottawa Forest Reserve
Kottawa Forest Reserve
Basic information
Sample name: Kottawa Forest Reserve

Sample aka: Yakkalamulla

Reference: S. N. Gamage, A. Gunawardena, D. K. Weerakoon, and W. K. D. D. Liyanage. 2008. A comparative study of the leaf litter herpetofauna and physical parameters in different agro-ecosystems (tea, rubber and oil palm) and natural rain forest in the south-western wet-zone of Sri Lanka. Journal of Environmental Research And Development 2(3):285-294 [ER 223]
Geography
Country: Sri Lanka


Coordinate: 6° 6' N, 80° 20' E
Geography comments: coordinate based on Yakkalamulla
elevation 30 - 100 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

WMT: 28.8

CMT: 26.6

MAP: 2510.0

Habitat comments: MAP stated in text; CMT and WMT based on station 43497 (Ambalantota)

Methods
Life forms: lizards,snakes,caecilians,frogs

Sites: 18

Site area: 0.115

Sampling methods: hand capture

Sample size: 161 individuals

Years: 2003

Sampling comments: 18 8 x 8 m quadrats
all specimens were released

Metadata
Sample number: 459

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-18 11:15:28

Modified: 2014-04-26 10:18:32

Abundance distribution
20 species
4 singletons
total count 161
extrapolated richness: 31.3
Fisher's α: 6.018
geometric series k: 0.8376
Hurlbert's PIE: 0.9062
Shannon's H: 2.5885
Good's u: 0.9754
Each square represents a species. Square sizes are proportional to counts.
Register