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=2053 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2053SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2103SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2053 ORDER BY register_no ASCSELECT 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='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='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='Liquidambar' AND (junior_species='styraciflua' OR junior_species='styraciflua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liquidambar' AND (species='styraciflua' OR species='styraciflua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liquidambar' AND (species='styraciflua' OR species='styraciflua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liquidambar' AND (junior_species='styraciflua' OR junior_species='styraciflua')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='Liquidambar' AND (species='styraciflua' OR species='styraciflua') 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='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='Fagus' AND (junior_species='grandifolia' OR junior_species='grandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagus' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagus' AND (species='grandifolia' OR species='grandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='grandifolia' OR junior_species='grandifolia')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='Fagus' AND (species='grandifolia' OR species='grandifolia') 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='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='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='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='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='Ulmus' AND (junior_species='alata' OR junior_species='alata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ulmus' AND (species='alata' OR species='alata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ulmus' AND (species='alata' OR species='alata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='alata' OR junior_species='alata')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='alata' OR species='alata') ORDER BY year,last_namesSELECT 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='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='Quercus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' 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='Fraxinus' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' 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='Fraxinus' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' 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='Fraxinus' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' 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='Fraxinus' AND (species='nigra' OR species='nigra') 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='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='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 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='Amelanchier' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amelanchier' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amelanchier' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amelanchier' AND (junior_species='arborea' OR junior_species='arborea')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='Amelanchier' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxydendrum' AND (junior_species='arboreum' OR junior_species='arboreum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxydendrum' AND (species='arboreum' OR species='arboreum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxydendrum' AND (species='arboreum' OR species='arboreum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxydendrum' AND (junior_species='arboreum' OR junior_species='arboreum')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='Oxydendrum' AND (species='arboreum' OR species='arboreum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2053 The Ecological Register: Bonayer Forest
Bonayer Forest
Basic information
Sample name: Bonayer Forest

Reference: C. K. Bougher and J. E. Winstead. 1974. A phytosociological study of a relict hardwood forest in Barren County, Kentucky. Transactions of the Kentucky Academy of Science 35(1-2):44-54 [ER 2103]
Geography
Country: United States

State: Kentucky


Coordinate: 37° 1' N, 86° 4' W
Coordinate basis: based on nearby landmark

Geography comments: "25 miles (40.25 km) east of Bowling Green and 6 miles (9.7 km) west of Glasgow on U.S. Highway 67 at the village of Bonayer" (coordinate based on Bon Ayr)
altitude range of 165 to 229 m is for this part of the county and is from Johnson (1980, Western Kentucky University M.S. thesis)

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: fragment

Protection: unprotected

Substrate: ground surface

MAT: 13.8

MAP: 1294.0

Habitat comments: "approximately 14.5 acres (5.9 hectares) of mature hardwood forest... there has been no timber removed except for dead chestnut trees after the epidemic of chestnut blight in the late 1930's"
climate data are for Bowling Green and are from Rhoades et al. (2002, Restoration Ecology)

Methods
Life forms: trees

Sites: 30

Site area: 0.3

Sampling methods: quadrat

Sample size: 214 individuals

Years: 1971

Size min: 5

Basal area: 31.8

Sampling comments: "23 quadrats of 10 m x 10 m dimenstions were placed on 4 transect lines with a 30-m interval between each quadrat. Seven additional 100-m2 quadrats were placed at random in the remaining area"

Metadata
Sample number: 2053

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-12 15:06:25

Modified: 2020-06-05 09:03:52

Abundance distribution
24 species
5 singletons
total count 214
extrapolated richness: 36.0
Fisher's α: 6.933
geometric series k: 0.8665
Hurlbert's PIE: 0.9254
Shannon's H: 2.7992
Good's u: 0.9767
Each square represents a species. Square sizes are proportional to counts.
Register