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=1010 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1010SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=698SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1010 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='saccharum' OR junior_species='saccharum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='saccharum' OR species='saccharum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='saccharum' OR species='saccharum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='saccharum' OR junior_species='saccharum')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='Acer' AND (species='saccharum' OR species='saccharum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tilia' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tilia' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tilia' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tilia' AND (junior_species='americana' OR junior_species='americana')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='Tilia' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrya' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ostrya' AND (species='virginiana' OR species='virginiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrya' AND (species='virginiana' OR species='virginiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrya' AND (junior_species='virginiana' OR junior_species='virginiana')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='Ostrya' AND (species='virginiana' OR species='virginiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')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='Quercus' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='papyrifera' OR junior_species='papyrifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='papyrifera' OR species='papyrifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='papyrifera' OR species='papyrifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='papyrifera' OR junior_species='papyrifera')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='Betula' AND (species='papyrifera' OR species='papyrifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Populus' AND (junior_species='balsamifera' OR junior_species='balsamifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Populus' AND (species='balsamifera' OR species='balsamifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Populus' AND (species='balsamifera' OR species='balsamifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Populus' AND (junior_species='balsamifera' OR junior_species='balsamifera')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='Populus' AND (species='balsamifera' OR species='balsamifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='pennsylvanica' OR junior_species='pennsylvanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='pennsylvanica' OR species='pennsylvanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='pennsylvanica' OR species='pennsylvanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='pennsylvanica' OR junior_species='pennsylvanica')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='Fraxinus' AND (species='pennsylvanica' OR species='pennsylvanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ulmus' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ulmus' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='americana' OR junior_species='americana')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='Ulmus' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='fulva' OR junior_species='fulva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ulmus' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ulmus' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='fulva' OR junior_species='fulva')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='Ulmus' AND (species='fulva' OR species='fulva') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1010 The Ecological Register: Waubun
Waubun
Basic information
Sample name: Waubun

Reference: M. F. Buell and J. E. Cantlon. 1951. A study of two forest stands in Minnesota with an interpretation of the prairie-forest margin. Ecology 32(2):294-316 [ER 698]
Geography
Country: United States

State: Minnesota


Coordinate: 47.201° N, -95.774° W
Coordinate basis: stated in text

Geography comments: SW quarter sec 17 T143N R406W
altitude of 1300 ft is for Waubun and is based on fig. 1 in Buell and Facey (1960, Bulletin of the Torrey Botanical Club)

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 3.7

MAP: 640.0

Habitat comments: climate data are for Itasca State Park and are from Webb and Scanga (2001, Ecology)

Methods
Life forms: trees

Sites: 1

Site length: 250

Site width: 10

Sampling methods: belt transect

Sample size: 391 individuals

Size min: 1

Basal area: 8.5211

Sampling comments: 25 10 x 10 m quadrats arrayed in a transect

Metadata
Sample number: 1010

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-07-08 16:04:38

Modified: 2017-11-10 09:49:53

Abundance distribution
9 species
1 singleton
total count 391
extrapolated richness: 11.2
Fisher's α: 1.644
geometric series k: 0.5240
Hurlbert's PIE: 0.6841
Shannon's H: 1.4261
Good's u: 0.9974
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Acer saccharum92
Tilia americana21
Ostrya virginiana106
Quercus macrocarpa olivaeformis
Betula papyrifera3
Populus balsamifera1
Fraxinus pennsylvanica0
Ulmus americana4
Ulmus fulva2