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=1549 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1549SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1044SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1549 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='conflata' OR junior_species='conflata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='conflata' OR species='conflata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='conflata' OR species='conflata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='conflata' OR junior_species='conflata')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='conflata' OR species='conflata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='tuberculatus' OR junior_species='tuberculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cychrus' AND (species='tuberculatus' OR species='tuberculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cychrus' AND (species='tuberculatus' OR species='tuberculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='tuberculatus' OR junior_species='tuberculatus')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='Cychrus' AND (species='tuberculatus' OR species='tuberculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='cautus' OR junior_species='cautus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='cautus' OR species='cautus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='cautus' OR species='cautus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='cautus' OR junior_species='cautus')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='cautus' OR species='cautus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrius' AND (junior_species='contractus' OR junior_species='contractus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metrius' AND (species='contractus' OR species='contractus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metrius' AND (species='contractus' OR species='contractus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrius' AND (junior_species='contractus' OR junior_species='contractus')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='Metrius' AND (species='contractus' OR species='contractus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='directus' OR junior_species='directus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='directus' OR species='directus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='directus' OR species='directus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='directus' OR junior_species='directus')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='directus' OR species='directus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omus' AND (junior_species='cazieri' OR junior_species='cazierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omus' AND (species='cazieri' OR species='cazierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omus' AND (species='cazieri' OR species='cazierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omus' AND (junior_species='cazieri' OR junior_species='cazierii')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='Omus' AND (species='cazieri' OR species='cazierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='herculaneus' OR junior_species='herculaneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='herculaneus' OR species='herculaneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='herculaneus' OR species='herculaneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='herculaneus' OR junior_species='herculaneus')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='herculaneus' OR species='herculaneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='lama' OR junior_species='lama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='lama' OR species='lama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='lama' OR species='lama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='lama' OR junior_species='lama')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='lama' OR species='lama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='melanarius' OR species='melanarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='melanarius' OR species='melanarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')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='melanarius' OR species='melanarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='setosus' OR junior_species='setosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='setosus' OR species='setosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='setosus' OR species='setosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='setosus' OR junior_species='setosus')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='setosus' OR species='setosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphinotus' AND (junior_species='rugiceps' OR junior_species='rugiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scaphinotus' AND (species='rugiceps' OR species='rugiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scaphinotus' AND (species='rugiceps' OR species='rugiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphinotus' AND (junior_species='rugiceps' OR junior_species='rugiceps')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='Scaphinotus' AND (species='rugiceps' OR species='rugiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachypachus' AND (junior_species='holmbergi' OR junior_species='holmbergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachypachus' AND (species='holmbergi' OR species='holmbergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachypachus' AND (species='holmbergi' OR species='holmbergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachypachus' AND (junior_species='holmbergi' OR junior_species='holmbergii')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='Trachypachus' AND (species='holmbergi' OR species='holmbergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zacotus' AND (junior_species='matthewsii' OR junior_species='matthewsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zacotus' AND (species='matthewsii' OR species='matthewsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zacotus' AND (species='matthewsii' OR species='matthewsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zacotus' AND (junior_species='matthewsii' OR junior_species='matthewsi')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='Zacotus' AND (species='matthewsii' OR species='matthewsi') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1549 The Ecological Register: Ashland Ranger District (burned)
Ashland Ranger District (burned)
Basic information
Sample name: Ashland Ranger District (burned)

Reference: C. G. Niwa and R. W. Peck. 2002. Influence of prescribed fire on carabid beetle (Carabidae) and spider (Araneae) assemblages in forest litter in southwestern Oregon. Environmental Entomology 31(5):785-796 [ER 1044]
Geography
Country: United States

State: Oregon


Coordinate: 42° 11' N, 122° 42' W
Coordinate basis: based on nearby landmark

Geography comments: "~6.4 km south of Ashland, OR, in the Ashland Ranger District, Rogue River National Forest" (coordinate based on Ashland)
elevation 900 to 1500 m

•
Environment
Habitat: temperate coniferous forest

Protection: national/state forest

Substrate: ground surface

Disturbance: recent fire

Methods
Life forms: ground beetles

Sites: 9

Sampling methods: pitfall traps

Sample size: 4980 individuals

Years: 1998

Seasons: spring,summer,autumn

Nets or traps: 108

Sampling comments: "12 pitfall traps were placed at 30-m intervals along transects" in nine locations

Metadata
Sample number: 1549

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-16 15:29:07

Modified: 2018-06-30 10:54:38

Abundance distribution
13 species
0 singletons
total count 4980
extrapolated richness: 14.1
Fisher's α: 1.619
geometric series k: 0.5674
Hurlbert's PIE: 0.7303
Shannon's H: 1.5156
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
Amara conflata67
Cychrus tuberculatus5
Harpalus cautus21
Metrius contractus contractus11
Notiophilus directus12
Omus cazieri1797
Pterostichus herculaneus417
Pterostichus lama47
Pterostichus melanarius2
Pterostichus setosus1539
Scaphinotus rugiceps rugiceps949
Trachypachus holmbergi26
Zacotus matthewsii87