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=228 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=228SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=90SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=228 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rubrum' OR junior_species='rubrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='rubrum' OR species='rubrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='rubrum' OR species='rubrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rubrum' OR junior_species='rubrum')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='rubrum' OR species='rubrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='nigra' OR junior_species='nigra')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='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='caroliniana' OR junior_species='caroliniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='caroliniana' OR species='caroliniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='caroliniana' OR species='caroliniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='caroliniana' OR junior_species='caroliniana')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='Carpinus' AND (species='caroliniana' OR species='caroliniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='cordiformis' OR junior_species='cordiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carya' AND (species='cordiformis' OR species='cordiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carya' AND (species='cordiformis' OR species='cordiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='cordiformis' OR junior_species='cordiformis')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='Carya' AND (species='cordiformis' OR species='cordiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='glabra' OR junior_species='glabra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carya' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carya' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='glabra' OR junior_species='glabra')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='Carya' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='ovata' OR junior_species='ovata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carya' AND (species='ovata' OR species='ovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carya' AND (species='ovata' OR species='ovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='ovata' OR junior_species='ovata')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='Carya' AND (species='ovata' OR species='ovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='tomentosa' OR junior_species='tomentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carya' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carya' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='tomentosa' OR junior_species='tomentosa')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='Carya' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercis' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercis' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercis' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercis' AND (junior_species='canadensis' OR junior_species='canadensis')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='Cercis' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cornus' AND (junior_species='florida' OR junior_species='florida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cornus' AND (species='florida' OR species='florida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cornus' AND (species='florida' OR species='florida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cornus' AND (junior_species='florida' OR junior_species='florida')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='Cornus' AND (species='florida' OR species='florida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' 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='Diospyros' AND (species='virginiana' OR species='virginiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='virginiana' OR species='virginiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' 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='Diospyros' AND (species='virginiana' OR species='virginiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liriodendron' AND (junior_species='tulipifera' OR junior_species='tulipifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liriodendron' AND (species='tulipifera' OR species='tulipifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liriodendron' AND (species='tulipifera' OR species='tulipifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liriodendron' AND (junior_species='tulipifera' OR junior_species='tulipifera')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='Liriodendron' AND (species='tulipifera' OR species='tulipifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyssa' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyssa' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyssa' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyssa' AND (junior_species='sylvatica' OR junior_species='sylvatica')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='Nyssa' AND (species='sylvatica' OR species='sylvatica') 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='Prunus' AND (junior_species='serotina' OR junior_species='serotina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='serotina' OR species='serotina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='serotina' OR species='serotina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='serotina' OR junior_species='serotina')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='Prunus' AND (species='serotina' OR species='serotina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='alba' OR junior_species='alba')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='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='coccinea' OR junior_species='coccinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='coccinea' OR species='coccinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='coccinea' OR species='coccinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='coccinea' OR junior_species='coccinea')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='coccinea' OR species='coccinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='falcata' OR junior_species='falcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='falcata' OR species='falcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='falcata' OR species='falcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='falcata' OR junior_species='falcata')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='falcata' OR species='falcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='rubra' OR junior_species='rubra')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='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='stellata' OR junior_species='stellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='stellata' OR species='stellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='stellata' OR species='stellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='stellata' OR junior_species='stellata')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='stellata' OR species='stellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='velutina' OR junior_species='velutina')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='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sassafras' AND (junior_species='albidum' OR junior_species='albidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sassafras' AND (species='albidum' OR species='albidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sassafras' AND (species='albidum' OR species='albidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sassafras' AND (junior_species='albidum' OR junior_species='albidum')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='Sassafras' AND (species='albidum' OR species='albidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ulmus' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ulmus' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='rubra' OR junior_species='rubra')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='rubra' OR species='rubra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=228 The Ecological Register: Stewart State Forest (H)
Stewart State Forest (H)
Basic information
Sample name: Stewart State Forest (H)

Reference: J. L. Hart, S. L. van de Gevel, and D. F. Mann. 2008. Legacy of charcoaling in a Western Highland Rim Forest in Tennessee. American Midland Naturalist 159(1):238-250 [ER 90]
Geography
Country: United States

State: Tennessee


Coordinate: 36° 19' N, 87° 42' W
Coordinate basis: based on nearby landmark

Geography comments: "near Erin" (basis of coordinate) according to Hall et al. (2004, in K. F. Connor, ed.)
elevation of "400 to 500 feet" is for Stewart State Forest and is based on Hall et al.

Environment
Habitat: temperate broadleaf/mixed forest

Protection: national/state forest

Substrate: ground surface

MAT: 15.0

WMT: 26.0

CMT: 3.0

MAP: 1210.0

Habitat comments: charcoal hearth site
MAT, CMT, and WMT stated in text; MAP is for Land Between the Lakes National Recreation Area and is based on Franklin et al. (1997, Journal of Applied Ecology)

Methods
Life forms: trees

Sites: 15

Site area: 0.6

Sample size: 141 individuals

Size min: 10

Basal area: 17.83

Sampling comments: sampled 15 0.04 ha fixed-radius circular plots (p. 239) = 0.6 ha sampled area
Results are given in terms of Density (n/ha). Thus, n=D*0.6 ha

Metadata
Sample number: 228

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-22 16:37:12

Modified: 2017-11-11 00:07:59

Abundance distribution
22 species
4 singletons
total count 141
extrapolated richness: 36.9
Fisher's α: 7.308
geometric series k: 0.8479
Hurlbert's PIE: 0.8946
Shannon's H: 2.5914
Good's u: 0.9722
Each square represents a species. Square sizes are proportional to counts.
Register