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=450 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=450SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=217SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=450 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='exsanguis' OR junior_species='exsanguis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='exsanguis' OR species='exsanguis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='exsanguis' OR species='exsanguis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='exsanguis' OR junior_species='exsanguis')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='Aspidoscelis' AND (species='exsanguis' OR species='exsanguis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='inornatus' OR junior_species='inornatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='inornatus' OR species='inornatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='inornatus' OR species='inornatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='inornatus' OR junior_species='inornatus')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='Aspidoscelis' AND (species='inornatus' OR species='inornatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='marmoratus' OR junior_species='marmoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='marmoratus' OR species='marmoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='marmoratus' OR species='marmoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='marmoratus' OR junior_species='marmoratus')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='Aspidoscelis' AND (species='marmoratus' OR species='marmoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='neomexicanus' OR junior_species='neomexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='neomexicanus' OR species='neomexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='neomexicanus' OR species='neomexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='neomexicanus' OR junior_species='neomexicanus')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='Aspidoscelis' AND (species='neomexicanus' OR species='neomexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cophosaurus' AND (junior_species='texanus' OR junior_species='texanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cophosaurus' AND (species='texanus' OR species='texanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cophosaurus' AND (species='texanus' OR species='texanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cophosaurus' AND (junior_species='texanus' OR junior_species='texanus')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='Cophosaurus' AND (species='texanus' OR species='texanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynosoma' AND (junior_species='modestum' OR junior_species='modestum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynosoma' AND (species='modestum' OR species='modestum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynosoma' AND (species='modestum' OR species='modestum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynosoma' AND (junior_species='modestum' OR junior_species='modestum')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='Phrynosoma' AND (species='modestum' OR species='modestum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphiopus' AND (junior_species='couchii' OR junior_species='couchi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scaphiopus' AND (species='couchii' OR species='couchi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scaphiopus' AND (species='couchii' OR species='couchi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphiopus' AND (junior_species='couchii' OR junior_species='couchi')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='Scaphiopus' AND (species='couchii' OR species='couchi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' 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='Sceloporus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' 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='Sceloporus' AND (species='undulatus' OR species='undulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uta' AND (junior_species='stansburiana' OR junior_species='stansburiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uta' AND (species='stansburiana' OR species='stansburiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uta' AND (species='stansburiana' OR species='stansburiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uta' AND (junior_species='stansburiana' OR junior_species='stansburiana')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='Uta' AND (species='stansburiana' OR species='stansburiana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=450
Reference:E. E. Jorgensen and S. Demarais. 1998. Herpetofauna associated with arroyos and uplands in foothills of the Chihuahuan Desert. Southwestern Naturalist43(4):441-448 [ER 217]
Geography
Country: United States
State: New Mexico
Coordinate:32° 41' N, 106° 32' W
Geography comments: coordinate based on San Andres National Wildlife Refuge
elevation 1255 to 1585 m
•
Environment
Habitat: desert/xeric shrubland
Substrate: ground surface
WMT: 28.2
CMT: 7.2
MAP: 249.0
Habitat comments: "arroyos and uplands"
climate data based on station 72270 (El Paso International Airport)
Methods
Life forms: lizards
Sampling methods: drift fences,pitfall traps
Sample size: 650 individuals
Years: 1993, 1994
Sampling comments: drift fence arrays with pitfall traps in eight arroyo-upland pairs
Metadata
Sample number: 450
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-03-17 13:27:27
Modified: 2014-04-26 10:47:01
Abundance distribution
9 species
0 singletons
total count 650
extrapolated richness: 9.3
Fisher's α: 1.478
geometric series k: 0.7096
Hurlbert's PIE: 0.7445
Shannon's H: 1.6595
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.