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=452 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=452SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=219SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=452 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triturus' AND (junior_species='carnifex' OR junior_species='carnifex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triturus' AND (species='carnifex' OR species='carnifex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triturus' AND (species='carnifex' OR species='carnifex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triturus' AND (junior_species='carnifex' OR junior_species='carnifex')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='Triturus' AND (species='carnifex' OR species='carnifex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lissotriton' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lissotriton' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lissotriton' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lissotriton' AND (junior_species='vulgaris' OR junior_species='vulgaris')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='Lissotriton' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='bufo' OR species='bufo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='bufo' OR species='bufo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')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='Bufo' AND (species='bufo' OR species='bufo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudepidalea' AND (junior_species='balearica' OR junior_species='balearica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudepidalea' AND (species='balearica' OR species='balearica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudepidalea' AND (species='balearica' OR species='balearica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudepidalea' AND (junior_species='balearica' OR junior_species='balearica')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='Pseudepidalea' AND (species='balearica' OR species='balearica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='italica' OR junior_species='italica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='italica' OR species='italica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='italica' OR species='italica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='italica' OR junior_species='italica')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='Rana' AND (species='italica' OR species='italica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='dalmatina' OR junior_species='dalmatina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='dalmatina' OR species='dalmatina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='dalmatina' OR species='dalmatina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='dalmatina' OR junior_species='dalmatina')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='Rana' AND (species='dalmatina' OR species='dalmatina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='intermedia' OR junior_species='intermedia')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='Hyla' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelophylax' 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='Pelophylax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelophylax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelophylax' 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='Pelophylax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachemys' AND (junior_species='scripta' OR junior_species='scripta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachemys' AND (species='scripta' OR species='scripta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachemys' AND (species='scripta' OR species='scripta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachemys' AND (junior_species='scripta' OR junior_species='scripta')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='Trachemys' AND (species='scripta' OR species='scripta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='hermanni' OR junior_species='hermannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Testudo' AND (species='hermanni' OR species='hermannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudo' AND (species='hermanni' OR species='hermannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='hermanni' OR junior_species='hermannii')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='Testudo' AND (species='hermanni' OR species='hermannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarentola' AND (junior_species='mauretanica' OR junior_species='mauretanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tarentola' AND (species='mauretanica' OR species='mauretanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tarentola' AND (species='mauretanica' OR species='mauretanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarentola' AND (junior_species='mauretanica' OR junior_species='mauretanica')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='Tarentola' AND (species='mauretanica' OR species='mauretanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcides' AND (junior_species='chalcides' OR junior_species='chalcides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcides' AND (species='chalcides' OR species='chalcides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcides' AND (species='chalcides' OR species='chalcides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcides' AND (junior_species='chalcides' OR junior_species='chalcides')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='Chalcides' AND (species='chalcides' OR species='chalcides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguis' AND (species='fragilis' OR species='fragilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')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='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='muralis' OR junior_species='muralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podarcis' AND (species='muralis' OR species='muralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podarcis' AND (species='muralis' OR species='muralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='muralis' OR junior_species='muralis')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='Podarcis' AND (species='muralis' OR species='muralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='sicula' OR junior_species='sicula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podarcis' AND (species='sicula' OR species='sicula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podarcis' AND (species='sicula' OR species='sicula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='sicula' OR junior_species='sicula')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='Podarcis' AND (species='sicula' OR species='sicula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='bilineata' OR species='bilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='bilineata' OR junior_species='bilineata')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='Lacerta' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='natrix' OR junior_species='natrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natrix' AND (species='natrix' OR species='natrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Natrix' AND (species='natrix' OR species='natrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='natrix' OR junior_species='natrix')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='Natrix' AND (species='natrix' OR species='natrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='tessellata' OR junior_species='tessellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natrix' AND (species='tessellata' OR species='tessellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Natrix' AND (species='tessellata' OR species='tessellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='tessellata' OR junior_species='tessellata')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='Natrix' AND (species='tessellata' OR species='tessellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='austriaca' OR junior_species='austriaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coronella' AND (species='austriaca' OR species='austriaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coronella' AND (species='austriaca' OR species='austriaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='austriaca' OR junior_species='austriaca')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='Coronella' AND (species='austriaca' OR species='austriaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coronella' AND (species='girondica' OR species='girondica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coronella' AND (species='girondica' OR species='girondica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')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='Coronella' AND (species='girondica' OR species='girondica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zamenis' AND (junior_species='longissimus' OR junior_species='longissimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zamenis' AND (species='longissimus' OR species='longissimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zamenis' AND (species='longissimus' OR species='longissimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zamenis' AND (junior_species='longissimus' OR junior_species='longissimus')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='Zamenis' AND (species='longissimus' OR species='longissimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hierophis' AND (junior_species='virdiflavus' OR junior_species='virdiflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hierophis' AND (species='virdiflavus' OR species='virdiflavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hierophis' AND (species='virdiflavus' OR species='virdiflavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hierophis' AND (junior_species='virdiflavus' OR junior_species='virdiflavus')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='Hierophis' AND (species='virdiflavus' OR species='virdiflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='quatuorlineata' OR junior_species='quatuorlineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='quatuorlineata' OR species='quatuorlineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='quatuorlineata' OR species='quatuorlineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='quatuorlineata' OR junior_species='quatuorlineata')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='Elaphe' AND (species='quatuorlineata' OR species='quatuorlineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='aspis' OR junior_species='aspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vipera' AND (species='aspis' OR species='aspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vipera' AND (species='aspis' OR species='aspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='aspis' OR junior_species='aspis')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='Vipera' AND (species='aspis' OR species='aspis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=452 The Ecological Register: Poggi di Prata
Poggi di Prata
Basic information
Sample name: Poggi di Prata

Reference: M. Cantini, M. Menchetti, A. Vannini, G. Bruni, B. Borri, and E. Mori. 2013. Checklist of Amphibians and Reptiles in a hilly area of Southern Tuscany (Central Italy): an update. Herpetology Notes 6:223-228 [ER 219]
Geography
Country: Italy

State: Grosseto


Coordinate: 43° 4' N, 10° 58' E
Geography comments: coordinate based on Prata
elevation 475 to 903 m

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 12.0

MAP: 1000.0

Habitat comments: mostly "mixed deciduous woods" and "chestnut woods" with some fallows, cultivated fields, etc.

Methods
Life forms: lizards,snakes,turtles,frogs,salamanders

Site area: 1.35

Sampling methods: hand capture

Sample size: 2654 captures or sightings

Years: 2011, 2012

Sampling comments: amphibians were caught with a meshed landing net
hand capturing is inferred

Metadata
Sample number: 452

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-17 16:15:36

Modified: 2014-03-17 05:15:36

Abundance distribution
24 species
1 singleton
total count 2654
extrapolated richness: 29.4
Fisher's α: 3.640
geometric series k: 0.7528
Hurlbert's PIE: 0.8334
Shannon's H: 2.0840
Good's u: 0.9996
Each square represents a species. Square sizes are proportional to counts.
Register