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=411 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=411SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=193SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=411 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='gecko' OR junior_species='gecko')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='gecko' OR species='gecko') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='gecko' OR species='gecko')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='gecko' OR junior_species='gecko')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='gecko' OR species='gecko') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='chinensis' OR junior_species='chinensis')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='chinensis' OR species='chinensis') 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='Acanthosaura' AND (junior_species='lepidogaster' OR junior_species='lepidogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthosaura' AND (species='lepidogaster' OR species='lepidogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthosaura' AND (species='lepidogaster' OR species='lepidogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthosaura' AND (junior_species='lepidogaster' OR junior_species='lepidogaster')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='Acanthosaura' AND (species='lepidogaster' OR species='lepidogaster') 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='Draco' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Draco' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Draco' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Draco' AND (junior_species='maculatus' OR junior_species='maculatus')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='Draco' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='quadrilineatus' OR species='quadrilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')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='Eumeces' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='reevesii' OR junior_species='reevesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scincella' AND (species='reevesii' OR species='reevesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='reevesii' OR species='reevesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='reevesii' OR junior_species='reevesi')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='Scincella' AND (species='reevesii' OR species='reevesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' 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='Scincella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' 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='Scincella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='tritaeniatus' OR junior_species='tritaeniatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphenomorphus' AND (species='tritaeniatus' OR species='tritaeniatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='tritaeniatus' OR species='tritaeniatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='tritaeniatus' OR junior_species='tritaeniatus')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='Sphenomorphus' AND (species='tritaeniatus' OR species='tritaeniatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' AND (junior_species='baviensis' OR junior_species='baviensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropidophorus' AND (species='baviensis' OR species='baviensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidophorus' AND (species='baviensis' OR species='baviensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' AND (junior_species='baviensis' OR junior_species='baviensis')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='Tropidophorus' AND (species='baviensis' OR species='baviensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' 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='Tropidophorus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidophorus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' 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='Tropidophorus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' AND (junior_species='hainanus' OR junior_species='hainanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropidophorus' AND (species='hainanus' OR species='hainanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidophorus' AND (species='hainanus' OR species='hainanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidophorus' AND (junior_species='hainanus' OR junior_species='hainanus')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='Tropidophorus' AND (species='hainanus' OR species='hainanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=411 The Ecological Register: Cuc Phuong National Park (lizards)
Cuc Phuong National Park (lizards)
Basic information
Sample name: Cuc Phuong National Park (lizards)

Reference: V. V. Bobrov. 1993. Spatial organization of a tropical lizard community in a forested area in northern Vietnam. Herpetozoa 6(1/2):21-28 [ER 193]
Geography
Country: Vietnam


Coordinate: 20° 19' N, 105° 33' E
Coordinate basis: stated in text

Geography comments: coordinate based on range given in text
"surrounded by" mountains that are 300 - 400 m in elevation, so elevation is estimated as 300 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 23.4

MAP: 1850.0

Habitat comments: "tropical monsoon region with all specimens coming from "tropical forest"
climate data are based on Averyanov et al. (2013, Orchids of Cuc Phuong National Park): rainfall pattern is strongly seasonal

Methods
Life forms: lizards

Site length: 30000

Sampling methods: line transect,hand capture

Sample size: 464 individuals

Sampling comments: "random one-kilometer trails" to totalling 30 km were censused

Metadata
Sample number: 411

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 11:47:32

Modified: 2014-08-30 07:12:08

Abundance distribution
13 species
1 singleton
total count 464
extrapolated richness: 16.4
Fisher's α: 2.483
geometric series k: 0.6551
Hurlbert's PIE: 0.7535
Shannon's H: 1.7562
Good's u: 0.9979
Each square represents a species. Square sizes are proportional to counts.
Register