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=3285 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3285SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3037SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3285 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='aureus' OR junior_species='aureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='aureus' OR species='aureus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='aureus' OR junior_species='aureus')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='Canis' AND (species='aureus' OR species='aureus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='catus' OR junior_species='catus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='catus' OR species='catus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='catus' OR species='catus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='catus' OR junior_species='catus')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='Felis' AND (species='catus' OR species='catus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='gazella' OR junior_species='gazella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='gazella' OR species='gazella') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='gazella' OR junior_species='gazella')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='Gazella' AND (species='gazella' OR species='gazella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaena' AND (junior_species='hyaena' OR junior_species='hyaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyaena' AND (species='hyaena' OR species='hyaena') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaena' AND (junior_species='hyaena' OR junior_species='hyaena')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='Hyaena' AND (species='hyaena' OR species='hyaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='indica' OR junior_species='indica')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='Hystrix' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3285 The Ecological Register: Shikma Biosphere Zone (spring)
Shikma Biosphere Zone (spring)
Basic information
Sample name: Shikma Biosphere Zone (spring)

Reference: H. Shamoon, S. Cain, U. Shanas, A. Bar-Massada, Y. Malihi, and I. Shapira. 2018. Spatio-temporal activity patterns of mammals in an agro-ecological mosaic with seasonal recreation activities. European Journal of Wildlife Research 64(35):1-10 [ER 3037]
Geography
Country: Israel


Coordinate: 31.488331° N, 34.568909° E
Coordinate basis: stated in text

Geography comments: "The area comprises the western and middle parts of the Shikma River drain- age basin"
latitude and longitude are swapped in the text

Environment
Habitat: desert/xeric shrubland

Altered habitat: cropland

Protection: unprotected

Substrate: ground surface

Habitat comments: "in the western Mediterranean desert ecotone... a mosaic of agricultural fields (mainly seasonal crops), nature reserves (3000 ha), patches of natural steppe habitats, and planted tree stands (mostly of alien species), spotted with rural settlements"

Methods
Life forms: carnivores,rodents,ungulates

Sampling methods: no design,automatic cameras

Sample size: 78 captures or sightings

Years: 2017

Days: 13

Seasons: spring

Nets or traps: 60

Net or trap nights: 780

Camera type: digital

Cameras paired: no

Sampling comments: "We used infrared (IR) trap cameras (HCO Scout Guard SG550-8MHD, www.trail-camera.co.il)... during winter (December 2015–January 2016), summer (June–July 2016), and spring (March–April 2017). The cameras were located in 10 natural patches nested in agricultural fields... Distance between sites was 1–4 km... We mounted six cameras at each site by six separate animal trails. Cameras were set with 50 to 150 m intervals between them depending on the terrain. Cameras were mounted on pegs 30–50 cm above ground level... We collected data from each camera location during 13 consecutive days; overall, we mounted 60 cameras per season, resulting in 2340 sampled days throughout the study period... An individual detection event was defined by a 1-min filter"
the spring data were collected in March and April 2017
I have omitted counts of "Canis spp."

Metadata
Sample number: 3285

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-16 14:55:11

Modified: 2021-06-22 05:23:46

Abundance distribution
7 species
1 singleton
total count 78
extrapolated richness: 9.4
Fisher's α: 1.863
geometric series k: 0.5848
Hurlbert's PIE: 0.7612
Shannon's H: 1.6044
Good's u: 0.9872
Each square represents a species. Square sizes are proportional to counts.
Register
Canis aureus169.9 kg carnivore-frugivore
Felis catus6
Gazella gazella2521 kg
Hyaena hyaena130 kg carnivore-insectivore
Hystrix indica2213 kg browser
Meles meles411 kg invertivore-herbivore
Sus scrofa454 kg herbivore