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=2056 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2056SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2106SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2056 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagus' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagus' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='sylvatica' OR junior_species='sylvatica')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='sylvatica' OR species='sylvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abies' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abies' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='alba' OR junior_species='alba')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='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='pseudoplatanus' OR junior_species='pseudoplatanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='pseudoplatanus' OR species='pseudoplatanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='pseudoplatanus' OR species='pseudoplatanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='pseudoplatanus' OR junior_species='pseudoplatanus')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='pseudoplatanus' OR species='pseudoplatanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='excelsior' OR junior_species='excelsior')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='excelsior' OR species='excelsior') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='excelsior' OR species='excelsior')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='excelsior' OR junior_species='excelsior')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='excelsior' OR species='excelsior') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2056 The Ecological Register: Tunjemir 1
Tunjemir 1
Basic information
Sample name: Tunjemir 1

Sample aka: Perucica Forest Reserve

Reference: T. A. Nagel, M. Svoboda, T. Rugani, and J. Diaci. 2010. Gap regeneration and replacement patterns in an old-growth Fagus-Abies forest of Bosnia-Herzegovina. Plant Ecology 208:307-318 [ER 2106]
Geography
Country: Bosnia and Herzegovina


Coordinate: 43° 20' N, 18° 41' E
Coordinate basis: based on nearby landmark

Geography comments: "in the Dinaric Mountains" (coordinate based on Sutjeska National Park)
elevation 1000 to 1300 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: forest reserve

Substrate: ground surface

WMT: 15.0

CMT: -3.3

MAP: 1837.0

Habitat comments: "old-growth... The climate has both the Mediterranean and continental influence"

Methods
Life forms: trees

Sites: 15

Site area: 0.6

Sampling methods: quadrat

Sample size: 252 individuals

Size min: 5

Basal area: 47

Sampling comments: "We established three transects in each stand varying in length from 200 to 400 m... separated by 50 m... Forest structure was sampled in 400 m2 circular plots (n = 55) placed at 40 m intervals along each transect" (this apparently means 55 plots over the four different sites reported in the study; my best guess is that there were 15 plots in this transect, because this is the minimum given that the three transects were each at least 200 m long; this works out to 15 x 400 m2 = 0.6 ha)

Metadata
Sample number: 2056

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-12 18:05:06

Modified: 2017-11-02 03:39:05

Abundance distribution
4 species
0 singletons
total count 252
extrapolated richness: 5.4
Fisher's α: 0.675
geometric series k: 0.2257
Hurlbert's PIE: 0.4346
Shannon's H: 0.6923
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Fagus sylvatica174
Abies alba74
Acer pseudoplatanus2
Fraxinus excelsior2