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=1179 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1179SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=830SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1179 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupido' AND (junior_species='comyntas' OR junior_species='comyntas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupido' AND (species='comyntas' OR species='comyntas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupido' AND (species='comyntas' OR species='comyntas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupido' AND (junior_species='comyntas' OR junior_species='comyntas')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='Cupido' AND (species='comyntas' OR species='comyntas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='acmon' OR junior_species='acmon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='acmon' OR species='acmon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='acmon' OR species='acmon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='acmon' OR junior_species='acmon')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='Plebejus' AND (species='acmon' OR species='acmon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlides' AND (junior_species='halesus' OR junior_species='halesus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atlides' AND (species='halesus' OR species='halesus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlides' AND (species='halesus' OR species='halesus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlides' AND (junior_species='halesus' OR junior_species='halesus')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='Atlides' AND (species='halesus' OR species='halesus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='augustinus' OR junior_species='augustinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callophrys' AND (species='augustinus' OR species='augustinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callophrys' AND (species='augustinus' OR species='augustinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='augustinus' OR junior_species='augustinus')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='Callophrys' AND (species='augustinus' OR species='augustinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='melinus' OR junior_species='melinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='melinus' OR species='melinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='melinus' OR species='melinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='melinus' OR junior_species='melinus')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='Strymon' AND (species='melinus' OR species='melinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='plexippus' OR junior_species='plexippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='plexippus' OR species='plexippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='plexippus' OR species='plexippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='plexippus' OR junior_species='plexippus')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='Danaus' AND (species='plexippus' OR species='plexippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='bredowii' OR junior_species='bredowi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='bredowii' OR species='bredowi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='bredowii' OR species='bredowi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='bredowii' OR junior_species='bredowi')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='Adelpha' AND (species='bredowii' OR species='bredowi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='lorquini' OR junior_species='lorquinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='lorquini' OR species='lorquinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='lorquini' OR species='lorquinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='lorquini' OR junior_species='lorquinii')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='Limenitis' AND (species='lorquini' OR species='lorquinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='milberti' OR junior_species='milbertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglais' AND (species='milberti' OR species='milbertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglais' AND (species='milberti' OR species='milbertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='milberti' OR junior_species='milbertii')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='Aglais' AND (species='milberti' OR species='milbertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='coenia' OR junior_species='coenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='coenia' OR species='coenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='coenia' OR species='coenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='coenia' OR junior_species='coenia')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='Junonia' AND (species='coenia' OR species='coenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='antiopa' OR species='antiopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')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='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='californica' OR junior_species='californica')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='Nymphalis' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='mylitta' OR junior_species='mylitta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyciodes' AND (species='mylitta' OR species='mylitta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyciodes' AND (species='mylitta' OR species='mylitta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='mylitta' OR junior_species='mylitta')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='Phyciodes' AND (species='mylitta' OR species='mylitta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='atalanta' OR species='atalanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='atalanta' OR species='atalanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')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='Vanessa' AND (species='atalanta' OR species='atalanta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')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='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='virginiensis' OR junior_species='virginiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='virginiensis' OR species='virginiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='virginiensis' OR species='virginiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='virginiensis' OR junior_species='virginiensis')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='Vanessa' AND (species='virginiensis' OR species='virginiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='philenor' OR junior_species='philenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='philenor' OR species='philenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='philenor' OR species='philenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='philenor' OR junior_species='philenor')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='Battus' AND (species='philenor' OR species='philenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='multicaudata' OR junior_species='multicaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='multicaudata' OR species='multicaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='multicaudata' OR species='multicaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='multicaudata' OR junior_species='multicaudata')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='Papilio' AND (species='multicaudata' OR species='multicaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='rutulus' OR junior_species='rutulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='rutulus' OR species='rutulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='rutulus' OR species='rutulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='rutulus' OR junior_species='rutulus')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='Papilio' AND (species='rutulus' OR species='rutulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='zelicaon' OR junior_species='zelicaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='zelicaon' OR species='zelicaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='zelicaon' OR species='zelicaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='zelicaon' OR junior_species='zelicaon')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='Papilio' AND (species='zelicaon' OR species='zelicaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='eurytheme' OR junior_species='eurytheme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='eurytheme' OR species='eurytheme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='eurytheme' OR species='eurytheme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='eurytheme' OR junior_species='eurytheme')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='Colias' AND (species='eurytheme' OR species='eurytheme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zerene' AND (junior_species='eurydice' OR junior_species='eurydice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zerene' AND (species='eurydice' OR species='eurydice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zerene' AND (species='eurydice' OR species='eurydice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zerene' AND (junior_species='eurydice' OR junior_species='eurydice')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='Zerene' AND (species='eurydice' OR species='eurydice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='sara' OR junior_species='sara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthocharis' AND (species='sara' OR species='sara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocharis' AND (species='sara' OR species='sara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='sara' OR junior_species='sara')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='Anthocharis' AND (species='sara' OR species='sara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='rapae' OR species='rapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='rapae' OR species='rapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')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='Pieris' AND (species='rapae' OR species='rapae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1179 The Ecological Register: Sutter Buttes
Sutter Buttes
Basic information
Sample name: Sutter Buttes

Sample aka: Dean Ranch

Reference: M. R. L. Whitaker and E. C. Long. 2014. Survey of the butterflies of the Sutter Buttes, California. Journal of Research on the Lepidoptera 47:1-10 [ER 830]
Geography
Country: United States

State: California


Coordinate: 39.22° N, -121.80° W
Coordinate basis: stated in text

Geography comments: "on the Dean Ranch property"

Environment
Habitat: Mediterranean woodland

Substrate: ground surface

Disturbance: grazing

WMT: 24.4

CMT: 7.5

MAP: 510.0

Habitat comments: "a Mediterranean climate" with "oak scrubland, a riparian corridor, grazed pasture, cultivated fields, and chaparral"; "much" of the land is "undeveloped"
MAP stated in text; CMT and WMT based on climate station 72483 (Sacramento)

Methods
Life forms: butterflies

Sampling methods: visual

Sample size: 971 individuals

Years: 2008 - 2010

Days: 54

Sampling comments: "biweekly Pollard walks" over two years and a month "when weather was suitable" with "some specimens... collected as vouchers"

Metadata
Sample number: 1179

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-30 20:17:59

Modified: 2014-09-30 10:22:52

Abundance distribution
24 species
6 singletons
total count 971
extrapolated richness: 39.7
Fisher's α: 4.453
geometric series k: 0.7592
Hurlbert's PIE: 0.6343
Shannon's H: 1.6107
Good's u: 0.9938
Each square represents a species. Square sizes are proportional to counts.
Register