Coordinate: 64° 59' N, 145° 8' W
elevation 330 to 385 m
CMT -2 to -4ÂșC, MAP 250 to 300 mm
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=2240 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2240SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2205SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2240 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='adstrictus' OR junior_species='adstrictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='adstrictus' OR species='adstrictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='adstrictus' OR species='adstrictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='adstrictus' OR junior_species='adstrictus')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='Pterostichus' AND (species='adstrictus' OR species='adstrictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='cupreum' OR junior_species='cupreum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='cupreum' OR species='cupreum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='cupreum' OR species='cupreum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='cupreum' OR junior_species='cupreum')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='Agonum' AND (species='cupreum' OR species='cupreum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='ingratus' OR junior_species='ingratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='ingratus' OR species='ingratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='ingratus' OR species='ingratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='ingratus' OR junior_species='ingratus')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='Calathus' AND (species='ingratus' OR species='ingratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='obesa' OR junior_species='obesa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='obesa' OR species='obesa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='obesa' OR species='obesa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='obesa' OR junior_species='obesa')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='Amara' AND (species='obesa' OR species='obesa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicherotrichus' AND (junior_species='cognatus' OR junior_species='cognatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicherotrichus' AND (species='cognatus' OR species='cognatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicherotrichus' AND (species='cognatus' OR species='cognatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicherotrichus' AND (junior_species='cognatus' OR junior_species='cognatus')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='Dicherotrichus' AND (species='cognatus' OR species='cognatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='sp(p.)' OR junior_species='sp(p.)')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='sp(p.)' OR species='sp(p.)') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='sp(p.)' OR species='sp(p.)')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='sp(p.)' OR junior_species='sp(p.)')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='Amara' AND (species='sp(p.)' OR species='sp(p.)') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='chamissonis' OR junior_species='chamissonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='chamissonis' OR species='chamissonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='chamissonis' OR species='chamissonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='chamissonis' OR junior_species='chamissonis')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='Carabus' AND (species='chamissonis' OR species='chamissonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asaphidion' AND (junior_species='yukonense' OR junior_species='yukonense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asaphidion' AND (species='yukonense' OR species='yukonense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asaphidion' AND (species='yukonense' OR species='yukonense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asaphidion' AND (junior_species='yukonense' OR junior_species='yukonense')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='Asaphidion' AND (species='yukonense' OR species='yukonense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymindis' AND (junior_species='cribricollis' OR junior_species='cribricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymindis' AND (species='cribricollis' OR species='cribricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymindis' AND (species='cribricollis' OR species='cribricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymindis' AND (junior_species='cribricollis' OR junior_species='cribricollis')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='Cymindis' AND (species='cribricollis' OR species='cribricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='longilabris' OR junior_species='longilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cicindela' AND (species='longilabris' OR species='longilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cicindela' AND (species='longilabris' OR species='longilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='longilabris' OR junior_species='longilabris')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='Cicindela' AND (species='longilabris' OR species='longilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='vietinghoffii' OR junior_species='vietinghoffi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='vietinghoffii' OR species='vietinghoffi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='vietinghoffii' OR species='vietinghoffi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='vietinghoffii' OR junior_species='vietinghoffi')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='Carabus' AND (species='vietinghoffii' OR species='vietinghoffi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='sp.' OR junior_species='sp.')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='Bembidion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miscodera' AND (junior_species='arctica' OR junior_species='arctica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miscodera' AND (species='arctica' OR species='arctica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miscodera' AND (species='arctica' OR species='arctica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miscodera' AND (junior_species='arctica' OR junior_species='arctica')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='Miscodera' AND (species='arctica' OR species='arctica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='laticeps' OR species='laticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='laticeps' OR species='laticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='laticeps' OR junior_species='laticeps')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='Harpalus' AND (species='laticeps' OR species='laticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='semistriatus' OR junior_species='semistriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='semistriatus' OR species='semistriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='semistriatus' OR species='semistriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='semistriatus' OR junior_species='semistriatus')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='Notiophilus' AND (species='semistriatus' OR species='semistriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='hyperobrea' OR junior_species='hyperobrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='hyperobrea' OR species='hyperobrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='hyperobrea' OR species='hyperobrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='hyperobrea' OR junior_species='hyperobrea')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='Amara' AND (species='hyperobrea' OR species='hyperobrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syntomus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syntomus' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='americanus' OR junior_species='americanus')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='Syntomus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harplaus' AND (junior_species='fulvilabris' OR junior_species='fulvilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harplaus' AND (species='fulvilabris' OR species='fulvilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harplaus' AND (species='fulvilabris' OR species='fulvilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harplaus' AND (junior_species='fulvilabris' OR junior_species='fulvilabris')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='Harplaus' AND (species='fulvilabris' OR species='fulvilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='somnulentus' OR junior_species='somnulentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='somnulentus' OR species='somnulentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='somnulentus' OR species='somnulentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='somnulentus' OR junior_species='somnulentus')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='Harpalus' AND (species='somnulentus' OR species='somnulentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='kotzebuei' OR junior_species='kotzebueii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='kotzebuei' OR species='kotzebueii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='kotzebuei' OR species='kotzebueii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='kotzebuei' OR junior_species='kotzebueii')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='Pterostichus' AND (species='kotzebuei' OR species='kotzebueii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2240