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=2321 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2321SELECT 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=2321 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='Hoplobatrachus' AND (junior_species='crassus' OR junior_species='crassus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplobatrachus' AND (species='crassus' OR species='crassus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplobatrachus' AND (species='crassus' OR species='crassus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplobatrachus' AND (junior_species='crassus' OR junior_species='crassus')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='Hoplobatrachus' AND (species='crassus' OR species='crassus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' 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='Hylarana' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='aurantiaca' OR species='aurantiaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' 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='Hylarana' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='temporalis' OR junior_species='temporalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='temporalis' OR species='temporalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='temporalis' OR species='temporalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='temporalis' OR junior_species='temporalis')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='temporalis' OR species='temporalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='cruciger' OR junior_species='cruciger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='cruciger' OR species='cruciger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='cruciger' OR species='cruciger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='cruciger' OR junior_species='cruciger')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='cruciger' OR species='cruciger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='folicola' OR junior_species='folicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudophilautus' AND (species='folicola' OR species='folicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudophilautus' AND (species='folicola' OR species='folicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='folicola' OR junior_species='folicola')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='folicola' OR species='folicola') 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='schneideri' OR junior_species='schneiderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudophilautus' AND (species='schneideri' OR species='schneiderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudophilautus' AND (species='schneideri' OR species='schneiderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudophilautus' AND (junior_species='schneideri' OR junior_species='schneiderii')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='schneideri' OR species='schneiderii') 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='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='Cercaspis' 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='Cercaspis' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercaspis' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercaspis' 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='Cercaspis' AND (species='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnale' AND (junior_species='zara' OR junior_species='zara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypnale' AND (species='zara' OR species='zara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypnale' AND (species='zara' OR species='zara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnale' AND (junior_species='zara' OR junior_species='zara')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='zara' OR species='zara') 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='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='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='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 * FROM register WHERE sample_no=2321 The Ecological Register: Mahausakande (abandoned rubber, nocturnal)
Mahausakande (abandoned rubber, nocturnal)
Basic information
Sample name: Mahausakande (abandoned rubber, nocturnal)

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,frogs

Sites: 4

Sampling methods: no design,hand capture

Sample size: 273 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: 2321

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-22 13:02:54

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

Abundance distribution
20 species
6 singletons
total count 273
extrapolated richness: 36.1
Fisher's α: 4.970
geometric series k: 0.7925
Hurlbert's PIE: 0.8008
Shannon's H: 2.0098
Good's u: 0.9781
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Duttaphrynus melanostictus7
Zakerana kirtisinghei11
Zakerana syhadrensis74
Hoplobatrachus crassus2
Hylarana aurantiaca1
Hylarana temporalis2
Polypedates cruciger1
Pseudophilautus folicola42
Pseudophilautus popularis83
Pseudophilautus schneideri4
Pseudophilautus stictomerus18
Aspidura guentheri1
Cercaspis carinata1
Hypnale zara3
Calotes calotes1
Calotes versicolor2
Hemidactylus frenatus6
Hemidactylus parvimaculatus5
Lankascincus fallax1
Otocryptis wiegmanni8