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=2755 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2755SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2475SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2755 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrahamia' AND (junior_species='grandidieri' OR junior_species='grandidierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrahamia' AND (species='grandidieri' OR species='grandidierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abrahamia' AND (species='grandidieri' OR species='grandidierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrahamia' AND (junior_species='grandidieri' OR junior_species='grandidierii')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='Abrahamia' AND (species='grandidieri' OR species='grandidierii') ORDER BY year,last_namesSELECT 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,yearSELECT *,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_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerbera' AND (junior_species='venenifera' OR junior_species='venenifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerbera' AND (species='venenifera' OR species='venenifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerbera' AND (species='venenifera' OR species='venenifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerbera' AND (junior_species='venenifera' OR junior_species='venenifera')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='Cerbera' AND (species='venenifera' OR species='venenifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuxia' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nuxia' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nuxia' AND (species='oppositifolia' OR species='oppositifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuxia' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')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='Nuxia' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='seyrigii' OR junior_species='seyrigi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='seyrigii' OR species='seyrigi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='seyrigii' OR species='seyrigi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='seyrigii' OR junior_species='seyrigi')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='seyrigii' OR species='seyrigi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='humbertiana' OR junior_species='humbertiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='humbertiana' OR species='humbertiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='humbertiana' OR species='humbertiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='humbertiana' OR junior_species='humbertiana')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='Diospyros' AND (species='humbertiana' OR species='humbertiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='gummifera' OR junior_species='gummifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='gummifera' OR species='gummifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='gummifera' OR species='gummifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='gummifera' OR junior_species='gummifera')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='gummifera' OR species='gummifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='tulearensis' OR junior_species='tulearensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='tulearensis' OR species='tulearensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='tulearensis' OR species='tulearensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='tulearensis' OR junior_species='tulearensis')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='tulearensis' OR species='tulearensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sesbania' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sesbania' AND (species='rostrata' OR species='rostrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sesbania' AND (species='rostrata' OR species='rostrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sesbania' AND (junior_species='rostrata' OR junior_species='rostrata')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='Sesbania' AND (species='rostrata' OR species='rostrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmiopsis' AND (junior_species='hily' OR junior_species='hily')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helmiopsis' AND (species='hily' OR species='hily') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helmiopsis' AND (species='hily' OR species='hily')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmiopsis' AND (junior_species='hily' OR junior_species='hily')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='Helmiopsis' AND (species='hily' OR species='hily') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melia' AND (junior_species='azedarach' OR junior_species='azedarach')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melia' AND (species='azedarach' OR species='azedarach') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melia' AND (species='azedarach' OR species='azedarach')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melia' AND (junior_species='azedarach' OR junior_species='azedarach')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='Melia' AND (species='azedarach' OR species='azedarach') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='jambolana' OR junior_species='jambolana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='jambolana' OR species='jambolana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='jambolana' OR species='jambolana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='jambolana' OR junior_species='jambolana')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='Eugenia' AND (species='jambolana' OR species='jambolana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandanus' AND (junior_species='dauphinensis' OR junior_species='dauphinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pandanus' AND (species='dauphinensis' OR species='dauphinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pandanus' AND (species='dauphinensis' OR species='dauphinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandanus' AND (junior_species='dauphinensis' OR junior_species='dauphinensis')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='Pandanus' AND (species='dauphinensis' OR species='dauphinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Breonadia' AND (junior_species='salicina' OR junior_species='salicina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Breonadia' AND (species='salicina' OR species='salicina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Breonadia' AND (species='salicina' OR species='salicina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Breonadia' AND (junior_species='salicina' OR junior_species='salicina')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='Breonadia' AND (species='salicina' OR species='salicina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2755 The Ecological Register: Andohahela National Park (gallery forest)
Andohahela National Park (gallery forest)
Basic information
Sample name: Andohahela National Park (gallery forest)

Reference: T. Andriaharimalala, E. Roger, C. Rajeriarison, and J. U. Ganzhorn. 2012. Phenology of different vegetation types in the dry forest of Andohahela National Park, southeastern Madagascar. Malagasy Nature 6:24-45 [ER 2475]
Geography
Country: Madagascar


Coordinate: 24° 49' S, 46° 40' E
Coordinate basis: stated in text as range

Geography comments: near the villages of Ambatoabo, Ankoba, and Tsimelahy
altitudes of the three sites are 150, 160, and 100 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

WMT: 28.2

CMT: 23.8

MAP: 650.0

Habitat comments: "the dry season lasts for 5 to 6 months with an annual precipitation between 600 and 700 mm"

Methods
Life forms: trees

Sites: 3

Site area: 0.15

Sampling methods: quadrat

Sample size: 60 individuals

Years: 2007 - 2009

Size min: 10

Sampling comments: sites were each "10 x 50 m2"

Metadata
Sample number: 2755

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-10-27 19:02:15

Modified: 2017-10-27 08:02:15

Abundance distribution
14 species
7 singletons
total count 60
extrapolated richness: 37.8
Fisher's α: 5.743
geometric series k: 0.7761
Hurlbert's PIE: 0.7503
Shannon's H: 1.9146
Good's u: 0.8839
Each square represents a species. Square sizes are proportional to counts.
Register