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=415 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=415SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=196SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=415 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Sceloporus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='grammicus' OR junior_species='grammicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='grammicus' OR species='grammicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='grammicus' OR species='grammicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='grammicus' OR junior_species='grammicus')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='Sceloporus' AND (species='grammicus' OR species='grammicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' 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='Sceloporus' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' 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='Sceloporus' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='naufragus' OR junior_species='naufragus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='naufragus' OR species='naufragus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='naufragus' OR species='naufragus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='naufragus' OR junior_species='naufragus')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='Anolis' AND (species='naufragus' OR species='naufragus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='lynxe' OR junior_species='lynxe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plestiodon' AND (species='lynxe' OR species='lynxe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plestiodon' AND (species='lynxe' OR species='lynxe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='lynxe' OR junior_species='lynxe')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='Plestiodon' AND (species='lynxe' OR species='lynxe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='gemmingeri' OR junior_species='gemmingerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scincella' AND (species='gemmingeri' OR species='gemmingerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='gemmingeri' OR species='gemmingerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='gemmingeri' OR junior_species='gemmingerii')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='gemmingeri' OR species='gemmingerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidophyma' AND (junior_species='sylvaticum' OR junior_species='sylvaticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidophyma' AND (species='sylvaticum' OR species='sylvaticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidophyma' AND (species='sylvaticum' OR species='sylvaticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidophyma' AND (junior_species='sylvaticum' OR junior_species='sylvaticum')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='Lepidophyma' AND (species='sylvaticum' OR species='sylvaticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='fissidens' OR junior_species='fissidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coniophanes' AND (species='fissidens' OR species='fissidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coniophanes' AND (species='fissidens' OR species='fissidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='fissidens' OR junior_species='fissidens')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='Coniophanes' AND (species='fissidens' OR species='fissidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geophis' AND (junior_species='mutitorques' OR junior_species='mutitorques')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geophis' AND (species='mutitorques' OR species='mutitorques') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geophis' AND (species='mutitorques' OR species='mutitorques')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geophis' AND (junior_species='mutitorques' OR junior_species='mutitorques')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='Geophis' AND (species='mutitorques' OR species='mutitorques') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Storeria' AND (junior_species='dekayi' OR junior_species='dekayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Storeria' AND (species='dekayi' OR species='dekayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Storeria' AND (species='dekayi' OR species='dekayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Storeria' AND (junior_species='dekayi' OR junior_species='dekayii')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='Storeria' AND (species='dekayi' OR species='dekayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='eques' OR junior_species='eques')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='eques' OR species='eques') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='eques' OR species='eques')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='eques' OR junior_species='eques')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='Thamnophis' AND (species='eques' OR species='eques') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='proximus' OR junior_species='proximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='proximus' OR species='proximus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='proximus' OR species='proximus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='proximus' OR junior_species='proximus')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='Thamnophis' AND (species='proximus' OR species='proximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='scalaris' OR junior_species='scalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='scalaris' OR species='scalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='scalaris' OR species='scalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='scalaris' OR junior_species='scalaris')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='Thamnophis' AND (species='scalaris' OR species='scalaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='sumichrasti' OR junior_species='sumichrastii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='sumichrasti' OR species='sumichrastii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='sumichrasti' OR species='sumichrastii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='sumichrasti' OR junior_species='sumichrastii')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='Thamnophis' AND (species='sumichrasti' OR species='sumichrastii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophryacus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophryacus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophryacus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophryacus' AND (junior_species='undulatus' OR junior_species='undulatus')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='Ophryacus' AND (species='undulatus' OR species='undulatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=415 The Ecological Register: Acaxochitlân
Acaxochitlân
Basic information
Sample name: Acaxochitlân

Reference: A. Ramírez-Bautista and R. Cruz-Elizalde. 2013. Reptile community structure in two fragments of cloud forest of the Sierra Madre Oriental, Mexico. North-Western Journal of Zoology 9(2):410-417 [ER 196]
Geography
Country: Mexico

State: Hidalgo


Coordinate: 20° 8' N, 98° 8' W
Coordinate basis: stated in text

Geography comments: coordinate given in text
altitude 1400 to 2400 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: fragment

Substrate: ground surface

MAT: 16.7

MAP: 1869.0

Habitat comments: 89.5 ha cloud forest fragment
deciduous forest
MAT of 15 stated in text; climate data based on Ayala and Vega (1997) and apply to Tenango de Doria

Methods
Life forms: lizards,snakes

Site area: 9.5

Sampling methods: no design,hand capture

Sample size: 37 individuals

Years: 2008, 2009

Metadata
Sample number: 415

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 18:04:02

Modified: 2015-02-23 22:23:43

Abundance distribution
15 species
8 singletons
total count 37
extrapolated richness: 45.2
Fisher's α: 9.390
geometric series k: 0.8799
Hurlbert's PIE: 0.8926
Shannon's H: 2.4431
Good's u: 0.7867
Each square represents a species. Square sizes are proportional to counts.
Register