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=839 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=839SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=477SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=839 ORDER BY register_no ASCSELECT 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='Crematogaster' AND (junior_species='mormonum' OR junior_species='mormonum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='mormonum' OR species='mormonum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='mormonum' OR species='mormonum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='mormonum' OR junior_species='mormonum')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='mormonum' OR species='mormonum') 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='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='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='Paratrechina' AND (junior_species='terricola' OR junior_species='terricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='terricola' OR species='terricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='terricola' OR species='terricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='terricola' OR junior_species='terricola')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='Paratrechina' AND (species='terricola' OR species='terricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='hyatti' OR species='hyattii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='hyatti' OR species='hyattii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='hyatti' OR species='hyattii') 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='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='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='Linepithema' AND (junior_species='humile' OR junior_species='humile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Linepithema' AND (species='humile' OR species='humile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Linepithema' AND (species='humile' OR species='humile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linepithema' AND (junior_species='humile' OR junior_species='humile')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='Linepithema' AND (species='humile' OR species='humile') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=839 The Ecological Register: Reservoir Canyon
Reservoir Canyon
Basic information
Sample name: Reservoir Canyon

Reference: T. A. Kennedy. 1998. Patterns of an invasion by Argentine ants (Linepithema humile) in a riparian corridor and its effects on ant diversity. American Midland Naturalist 140(2):343-350 [ER 477]
Geography
Country: United States

State: California


Coordinate: 35° 16' 27" N, 120° 39' 47" W
Coordinate basis: based on nearby landmark

Geography comments: 1 mile NE of San Luis Obispo (basis of coordinate)

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

Disturbance: invasive animals

WMT: 17.7

CMT: 10.7

MAP: 326.0

Habitat comments: riparian woodland dominated by Quercus, Toxicodendron, and Salix
climate based on station 72394 (Santa Maria)

Methods
Life forms: ants

Sites: 5

Sampling methods: line transect,pitfall traps

Sample size: 364 individuals

Years: 1994

Days: 2

Seasons: spring

Nets or traps: 87

Net or trap nights: 174

Sampling comments: five 120 to 200 m transects spaced 100 m apart with a total of 87 traps set out for "48 h starting 27 May"

Metadata
Sample number: 839

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-18 21:23:22

Modified: 2015-10-03 22:51:01

Abundance distribution
11 species
0 singletons
total count 364
extrapolated richness: 13.2
Fisher's α: 2.139
geometric series k: 0.6464
Hurlbert's PIE: 0.7394
Shannon's H: 1.6760
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Camponotus vicinus11
Crematogaster mormonum19
Formica moki75
Leptothorax andrei5
Liometopum occidentale3
Paratrechina terricola2
Pheidole hyatti2
Prenolepis imparis53
Solenopsis xyloni10
Tapinoma sessile27
Linepithema humile157