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=528 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=528SELECT 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=528 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callisaurus' AND (junior_species='draconoides' OR junior_species='draconoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callisaurus' AND (species='draconoides' OR species='draconoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callisaurus' AND (species='draconoides' OR species='draconoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callisaurus' AND (junior_species='draconoides' OR junior_species='draconoides')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='Callisaurus' AND (species='draconoides' OR species='draconoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='magister' OR junior_species='magister')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='magister' OR species='magister') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='magister' OR species='magister')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='magister' OR junior_species='magister')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='magister' OR species='magister') ORDER BY year,last_namesSELECT 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='Gambelia' AND (junior_species='wislizenii' OR junior_species='wislizeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gambelia' AND (species='wislizenii' OR species='wislizeni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gambelia' AND (species='wislizenii' OR species='wislizeni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gambelia' AND (junior_species='wislizenii' OR junior_species='wislizeni')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='Gambelia' AND (species='wislizenii' OR species='wislizeni') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=528
The Ecological Register: Santa Rita Experimental Range (mesquite with clearings)
Santa Rita Experimental Range (mesquite with clearings)
Basic information
Sample name: Santa Rita Experimental Range (mesquite with clearings)
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 native mesquite-dominated vegetation
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: 362 individuals
Years: 1977, 1978
Sampling comments: four visually censused transect lines each 1200 m long
Metadata
Sample number: 528
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-03-22 13:26:45
Modified: 2014-04-26 03:58:23
Abundance distribution
7 species
1 singleton
total count 362
extrapolated richness: 8.6
Fisher's α: 1.231
geometric series k: 0.4102
Hurlbert's PIE: 0.6169
Shannon's H: 1.2930
Good's u: 0.9972
Each square represents a species. Square sizes are proportional to counts.