SELECT * FROM samples WHERE sample_no=2817
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=2514
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=2817 ORDER BY register_no ASC
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucalyptus' AND (junior_species='tereticornis' OR junior_species='tereticornis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucalyptus' AND (species='tereticornis' OR species='tereticornis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Eucalyptus' AND (species='tereticornis' OR species='tereticornis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucalyptus' AND (junior_species='tereticornis' OR junior_species='tereticornis')
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='Eucalyptus' AND (species='tereticornis' OR species='tereticornis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='cardiosperma' OR junior_species='cardiosperma')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='cardiosperma' OR species='cardiosperma') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='cardiosperma' OR species='cardiosperma')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='cardiosperma' OR junior_species='cardiosperma')
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='Aporosa' AND (species='cardiosperma' OR species='cardiosperma') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='spicata' OR junior_species='spicata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symplocos' AND (species='spicata' OR species='spicata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='spicata' OR species='spicata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='spicata' OR junior_species='spicata')
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='spicata' OR species='spicata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='paniculata' OR junior_species='paniculata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='paniculata' OR species='paniculata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='paniculata' OR junior_species='paniculata')
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='Terminalia' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='dioica' OR junior_species='dioica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olea' AND (species='dioica' OR species='dioica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Olea' AND (species='dioica' OR species='dioica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='dioica' OR junior_species='dioica')
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='Olea' AND (species='dioica' OR species='dioica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='peltata' OR junior_species='peltata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='peltata' OR species='peltata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='peltata' OR species='peltata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='peltata' OR junior_species='peltata')
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='Macaranga' AND (species='peltata' OR species='peltata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Careya' AND (junior_species='arborea' OR junior_species='arborea')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Careya' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Careya' AND (species='arborea' OR species='arborea')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Careya' AND (junior_species='arborea' OR junior_species='arborea')
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='Careya' AND (species='arborea' OR species='arborea') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='marsupium' OR junior_species='marsupium')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocarpus' AND (species='marsupium' OR species='marsupium') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='marsupium' OR species='marsupium')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='marsupium' OR junior_species='marsupium')
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='Pterocarpus' AND (species='marsupium' OR species='marsupium') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')
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='Artocarpus' AND (species='hirsutus' OR species='hirsutus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='indica' OR species='indica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')
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='Mangifera' AND (species='indica' OR species='indica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='laurifolia' OR junior_species='laurifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydnocarpus' AND (species='laurifolia' OR species='laurifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Hydnocarpus' AND (species='laurifolia' OR species='laurifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='laurifolia' OR junior_species='laurifolia')
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='Hydnocarpus' AND (species='laurifolia' OR species='laurifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='lanceolata' OR junior_species='lanceolata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchanania' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Buchanania' AND (species='lanceolata' OR species='lanceolata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='lanceolata' OR junior_species='lanceolata')
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='Buchanania' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllanthus' AND (junior_species='emblica' OR junior_species='emblica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllanthus' AND (species='emblica' OR species='emblica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Phyllanthus' AND (species='emblica' OR species='emblica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllanthus' AND (junior_species='emblica' OR junior_species='emblica')
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='Phyllanthus' AND (species='emblica' OR species='emblica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='odoratissima' OR junior_species='odoratissima')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='odoratissima' OR species='odoratissima') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='odoratissima' OR species='odoratissima')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='odoratissima' OR junior_species='odoratissima')
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='Albizia' AND (species='odoratissima' OR species='odoratissima') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='crenulata' OR junior_species='crenulata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bridelia' AND (species='crenulata' OR species='crenulata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Bridelia' AND (species='crenulata' OR species='crenulata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='crenulata' OR junior_species='crenulata')
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='Bridelia' AND (species='crenulata' OR species='crenulata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='bellirica' OR junior_species='bellirica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='bellirica' OR species='bellirica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='bellirica' OR species='bellirica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='bellirica' OR junior_species='bellirica')
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='Terminalia' AND (species='bellirica' OR species='bellirica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='procera' OR junior_species='procera')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='procera' OR species='procera') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='procera' OR species='procera')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='procera' OR junior_species='procera')
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='Albizia' AND (species='procera' OR species='procera') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='altissima' OR junior_species='altissima')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='altissima' OR species='altissima') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='altissima' OR species='altissima')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='altissima' OR junior_species='altissima')
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='Vitex' AND (species='altissima' OR species='altissima') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacardium' AND (junior_species='occidentale' OR junior_species='occidentale')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anacardium' AND (species='occidentale' OR species='occidentale') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Anacardium' AND (species='occidentale' OR species='occidentale')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacardium' AND (junior_species='occidentale' OR junior_species='occidentale')
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='Anacardium' AND (species='occidentale' OR species='occidentale') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='dichotoma' OR junior_species='dichotoma')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='dichotoma' OR species='dichotoma') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='dichotoma' OR species='dichotoma')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='dichotoma' OR junior_species='dichotoma')
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='Tabernaemontana' AND (species='dichotoma' OR species='dichotoma') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='glandulosa' OR junior_species='glandulosa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='glandulosa' OR species='glandulosa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='glandulosa' OR junior_species='glandulosa')
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='glandulosa' OR species='glandulosa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='callosa' OR junior_species='callosa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='callosa' OR species='callosa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='callosa' OR species='callosa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='callosa' OR junior_species='callosa')
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='callosa' OR species='callosa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psidium' AND (junior_species='guajava' OR junior_species='guajava')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psidium' AND (species='guajava' OR species='guajava') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Psidium' AND (species='guajava' OR species='guajava')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psidium' AND (junior_species='guajava' OR junior_species='guajava')
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='Psidium' AND (species='guajava' OR species='guajava') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=2817
SELECT genus FROM register WHERE register_no IN (42713,72355,78395,5435,85334,9928,16584,64555,69530,57062) AND species REGEXP '^[a-z]*$'
The Ecological Register: Neyyar Wildlife Sanctuary
Neyyar Wildlife Sanctuary
Basic information
Sample name: Neyyar Wildlife Sanctuary

Reference: S. J. George, B. Mohan Kumar, and G. R. Rajiv. 1993. Nature of secondary succession in the abandoned Eucalyptus plantations of Neyyar (Kerala) in Peninsular India. Journal of Tropical Forest Science 5(3):372-386 [ER 2514]
Geography
Country: India

State: Kerala


Coordinate: 8° 35' 0" N, 77° 2' 30" E
Coordinate basis: stated in text

Geography comments: "in the Neyyar Wildlife Sanctuary... 8º 17' N and 8º 53' N latitudes; 76º 48'E and 77º 17'E longitudes"
elevation range of the sanctuary is 90 to 1868 m based on Mathew et al. (2007, Zoos' Print Journal)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: plantation

Protection: wildlife protected area

Substrate: ground surface

MAT: 25.5

MAP: 2800.0

Habitat comments: "E. tereticornis was planted in this area during 1964 and 1965 and was clear-felled in 1975 (total area: 111.48 ha). The plantation was abandoned" in 1972 and the original habitat was "secondary moist deciduous" forest
MAP stated in text
MAT is for the adjacent Kottoor Reserve and is based on the mean daily minimum and maximum of 16 and 35ºC reported by Vijayan et al. (2007, Indian Journal of Traditional Knowledge)

Methods
Life forms: trees

Sites: 100

Site area: 1

Sampling methods: quadrat

Sample size: 727 individuals

Years: 1990

Size min: 15

Basal area: 12.77

Sampling comments: "One hundred 10 x 10 m quadrats were randomly distributed in the study area"

Metadata
Sample number: 2817

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-11-28 21:03:40

Modified: 2017-11-28 10:30:23

Abundance distribution
23 species
2 singletons
total count 727
geometric series index: 29.5
Fisher's α: 4.522
geometric series k: 0.7802
Hurlbert's PIE: 0.8504
Shannon's H: 2.3456
Good's u: 0.9973
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Eucalyptus tereticornis235
Aporosa cardiosperma63
"Aporusa lindleyana"
Symplocos spicata74
Terminalia paniculata62
Olea dioica60
Macaranga peltata54
Careya arborea36
Pterocarpus marsupium37
Artocarpus hirsutus14
Mangifera indica9
Hydnocarpus laurifolia19
Buchanania lanceolata13
Phyllanthus emblica18
"Emblica officinalis"
Albizia odoratissima2
Bridelia crenulata5
Terminalia bellirica6
Albizia procera4
Vitex altissima2
Anacardium occidentale4
Tabernaemontana dichotoma6
Elaeocarpus glandulosa1
Ficus callosa2
Psidium guajava1