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=573 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=573SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=285SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=573 ORDER BY register_no ASCSELECT 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='Thelotornis' AND (junior_species='kirtlandii' OR junior_species='kirtlandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thelotornis' AND (species='kirtlandii' OR species='kirtlandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thelotornis' AND (species='kirtlandii' OR species='kirtlandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thelotornis' AND (junior_species='kirtlandii' OR junior_species='kirtlandi')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='Thelotornis' AND (species='kirtlandii' OR species='kirtlandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodryas' AND (junior_species='blandingii' OR junior_species='blandingi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxicodryas' AND (species='blandingii' OR species='blandingi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxicodryas' AND (species='blandingii' OR species='blandingi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxicodryas' AND (junior_species='blandingii' OR junior_species='blandingi')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='Toxicodryas' AND (species='blandingii' OR species='blandingi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamnophis' AND (junior_species='aethiopissa' OR junior_species='aethiopissa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhamnophis' AND (species='aethiopissa' OR species='aethiopissa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhamnophis' AND (species='aethiopissa' OR species='aethiopissa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamnophis' AND (junior_species='aethiopissa' OR junior_species='aethiopissa')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='Rhamnophis' AND (species='aethiopissa' OR species='aethiopissa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thrasops' AND (junior_species='flavigularis' OR junior_species='flavigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thrasops' AND (species='flavigularis' OR species='flavigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thrasops' AND (species='flavigularis' OR species='flavigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thrasops' AND (junior_species='flavigularis' OR junior_species='flavigularis')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='Thrasops' AND (species='flavigularis' OR species='flavigularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastropyxis' AND (junior_species='smaragdina' OR junior_species='smaragdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastropyxis' AND (species='smaragdina' OR species='smaragdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastropyxis' AND (species='smaragdina' OR species='smaragdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastropyxis' AND (junior_species='smaragdina' OR junior_species='smaragdina')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='Gastropyxis' AND (species='smaragdina' OR species='smaragdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hapsidophrys' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hapsidophrys' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hapsidophrys' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hapsidophrys' AND (junior_species='lineatus' OR junior_species='lineatus')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='Hapsidophrys' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philothamnus' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philothamnus' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='nitidus' OR junior_species='nitidus')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='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grayia' AND (junior_species='smythii' OR junior_species='smythi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grayia' AND (species='smythii' OR species='smythi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grayia' AND (species='smythii' OR species='smythi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grayia' AND (junior_species='smythii' OR junior_species='smythi')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='Grayia' AND (species='smythii' OR species='smythi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypeltis' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypeltis' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasypeltis' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypeltis' AND (junior_species='fasciata' OR junior_species='fasciata')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='Dasypeltis' AND (species='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotaphopeltis' AND (junior_species='hotamboeia' OR junior_species='hotamboeia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotaphopeltis' AND (species='hotamboeia' OR species='hotamboeia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotaphopeltis' AND (species='hotamboeia' OR species='hotamboeia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotaphopeltis' AND (junior_species='hotamboeia' OR junior_species='hotamboeia')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='Crotaphopeltis' AND (species='hotamboeia' OR species='hotamboeia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naja' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naja' AND (species='melanoleuca' OR species='melanoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')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='Naja' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naja' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naja' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='nigricollis' OR junior_species='nigricollis')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='Naja' AND (species='nigricollis' OR species='nigricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Python' AND (junior_species='sebae' OR junior_species='sebae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Python' AND (species='sebae' OR species='sebae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Python' AND (species='sebae' OR species='sebae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Python' AND (junior_species='sebae' OR junior_species='sebae')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='Python' AND (species='sebae' OR species='sebae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Python' AND (junior_species='regius' OR junior_species='regius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Python' AND (species='regius' OR species='regius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Python' AND (species='regius' OR species='regius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Python' AND (junior_species='regius' OR junior_species='regius')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='Python' AND (species='regius' OR species='regius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=573 The Ecological Register: Southwest of Port Harcourt (secondary mangrove)
Southwest of Port Harcourt (secondary mangrove)
Basic information
Sample name: Southwest of Port Harcourt (secondary mangrove)

Reference: L. Luiselli and G. C. Akani. 2002. An investigation into the composition, complexity and functioning of snake communities in the mangroves of south-eastern Nigeria. African Journal of Ecology 40:220-227 [ER 285]
Geography
Country: Nigeria

State: Rivers


Coordinate: 4° 45' N, 6° 50' E
Coordinate basis: based on nearby landmark

Geography comments: "between the rivers Nun and Brass, in the Niger Delta" (coordinate based on Rivers State)

Environment
Habitat: mangrove

Altered habitat: secondary forest

Substrate: ground surface

WMT: 27.8

CMT: 23.7

MAP: 2436.0

Habitat comments: "secondary 'shrub' mangrove"
climate data are for Port Harcourt and from Uko and Tamunobereton-Ari (2013): min/max CMT (June) 21.78/25.71, min/max WMT (Feb) 22.49/33.08

Methods
Life forms: snakes

Sampling methods: timed,drift fences,pitfall traps,hand capture

Sample size: 50 individuals

Years: 1996 - 2000

Metadata
Sample number: 573

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-26 16:48:42

Modified: 2014-04-26 00:51:42

Abundance distribution
15 species
4 singletons
total count 50
extrapolated richness: 29.9
Fisher's α: 7.265
geometric series k: 0.8548
Hurlbert's PIE: 0.8963
Shannon's H: 2.4645
Good's u: 0.9231
Each square represents a species. Square sizes are proportional to counts.
Register