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=406 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=406SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=190SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=406 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laudakia' 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='Laudakia' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laudakia' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laudakia' 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='Laudakia' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotrapelus' AND (junior_species='sinaitus' OR junior_species='sinaitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudotrapelus' AND (species='sinaitus' OR species='sinaitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudotrapelus' AND (species='sinaitus' OR species='sinaitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotrapelus' AND (junior_species='sinaitus' OR junior_species='sinaitus')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='Pseudotrapelus' AND (species='sinaitus' OR species='sinaitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trapelus' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trapelus' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trapelus' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trapelus' AND (junior_species='pallidus' OR junior_species='pallidus')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='Trapelus' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropiocolotes' AND (junior_species='steudneri' OR junior_species='steudnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropiocolotes' AND (species='steudneri' OR species='steudnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropiocolotes' AND (species='steudneri' OR species='steudnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropiocolotes' AND (junior_species='steudneri' OR junior_species='steudnerii')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='Tropiocolotes' AND (species='steudneri' OR species='steudnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptyodactylus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptyodactylus' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptyodactylus' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptyodactylus' AND (junior_species='guttatus' OR junior_species='guttatus')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='Ptyodactylus' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='turcicus' OR junior_species='turcicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='turcicus' OR species='turcicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='turcicus' OR species='turcicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='turcicus' OR junior_species='turcicus')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='Hemidactylus' AND (species='turcicus' OR species='turcicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenodactylus' AND (junior_species='sthenodactylus' OR junior_species='sthenodactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenodactylus' AND (species='sthenodactylus' OR species='sthenodactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenodactylus' AND (species='sthenodactylus' OR species='sthenodactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenodactylus' AND (junior_species='sthenodactylus' OR junior_species='sthenodactylus')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='Stenodactylus' AND (species='sthenodactylus' OR species='sthenodactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthodactylus' AND (junior_species='boskianus' OR junior_species='boskianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthodactylus' AND (species='boskianus' OR species='boskianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthodactylus' AND (species='boskianus' OR species='boskianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthodactylus' AND (junior_species='boskianus' OR junior_species='boskianus')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='Acanthodactylus' AND (species='boskianus' OR species='boskianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesalina' AND (junior_species='guttulata' OR junior_species='guttulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesalina' AND (species='guttulata' OR species='guttulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesalina' AND (species='guttulata' OR species='guttulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesalina' AND (junior_species='guttulata' OR junior_species='guttulata')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='Mesalina' AND (species='guttulata' OR species='guttulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesalina' AND (junior_species='olivieri' OR junior_species='olivierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesalina' AND (species='olivieri' OR species='olivierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesalina' AND (species='olivieri' OR species='olivierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesalina' AND (junior_species='olivieri' OR junior_species='olivierii')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='Mesalina' AND (species='olivieri' OR species='olivierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophisops' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophisops' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophisops' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophisops' AND (junior_species='elegans' OR junior_species='elegans')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='Ophisops' AND (species='elegans' OR species='elegans') 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='Chalcides' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcides' AND (species='ocellatus' OR species='ocellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcides' AND (species='ocellatus' OR species='ocellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcides' AND (junior_species='ocellatus' OR junior_species='ocellatus')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='ocellatus' OR species='ocellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='schneiderii' OR junior_species='schneideri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='schneiderii' OR species='schneideri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='schneiderii' OR species='schneideri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='schneiderii' OR junior_species='schneideri')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='Eumeces' AND (species='schneiderii' OR species='schneideri') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=406 The Ecological Register: Ramon erosion cirque
Ramon erosion cirque
Basic information
Sample name: Ramon erosion cirque

Reference: G. Shenbrot and B. Krasnov. 1997. Habitat relationships of the lizard fauna in the Ramon erosion cirque, Negev Highlands (Israel). Journal of Zoology 241:429-440 [ER 190]
Geography
Country: Israel


Coordinate: 30° 34' N, 34° 45' E
Coordinate basis: stated in text

Geography comments: coordinate stated in text
510 to 800 m

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

WMT: 26.8

CMT: 10.7

MAP: 71.0

Habitat comments: "sand dunes to limestone and sandstone rocks in the rims"
cold month min/max 19.7/33.9, warm month min/max 6.4/14.9
precip 56 to 85 (spatially)

Methods
Life forms: lizards

Sites: 24

Site area: 24

Sampling methods: quadrat,pitfall traps,visual

Sample size: 353 individuals

Years: 1994

Sampling comments: 24 one-ha grids each subdivided into 25 20 x 20 m plots
combination of visual search and pitfall traps

Metadata
Sample number: 406

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 08:20:37

Modified: 2014-03-19 01:57:30

Abundance distribution
14 species
0 singletons
total count 353
extrapolated richness: 15.6
Fisher's α: 2.913
geometric series k: 0.7529
Hurlbert's PIE: 0.7570
Shannon's H: 1.9509
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register