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=1818 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1818SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1589SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1818 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='arcticus' OR junior_species='arcticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='arcticus' OR species='arcticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='arcticus' OR junior_species='arcticus')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='arcticus' OR species='arcticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='cinereus' OR junior_species='cinereus')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='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='hoyi' OR junior_species='hoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='hoyi' OR species='hoyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='hoyi' OR junior_species='hoyii')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='hoyi' OR species='hoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')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='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='pennsylvanicus' OR species='pennsylvanicus') 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='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zapus' AND (species='hudsonius' OR species='hudsonius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')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='Zapus' AND (species='hudsonius' OR species='hudsonius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1818 The Ecological Register: North of Madison
North of Madison
Basic information
Sample name: North of Madison

Reference: G. C. Clough. 1963. Biology of the arctic shrew, Sorex arcticus. American Midland Naturalist 69(1):69-81 [ER 1589]
Geography
Country: United States

State: Wisconsin


Coordinate: 43° 4' N, 89° 24' W
Coordinate basis: based on nearby landmark

Geography comments: "one mile north of Madison" (basis of coordinate)

•
Environment
Habitat: temperate wetland

Substrate: ground surface

MAT: 7.3

MAP: 784.0

Habitat comments: "a marsh... primarily grass-sedge... Each spring much of the surface, except for the emergent tussocks, was covered with water up to six inches deep"
climate data are from Kucharik et al. (2003, Journal of Soil and Water Conservation) and are apparently for Dane County: mean annual daily min/max 1.5 and 13.1 C

Methods
Life forms: rodents,other small mammals

Sampling methods: snap traps,other traps

Sample size: 261 individuals

Years: 1959 - 1961

Net or trap nights: 6500

Sampling comments: "Longworth live traps were used in two areas... One hundred trapping stations were marked by states placed in 10 rows of 10 stations each. Stations were 50 feet apart. Generally 40 to 50 live traps, one at a station, were set during one trapping period. Snap traps were used once for a period of five days on a square grid of the same dimensions as the live-trap grids. The major portion of the material was collected on two trap lines... Each line consisted of two parallel rows 400 feet apart, of 20 stations each. Three Victor snap traps, baited with a peanut butter-rolled oats mixture were set at each station in a triangle" and "operated alternately at intervals of six to eight weeks for three days at each period... The two census lines were operated from April, 1959, through July, 1961, with a total of 16 trapping periods" (total trapping effort 45 x 3 x 16 + 100 x 5 + 2 x 2 x 20 x 3 x 16 = 6500 trap nights)

Metadata
Sample number: 1818

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-12-11 13:28:10

Modified: 2015-12-11 02:28:10

Abundance distribution
7 species
1 singleton
total count 261
extrapolated richness: 9.4
Fisher's α: 1.323
geometric series k: 0.4240
Hurlbert's PIE: 0.5202
Shannon's H: 1.0540
Good's u: 0.9962
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sorex arcticus288.1 g
Sorex cinereus464.1 g
Sorex hoyi12.8 g
"Microsorex hoyi"
Blarina brevicauda415.1 g
Microtus pennsylvanicus17235.7 g
Mus musculus317.6 g
Zapus hudsonius715.6 g