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=272 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=272SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=117SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=272 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leistus' AND (species='ferrugineus' OR species='ferrugineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leistus' AND (species='ferrugineus' OR species='ferrugineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')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='Leistus' AND (species='ferrugineus' OR species='ferrugineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerbia' AND (junior_species='brevicollis' OR junior_species='brevicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerbia' AND (species='brevicollis' OR species='brevicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerbia' AND (species='brevicollis' OR species='brevicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerbia' AND (junior_species='brevicollis' OR junior_species='brevicollis')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='Nerbia' AND (species='brevicollis' OR species='brevicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='subtriatus' OR junior_species='subtriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='subtriatus' OR species='subtriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='subtriatus' OR species='subtriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='subtriatus' OR junior_species='subtriatus')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='subtriatus' OR species='subtriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='lampros' OR species='lampros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='lampros' OR species='lampros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')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='lampros' OR species='lampros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='normannum' OR junior_species='normannum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='normannum' OR species='normannum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='normannum' OR species='normannum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='normannum' OR junior_species='normannum')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='normannum' OR species='normannum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='aenieum' OR junior_species='aenieum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='aenieum' OR species='aenieum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='aenieum' OR species='aenieum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='aenieum' OR junior_species='aenieum')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='aenieum' OR species='aenieum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='guttula' OR junior_species='guttula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='guttula' OR species='guttula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='guttula' OR species='guttula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='guttula' OR junior_species='guttula')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='guttula' OR species='guttula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechuts' AND (junior_species='obtusuts' OR junior_species='obtusuts')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trechuts' AND (species='obtusuts' OR species='obtusuts') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trechuts' AND (species='obtusuts' OR species='obtusuts')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechuts' AND (junior_species='obtusuts' OR junior_species='obtusuts')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='Trechuts' AND (species='obtusuts' OR species='obtusuts') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rubripes' OR species='rubripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')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='rubripes' OR species='rubripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')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='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='curta' OR junior_species='curta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='curta' OR species='curta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='curta' OR species='curta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='curta' OR junior_species='curta')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='curta' OR species='curta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='amniliaris' OR junior_species='amniliaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='amniliaris' OR species='amniliaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='amniliaris' OR species='amniliaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='amniliaris' OR junior_species='amniliaris')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='amniliaris' OR species='amniliaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stomnis' AND (junior_species='pumicatus' OR junior_species='pumicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stomnis' AND (species='pumicatus' OR species='pumicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stomnis' AND (species='pumicatus' OR species='pumicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stomnis' AND (junior_species='pumicatus' OR junior_species='pumicatus')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='Stomnis' AND (species='pumicatus' OR species='pumicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='cupraea' OR junior_species='cupraea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='cupraea' OR species='cupraea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='cupraea' OR species='cupraea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='cupraea' OR junior_species='cupraea')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='Feronia' AND (species='cupraea' OR species='cupraea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='verntalis' OR junior_species='verntalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='verntalis' OR species='verntalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='verntalis' OR species='verntalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='verntalis' OR junior_species='verntalis')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='Feronia' AND (species='verntalis' OR species='verntalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='nigrita' OR species='nigrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='nigrita' OR species='nigrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='nigrita' OR junior_species='nigrita')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='Feronia' AND (species='nigrita' OR species='nigrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='madida' OR junior_species='madida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='madida' OR species='madida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='madida' OR species='madida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='madida' OR junior_species='madida')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='Feronia' AND (species='madida' OR species='madida') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=272 The Ecological Register: Mill Copse
Mill Copse
Basic information
Sample name: Mill Copse

Reference: G. Williams. 1959. Seasonal and diurnal activity of Carabidae, with particular reference to Nebria, Notiophilus and Feronia. Journal of Animal Ecology 28(2):309-330 [ER 117]
Geography
Country: United Kingdom


Coordinate: 51.2° N, 0.2° E
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

Habitat comments: area of open scrub

Methods
Life forms: ground beetles

Sites: 1

Sampling methods: pitfall traps

Sample size: 81 captures or sightings

Nets or traps: 3

Net or trap nights: 273

Sampling comments: JA: three pitfall traps each operated for a week at a time at intervals of four weeks over a year (i.e., 13 times) for a total of 3 x 7 x 13 =273 days

Metadata
Sample number: 272

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-04-08 16:13:26

Modified: 2014-08-22 02:54:33

Abundance distribution
17 species
6 singletons
total count 81
extrapolated richness: 34.8
Fisher's α: 6.561
geometric series k: 0.8347
Hurlbert's PIE: 0.8761
Shannon's H: 2.3792
Good's u: 0.9265
Each square represents a species. Square sizes are proportional to counts.
Register