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=422 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=422SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=199SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=422 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphophylax' AND (junior_species='subcristatus' OR junior_species='subcristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coryphophylax' AND (species='subcristatus' OR species='subcristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coryphophylax' AND (species='subcristatus' OR species='subcristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphophylax' AND (junior_species='subcristatus' OR junior_species='subcristatus')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='Coryphophylax' AND (species='subcristatus' OR species='subcristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtodactylus' AND (junior_species='rubidus' OR junior_species='rubidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrtodactylus' AND (species='rubidus' OR species='rubidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrtodactylus' AND (species='rubidus' OR species='rubidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtodactylus' AND (junior_species='rubidus' OR junior_species='rubidus')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='Cyrtodactylus' AND (species='rubidus' OR species='rubidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='andamanensis' OR species='andamanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='andamanensis' OR species='andamanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='andamanensis' OR junior_species='andamanensis')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='andamanensis' OR species='andamanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='verreauxi' OR species='verreauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='verreauxi' OR species='verreauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='verreauxi' OR junior_species='verreauxii')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='Gekko' AND (species='verreauxi' OR species='verreauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='tytleri' OR junior_species='tytlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='tytleri' OR species='tytlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='tytleri' OR species='tytlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='tytleri' OR junior_species='tytlerii')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='tytleri' OR species='tytlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='chakrapani' OR junior_species='chakrapanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='chakrapani' OR species='chakrapanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='chakrapani' OR species='chakrapanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='chakrapani' OR junior_species='chakrapanii')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='chakrapani' OR species='chakrapanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimeresurus' AND (junior_species='andersoni' OR junior_species='andersonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimeresurus' AND (species='andersoni' OR species='andersonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimeresurus' AND (species='andersoni' OR species='andersonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimeresurus' AND (junior_species='andersoni' OR junior_species='andersonii')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='Trimeresurus' AND (species='andersoni' OR species='andersonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodon' AND (junior_species='capucinus' OR junior_species='capucinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycodon' AND (species='capucinus' OR species='capucinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycodon' AND (species='capucinus' OR species='capucinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodon' AND (junior_species='capucinus' OR junior_species='capucinus')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='capucinus' OR species='capucinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerberus' AND (junior_species='rynchops' OR junior_species='rynchops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerberus' AND (species='rynchops' OR species='rynchops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerberus' AND (species='rynchops' OR species='rynchops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerberus' AND (junior_species='rynchops' OR junior_species='rynchops')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='Cerberus' AND (species='rynchops' OR species='rynchops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' 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='Bufo' AND (species='melanostictus' OR species='melanostictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='melanostictus' OR species='melanostictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' 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='Bufo' AND (species='melanostictus' OR species='melanostictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bungarus' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bungarus' AND (species='andamanensis' OR species='andamanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bungarus' AND (species='andamanensis' OR species='andamanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bungarus' AND (junior_species='andamanensis' OR junior_species='andamanensis')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='Bungarus' AND (species='andamanensis' OR species='andamanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platyurus' OR junior_species='platyurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='platyurus' OR species='platyurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='platyurus' OR species='platyurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platyurus' OR junior_species='platyurus')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='platyurus' OR species='platyurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenochrophis' AND (junior_species='tytleri' OR junior_species='tytlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenochrophis' AND (species='tytleri' OR species='tytlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenochrophis' AND (species='tytleri' OR species='tytlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenochrophis' AND (junior_species='tytleri' OR junior_species='tytlerii')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='Xenochrophis' AND (species='tytleri' OR species='tytlerii') 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='Kaloula' AND (junior_species='baleata' OR junior_species='baleata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kaloula' AND (species='baleata' OR species='baleata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kaloula' AND (species='baleata' OR species='baleata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaloula' AND (junior_species='baleata' OR junior_species='baleata')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='Kaloula' AND (species='baleata' OR species='baleata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerana' AND (junior_species='charlesdarwini' OR junior_species='charlesdarwinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ingerana' AND (species='charlesdarwini' OR species='charlesdarwinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ingerana' AND (species='charlesdarwini' OR species='charlesdarwinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerana' AND (junior_species='charlesdarwini' OR junior_species='charlesdarwinii')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='Ingerana' AND (species='charlesdarwini' OR species='charlesdarwinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='andamanense' OR junior_species='andamanense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='andamanense' OR species='andamanense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='andamanense' OR species='andamanense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='andamanense' OR junior_species='andamanense')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='Phelsuma' AND (species='andamanense' OR species='andamanense') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=422 The Ecological Register: Long Island
Long Island
Basic information
Sample name: Long Island

Reference: S. Harikrishnan, S. R. Chandramouli, and K. Vasudevan. 2012. A survey of herpetofauna on Long Island, Andaman and Nicobar Islands, India. Herpetological Bulletin 119:19-28 [ER 199]
Geography
Country: India

State: Andaman and Nicobar Islands


Coordinate: 12.376° N, 92.924° E
Coordinate basis: stated in text

Geography comments: "east of the Middle Andaman Island"
coordinate given in text
"maximum elevation is less than 50 m"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 28.0

CMT: 25.5

MAP: 2797.0

Habitat comments: climate data based on station 43333 (Port Blair)

Methods
Life forms: lizards,snakes,frogs

Sampling methods: timed,visual

Sample size: 494 individuals

Years: 2010

Sampling comments: time-constrained visual encounter surveys plus several other methods (not included in counts)

Metadata
Sample number: 422

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 08:28:23

Modified: 2014-08-22 03:06:14

Abundance distribution
18 species
4 singletons
total count 494
extrapolated richness: 28.6
Fisher's α: 3.665
geometric series k: 0.7171
Hurlbert's PIE: 0.6253
Shannon's H: 1.5202
Good's u: 0.9919
Each square represents a species. Square sizes are proportional to counts.
Register