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=3714 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3714SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3345SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3714 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvilagus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='spp.' OR junior_species='spp.')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='Sylvilagus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='latrans' OR species='latrans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')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='latrans' OR species='latrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')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='Lynx' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otospermophilus' AND (junior_species='beecheyi' OR junior_species='beecheyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otospermophilus' AND (species='beecheyi' OR species='beecheyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otospermophilus' AND (species='beecheyi' OR species='beecheyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otospermophilus' AND (junior_species='beecheyi' OR junior_species='beecheyii')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='Otospermophilus' AND (species='beecheyi' OR species='beecheyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='californicus' OR junior_species='californicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='californicus' OR species='californicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='californicus' OR junior_species='californicus')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='Lepus' AND (species='californicus' OR species='californicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')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='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')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='Odocoileus' AND (species='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3714 The Ecological Register: Black Mountain Open Space Park
Black Mountain Open Space Park
Basic information
Sample name: Black Mountain Open Space Park

Reference: C. L. Larson, S. E. Reed, and K. R. Crooks. 2020. Increased hiking and mountain biking are associated with declines in urban mammal activity. California Fish and Wildlife Recreation:52-61 [ER 3345]
Geography
Country: United States

State: California


Coordinate: 32° 59' N, 117° 7' W
Coordinate basis: based on nearby landmark

Geography comments: "in San Diego"
coordinate based on Black Mountain Open Space Park

Environment
Habitat: Mediterranean woodland

Altered habitat: fragment

Protection: other protected area

Substrate: ground surface

Habitat comments: "The park is 951 ha, comprised primarily of coastal sage scrub and chaparral vegetation communities with some riparian and native and non-native grassland habitats. Dense suburban communities surround the park, and it contains approximately 32 kilometers of multi-use trails visited primarily by hikers and mountain bikers. The park also permits leashed dogs on the trails"

Methods
Life forms: carnivores,rodents,ungulates,other small mammals

Sampling methods: no design,automatic cameras

Sample size: 1110 captures or sightings

Years: 2017, 2018

Seasons: winter,spring,autumn

Nets or traps: 7

Net or trap nights: 476

Camera type: digital

Cameras paired: no

Sampling comments: "We established a total of seven sampling points on official and unofficial trails within the park in January 2017... we installed one motion-triggered camera (Bushnell TrophyCam HD Aggressor) at each sampling point"
sampling was from November to February 2017 - 208 and April to May 2018
trap-days per camera are reported and total 596, but "we randomly subsampled 20% of photos between 11 am and 5 pm at all sampling points" (meaning that 75% of all hours were sample completely and 25% were sample at a rate of 20%, summing to 80% x 596 = 476 trap-days)
dogs, horses, and people were also photographed, but exact counts are not given

Metadata
Sample number: 3714

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-11-01 19:49:42

Modified: 2020-11-01 08:49:42

Abundance distribution
7 species
1 singleton
total count 1110
extrapolated richness: 9.4
Fisher's α: 0.998
geometric series k: 0.3508
Hurlbert's PIE: 0.6146
Shannon's H: 1.0911
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.
Register
Sylvilagus spp.537
bachmani and audubonii
Canis latrans40912 kg carnivore-insectivore
Lynx rufus1359.0 kg carnivore
Otospermophilus beecheyi22
Lepus californicus42.1 kg
Procyon lotor25.5 kg carnivore-granivore
Odocoileus hemionus165 kg browser