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=3572 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3572SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3242SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3572 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')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='Apodemus' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='agrestis' OR species='agrestis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')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='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myodes' AND (species='glareolus' OR species='glareolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')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='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neomys' AND (species='fodiens' OR species='fodiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')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='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='araneus' OR junior_species='araneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='araneus' OR species='araneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='araneus' OR species='araneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='araneus' OR junior_species='araneus')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='Sorex' AND (species='araneus' OR species='araneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')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='Sorex' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3572 The Ecological Register: Angedalen (fall)
Angedalen (fall)
Basic information
Sample name: Angedalen (fall)

Reference: A. Mysterud, R. Byrkjeland, L. Qviller, and H. Viljugrein. 2015. The generalist tick Ixodes ricinus and the specialist tick Ixodes trianguliceps on shrews and rodents in a northern forest ecosystem - a role of body size even among small hosts. Parasites & Vectors 8(639):1-10 [ER 3242]
Geography
Country: Norway


Coordinate: 61° 28' N, 5° 55' E
Coordinate basis: based on nearby landmark

Geography comments: "in F÷rde and Askvoll municipalities in Sogn & Fjordane county, close to the small town F÷rde"
coordinate based on Angedalen

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: unprotected

Substrate: ground surface

MAT: 6.0

MAP: 2270.0

Habitat comments: "within the boreonemoral vegetation zone... mixed forests with deciduous woodland" and "Other parts are dominated by Scots pine... together with planted Norway spruce"

Methods
Life forms: rodents,other small mammals

Sampling methods: line transect,other traps

Sample size: 171 specimens

Years: 2014

Days: 4

Seasons: autumn

Sampling comments: sampled during "fall (1st-4th September)... Four traps were spaced out in the corners of a 15 m × 15 m square at each station... All traps were live traps of type 'Ugglan' baited with carrots... and oat"
number of trapping stations is not stated, but were 500 m apart on a transect

Metadata
Sample number: 3572

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-12-23 21:28:05

Modified: 2019-12-23 10:28:05

Abundance distribution
6 species
0 singletons
total count 171
extrapolated richness: 7.1
Fisher's α: 1.210
geometric series k: 0.4388
Hurlbert's PIE: 0.4591
Shannon's H: 0.9990
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
Apodemus sylvaticus12
Microtus agrestis11
Myodes glareolus17
Neomys fodiens2
Sorex araneus123
Sorex minutus6