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=530 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=530SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=262SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=530 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holbrookia' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holbrookia' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holbrookia' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holbrookia' AND (junior_species='maculata' OR junior_species='maculata')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='Holbrookia' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urosaurus' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urosaurus' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urosaurus' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urosaurus' AND (junior_species='inornata' OR junior_species='inornata')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='Urosaurus' AND (species='inornata' OR species='inornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='tigris' OR junior_species='tigris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='tigris' OR species='tigris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='tigris' OR species='tigris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='tigris' OR junior_species='tigris')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='tigris' OR species='tigris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='sonorae' OR junior_species='sonorae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='sonorae' OR species='sonorae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='sonorae' OR species='sonorae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='sonorae' OR junior_species='sonorae')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='sonorae' OR species='sonorae') 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='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='Terrapene' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terrapene' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terrapene' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terrapene' AND (junior_species='ornata' OR junior_species='ornata')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='Terrapene' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spea' AND (junior_species='hammondii' OR junior_species='hammondi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spea' AND (species='hammondii' OR species='hammondi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spea' AND (species='hammondii' OR species='hammondi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spea' AND (junior_species='hammondii' OR junior_species='hammondi')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='Spea' AND (species='hammondii' OR species='hammondi') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=530
The Ecological Register: Santa Rita Experimental Range (mesquite-free)
Sample name: Santa Rita Experimental Range (mesquite-free)
Reference:D. J. Germano and C. R. Hungerford. 1981. Reptile population changes with manipulation of Sonoran desert shrub. Great Basin Naturalist41(1):129-138 [ER 262]
Geography
Country: United States
State: Arizona
Coordinate:31° 50' N, 110° 51' W
Coordinate basis: based on nearby landmark
Geography comments: coordinate based on Santa Rita Experimental Range
•
Environment
Habitat: desert/xeric shrubland
Altered habitat: pasture
Substrate: ground surface
Disturbance: grazing
WMT: 31.1
CMT: 11.5
MAP: 310.0
Habitat comments: lightly grazed pastures with mesquite removed years before
precip 350 to 400 mm according to text; climate data based on station 722740 (Tucson International Airport)
Methods
Life forms: lizards
Sites: 4
Site length: 4800
Sampling methods: line transect,visual
Sample size: 122 individuals
Years: 1977, 1978
Sampling comments: four visually censused transect lines each 1200 m long
Metadata
Sample number: 530
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-03-22 13:29:21
Modified: 2014-04-26 03:57:51
Abundance distribution
8 species
3 singletons
total count 122
extrapolated richness: 15.8
Fisher's α: 1.920
geometric series k: 0.5450
Hurlbert's PIE: 0.6014
Shannon's H: 1.2132
Good's u: 0.9755
Each square represents a species. Square sizes are proportional to counts.