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=2320 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2320SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2255SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2320 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duttaphrynus' AND (junior_species='melanostictus' OR junior_species='melanostictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Duttaphrynus' AND (species='melanostictus' OR species='melanostictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duttaphrynus' AND (species='melanostictus' OR species='melanostictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duttaphrynus' AND (junior_species='melanostictus' OR junior_species='melanostictus')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='Duttaphrynus' AND (species='melanostictus' OR species='melanostictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zakerana' AND (junior_species='kirtisinghei' OR junior_species='kirtisingheii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zakerana' AND (species='kirtisinghei' OR species='kirtisingheii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zakerana' AND (species='kirtisinghei' OR species='kirtisingheii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zakerana' AND (junior_species='kirtisinghei' OR junior_species='kirtisingheii')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='Zakerana' AND (species='kirtisinghei' OR species='kirtisingheii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zakerana' AND (junior_species='syhadrensis' OR junior_species='syhadrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zakerana' AND (species='syhadrensis' OR species='syhadrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zakerana' AND (species='syhadrensis' OR species='syhadrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zakerana' AND (junior_species='syhadrensis' OR junior_species='syhadrensis')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='Zakerana' AND (species='syhadrensis' OR species='syhadrensis') 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='Pseudophilautus' AND (junior_species='popularis' OR junior_species='popularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudophilautus' AND (species='popularis' OR species='popularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudophilautus' AND (species='popularis' OR species='popularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='popularis' OR junior_species='popularis')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='Pseudophilautus' AND (species='popularis' OR species='popularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='stictomerus' OR junior_species='stictomerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudophilautus' AND (species='stictomerus' OR species='stictomerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudophilautus' AND (species='stictomerus' OR species='stictomerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='stictomerus' OR junior_species='stictomerus')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='Pseudophilautus' AND (species='stictomerus' OR species='stictomerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahaetulla' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ahaetulla' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ahaetulla' AND (species='nasuta' OR species='nasuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahaetulla' AND (junior_species='nasuta' OR junior_species='nasuta')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='Ahaetulla' AND (species='nasuta' OR species='nasuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidura' AND (junior_species='guentheri' OR junior_species='guentherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidura' AND (species='guentheri' OR species='guentherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidura' AND (species='guentheri' OR species='guentherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidura' AND (junior_species='guentheri' OR junior_species='guentherii')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='Aspidura' AND (species='guentheri' OR species='guentherii') 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='Naja' AND (junior_species='naja' OR junior_species='naja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naja' AND (species='naja' OR species='naja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naja' AND (species='naja' OR species='naja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='naja' OR junior_species='naja')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='Naja' AND (species='naja' OR species='naja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptyas' AND (junior_species='mucosa' OR junior_species='mucosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptyas' AND (species='mucosa' OR species='mucosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptyas' AND (species='mucosa' OR species='mucosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptyas' AND (junior_species='mucosa' OR junior_species='mucosa')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='Ptyas' AND (species='mucosa' OR species='mucosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='calotes' OR junior_species='calotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calotes' AND (species='calotes' OR species='calotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calotes' AND (species='calotes' OR species='calotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='calotes' OR junior_species='calotes')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='calotes' OR species='calotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calotes' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calotes' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='versicolor' OR junior_species='versicolor')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='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' 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='Eutropis' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' 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='Eutropis' AND (species='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='frenatus' OR species='frenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='frenatus' OR species='frenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')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='Hemidactylus' AND (species='frenatus' OR species='frenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='parvimaculatus' OR junior_species='parvimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='parvimaculatus' OR species='parvimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='parvimaculatus' OR species='parvimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='parvimaculatus' OR junior_species='parvimaculatus')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='Hemidactylus' AND (species='parvimaculatus' OR species='parvimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='dorsicatenatus' OR junior_species='dorsicatenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lankascincus' AND (species='dorsicatenatus' OR species='dorsicatenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lankascincus' AND (species='dorsicatenatus' OR species='dorsicatenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lankascincus' AND (junior_species='dorsicatenatus' OR junior_species='dorsicatenatus')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='dorsicatenatus' OR species='dorsicatenatus') 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='Lyriocephalus' AND (junior_species='scutatus' OR junior_species='scutatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lyriocephalus' AND (species='scutatus' OR species='scutatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lyriocephalus' AND (species='scutatus' OR species='scutatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyriocephalus' AND (junior_species='scutatus' OR junior_species='scutatus')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='Lyriocephalus' AND (species='scutatus' OR species='scutatus') 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='Varanus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Varanus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2320 The Ecological Register: Mahausakande (abandoned rubber, diurnal)
Mahausakande (abandoned rubber, diurnal)
Basic information
Sample name: Mahausakande (abandoned rubber, diurnal)

Reference: M. Wickramasinghe, C. Bambaradeniya, D. Vidanapathirana, and S. Karunaratna. 2012. Diversity of herpetofauna in Mahausakande: a regenerating rainforest in Sri Lanka. Mahausakande Tropical Rainforest Regeneration Initiative, Research Paper 1:1-40 [ER 2255]
Geography
Country: Sri Lanka

State: Sabaragamuwa


Coordinate: 6° 35' N, 80° 35' E
Coordinate basis: based on political unit

Geography comments: "in the Ratnapura district... The site consists of approximately 40 acres spread across a hilly terrain, with its altitude ranging from 80-1100 m asl" (coordinate based on Ratnapura District)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: plantation

Protection: unprotected

Substrate: ground surface

MAT: 31.0

MAP: 4000.0

Habitat comments: "regenerating tropical rain forest... The site was managed as a rubber plantation till year 2003, which was subsequently abandoned in order to initiate a restoration program to establish a tropical rainforest. The area receives an annual rainfall of over 4000 mm, and the mean temperature is around 31ยบ C"

Methods
Life forms: lizards,snakes,caecilians,frogs

Sites: 4

Sampling methods: no design,hand capture

Sample size: 109 individuals

Years: 2011

Sampling comments: "Field observations were made over a period of four months, extending from April to July 2011... Observations were made by walking through representative terrestrial habitat types, and at the edge of man-made ponds during day and night time. Torch, and head lamps were used to observe species during night time. The specimens encountered were caught, measured (the length from the tip of the snout to the vent), sexed, and checked for any deformities"
there were four "Sampling replicates per habitat type" (presumably meaning separate sites)

Metadata
Sample number: 2320

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-22 12:55:48

Modified: 2020-01-14 09:48:04

Abundance distribution
21 species
8 singletons
total count 109
extrapolated richness: 46.0
Fisher's α: 7.738
geometric series k: 0.8422
Hurlbert's PIE: 0.8609
Shannon's H: 2.4016
Good's u: 0.9271
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Duttaphrynus melanostictus4
Zakerana kirtisinghei6
Zakerana syhadrensis31
Ichthyophis glutinosus1
Pseudophilautus popularis1
Pseudophilautus stictomerus1
Ahaetulla nasuta2
Aspidura guentheri3
Lycodon striatus1
Naja naja1
Ptyas mucosa1
Calotes calotes3
Calotes versicolor13
Eutropis carinata3
Hemidactylus frenatus4
Hemidactylus parvimaculatus2
Lankascincus dorsicatenatus2
Lankascincus fallax14
Lyriocephalus scutatus1
Otocryptis wiegmanni14
Varanus bengalensis1