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=414 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=414SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=195SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=414 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='cerastes' OR junior_species='cerastes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='cerastes' OR species='cerastes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='cerastes' OR species='cerastes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='cerastes' OR junior_species='cerastes')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='Crotalus' AND (species='cerastes' OR species='cerastes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='scutulatus' OR junior_species='scutulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='scutulatus' OR species='scutulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='scutulatus' OR species='scutulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='scutulatus' OR junior_species='scutulatus')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='Crotalus' AND (species='scutulatus' OR species='scutulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocheilus' AND (junior_species='lecontei' OR junior_species='leconteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinocheilus' AND (species='lecontei' OR species='leconteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocheilus' AND (species='lecontei' OR species='leconteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocheilus' AND (junior_species='lecontei' OR junior_species='leconteii')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='Rhinocheilus' AND (species='lecontei' OR species='leconteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='atrox' OR junior_species='atrox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='atrox' OR species='atrox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='atrox' OR species='atrox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='atrox' OR junior_species='atrox')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='Crotalus' AND (species='atrox' OR species='atrox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionactis' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chionactis' AND (species='occipitalis' OR species='occipitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chionactis' AND (species='occipitalis' OR species='occipitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionactis' AND (junior_species='occipitalis' OR junior_species='occipitalis')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='Chionactis' AND (species='occipitalis' OR species='occipitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllorhynchus' AND (junior_species='decurtatus' OR junior_species='decurtatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllorhynchus' AND (species='decurtatus' OR species='decurtatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllorhynchus' AND (species='decurtatus' OR species='decurtatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllorhynchus' AND (junior_species='decurtatus' OR junior_species='decurtatus')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='Phyllorhynchus' AND (species='decurtatus' OR species='decurtatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='catenifer' OR junior_species='catenifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pituophis' AND (species='catenifer' OR species='catenifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pituophis' AND (species='catenifer' OR species='catenifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='catenifer' OR junior_species='catenifer')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='Pituophis' AND (species='catenifer' OR species='catenifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiglena' AND (junior_species='torquata' OR junior_species='torquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiglena' AND (species='torquata' OR species='torquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiglena' AND (species='torquata' OR species='torquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiglena' AND (junior_species='torquata' OR junior_species='torquata')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='Hypsiglena' AND (species='torquata' OR species='torquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arizona' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arizona' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arizona' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arizona' AND (junior_species='elegans' OR junior_species='elegans')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='Arizona' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Masticophis' AND (species='flagellum' OR species='flagellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Masticophis' AND (species='flagellum' OR species='flagellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')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='Masticophis' AND (species='flagellum' OR species='flagellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='getula' OR junior_species='getula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropeltis' AND (species='getula' OR species='getula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropeltis' AND (species='getula' OR species='getula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='getula' OR junior_species='getula')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='Lampropeltis' AND (species='getula' OR species='getula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvadora' AND (junior_species='hexalepis' OR junior_species='hexalepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salvadora' AND (species='hexalepis' OR species='hexalepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salvadora' AND (species='hexalepis' OR species='hexalepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvadora' AND (junior_species='hexalepis' OR junior_species='hexalepis')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='Salvadora' AND (species='hexalepis' OR species='hexalepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilomeniscus' AND (junior_species='cinctus' OR junior_species='cinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilomeniscus' AND (species='cinctus' OR species='cinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilomeniscus' AND (species='cinctus' OR species='cinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilomeniscus' AND (junior_species='cinctus' OR junior_species='cinctus')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='Chilomeniscus' AND (species='cinctus' OR species='cinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimorphodon' AND (junior_species='biscutatus' OR junior_species='biscutatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimorphodon' AND (species='biscutatus' OR species='biscutatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimorphodon' AND (species='biscutatus' OR species='biscutatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimorphodon' AND (junior_species='biscutatus' OR junior_species='biscutatus')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='Trimorphodon' AND (species='biscutatus' OR species='biscutatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=414 The Ecological Register: Sun Valley Parkway
Sun Valley Parkway
Basic information
Sample name: Sun Valley Parkway

Reference: T. R. Jones, R. D. Babb, F. R. Hensley, C. Liwanpo, and B. K. Sullivan. 2011. Sonoran desert snake communities at two sites: concordance and effects of increased road traffic. Herpetological Conservation and Biology 6(1):61-71 [ER 195]
Geography
Country: United States

State: Arizona


Coordinate: 33° 35' N, 112° 14' W
Coordinate basis: based on nearby landmark

Geography comments: elevation between 350 and 500 m
road goes right through Peoria (basis of coordinate)

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

WMT: 34.7

CMT: 13.2

MAP: 225.0

Habitat comments: climate data based on station 72278 (Phoenix airport)

Methods
Life forms: snakes

Sampling methods: line transect,road kill

Sample size: 175 individuals

Years: 1998 - 2009

Sampling comments: road cruising

Metadata
Sample number: 414

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 17:51:00

Modified: 2014-04-27 03:03:00

Abundance distribution
14 species
2 singletons
total count 175
extrapolated richness: 19.5
Fisher's α: 3.581
geometric series k: 0.7245
Hurlbert's PIE: 0.8069
Shannon's H: 2.0565
Good's u: 0.9886
Each square represents a species. Square sizes are proportional to counts.
Register