SELECT * FROM samples WHERE sample_no=2325SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2257SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2325 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corytophanes' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corytophanes' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corytophanes' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corytophanes' AND (junior_species='cristatus' OR junior_species='cristatus')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='Corytophanes' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='albogularis' OR junior_species='albogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonatodes' AND (species='albogularis' OR species='albogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonatodes' AND (species='albogularis' OR species='albogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='albogularis' OR junior_species='albogularis')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='Gonatodes' AND (species='albogularis' OR species='albogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='sanctaemartae' OR junior_species='sanctaemartae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidoblepharis' AND (species='sanctaemartae' OR species='sanctaemartae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidoblepharis' AND (species='sanctaemartae' OR species='sanctaemartae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='sanctaemartae' OR junior_species='sanctaemartae')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='Lepidoblepharis' AND (species='sanctaemartae' OR species='sanctaemartae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bachia' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bachia' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='bicolor' OR junior_species='bicolor')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='Bachia' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnophthalmus' AND (junior_species='speciosus' OR junior_species='speciosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnophthalmus' AND (species='speciosus' OR species='speciosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnophthalmus' AND (species='speciosus' OR species='speciosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnophthalmus' AND (junior_species='speciosus' OR junior_species='speciosus')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='Gymnophthalmus' AND (species='speciosus' OR species='speciosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leposoma' AND (junior_species='rugiceps' OR junior_species='rugiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leposoma' AND (species='rugiceps' OR species='rugiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leposoma' AND (species='rugiceps' OR species='rugiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leposoma' AND (junior_species='rugiceps' OR junior_species='rugiceps')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='Leposoma' AND (species='rugiceps' OR species='rugiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tretioscincus' AND (junior_species='bifasciatus' OR junior_species='bifasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tretioscincus' AND (species='bifasciatus' OR species='bifasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tretioscincus' AND (species='bifasciatus' OR species='bifasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tretioscincus' AND (junior_species='bifasciatus' OR junior_species='bifasciatus')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='Tretioscincus' AND (species='bifasciatus' OR species='bifasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iguana' AND (junior_species='iguana' OR junior_species='iguana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iguana' AND (species='iguana' OR species='iguana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iguana' AND (species='iguana' OR species='iguana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iguana' AND (junior_species='iguana' OR junior_species='iguana')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='Iguana' AND (species='iguana' OR species='iguana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='auratus' OR junior_species='auratus')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='Anolis' AND (species='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='maculiventris' OR junior_species='maculiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='maculiventris' OR species='maculiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='maculiventris' OR species='maculiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='maculiventris' OR junior_species='maculiventris')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='Anolis' AND (species='maculiventris' OR species='maculiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='sulcifrons' OR junior_species='sulcifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='sulcifrons' OR species='sulcifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='sulcifrons' OR species='sulcifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='sulcifrons' OR junior_species='sulcifrons')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='Anolis' AND (species='sulcifrons' OR species='sulcifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='tropidogaster' OR junior_species='tropidogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='tropidogaster' OR species='tropidogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='tropidogaster' OR species='tropidogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='tropidogaster' OR junior_species='tropidogaster')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='Anolis' AND (species='tropidogaster' OR species='tropidogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='vittigerus' OR junior_species='vittigerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='vittigerus' OR species='vittigerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='vittigerus' OR species='vittigerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='vittigerus' OR junior_species='vittigerus')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='Anolis' AND (species='vittigerus' OR species='vittigerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='sp.' OR junior_species='sp.')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='Mabuya' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='praesignis' OR junior_species='praesignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameiva' AND (species='praesignis' OR species='praesignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameiva' AND (species='praesignis' OR species='praesignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='praesignis' OR junior_species='praesignis')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='Ameiva' AND (species='praesignis' OR species='praesignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holcosus' AND (junior_species='festivus' OR junior_species='festivus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holcosus' AND (species='festivus' OR species='festivus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holcosus' AND (species='festivus' OR species='festivus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holcosus' AND (junior_species='festivus' OR junior_species='festivus')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='Holcosus' AND (species='festivus' OR species='festivus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemidophorus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemidophorus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')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='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corallus' AND (junior_species='ruschenbergerii' OR junior_species='ruschenbergeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corallus' AND (species='ruschenbergerii' OR species='ruschenbergeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corallus' AND (species='ruschenbergerii' OR species='ruschenbergeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corallus' AND (junior_species='ruschenbergerii' OR junior_species='ruschenbergeri')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='Corallus' AND (species='ruschenbergerii' OR species='ruschenbergeri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='bizonus' OR junior_species='bizonus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='bizonus' OR species='bizonus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='bizonus' OR species='bizonus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='bizonus' OR junior_species='bizonus')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='Erythrolamprus' AND (species='bizonus' OR species='bizonus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Imantodes' AND (species='cenchoa' OR species='cenchoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')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='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodeira' AND (species='septentrionalis' OR species='septentrionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodeira' AND (species='septentrionalis' OR species='septentrionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')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='septentrionalis' OR species='septentrionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='neuwiedii' OR junior_species='neuwiedi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoboa' AND (species='neuwiedii' OR species='neuwiedi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoboa' AND (species='neuwiedii' OR species='neuwiedi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='neuwiedii' OR junior_species='neuwiedi')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='neuwiedii' OR species='neuwiedi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulatus' OR junior_species='nebulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibon' AND (species='nebulatus' OR species='nebulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibon' AND (species='nebulatus' OR species='nebulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulatus' OR junior_species='nebulatus')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='Sibon' AND (species='nebulatus' OR species='nebulatus') 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='Micrurus' AND (junior_species='dumerilii' OR junior_species='dumerili')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='dumerilii' OR species='dumerili') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='dumerilii' OR species='dumerili')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='dumerilii' OR junior_species='dumerili')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='dumerilii' OR species='dumerili') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilepida' AND (junior_species='macrolepis' OR junior_species='macrolepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trilepida' AND (species='macrolepis' OR species='macrolepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trilepida' AND (species='macrolepis' OR species='macrolepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilepida' AND (junior_species='macrolepis' OR junior_species='macrolepis')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='Trilepida' AND (species='macrolepis' OR species='macrolepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='asper' OR junior_species='asper')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='asper' OR species='asper') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='asper' OR species='asper')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='asper' OR junior_species='asper')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='Bothrops' AND (species='asper' OR species='asper') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2325SELECT genus FROM register WHERE register_no IN (49754,7565,80438,58629,2510,75543,2499,20445,80831,83665) AND species REGEXP '^[a-z]*$' The Ecological Register: Pueblo Nuevo (edge)
Pueblo Nuevo (edge)
Basic information
Sample name: Pueblo Nuevo (edge)

Reference: J. E. Carvajal-Cogollo and N. Urbina-Cardona. 2015. Ecological grouping and edge effects in tropical dry forest: reptile-microenvironment relationships. Biodiversity and Conservation 24:1109-1130 [ER 2257]
Geography
Country: Colombia


Coordinate: 8° 17' N, 75° 3' W
Coordinate basis: stated in text

Geography comments: "in six tropical dry forest fragments and adjacent pasture habitat in the municipality of Pueblo Nuevo, department of Co ́rdoba"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: fragment

Substrate: ground surface

MAT: 27.0

MAP: 1463.0

Habitat comments: "The climate is semidry with a substantial reduction in rainfall during the dry season (from November to March)" and sites are in "tropical dry (evergreen and seasonal) forest"

Methods
Life forms: lizards,snakes

Sites: 15

Sampling methods: line transect,hand capture

Sample size: 385 individuals

Years: 2006

Seasons: dry,wet or monsoon

Sampling comments: "For the selection of the fragments the criteria were: (1) the fragments must be completely surrounded by pasture matrix and create an abrupt contrast with the forest edge, (2) the size and shape of the fragments must be sufficient to set up at least two independent 250 x 50 m pasture-edge-interior gradients, perpendicular to and on either side of the physical edge of the fragment... A total of fifteen 250 x 50 m pasture-edge-interior forest gradients were set up... In each habitat (pasture, edge and interior) we set up four permanent linear transects 50 m in length and parallel to the dry forest edge at set distances in the pasture (-100, -65, -35 and -5 m), at the forest edge (1, 7, 14, 20 m) and in the forest interior (50, 85, 115, 150 m)... Data were collected twice during the wet season (May and August 2006) and once during the dry season (December 2006). Each gradient was sampled three times by one person for 8 h (0800–1,200 h and 1,800–2,200 h)... We surveyed the reptiles along the transects by visual encounter surveys (VESs)... All individuals were marked on the dorsum with distinguishable nail polish"

Metadata
Sample number: 2325

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-23 16:33:28

Modified: 2020-05-29 10:20:33

Abundance distribution
27 species
15 singletons
total count 385
geometric series index: 71.7
Fisher's α: 6.616
geometric series k: 0.8107
Hurlbert's PIE: 0.6052
Shannon's H: 1.5988
Good's u: 0.9610
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Corytophanes cristatus1
Gonatodes albogularis234
Lepidoblepharis sanctaemartae7
Bachia 'bicolor'1
Gymnophthalmus speciosus6
Leposoma rugiceps11
Tretioscincus bifasciatus3
Iguana iguana1
Anolis auratus3
Anolis maculiventris1
Anolis sulcifrons1
Anolis tropidogaster50
Anolis vittigerus1
Mabuya sp.20
Ameiva praesignis3
Holcosus festivus9
Cnemidophorus lemniscatus19
Corallus ruschenbergerii1
Erythrolamprus bizonus1
Imantodes cenchoa1
Leptodeira septentrionalis5
Pseudoboa neuwiedii1
Sibon nebulatus1
Leptophis ahaetulla1
Micrurus dumerilii1
Trilepida macrolepis1
Bothrops asper1