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=3048 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3048SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2808SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3048 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chengiopanax' AND (junior_species='sciadophylloides' OR junior_species='sciadophylloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chengiopanax' AND (junior_species='sciadophylloides' OR junior_species='sciadophylloides')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='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='japonicum' OR junior_species='japonicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='japonicum' OR species='japonicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='japonicum' OR species='japonicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='japonicum' OR junior_species='japonicum')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='japonicum' OR species='japonicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='micranthum' OR junior_species='micranthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='micranthum' OR species='micranthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='micranthum' OR species='micranthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='micranthum' OR junior_species='micranthum')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='micranthum' OR species='micranthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='mono' OR junior_species='mono')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='mono' OR species='mono') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='mono' OR species='mono')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='mono' OR junior_species='mono')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='mono' OR species='mono') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='nipponicum' OR junior_species='nipponicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='nipponicum' OR species='nipponicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='nipponicum' OR species='nipponicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='nipponicum' OR junior_species='nipponicum')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='nipponicum' OR species='nipponicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rufinerve' OR junior_species='rufinerve')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='rufinerve' OR species='rufinerve') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='rufinerve' OR species='rufinerve')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rufinerve' OR junior_species='rufinerve')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='rufinerve' OR species='rufinerve') 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='Cornus' AND (junior_species='controversa' OR junior_species='controversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cornus' AND (species='controversa' OR species='controversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cornus' AND (species='controversa' OR species='controversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cornus' AND (junior_species='controversa' OR junior_species='controversa')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='controversa' OR species='controversa') 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='Fagus' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagus' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagus' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='crenata' OR junior_species='crenata')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='crenata' OR species='crenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='umbellata' OR junior_species='umbellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lindera' AND (species='umbellata' OR species='umbellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lindera' AND (species='umbellata' OR species='umbellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='umbellata' OR junior_species='umbellata')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='Lindera' AND (species='umbellata' OR species='umbellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='obovata' OR junior_species='obovata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Magnolia' AND (species='obovata' OR species='obovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Magnolia' AND (species='obovata' OR species='obovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='obovata' OR junior_species='obovata')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='Magnolia' AND (species='obovata' OR species='obovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='salicifolia' OR junior_species='salicifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Magnolia' AND (species='salicifolia' OR species='salicifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Magnolia' AND (species='salicifolia' OR species='salicifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='salicifolia' OR junior_species='salicifolia')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='Magnolia' AND (species='salicifolia' OR species='salicifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grayana' OR junior_species='grayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='grayana' OR species='grayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='grayana' OR species='grayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grayana' OR junior_species='grayana')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='grayana' OR species='grayana') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='alnifolia' OR junior_species='alnifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorbus' AND (species='alnifolia' OR species='alnifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorbus' AND (species='alnifolia' OR species='alnifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='alnifolia' OR junior_species='alnifolia')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='Sorbus' AND (species='alnifolia' OR species='alnifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='commixta' OR junior_species='commixta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorbus' AND (species='commixta' OR species='commixta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorbus' AND (species='commixta' OR species='commixta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='commixta' OR junior_species='commixta')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='Sorbus' AND (species='commixta' OR species='commixta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stewartia' AND (junior_species='pseudocamellia' OR junior_species='pseudocamellia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stewartia' AND (junior_species='pseudocamellia' OR junior_species='pseudocamellia')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='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='furcatum' OR junior_species='furcatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Viburnum' AND (species='furcatum' OR species='furcatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Viburnum' AND (species='furcatum' OR species='furcatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='furcatum' OR junior_species='furcatum')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='Viburnum' AND (species='furcatum' OR species='furcatum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3048 The Ecological Register: Daisen Forest Reserve (closed canopy)
Daisen Forest Reserve (closed canopy)
Basic information
Sample name: Daisen Forest Reserve (closed canopy)

Reference: A. Yamashita, J. Sano, and S.-I. Yamamoto. 2002. Impact of a strong typhoon on the structure and dynamics of an old-growth beech (Fagus crenata) forest, southwestern Japan. Folia Geobotanica 37:5-16 [ER 2808]
Geography
Country: Japan


Coordinate: 35° 22' N, 133° 33' E
Coordinate basis: stated in text

Geography comments: "around the Oyasumi-Pass, Mt. Daisen... in the Daisen Forest Reserve, Tottori Prefecture"
coordinate erroneously stated as 35º 21' 77" N, 133º 33' 23" E

Environment
Habitat: temperate broadleaf/mixed forest

Protection: forest reserve

Substrate: ground surface

MAP: 3450.0

Habitat comments: "an old-growth beech stand"
MAP 3400 to 3500 mm

Methods
Life forms: trees

Site area: 0.36

Sample size: 262 individuals

Years: 1998

Size min: 5

Sampling comments: the 36 10 x 10 m quadrats are scattered throughout a 200 x 50 m plot

Metadata
Sample number: 3048

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-07-12 16:05:43

Modified: 2018-07-12 06:05:43

Abundance distribution
19 species
6 singletons
total count 262
extrapolated richness: 31.6
Fisher's α: 4.706
geometric series k: 0.7951
Hurlbert's PIE: 0.8727
Shannon's H: 2.3340
Good's u: 0.9771
Each square represents a species. Square sizes are proportional to counts.
Register