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=395 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=395SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=181SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=395 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apostolepis' AND (species='cearensis' OR species='cearensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')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='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boa' AND (species='constrictor' OR species='constrictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')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='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiruna' AND (junior_species='sertaneja' OR junior_species='sertaneja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boiruna' AND (species='sertaneja' OR species='sertaneja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boiruna' AND (species='sertaneja' OR species='sertaneja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiruna' AND (junior_species='sertaneja' OR junior_species='sertaneja')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='Boiruna' AND (species='sertaneja' OR species='sertaneja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='durissus' OR species='durissus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')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='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epicrates' AND (species='assisi' OR species='assisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')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='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodeira' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodeira' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='annulata' OR junior_species='annulata')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='Leptodeira' AND (species='annulata' OR species='annulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')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='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='dilepis' OR junior_species='dilepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='dilepis' OR species='dilepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='dilepis' OR species='dilepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='dilepis' OR junior_species='dilepis')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='Liophis' AND (species='dilepis' OR species='dilepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='mossoroensis' OR junior_species='mossoroensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='mossoroensis' OR species='mossoroensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='mossoroensis' OR species='mossoroensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='mossoroensis' OR junior_species='mossoroensis')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='Liophis' AND (species='mossoroensis' OR species='mossoroensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')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='Liophis' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='viridis' OR junior_species='viridis')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='Liophis' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')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='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')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='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxybelis' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxybelis' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='aeneus' OR junior_species='aeneus')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='Oxybelis' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')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='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='nattereri' OR species='nattererii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')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='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='olfersii' OR junior_species='olfersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='olfersii' OR species='olfersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='olfersii' OR species='olfersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='olfersii' OR junior_species='olfersi')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='Philodryas' AND (species='olfersii' OR species='olfersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoboa' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')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='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psomophis' AND (species='joberti' OR species='jobertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')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='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='melanocephala' OR junior_species='melanocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='melanocephala' OR species='melanocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='melanocephala' OR species='melanocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='melanocephala' OR junior_species='melanocephala')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='Tantilla' AND (species='melanocephala' OR species='melanocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='strigilis' OR junior_species='strigilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnodynastes' AND (species='strigilis' OR species='strigilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnodynastes' AND (species='strigilis' OR species='strigilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='strigilis' OR junior_species='strigilis')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='Thamnodynastes' AND (species='strigilis' OR species='strigilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenodon' AND (species='merremii' OR species='merremi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')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='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=395 The Ecological Register: Vale do Curu
Vale do Curu
Basic information
Sample name: Vale do Curu

Reference: P. C. M. D. Mesquita, D. C. Passos, and S. Z. Cechin. 2013. Efficiency of snake sampling methods in the Brazilian semiarid region. Anais da Academia Brasileira de Ciencias 85(3):1127-1139 [ER 181]
Geography
Country: Brazil

State: Ceara


Coordinate: 3° 49' 6" S, 39° 20' 15" W
Coordinate basis: stated in text

Geography comments: coordinate stated in text

Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

MAT: 26.8

MAP: 723.0

Methods
Life forms: snakes

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

Sample size: 597 individuals

Years: 2008 - 2010

Sampling comments: summation of counts based on time-constrained search, occasional encounters, and pitfall traps with drift fences

Metadata
Sample number: 395

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 14:16:36

Modified: 2014-03-20 04:53:51

Abundance distribution
22 species
4 singletons
total count 597
extrapolated richness: 29.3
Fisher's α: 4.493
geometric series k: 0.7940
Hurlbert's PIE: 0.8981
Shannon's H: 2.5543
Good's u: 0.9933
Each square represents a species. Square sizes are proportional to counts.
Register