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=1175 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1175SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=826SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1175 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='brassicae' OR species='brassicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')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='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='napi' OR junior_species='napii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='napi' OR species='napii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='napi' OR species='napii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='napi' OR junior_species='napii')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='Pieris' AND (species='napi' OR species='napii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonepteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonepteryx' AND (species='rhamni' OR species='rhamnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')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='Gonepteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynthia' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynthia' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynthia' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynthia' AND (junior_species='cardui' OR junior_species='carduii')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='Cynthia' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='urticae' OR junior_species='urticae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglais' AND (species='urticae' OR species='urticae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglais' AND (species='urticae' OR species='urticae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='urticae' OR junior_species='urticae')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='Aglais' AND (species='urticae' OR species='urticae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoacidalia' AND (junior_species='aglaja' OR junior_species='aglaja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesoacidalia' AND (species='aglaja' OR species='aglaja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesoacidalia' AND (species='aglaja' OR species='aglaja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoacidalia' AND (junior_species='aglaja' OR junior_species='aglaja')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='Mesoacidalia' AND (species='aglaja' OR species='aglaja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Issoria' AND (species='lathonia' OR species='lathonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Issoria' AND (species='lathonia' OR species='lathonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')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='Issoria' AND (species='lathonia' OR species='lathonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='ino' OR junior_species='ino')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brenthis' AND (species='ino' OR species='ino') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brenthis' AND (species='ino' OR species='ino')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='ino' OR junior_species='ino')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='Brenthis' AND (species='ino' OR species='ino') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clossiana' AND (junior_species='selene' OR junior_species='selene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clossiana' AND (species='selene' OR species='selene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clossiana' AND (species='selene' OR species='selene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clossiana' AND (junior_species='selene' OR junior_species='selene')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='Clossiana' AND (species='selene' OR species='selene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellicta' AND (junior_species='athalia' OR junior_species='athalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mellicta' AND (species='athalia' OR species='athalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mellicta' AND (species='athalia' OR species='athalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellicta' AND (junior_species='athalia' OR junior_species='athalia')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='Mellicta' AND (species='athalia' OR species='athalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebia' AND (junior_species='ligea' OR junior_species='ligea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erebia' AND (species='ligea' OR species='ligea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erebia' AND (species='ligea' OR species='ligea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebia' AND (junior_species='ligea' OR junior_species='ligea')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='Erebia' AND (species='ligea' OR species='ligea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphantopus' AND (junior_species='hyperantus' OR junior_species='hyperantus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphantopus' AND (species='hyperantus' OR species='hyperantus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphantopus' AND (species='hyperantus' OR species='hyperantus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphantopus' AND (junior_species='hyperantus' OR junior_species='hyperantus')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='Aphantopus' AND (species='hyperantus' OR species='hyperantus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')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='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='arcania' OR junior_species='arcania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='arcania' OR species='arcania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='arcania' OR species='arcania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='arcania' OR junior_species='arcania')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='Coenonympha' AND (species='arcania' OR species='arcania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='maera/petropolitana' OR junior_species='maera/petropolitana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiommata' AND (species='maera/petropolitana' OR species='maera/petropolitana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiommata' AND (species='maera/petropolitana' OR species='maera/petropolitana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='maera/petropolitana' OR junior_species='maera/petropolitana')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='Lasiommata' AND (species='maera/petropolitana' OR species='maera/petropolitana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='virgaureae' OR junior_species='virgaureae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='virgaureae' OR species='virgaureae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='virgaureae' OR species='virgaureae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='virgaureae' OR junior_species='virgaureae')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='Lycaena' AND (species='virgaureae' OR species='virgaureae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='artaxerxes' OR junior_species='artaxerxes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aricia' AND (species='artaxerxes' OR species='artaxerxes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aricia' AND (species='artaxerxes' OR species='artaxerxes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='artaxerxes' OR junior_species='artaxerxes')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='Aricia' AND (species='artaxerxes' OR species='artaxerxes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyaniris' AND (junior_species='semiargus' OR junior_species='semiargus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyaniris' AND (species='semiargus' OR species='semiargus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyaniris' AND (species='semiargus' OR species='semiargus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyaniris' AND (junior_species='semiargus' OR junior_species='semiargus')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='Cyaniris' AND (species='semiargus' OR species='semiargus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='amanda' OR junior_species='amanda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='amanda' OR species='amanda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='amanda' OR species='amanda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='amanda' OR junior_species='amanda')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='Polyommatus' AND (species='amanda' OR species='amanda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='icarus' OR species='icarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')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='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineola' OR junior_species='lineola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='lineola' OR species='lineola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='lineola' OR species='lineola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineola' OR junior_species='lineola')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='Thymelicus' AND (species='lineola' OR species='lineola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='venatus' OR junior_species='venatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlodes' AND (species='venatus' OR species='venatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlodes' AND (species='venatus' OR species='venatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='venatus' OR junior_species='venatus')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='Ochlodes' AND (species='venatus' OR species='venatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygaena' AND (junior_species='lonicerae' OR junior_species='lonicerae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygaena' AND (species='lonicerae' OR species='lonicerae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygaena' AND (species='lonicerae' OR species='lonicerae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygaena' AND (junior_species='lonicerae' OR junior_species='lonicerae')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='Zygaena' AND (species='lonicerae' OR species='lonicerae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1175 The Ecological Register: Uppland (organic farm 1)
Uppland (organic farm 1)
Basic information
Sample name: Uppland (organic farm 1)

Reference: A.-C. Weibull, J. Bengtsson, and E. Nohlgren. 2000. Diversity of butterflies in the agricultural landscape: the role of farming system and landscape heterogeneity. Ecography 23(6):743-750 [ER 826]
Geography
Country: Sweden

State: Uppland


Coordinate: 60° 0' N, 18° 0' E
Coordinate basis: based on political unit

Geography comments: coordinate based on Uppland

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

MAT: 5.5

MAP: 527.0

Habitat comments: climate data are for Uppland in general and are based on Aronsson et al. (2014)

Methods
Life forms: butterflies

Sites: 1

Sampling methods: belt transect,visual

Sample size: 521 individuals

Years: 1997, 1998

Days: 11

Sampling comments: "line transect method" based on Pollard (i.e., with butterflies recorded up to 5 m on either side of the transect)
counts were during on 11 separate visits (assumed to be one day long each)

Metadata
Sample number: 1175

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-30 14:44:21

Modified: 2016-12-11 06:50:34

Abundance distribution
23 species
5 singletons
total count 521
extrapolated richness: 36.7
Fisher's α: 4.924
geometric series k: 0.7821
Hurlbert's PIE: 0.7590
Shannon's H: 1.9417
Good's u: 0.9904
Each square represents a species. Square sizes are proportional to counts.
Register