SELECT * FROM samples WHERE sample_no=2772
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=2489
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=2772 ORDER BY register_no ASC
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='thunbergii' OR junior_species='thunbergi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Persea' AND (species='thunbergii' OR species='thunbergi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Persea' AND (species='thunbergii' OR species='thunbergi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='thunbergii' OR junior_species='thunbergi')
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='Persea' AND (species='thunbergii' OR species='thunbergi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camellia' 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='Camellia' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Camellia' AND (species='japonica' OR species='japonica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camellia' 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='Camellia' AND (species='japonica' OR species='japonica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sylvestris' OR junior_species='sylvestris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='sylvestris' OR species='sylvestris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sylvestris' OR junior_species='sylvestris')
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='Elaeocarpus' AND (species='sylvestris' OR species='sylvestris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='japonicum' OR species='japonicum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='japonicum' OR species='japonicum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='japonicum' OR species='japonicum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daphniphyllum' AND (junior_species='teijsmannii' OR junior_species='teijsmanni')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Daphniphyllum' AND (species='teijsmannii' OR species='teijsmanni') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Daphniphyllum' AND (species='teijsmannii' OR species='teijsmanni')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daphniphyllum' AND (junior_species='teijsmannii' OR junior_species='teijsmanni')
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='Daphniphyllum' AND (species='teijsmannii' OR species='teijsmanni') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='thunbergii' OR junior_species='thunbergi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinus' AND (species='thunbergii' OR species='thunbergi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pinus' AND (species='thunbergii' OR species='thunbergi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinus' AND (junior_species='thunbergii' OR junior_species='thunbergi')
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='thunbergii' OR species='thunbergi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='camphora' OR junior_species='camphora')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='camphora' OR species='camphora') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='camphora' OR species='camphora')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='camphora' OR junior_species='camphora')
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='Cinnamomum' AND (species='camphora' OR species='camphora') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='sinensis' OR junior_species='sinensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='sinensis' OR species='sinensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='sinensis' OR species='sinensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='sinensis' OR junior_species='sinensis')
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='Celtis' AND (species='sinensis' OR species='sinensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='ailanthoides' OR junior_species='ailanthoides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='ailanthoides' OR species='ailanthoides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='ailanthoides' OR species='ailanthoides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='ailanthoides' OR junior_species='ailanthoides')
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='Zanthoxylum' AND (species='ailanthoides' OR species='ailanthoides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurya' 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='Eurya' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Eurya' AND (species='japonica' OR species='japonica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurya' 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='Eurya' AND (species='japonica' OR species='japonica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='erecta' OR junior_species='erecta')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='erecta' OR species='erecta') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='erecta' OR species='erecta')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='erecta' OR junior_species='erecta')
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='Ficus' AND (species='erecta' OR species='erecta') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='odoratissimum' OR junior_species='odoratissimum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Viburnum' AND (species='odoratissimum' OR species='odoratissimum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Viburnum' AND (species='odoratissimum' OR species='odoratissimum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='odoratissimum' OR junior_species='odoratissimum')
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='odoratissimum' OR species='odoratissimum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='sericea' OR junior_species='sericea')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neolitsea' AND (species='sericea' OR species='sericea') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Neolitsea' AND (species='sericea' OR species='sericea')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='sericea' OR junior_species='sericea')
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='Neolitsea' AND (species='sericea' OR species='sericea') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeagnus' 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='Elaeagnus' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Elaeagnus' AND (species='glabra' OR species='glabra')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeagnus' 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='Elaeagnus' AND (species='glabra' OR species='glabra') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=2772
SELECT genus FROM register WHERE register_no IN (60157,72516,27646,71529,83436,96831,69388,35050,70913,63579) AND species REGEXP '^[a-z]*$'
The Ecological Register: Miyake-jima
Miyake-jima
Basic information
Sample name: Miyake-jima

Reference: T. Kamijo. 1997. Regeneration process of Castanopsis and Persea forest on Miyake-jima, Izu Islands. Japanese Journal of Ecology 47:1-10 [ER 2489]
Geography
Country: Japan


Coordinate: 34° 5' N, 139° 31' E
Coordinate basis: stated in text

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 17.4

MAP: 2872.0

Methods
Life forms: trees

Sites: 1

Site length: 70

Site width: 70

Sampling methods: quadrat

Sample size: 289 individuals

Size min: 5

Basal area: 132.23

Metadata
Sample number: 2772

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-11-04 17:26:10

Modified: 2017-11-04 06:26:18

Abundance distribution
15 species
4 singletons
total count 289
geometric series index: 25.2
Fisher's α: 3.358
geometric series k: 0.7134
Hurlbert's PIE: 0.7420
Shannon's H: 1.7187
Good's u: 0.9862
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Castanopsis cuspidata sieboldii85
Persea thunbergii23
Camellia japonica113
Elaeocarpus sylvestris4
Cinnamomum japonicum21
Daphniphyllum teijsmannii20
Pinus thunbergii1
Cinnamomum camphora1
Celtis sinensis japonica3
Zanthoxylum ailanthoides2
Eurya japonica6
Ficus erecta6
Viburnum odoratissimum2
Neolitsea sericea1
Elaeagnus glabra1