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=3052 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3052SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2811SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3052 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='variabilis' OR junior_species='variabilis')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='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='serrata' OR junior_species='serrata')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='serrata' OR species='serrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='glauca' OR junior_species='glauca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='glauca' OR species='glauca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='glauca' OR species='glauca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='glauca' OR junior_species='glauca')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='glauca' OR species='glauca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='pedunculosa' OR junior_species='pedunculosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='pedunculosa' OR species='pedunculosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='pedunculosa' OR species='pedunculosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='pedunculosa' OR junior_species='pedunculosa')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='pedunculosa' OR species='pedunculosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyonia' AND (junior_species='ovalifolia' OR junior_species='ovalifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lyonia' AND (species='ovalifolia' OR species='ovalifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lyonia' AND (species='ovalifolia' OR species='ovalifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyonia' AND (junior_species='ovalifolia' OR junior_species='ovalifolia')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='Lyonia' AND (species='ovalifolia' OR species='ovalifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaecyparis' AND (junior_species='obtusa' OR junior_species='obtusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaecyparis' AND (species='obtusa' OR species='obtusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaecyparis' AND (species='obtusa' OR species='obtusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaecyparis' AND (junior_species='obtusa' OR junior_species='obtusa')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='Chamaecyparis' AND (species='obtusa' OR species='obtusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Photinia' 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='Photinia' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Photinia' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Photinia' 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='Photinia' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='densiflora' OR junior_species='densiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinus' AND (species='densiflora' OR species='densiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pinus' AND (species='densiflora' OR species='densiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='densiflora' OR junior_species='densiflora')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='densiflora' OR species='densiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gamblea' AND (junior_species='innovans' OR junior_species='innovans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gamblea' AND (species='innovans' OR species='innovans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gamblea' AND (species='innovans' OR species='innovans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gamblea' AND (junior_species='innovans' OR junior_species='innovans')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='Gamblea' AND (species='innovans' OR species='innovans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='macropoda' OR junior_species='macropoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='macropoda' OR species='macropoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='macropoda' OR species='macropoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='macropoda' OR junior_species='macropoda')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='macropoda' OR species='macropoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='prunifolia' OR junior_species='prunifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symplocos' AND (species='prunifolia' OR species='prunifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='prunifolia' OR species='prunifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='prunifolia' OR junior_species='prunifolia')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='Symplocos' AND (species='prunifolia' OR species='prunifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='cuspidata' OR junior_species='cuspidata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castanopsis' AND (species='cuspidata' OR species='cuspidata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='cuspidata' OR species='cuspidata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='cuspidata' OR junior_species='cuspidata')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='Castanopsis' AND (species='cuspidata' OR species='cuspidata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleyera' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cleyera' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cleyera' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleyera' AND (junior_species='japonica' OR junior_species='japonica')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='Cleyera' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clethra' AND (junior_species='barbinervis' OR junior_species='barbinervis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clethra' AND (species='barbinervis' OR species='barbinervis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clethra' AND (species='barbinervis' OR species='barbinervis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clethra' AND (junior_species='barbinervis' OR junior_species='barbinervis')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='Clethra' AND (species='barbinervis' OR species='barbinervis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='sieboldiana' OR junior_species='sieboldiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='sieboldiana' OR species='sieboldiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='sieboldiana' OR species='sieboldiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='sieboldiana' OR junior_species='sieboldiana')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='sieboldiana' OR species='sieboldiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodendron' AND (junior_species='trichocarpum' OR junior_species='trichocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxicodendron' AND (species='trichocarpum' OR species='trichocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxicodendron' AND (species='trichocarpum' OR species='trichocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodendron' AND (junior_species='trichocarpum' OR junior_species='trichocarpum')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='trichocarpum' OR species='trichocarpum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3052
Reference:K. Hirayama, S. Kawamura, T. Nishimura, and H. Takahara. 2010. Establishment of the evergreen broad-leaved tree species Castanopsis cuspidata in an abandoned secondary forest in western Japan. Journal of Plant Research123:655-663 [ER 2811]
Geography
Country: Japan
Coordinate:35° 3' N, 135° 46' E
Coordinate basis: stated in text
Geography comments: "on Mt. Hayashi at Takaragaike hill in the northern part of the Kyoto City urban area"
•
Environment
Habitat: temperate broadleaf/mixed forest
Altered habitat: secondary forest
Protection: unprotected
Substrate: ground surface
MAT: 15.6
WMT: 27.8
CMT: 4.6
MAP: 1545.0
Habitat comments: "secondary forest that was used intensively by humans until the 1960s... warm-temperate, evergreen broad-leaved forest"
climate data are for a station "5 km southwest of the study site"
Methods
Life forms: trees
Sites: 1
Site length: 60
Site width: 40
Sampling methods: quadrat
Sample size: 516 individuals
Years: 2008
Size min: 5
Basal area: 22.22
Metadata
Sample number: 3052
Contributor: John Alroy
Enterer: John Alroy
Created: 2018-07-15 15:45:59
Modified: 2018-07-15 05:45:59
Abundance distribution
16 species
2 singletons
total count 516
extrapolated richness: 20.9
Fisher's α: 3.131
geometric series k: 0.7233
Hurlbert's PIE: 0.8594
Shannon's H: 2.1828
Good's u: 0.9961
Each square represents a species. Square sizes are proportional to counts.