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=242 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=242SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=100SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=242 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotsuga' AND (junior_species='menziesii' OR junior_species='menziesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudotsuga' AND (species='menziesii' OR species='menziesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudotsuga' AND (species='menziesii' OR species='menziesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotsuga' AND (junior_species='menziesii' OR junior_species='menziesi')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='Pseudotsuga' AND (species='menziesii' OR species='menziesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='densiflorus' OR junior_species='densiflorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='densiflorus' OR species='densiflorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='densiflorus' OR species='densiflorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='densiflorus' OR junior_species='densiflorus')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='Lithocarpus' AND (species='densiflorus' OR species='densiflorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='parvula' OR junior_species='parvula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='parvula' OR species='parvula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='parvula' OR species='parvula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='parvula' OR junior_species='parvula')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='parvula' OR species='parvula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='agrifolia' OR junior_species='agrifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='agrifolia' OR species='agrifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='agrifolia' OR species='agrifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='agrifolia' OR junior_species='agrifolia')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='agrifolia' OR species='agrifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arbutus' AND (junior_species='menziesii' OR junior_species='menziesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arbutus' AND (species='menziesii' OR species='menziesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arbutus' AND (species='menziesii' OR species='menziesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arbutus' AND (junior_species='menziesii' OR junior_species='menziesi')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='Arbutus' AND (species='menziesii' OR species='menziesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodendron' AND (junior_species='diversilobum' OR junior_species='diversilobum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxicodendron' AND (species='diversilobum' OR species='diversilobum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxicodendron' AND (species='diversilobum' OR species='diversilobum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodendron' AND (junior_species='diversilobum' OR junior_species='diversilobum')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='Toxicodendron' AND (species='diversilobum' OR species='diversilobum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamnus' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhamnus' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhamnus' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamnus' AND (junior_species='californica' OR junior_species='californica')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='Rhamnus' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vaccinium' AND (junior_species='ovatum' OR junior_species='ovatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vaccinium' AND (species='ovatum' OR species='ovatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vaccinium' AND (species='ovatum' OR species='ovatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vaccinium' AND (junior_species='ovatum' OR junior_species='ovatum')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='Vaccinium' AND (species='ovatum' OR species='ovatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sequoia' AND (junior_species='sempervirens' OR junior_species='sempervirens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sequoia' AND (species='sempervirens' OR species='sempervirens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sequoia' AND (species='sempervirens' OR species='sempervirens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sequoia' AND (junior_species='sempervirens' OR junior_species='sempervirens')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='Sequoia' AND (species='sempervirens' OR species='sempervirens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corylus' AND (junior_species='cornuta' OR junior_species='cornuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corylus' AND (species='cornuta' OR species='cornuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corylus' AND (species='cornuta' OR species='cornuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corylus' AND (junior_species='cornuta' OR junior_species='cornuta')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='Corylus' AND (species='cornuta' OR species='cornuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctostaphylos' 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='Arctostaphylos' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctostaphylos' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctostaphylos' 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='Arctostaphylos' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cotoneaster' AND (junior_species='pannosus' OR junior_species='pannosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cotoneaster' AND (species='pannosus' OR species='pannosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cotoneaster' AND (species='pannosus' OR species='pannosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cotoneaster' AND (junior_species='pannosus' OR junior_species='pannosus')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='Cotoneaster' AND (species='pannosus' OR species='pannosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='ponderosa' OR junior_species='ponderosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinus' AND (species='ponderosa' OR species='ponderosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pinus' AND (species='ponderosa' OR species='ponderosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='ponderosa' OR junior_species='ponderosa')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='Pinus' AND (species='ponderosa' OR species='ponderosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctostaphylos' AND (junior_species='andersonii' OR junior_species='andersoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctostaphylos' AND (species='andersonii' OR species='andersoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctostaphylos' AND (species='andersonii' OR species='andersoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctostaphylos' AND (junior_species='andersonii' OR junior_species='andersoni')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='Arctostaphylos' AND (species='andersonii' OR species='andersoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromeles' AND (junior_species='arbutifolia' OR junior_species='arbutifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteromeles' AND (species='arbutifolia' OR species='arbutifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteromeles' AND (species='arbutifolia' OR species='arbutifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromeles' AND (junior_species='arbutifolia' OR junior_species='arbutifolia')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='Heteromeles' AND (species='arbutifolia' OR species='arbutifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='aquifolium' OR junior_species='aquifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='aquifolium' OR species='aquifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='aquifolium' OR species='aquifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='aquifolium' OR junior_species='aquifolium')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='Ilex' AND (species='aquifolium' OR species='aquifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umbellularia' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Umbellularia' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umbellularia' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umbellularia' AND (junior_species='californica' OR junior_species='californica')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='Umbellularia' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morella' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morella' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morella' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morella' AND (junior_species='californica' OR junior_species='californica')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='Morella' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedera' AND (junior_species='helix' OR junior_species='helix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hedera' AND (species='helix' OR species='helix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hedera' AND (species='helix' OR species='helix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedera' AND (junior_species='helix' OR junior_species='helix')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='Hedera' AND (species='helix' OR species='helix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucalyptus' AND (junior_species='globulus' OR junior_species='globulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucalyptus' AND (species='globulus' OR species='globulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucalyptus' AND (species='globulus' OR species='globulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucalyptus' AND (junior_species='globulus' OR junior_species='globulus')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='Eucalyptus' AND (species='globulus' OR species='globulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='macrophyllum' OR junior_species='macrophyllum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='macrophyllum' OR species='macrophyllum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='macrophyllum' OR species='macrophyllum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='macrophyllum' OR junior_species='macrophyllum')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='macrophyllum' OR species='macrophyllum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salix' AND (junior_species='lasiandra' OR junior_species='lasiandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salix' AND (species='lasiandra' OR species='lasiandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salix' AND (species='lasiandra' OR species='lasiandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salix' AND (junior_species='lasiandra' OR junior_species='lasiandra')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='Salix' AND (species='lasiandra' OR species='lasiandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceanothus' AND (junior_species='thyrsiflorus' OR junior_species='thyrsiflorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceanothus' AND (species='thyrsiflorus' OR species='thyrsiflorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceanothus' AND (species='thyrsiflorus' OR species='thyrsiflorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceanothus' AND (junior_species='thyrsiflorus' OR junior_species='thyrsiflorus')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='Ceanothus' AND (species='thyrsiflorus' OR species='thyrsiflorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='attenuata' OR junior_species='attenuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinus' AND (species='attenuata' OR species='attenuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pinus' AND (species='attenuata' OR species='attenuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='attenuata' OR junior_species='attenuata')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='Pinus' AND (species='attenuata' OR species='attenuata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=242 The Ecological Register: Plot UCSC-FERP
Plot UCSC-FERP
Basic information
Sample name: Plot UCSC-FERP

Sample aka: UCSC Forest Ecology Research Plot

Reference: G. S. Gilbert, E. Howard, B. Ayala-Orozco, M. Bonilla-Moheno, J. Cummings, S. Langridge, I. M. Parker, J. Pasari, D. Schweizer, and S. Swope. 2010. Beyond the tropics: forest structure in a temperate forest mapped plot. Journal of Vegetation Science 21:388-405 [ER 100]
Geography
Country: United States

State: California


Coordinate: 37° 0' 42" N, 122° 4' 29" W
Coordinate basis: stated in text

Geography comments: coordinate stated in the text 37º0.745'N, 122º4.490'W

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

WMT: 17.1

CMT: 9.7

MAP: 776.0

Methods
Life forms: trees

Sites: 1

Site area: 6

Sampling methods: quadrat

Sample size: 3623 individuals

Size min: 5

Sampling comments: Although authors report the numer of wooded species for 1, 2, 5, 10, 20, 30, and 60cm DBH (see Table 1, p. 395), here only those bigger than 5 cm DMH are included.
JA: total basal area down to 1 cm dbh is 47.3 m2/ha and 97% of that applies to the 10 cm+ dbh class, but no figure is given for the 5 cm+ dbh class

Metadata
Sample number: 242

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-25 14:14:13

Modified: 2021-07-11 05:43:18

Abundance distribution
24 species
4 singletons
total count 3623
extrapolated richness: 35.4
Fisher's α: 3.449
geometric series k: 0.7315
Hurlbert's PIE: 0.7781
Shannon's H: 1.7522
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
Register