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=477 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=477SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=234SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=477 ORDER BY register_no ASCSELECT 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='Emys' AND (junior_species='orbicularis' OR junior_species='orbicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emys' AND (species='orbicularis' OR species='orbicularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emys' AND (species='orbicularis' OR species='orbicularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emys' AND (junior_species='orbicularis' OR junior_species='orbicularis')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='Emys' AND (species='orbicularis' OR species='orbicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Algyroides' AND (junior_species='nigropunctatus' OR junior_species='nigropunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Algyroides' AND (species='nigropunctatus' OR species='nigropunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Algyroides' AND (species='nigropunctatus' OR species='nigropunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Algyroides' AND (junior_species='nigropunctatus' OR junior_species='nigropunctatus')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='Algyroides' AND (species='nigropunctatus' OR species='nigropunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' 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='Lacerta' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' 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='Lacerta' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='trilineata' OR junior_species='trilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='trilineata' OR species='trilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='trilineata' OR species='trilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='trilineata' OR junior_species='trilineata')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='trilineata' OR species='trilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='agilis' OR species='agilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='agilis' OR junior_species='agilis')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='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='erhardii' OR junior_species='erhardi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podarcis' AND (species='erhardii' OR species='erhardi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podarcis' AND (species='erhardii' OR species='erhardi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='erhardii' OR junior_species='erhardi')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='erhardii' OR species='erhardi') 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='taurica' OR junior_species='taurica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podarcis' AND (species='taurica' OR species='taurica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podarcis' AND (species='taurica' OR species='taurica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podarcis' AND (junior_species='taurica' OR junior_species='taurica')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='taurica' OR species='taurica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ablepharus' AND (junior_species='kitaibelii' OR junior_species='kitaibeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ablepharus' AND (junior_species='kitaibelii' OR junior_species='kitaibeli')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='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli') 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='Malpolon' AND (junior_species='monspessulanus' OR junior_species='monspessulanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malpolon' AND (species='monspessulanus' OR species='monspessulanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malpolon' AND (species='monspessulanus' OR species='monspessulanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malpolon' AND (junior_species='monspessulanus' OR junior_species='monspessulanus')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='Malpolon' AND (species='monspessulanus' OR species='monspessulanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='caspius' OR junior_species='caspius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coluber' AND (species='caspius' OR species='caspius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coluber' AND (species='caspius' OR species='caspius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='caspius' OR junior_species='caspius')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='Coluber' AND (species='caspius' OR species='caspius') 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='Elaphe' AND (junior_species='longissima' OR junior_species='longissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='longissima' OR species='longissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='longissima' OR species='longissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='longissima' OR junior_species='longissima')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='longissima' OR species='longissima') 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='Vipera' AND (junior_species='ammodytes' OR junior_species='ammodytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vipera' AND (species='ammodytes' OR species='ammodytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vipera' AND (species='ammodytes' OR species='ammodytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='ammodytes' OR junior_species='ammodytes')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='ammodytes' OR species='ammodytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='berus' OR junior_species='berus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vipera' AND (species='berus' OR species='berus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vipera' AND (species='berus' OR species='berus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='berus' OR junior_species='berus')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='berus' OR species='berus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=477 The Ecological Register: Lake Prespa National Park
Lake Prespa National Park
Basic information
Sample name: Lake Prespa National Park

Reference: Y. Ioannidis and D. Bousbouras. 1997. The space utilization by the reptiles in Prespa National Park. Hydrobiologia 351:135-142 [ER 234]
Geography
Country: Greece


Coordinate: 40° 54' N, 21° 1' E
Geography comments: coordinate based on Lake Prespa

Environment
Habitat: temperate broadleaf/mixed forest

Protection: national/state park

Substrate: ground surface

MAT: 11.0

WMT: 21.0

CMT: 1.0

MAP: 975.0

Habitat comments: "mixed," oak, and beech forests plus pastures, cultivated areas, marshes, beaches, wet meadows, and subalpine meadows
climate data based on Panagiotopoulos et al. (2014, Climate of the Past): MAP range 750 to 1200

Methods
Life forms: lizards,snakes,turtles

Sampling methods: no design,hand capture

Sample size: 1131 individuals

Years: 1986 - 1990

Sampling comments: data apparently includes some visual sightings and possibly some transect counts but the text is very unclear on these points

Metadata
Sample number: 477

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-19 14:05:34

Modified: 2014-04-26 10:03:04

Abundance distribution
20 species
1 singleton
total count 1131
extrapolated richness: 23.2
Fisher's α: 3.451
geometric series k: 0.7541
Hurlbert's PIE: 0.8794
Shannon's H: 2.3687
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.
Register