Coordinate: 38° 51' N, 122° 38' W
climate data are based on Safford and Harrison (2008, USDA Forest Service Gen. Tech. Rep. PSW-GTR-189), who report on this exact area
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=888 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=888SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=518SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=888 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liometopum' AND (junior_species='occidentale' OR junior_species='occidentale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liometopum' AND (species='occidentale' OR species='occidentale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liometopum' AND (species='occidentale' OR species='occidentale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liometopum' AND (junior_species='occidentale' OR junior_species='occidentale')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='Liometopum' AND (species='occidentale' OR species='occidentale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='sessile' OR junior_species='sessile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinoma' AND (species='sessile' OR species='sessile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinoma' AND (species='sessile' OR species='sessile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='sessile' OR junior_species='sessile')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='Tapinoma' AND (species='sessile' OR species='sessile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neivamyrmex' AND (junior_species='californicus' OR junior_species='californicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neivamyrmex' AND (species='californicus' OR species='californicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neivamyrmex' AND (species='californicus' OR species='californicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neivamyrmex' AND (junior_species='californicus' OR junior_species='californicus')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='Neivamyrmex' AND (species='californicus' OR species='californicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='depilus' OR junior_species='depilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachymyrmex' AND (species='depilus' OR species='depilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachymyrmex' AND (species='depilus' OR species='depilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='depilus' OR junior_species='depilus')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='Brachymyrmex' AND (species='depilus' OR species='depilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='vicinus' OR junior_species='vicinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='vicinus' OR species='vicinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='vicinus' OR species='vicinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='vicinus' OR junior_species='vicinus')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='Camponotus' AND (species='vicinus' OR species='vicinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='essigi' OR junior_species='essigii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='essigi' OR species='essigii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='essigi' OR species='essigii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='essigi' OR junior_species='essigii')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='Camponotus' AND (species='essigi' OR species='essigii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='hyatti' OR junior_species='hyattii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='hyatti' OR species='hyattii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='hyatti' OR species='hyattii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='hyatti' OR junior_species='hyattii')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='Camponotus' AND (species='hyatti' OR species='hyattii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='semitestaceus' OR junior_species='semitestaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='semitestaceus' OR species='semitestaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='semitestaceus' OR species='semitestaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='semitestaceus' OR junior_species='semitestaceus')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='Camponotus' AND (species='semitestaceus' OR species='semitestaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='moki' OR junior_species='mokii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='moki' OR species='mokii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='moki' OR species='mokii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='moki' OR junior_species='mokii')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='Formica' AND (species='moki' OR species='mokii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prenolepis' AND (junior_species='imparis' OR junior_species='imparis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prenolepis' AND (species='imparis' OR species='imparis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prenolepis' AND (species='imparis' OR species='imparis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prenolepis' AND (junior_species='imparis' OR junior_species='imparis')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='Prenolepis' AND (species='imparis' OR species='imparis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='coarctata' OR junior_species='coarctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='coarctata' OR species='coarctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='coarctata' OR species='coarctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='coarctata' OR junior_species='coarctata')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='Crematogaster' AND (species='coarctata' OR species='coarctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='andrei' OR junior_species='andreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptothorax' AND (species='andrei' OR species='andreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptothorax' AND (species='andrei' OR species='andreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='andrei' OR junior_species='andreii')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='Leptothorax' AND (species='andrei' OR species='andreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='nevadensis' OR junior_species='nevadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptothorax' AND (species='nevadensis' OR species='nevadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptothorax' AND (species='nevadensis' OR species='nevadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='nevadensis' OR junior_species='nevadensis')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='Leptothorax' AND (species='nevadensis' OR species='nevadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptothorax' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptothorax' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptothorax' AND (junior_species='nitens' OR junior_species='nitens')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='Leptothorax' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='andrei' OR junior_species='andreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Messor' AND (species='andrei' OR species='andreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Messor' AND (species='andrei' OR species='andreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Messor' AND (junior_species='andrei' OR junior_species='andreii')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='Messor' AND (species='andrei' OR species='andreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='ergatogyna' OR junior_species='ergatogyna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='ergatogyna' OR species='ergatogyna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='ergatogyna' OR species='ergatogyna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='ergatogyna' OR junior_species='ergatogyna')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='Monomorium' AND (species='ergatogyna' OR species='ergatogyna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='molesta' OR junior_species='molesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='molesta' OR species='molesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='molesta' OR species='molesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='molesta' OR junior_species='molesta')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='Solenopsis' AND (species='molesta' OR species='molesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='xyloni' OR junior_species='xylonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='xyloni' OR species='xylonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='xyloni' OR species='xylonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='xyloni' OR junior_species='xylonii')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='Solenopsis' AND (species='xyloni' OR species='xylonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='diecki' OR junior_species='dieckii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='diecki' OR species='dieckii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='diecki' OR species='dieckii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='diecki' OR junior_species='dieckii')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='Stenamma' AND (species='diecki' OR species='dieckii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='punctatoventre' OR junior_species='punctatoventre')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='punctatoventre' OR species='punctatoventre') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='punctatoventre' OR species='punctatoventre')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='punctatoventre' OR junior_species='punctatoventre')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='Stenamma' AND (species='punctatoventre' OR species='punctatoventre') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=888