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=1487 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1487SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=997SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1487 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='flavicollis' OR junior_species='flavicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='flavicollis' OR species='flavicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='flavicollis' OR species='flavicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='flavicollis' OR junior_species='flavicollis')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='flavicollis' OR species='flavicollis') ORDER BY year,last_namesSELECT 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='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='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')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='Mus' AND (species='musculus' OR species='musculus') 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 * FROM register WHERE sample_no=1487 The Ecological Register: Albo
Albo
Basic information
Sample name: Albo

Reference: M. Holmberg, J. N. Mills, S. McGill, G. Benjamin, and B. A. Ellis. 2003. Bartonella infection in sylvatic small mammals of central Sweden. Epidemiology and Infection 130(1):149-157 [ER 997]
Geography
Country: Sweden


Coordinate: 59° 23' 18" N, 17° 20' 36" E
Coordinate basis: stated in text

Geography comments: coordinate is almost due west of Stockholm in Södermanland County

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: combined

Protection: unprotected

Substrate: ground surface

MAT: 5.5

MAP: 787.0

Habitat comments: "sylvatic and peridomestic habitat types. The most commonly sampled habitats included forest, peridomestic (e.g. barns, sheds, rubbish piles), hedge-rows, rock walls, and disturbed habitats (roadside, fence lines, disturbed forest, etc.)"
climate data are for Södermanland-Östergötland and are from Allen et al. (2014, Eur J Wildl Res)

Methods
Life forms: rodents,other small mammals

Sampling methods: no design,baited,Sherman traps,Tomahawk traps

Sample size: 53 individuals

Years: 1999

Days: 2

Nets or traps: 130

Sampling comments: "approximately 100–130 Sherman traps and 15 Tomahawk traps were baited with peanut butter mixed with rolled oats, and placed in lines of 10–20 traps each, at approximately 5 m intervals"

Metadata
Sample number: 1487

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-06 21:14:33

Modified: 2020-01-14 07:24:19

Abundance distribution
5 species
1 singleton
total count 53
extrapolated richness: 7.1
Fisher's α: 1.354
geometric series k: 0.4429
Hurlbert's PIE: 0.6600
Shannon's H: 1.2703
Good's u: 0.9811
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Apodemus flavicollis26
Apodemus sylvaticus12
Myodes glareolus4
"Clethrionomys glareolus"
Mus musculus117.6 g
Sorex araneus10