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=3253 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3253SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3019SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3253 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='fascicularis' OR junior_species='fascicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='fascicularis' OR species='fascicularis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='fascicularis' OR junior_species='fascicularis')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='Macaca' AND (species='fascicularis' OR species='fascicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')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='Homo' AND (species='sapiens' OR species='sapiens') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='verrucosus' OR junior_species='verrucosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='verrucosus' OR species='verrucosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='verrucosus' OR species='verrucosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='verrucosus' OR junior_species='verrucosus')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='verrucosus' OR species='verrucosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='kuhlii' OR junior_species='kuhli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axis' AND (species='kuhlii' OR species='kuhli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Axis' AND (species='kuhlii' OR species='kuhli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='kuhlii' OR junior_species='kuhli')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='Axis' AND (species='kuhlii' OR species='kuhli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')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='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') 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='Rattus' AND (junior_species='tanezumi' OR junior_species='tanezumii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='tanezumi' OR species='tanezumii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='tanezumi' OR species='tanezumii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='tanezumi' OR junior_species='tanezumii')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='Rattus' AND (species='tanezumi' OR species='tanezumii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='brachyotis' OR junior_species='brachyotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynopterus' AND (species='brachyotis' OR species='brachyotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynopterus' AND (junior_species='brachyotis' OR junior_species='brachyotis')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='Cynopterus' AND (species='brachyotis' OR species='brachyotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilornis' AND (junior_species='cheela' OR junior_species='cheela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilornis' AND (species='cheela' OR species='cheela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilornis' AND (species='cheela' OR species='cheela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilornis' AND (junior_species='cheela' OR junior_species='cheela')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='Spilornis' AND (species='cheela' OR species='cheela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='salvator' OR junior_species='salvator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='salvator' OR species='salvator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='salvator' OR species='salvator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='salvator' OR junior_species='salvator')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='Varanus' AND (species='salvator' OR species='salvator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='multifasciata' OR species='multifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')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='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='memnon' OR species='memnon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')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='Papilio' AND (species='memnon' OR species='memnon') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3253 The Ecological Register: Bawean Island (dry season)
Bawean Island (dry season)
Basic information
Sample name: Bawean Island (dry season)

Reference: D. A. Rahman, G. Gonzalez, and S. Aulagnier. 2016. Benefit of camera trapping for surveying the critically endangered Bawean deer Axis kuhlii (Temminck, 1836). Tropical Zoology 29(4):155-172 [ER 3019]
Geography
Country: Indonesia

State: East Java


Coordinate: 5° 45' 0" S, 112° 19' 30" E
Coordinate basis: stated in text

Geography comments: most sampling was "in the Bawean Island Nature Reserve and Wildlife Sanctuary (BINR-WS), and in Tanjung Cina, a peninsula (ca. 950 m × 300 m) where there is no resident human population" and specifically "surveys focused on the wildlife sanctuary (ca. 3832 ha) and nature reserve (ca. 725 ha), and additionally on Tanjung Cina"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: other protected area

Substrate: ground surface

MAT: 27.0

MAP: 2500.0

Habitat comments: "Rainfall is mostly abundant during the north-west monsoon lasting from the end of October until April, and reaches ca. 2.500 mm on the southern coast. Temperature conditions are almost uniform throughout the year, the average of maximum temperature is 32 °C and minimum temperature is 22 °C... The centre of the island is mountainous with peaks at 400 to 630 m in altitude, and is mainly covered by evergreen tropical forests (4700 ha, ca 23% of the island), including teak (Tectona grandis) plantations... Coastal low hills... are primarily cultivated lands. A mosaic of grassland, shrub, open and closed forest with understory are found in the study area"

Methods
Life forms: bats,carnivores,primates,rodents,ungulates,birds,lizards,butterflies

Focal species: Axis kuhlii

Sampling methods: quadrat,automatic cameras

Sample size: 2295 captures or sightings

Years: 2014

Seasons: dry

Nets or traps: 20

Net or trap nights: 2400

Camera type: digital

Cameras paired: no

Trap spacing: 2

Sampling comments: "The BINR-WS area was divided into 20 4 km2 grids... From March to November 2014, 20 units of Bushnell Trophy Cam HD Max digital cameras working on passive infrared motion/heat sensors were installed, one per grid... Because our goal was to monitor Bawean deer... camera traps were deployed in the most promising locations... cameras were set up at 30–50 cm above the ground... data were considered independent if photographs were taken more than 0.5 h apart"
trap days for this season are not reported, but table 2 indicates that there were 1220 trap days in each of two sessions

Metadata
Sample number: 3253

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-09 20:09:19

Modified: 2019-03-09 09:09:19

Abundance distribution
14 species
4 singletons
total count 2295
extrapolated richness: 22.2
Fisher's α: 1.985
geometric series k: 0.5691
Hurlbert's PIE: 0.5063
Shannon's H: 1.0265
Good's u: 0.9983
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Macaca fascicularis15224.0 kg frugivore-folivore
Homo sapiens6864 kg
Sus scrofa51354 kg herbivore
Sus verrucosus47
Axis kuhlii112
Canis lupus familiaris943 kg carnivore
Paradoxurus hermaphroditus72.4 kg frugivore-insectivore
Felis catus1
Rattus tanezumi5
Cynopterus brachyotis230.4 g frugivore-nectarivore
Spilornis cheela120.5 g carnivore
Varanus salvator6
Eutropis multifasciata1
Papilio memnon1