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=434 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=434SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=210SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=434 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyodipsas' AND (junior_species='concolor' OR junior_species='concolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblyodipsas' AND (species='concolor' OR species='concolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblyodipsas' AND (species='concolor' OR species='concolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyodipsas' AND (junior_species='concolor' OR junior_species='concolor')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='Amblyodipsas' AND (species='concolor' OR species='concolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyodipsas' AND (junior_species='polylepis' OR junior_species='polylepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblyodipsas' AND (species='polylepis' OR species='polylepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblyodipsas' AND (species='polylepis' OR species='polylepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyodipsas' AND (junior_species='polylepis' OR junior_species='polylepis')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='Amblyodipsas' AND (species='polylepis' OR species='polylepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aparallactus' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aparallactus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aparallactus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aparallactus' AND (junior_species='capensis' OR junior_species='capensis')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='Aparallactus' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='walbergi' OR junior_species='walbergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arthroleptis' AND (species='walbergi' OR species='walbergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arthroleptis' AND (species='walbergi' OR species='walbergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthroleptis' AND (junior_species='walbergi' OR junior_species='walbergii')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='Arthroleptis' AND (species='walbergi' OR species='walbergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atractaspis' AND (junior_species='bibronii' OR junior_species='bibroni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atractaspis' AND (species='bibronii' OR species='bibroni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atractaspis' AND (species='bibronii' OR species='bibroni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atractaspis' AND (junior_species='bibronii' OR junior_species='bibroni')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='Atractaspis' AND (species='bibronii' OR species='bibroni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amietophrynus' AND (species='gutturalis' OR species='gutturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amietophrynus' AND (species='gutturalis' OR species='gutturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='gutturalis' OR junior_species='gutturalis')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='Amietophrynus' AND (species='gutturalis' OR species='gutturalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Causus' AND (junior_species='rhombeatus' OR junior_species='rhombeatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Causus' AND (species='rhombeatus' OR species='rhombeatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Causus' AND (species='rhombeatus' OR species='rhombeatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Causus' AND (junior_species='rhombeatus' OR junior_species='rhombeatus')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='Causus' AND (species='rhombeatus' OR species='rhombeatus') 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='Duberria' AND (junior_species='lutrix' OR junior_species='lutrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Duberria' AND (species='lutrix' OR species='lutrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duberria' AND (species='lutrix' OR species='lutrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duberria' AND (junior_species='lutrix' OR junior_species='lutrix')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='Duberria' AND (species='lutrix' OR species='lutrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhosaurus' 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='Gerrhosaurus' AND (species='flavigularis' OR species='flavigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerrhosaurus' AND (species='flavigularis' OR species='flavigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhosaurus' 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='Gerrhosaurus' AND (species='flavigularis' OR species='flavigularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='mabouia' OR species='mabouia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')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='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodonomorphus' AND (junior_species='rufulus' OR junior_species='rufulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycodonomorphus' AND (species='rufulus' OR species='rufulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycodonomorphus' AND (species='rufulus' OR species='rufulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycodonomorphus' AND (junior_species='rufulus' OR junior_species='rufulus')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='Lycodonomorphus' AND (species='rufulus' OR species='rufulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mehelya' AND (junior_species='nyassae' OR junior_species='nyassae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mehelya' AND (species='nyassae' OR species='nyassae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mehelya' AND (species='nyassae' OR species='nyassae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mehelya' AND (junior_species='nyassae' OR junior_species='nyassae')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='Mehelya' AND (species='nyassae' OR species='nyassae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panaspis' AND (junior_species='wahlbergii' OR junior_species='wahlbergi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panaspis' AND (species='wahlbergii' OR species='wahlbergi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panaspis' AND (species='wahlbergii' OR species='wahlbergi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panaspis' AND (junior_species='wahlbergii' OR junior_species='wahlbergi')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='Panaspis' AND (species='wahlbergii' OR species='wahlbergi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='hoplogaster' OR junior_species='hoplogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philothamnus' AND (species='hoplogaster' OR species='hoplogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philothamnus' AND (species='hoplogaster' OR species='hoplogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='hoplogaster' OR junior_species='hoplogaster')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='hoplogaster' OR species='hoplogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='mababiensis' OR junior_species='mababiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='mababiensis' OR species='mababiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='mababiensis' OR species='mababiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='mababiensis' OR junior_species='mababiensis')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='mababiensis' OR species='mababiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='natalensis' OR junior_species='natalensis')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='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schismaderma' AND (junior_species='carens' OR junior_species='carens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schismaderma' AND (species='carens' OR species='carens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schismaderma' AND (species='carens' OR species='carens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schismaderma' AND (junior_species='carens' OR junior_species='carens')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='Schismaderma' AND (species='carens' OR species='carens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomopterna' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tomopterna' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tomopterna' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tomopterna' AND (junior_species='natalensis' OR junior_species='natalensis')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='Tomopterna' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='striata' OR junior_species='striata')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='striata' OR species='striata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=434 The Ecological Register: Mtunzini (riparian)
Mtunzini (riparian)
Basic information
Sample name: Mtunzini (riparian)

Reference: B. Maritz and G. J. Alexander. 2007. Herpetofaunal utilisation of riparian buffer zones in an agricultural landscape near Mtunzini, South Africa. African Journal of Herpetology 56(2):163-169 [ER 210]
Geography
Country: South Africa

State: KwaZulu-Natal


Coordinate: 28° 58' S, 31° 44' E
Coordinate basis: stated in text

Geography comments: coordinate stated in text

Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

WMT: 24.6

CMT: 16.9

MAP: 1010.0

Habitat comments: natural riparian woodlands surrounded by sugarcane and Eucalyptus plantations
climate data based on station 68588 (Durban airport)

Methods
Life forms: lizards,snakes,frogs

Sampling methods: drift fences,funnel traps,pitfall traps

Sample size: 91 individuals

Years: 2006

Sampling comments: three trap arrays of eight funnel traps, five pitfall traps, and drift fences

Metadata
Sample number: 434

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 20:46:42

Modified: 2014-04-26 23:58:17

Abundance distribution
20 species
7 singletons
total count 91
extrapolated richness: 43.5
Fisher's α: 7.922
geometric series k: 0.8499
Hurlbert's PIE: 0.8770
Shannon's H: 2.4624
Good's u: 0.9243
Each square represents a species. Square sizes are proportional to counts.
Register