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=2776 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2776SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2493SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2776 ORDER BY register_no ASCSELECT 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='Abies' AND (junior_species='sachalinensis' OR junior_species='sachalinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abies' AND (species='sachalinensis' OR species='sachalinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abies' AND (species='sachalinensis' OR species='sachalinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='sachalinensis' OR junior_species='sachalinensis')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='Abies' AND (species='sachalinensis' OR species='sachalinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrya' 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='Ostrya' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrya' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrya' 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='Ostrya' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercidiphyllum' 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='Cercidiphyllum' AND (species='japonicum' OR species='japonicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercidiphyllum' AND (species='japonicum' OR species='japonicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercidiphyllum' 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='Cercidiphyllum' AND (species='japonicum' OR species='japonicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maackia' AND (junior_species='amurensis' OR junior_species='amurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maackia' AND (species='amurensis' OR species='amurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maackia' AND (species='amurensis' OR species='amurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maackia' AND (junior_species='amurensis' OR junior_species='amurensis')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='Maackia' AND (species='amurensis' OR species='amurensis') ORDER BY year,last_namesSELECT 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='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='Quercus' AND (junior_species='mongolica' OR junior_species='mongolica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='mongolica' OR species='mongolica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='mongolica' OR species='mongolica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='mongolica' OR junior_species='mongolica')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='mongolica' OR species='mongolica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='laxiflora' OR junior_species='laxiflora')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='laxiflora' OR species='laxiflora') 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='Fraxinus' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='lanuginosa' OR species='lanuginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')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='lanuginosa' OR species='lanuginosa') 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='Prunus' AND (junior_species='sargentii' OR junior_species='sargenti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='sargentii' OR species='sargenti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='sargentii' OR species='sargenti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='sargentii' OR junior_species='sargenti')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='sargentii' OR species='sargenti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalopanax' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kalopanax' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kalopanax' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalopanax' AND (junior_species='pictus' OR junior_species='pictus')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='Kalopanax' AND (species='pictus' OR species='pictus') 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='Carpinus' AND (junior_species='cordata' OR junior_species='cordata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='cordata' OR species='cordata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='cordata' OR species='cordata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='cordata' OR junior_species='cordata')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='cordata' OR species='cordata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2776 The Ecological Register: Biratori
Biratori
Basic information
Sample name: Biratori

Reference: M. Ishida, K. Kikuzawa, T. Asai, N. Mizui, and K. Seiwa. 1991. Distribution and height growth of young trees in the canopy gap and in the closed stand: the case of a coniferous-broadleaved mixed forest in Hokkaido. Journal of the Japanese Forestry Society 73(2):145-150 [ER 2493]
Geography
Country: Japan


Coordinate: 42° 35' N, 142° 8' E
Coordinate basis: stated in text

Geography comments: coordinate places the stand in or very near the town of Biratori
elevation about 100 to 200 m

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 5.6

MAP: 1120.0

Methods
Life forms: trees

Sites: 1

Site area: 0.216

Sampling methods: quadrat

Sample size: 152 individuals

Size min: 10

Basal area: 47.3

Metadata
Sample number: 2776

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-11-05 15:37:53

Modified: 2017-11-05 04:37:53

Abundance distribution
16 species
2 singletons
total count 152
extrapolated richness: 25.2
Fisher's α: 4.511
geometric series k: 0.7366
Hurlbert's PIE: 0.5711
Shannon's H: 1.5681
Good's u: 0.9871
Each square represents a species. Square sizes are proportional to counts.
Register