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=403 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=403SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=187SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=403 ORDER BY register_no ASCSELECT 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='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='Crotalus' AND (junior_species='molussus' OR junior_species='molussus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='molussus' OR species='molussus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='molussus' OR species='molussus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='molussus' OR junior_species='molussus')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='molussus' OR species='molussus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='lepidus' OR junior_species='lepidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='lepidus' OR species='lepidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='lepidus' OR species='lepidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='lepidus' OR junior_species='lepidus')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='lepidus' OR species='lepidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='melanoleucus' OR junior_species='melanoleucus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pituophis' AND (species='melanoleucus' OR species='melanoleucus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pituophis' AND (species='melanoleucus' OR species='melanoleucus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='melanoleucus' OR junior_species='melanoleucus')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='melanoleucus' OR species='melanoleucus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='subocularis' OR junior_species='subocularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='subocularis' OR species='subocularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='subocularis' OR species='subocularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='subocularis' OR junior_species='subocularis')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='Elaphe' AND (species='subocularis' OR species='subocularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')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='Elaphe' AND (species='guttata' OR species='guttata') 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='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='Lampropeltis' AND (junior_species='getulus' OR junior_species='getulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropeltis' AND (species='getulus' OR species='getulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropeltis' AND (species='getulus' OR species='getulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='getulus' OR junior_species='getulus')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='getulus' OR species='getulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='nasicus' OR junior_species='nasicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterodon' AND (species='nasicus' OR species='nasicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterodon' AND (species='nasicus' OR species='nasicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='nasicus' OR junior_species='nasicus')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='Heterodon' AND (species='nasicus' OR species='nasicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='marcianus' OR junior_species='marcianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='marcianus' OR species='marcianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='marcianus' OR species='marcianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='marcianus' OR junior_species='marcianus')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='marcianus' OR species='marcianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='cyrtopsis' OR junior_species='cyrtopsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='cyrtopsis' OR species='cyrtopsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='cyrtopsis' OR species='cyrtopsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='cyrtopsis' OR junior_species='cyrtopsis')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='cyrtopsis' OR species='cyrtopsis') 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='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='Masticophis' AND (junior_species='taeniatus' OR junior_species='taeniatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Masticophis' AND (species='taeniatus' OR species='taeniatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Masticophis' AND (species='taeniatus' OR species='taeniatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='taeniatus' OR junior_species='taeniatus')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='taeniatus' OR species='taeniatus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='nigriceps' OR junior_species='nigriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='nigriceps' OR species='nigriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='nigriceps' OR species='nigriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='nigriceps' OR junior_species='nigriceps')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='Tantilla' AND (species='nigriceps' OR species='nigriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvadora' AND (junior_species='deserticola' OR junior_species='deserticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salvadora' AND (species='deserticola' OR species='deserticola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salvadora' AND (species='deserticola' OR species='deserticola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvadora' AND (junior_species='deserticola' OR junior_species='deserticola')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='deserticola' OR species='deserticola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sonora' AND (junior_species='semiannulata' OR junior_species='semiannulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sonora' AND (species='semiannulata' OR species='semiannulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sonora' AND (species='semiannulata' OR species='semiannulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sonora' AND (junior_species='semiannulata' OR junior_species='semiannulata')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='Sonora' AND (species='semiannulata' OR species='semiannulata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=403 The Ecological Register: Mexico Highway 16
Mexico Highway 16
Basic information
Sample name: Mexico Highway 16

Reference: R. P. Reynolds. 1982. Seasonal incidence of snakes in northeastern Chihuahua, Mexico. Southwestern Naturalist 27(2):161-166 [ER 187]
Geography
Country: Mexico

State: Chihuahua


Coordinate: 29° 10' N, 105° 30' W
Coordinate basis: stated in text

Geography comments: coordinate given in text

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

WMT: 27.6

CMT: 9.6

MAP: 316.0

Habitat comments: "desert shrub"
MAP stated in text; CMT and WMT based on climate station 76225 (Chihuahua), which is almost at the same altitude

Methods
Life forms: snakes

Sampling methods: line transect,road kill

Sample size: 421 individuals

Years: 1975 - 1977

Sampling comments: road collecting

Metadata
Sample number: 403

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 16:09:27

Modified: 2014-04-27 03:15:04

Abundance distribution
20 species
0 singletons
total count 421
extrapolated richness: 23.5
Fisher's α: 4.368
geometric series k: 0.8122
Hurlbert's PIE: 0.8747
Shannon's H: 2.4386
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register