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=3006 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3006SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2784SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3006 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='latifrons' OR junior_species='latifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='latifrons' OR species='latifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='latifrons' OR species='latifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='latifrons' OR junior_species='latifrons')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='Phrynobatrachus' AND (species='latifrons' OR species='latifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='francisci' OR junior_species='franciscii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='francisci' OR species='franciscii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='francisci' OR species='franciscii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='francisci' OR junior_species='franciscii')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='Phrynobatrachus' AND (species='francisci' OR species='franciscii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afrixalus' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Afrixalus' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Afrixalus' AND (species='dorsalis' OR species='dorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afrixalus' AND (junior_species='dorsalis' OR junior_species='dorsalis')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='Afrixalus' AND (species='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='agama' OR junior_species='agama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agama' AND (species='agama' OR species='agama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agama' AND (species='agama' OR species='agama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='agama' OR junior_species='agama')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='Agama' AND (species='agama' OR species='agama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='quinquetaniata' OR junior_species='quinquetaniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='quinquetaniata' OR species='quinquetaniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='quinquetaniata' OR species='quinquetaniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='quinquetaniata' OR junior_species='quinquetaniata')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='Trachylepis' AND (species='quinquetaniata' OR species='quinquetaniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='affinis' OR junior_species='affinis')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='Trachylepis' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='sibilans' OR junior_species='sibilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammophis' AND (species='sibilans' OR species='sibilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammophis' AND (species='sibilans' OR species='sibilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='sibilans' OR junior_species='sibilans')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='Psammophis' AND (species='sibilans' OR species='sibilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='phillipsi' OR junior_species='phillipsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammophis' AND (species='phillipsi' OR species='phillipsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammophis' AND (species='phillipsi' OR species='phillipsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='phillipsi' OR junior_species='phillipsii')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='Psammophis' AND (species='phillipsi' OR species='phillipsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='irregularis' OR junior_species='irregularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philothamnus' AND (species='irregularis' OR species='irregularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philothamnus' AND (species='irregularis' OR species='irregularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='irregularis' OR junior_species='irregularis')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='Philothamnus' AND (species='irregularis' OR species='irregularis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3006 The Ecological Register: Kogyae Strict Nature Reserve (riparian forest mosaic, rainy season)
Kogyae Strict Nature Reserve (riparian forest mosaic, rainy season)
Basic information
Sample name: Kogyae Strict Nature Reserve (riparian forest mosaic, rainy season)

Reference: Y. Musah, D. K. Attuquayefio, B. Y. Ofori, and E. H. Owusu. 2015. Herpetofauna under threat: A study of Kogyae Strict Nature Reserve, Ghana. International Journal of Biodiversity and Conservation 7(11):420-428 [ER 2784]
Geography
Country: Ghana


Coordinate: 7° 12' N, 1° 11' W
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical savanna

Protection: nature reserve

Substrate: ground surface

Disturbance: agriculture,hunting,selective logging

Habitat comments: the reserve "is located in the forest-savanna transition zone" and there are "logging and hunting activities as well as an increasing number of farms encroaching from the south and east... Sampling was undertaken in two distinct habitats types, riparian forest mosaic (RFM) at Oku Nkwanta and savanna woodland (SW) with some rocky outcrops at Dagomba village towards Asasebonso"

Methods
Life forms: lizards,snakes,frogs

Sampling methods: no design,auditory,hand capture,visual

Sample size: 66 captures or sightings

Years: 2012

Seasons: wet or monsoon

Sampling comments: "Visual encounter surveys (Rödel and Ernst, 2004) and refuge examination were undertaken... A running animal was chased and pinned down gently with a stick or a snake hook, then hand-picked... Animals were recorded based on sightings, captures, calls/sounds and interviews... animals were not marked... The survey sites were visited twice, once in the dry season (5 to 9th January, 2012) and once in the rainy season (16 to 21st June, 2012). There were 11 survey days in total, five days in the dry season and six days in the rainy season"

Metadata
Sample number: 3006

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-06-06 19:58:44

Modified: 2018-06-06 09:58:44

Abundance distribution
9 species
2 singletons
total count 66
extrapolated richness: 15.4
Fisher's α: 2.816
geometric series k: 0.6412
Hurlbert's PIE: 0.6709
Shannon's H: 1.5445
Good's u: 0.9706
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Phrynobatrachus latifrons35
Phrynobatrachus francisci5
Afrixalus dorsalis6
Agama agama4
Trachylepis quinquetaniata2
Trachylepis affinis10
Psammophis sibilans1
Psammophis phillipsi2
Philothamnus irregularis1