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=435 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=435SELECT 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=435 ORDER BY register_no ASCSELECT 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='Breviceps' AND (junior_species='mossambicus' OR junior_species='mossambicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Breviceps' AND (species='mossambicus' OR species='mossambicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Breviceps' AND (species='mossambicus' OR species='mossambicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Breviceps' AND (junior_species='mossambicus' OR junior_species='mossambicus')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='Breviceps' AND (species='mossambicus' OR species='mossambicus') 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='Lamprophis' 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='Lamprophis' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamprophis' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprophis' 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='Lamprophis' AND (species='capensis' OR species='capensis') 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='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='Psammophis' AND (junior_species='brevirostris' OR junior_species='brevirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammophis' AND (species='brevirostris' OR species='brevirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammophis' AND (species='brevirostris' OR species='brevirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='brevirostris' OR junior_species='brevirostris')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='brevirostris' OR species='brevirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='mossambicus' OR junior_species='mossambicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammophis' AND (species='mossambicus' OR species='mossambicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammophis' AND (species='mossambicus' OR species='mossambicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammophis' AND (junior_species='mossambicus' OR junior_species='mossambicus')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='mossambicus' OR species='mossambicus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='varia' OR junior_species='varia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='varia' OR species='varia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='varia' OR species='varia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='varia' OR junior_species='varia')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='varia' OR species='varia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=435 The Ecological Register: Mtunzini (non-riparian)
Mtunzini (non-riparian)
Basic information
Sample name: Mtunzini (non-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

Altered habitat: plantation

Substrate: ground surface

WMT: 24.6

CMT: 16.9

MAP: 1010.0

Habitat comments: 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: 31 individuals

Years: 2006

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

Metadata
Sample number: 435

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 20:50:53

Modified: 2014-04-26 23:57:52

Abundance distribution
15 species
10 singletons
total count 31
extrapolated richness: 65.1
Fisher's α: 11.444
geometric series k: 0.8702
Hurlbert's PIE: 0.8742
Shannon's H: 2.3860
Good's u: 0.6817
Each square represents a species. Square sizes are proportional to counts.
Register