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=3280 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3280SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3035SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3280 ORDER BY register_no ASCSELECT 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='Bos' AND (junior_species='javanicus' OR junior_species='javanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='javanicus' OR species='javanicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='javanicus' OR junior_species='javanicus')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='Bos' AND (species='javanicus' OR species='javanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ciconia' AND (junior_species='epicopus' OR junior_species='epicopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ciconia' AND (species='epicopus' OR species='epicopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ciconia' AND (species='epicopus' OR species='epicopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ciconia' AND (junior_species='epicopus' OR junior_species='epicopus')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='Ciconia' AND (species='epicopus' OR species='epicopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumatibis' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumatibis' AND (species='gigantea' OR species='gigantea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumatibis' AND (species='gigantea' OR species='gigantea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumatibis' AND (junior_species='gigantea' OR junior_species='gigantea')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='Thaumatibis' AND (species='gigantea' OR species='gigantea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudibis' AND (junior_species='davisoni' OR junior_species='davisonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudibis' AND (species='davisoni' OR species='davisonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudibis' AND (species='davisoni' OR species='davisonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudibis' AND (junior_species='davisoni' OR junior_species='davisonii')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='Pseudibis' AND (species='davisoni' OR species='davisonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptoptilos' AND (junior_species='javanicus' OR junior_species='javanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptoptilos' AND (species='javanicus' OR species='javanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptoptilos' AND (species='javanicus' OR species='javanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptoptilos' AND (junior_species='javanicus' OR junior_species='javanicus')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='Leptoptilos' AND (species='javanicus' OR species='javanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='eldii' OR junior_species='eldi')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='eldii' OR species='eldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervus' AND (species='eldii' OR species='eldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='eldii' OR junior_species='eldi')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cervus' AND (species='eldii' OR species='eldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='vaginalis' OR junior_species='vaginalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='vaginalis' OR species='vaginalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muntiacus' AND (species='vaginalis' OR species='vaginalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='vaginalis' OR junior_species='vaginalis')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='Muntiacus' AND (species='vaginalis' OR species='vaginalis') ORDER BY year,last_namesSELECT 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='Grus' AND (junior_species='antigone' OR junior_species='antigone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grus' AND (species='antigone' OR species='antigone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grus' AND (species='antigone' OR species='antigone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grus' AND (junior_species='antigone' OR junior_species='antigone')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='Grus' AND (species='antigone' OR species='antigone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ephippiorhynchus' AND (junior_species='asiaticus' OR junior_species='asiaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ephippiorhynchus' AND (species='asiaticus' OR species='asiaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ephippiorhynchus' AND (species='asiaticus' OR species='asiaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ephippiorhynchus' AND (junior_species='asiaticus' OR junior_species='asiaticus')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='Ephippiorhynchus' AND (species='asiaticus' OR species='asiaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavo' AND (junior_species='muticus' OR junior_species='muticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pavo' AND (species='muticus' OR species='muticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pavo' AND (species='muticus' OR species='muticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavo' AND (junior_species='muticus' OR junior_species='muticus')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='Pavo' AND (species='muticus' OR species='muticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverricula' 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='Viverricula' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverricula' 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='Viverricula' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnus' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnus' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='nigricollis' OR junior_species='nigricollis')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='Sturnus' AND (species='nigricollis' OR species='nigricollis') 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='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')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='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverra' AND (junior_species='megaspila' OR junior_species='megaspila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Viverra' AND (species='megaspila' OR species='megaspila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Viverra' AND (species='megaspila' OR species='megaspila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverra' AND (junior_species='megaspila' OR junior_species='megaspila')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='Viverra' AND (species='megaspila' OR species='megaspila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='pintadeanus' OR junior_species='pintadeanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='pintadeanus' OR species='pintadeanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='pintadeanus' OR species='pintadeanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='pintadeanus' OR junior_species='pintadeanus')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='Francolinus' AND (species='pintadeanus' OR species='pintadeanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='chaus' OR junior_species='chaus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='chaus' OR species='chaus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='chaus' OR junior_species='chaus')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='chaus' OR species='chaus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='tranquebarica' OR junior_species='tranquebarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='tranquebarica' OR species='tranquebarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='tranquebarica' OR species='tranquebarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='tranquebarica' OR junior_species='tranquebarica')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='Streptopelia' AND (species='tranquebarica' OR species='tranquebarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcogyps' AND (junior_species='calvus' OR junior_species='calvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcogyps' AND (species='calvus' OR species='calvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcogyps' AND (species='calvus' OR species='calvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcogyps' AND (junior_species='calvus' OR junior_species='calvus')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='Sarcogyps' AND (species='calvus' OR species='calvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='peguensis' OR junior_species='peguensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='peguensis' OR species='peguensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='peguensis' OR species='peguensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='peguensis' OR junior_species='peguensis')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='peguensis' OR species='peguensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urva' AND (junior_species='javanica' OR junior_species='javanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urva' AND (species='javanica' OR species='javanica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urva' AND (junior_species='javanica' OR junior_species='javanica')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='Urva' AND (species='javanica' OR species='javanica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3280 The Ecological Register: Mondulkiri Protected Forest
Mondulkiri Protected Forest
Basic information
Sample name: Mondulkiri Protected Forest

Reference: T. N. E. Gray, W. J. McShea, A. Koehncke, P. Sovanna, and M. Wright. 2015. Artificial deepening of seasonal waterholes in eastern Cambodia: impact on water retention and use by large ungulates and waterbirds. Journal of Threatened Taxa 7(6):7189-7195 [ER 3035]
Geography
Country: Cambodia


Coordinate: 13° 5' N, 107° 30' E
Coordinate basis: stated in text

Geography comments: "located in eastern Cambodia is approximately 2120km2... The study was conducted within approximately 450km2 inside the proposed core zone"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: forest reserve

Substrate: ground surface

Habitat comments: "deciduous dipterocarp forests... The study area, and modified waterholes, are all more than 30km away from the nearest village and not used at all by domestic ungulates"

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

Sampling methods: no design,automatic cameras

Sample size: 242 captures or sightings

Years: 2012

Seasons: dry,wet or monsoon

Nets or traps: 5

Net or trap nights: 448

Camera type: digital

Cameras paired: no

Sampling comments: "In April 2011 six totally dry natural waterholes (henceforth modified waterhole) in the study area were artificially deepened up to 100cm... Between March and June 2012 (late dry-season to early wet-season) automatic camera-traps (Reconyx RapidFire Professional PC90; Reconyx) were placed at each of the modified waterholes... The camera-trap at waterhole # 4 malfunctioned without producing any data... Following the definition for 'independent encounter' by Phan et al. (2010), a total of 242 'independent' camera-trap photographs... were obtained"

Metadata
Sample number: 3280

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-16 12:51:42

Modified: 2019-03-16 01:52:23

Abundance distribution
23 species
6 singletons
total count 242
extrapolated richness: 41.1
Fisher's α: 6.246
geometric series k: 0.8150
Hurlbert's PIE: 0.8114
Shannon's H: 2.1918
Good's u: 0.9753
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sus scrofa9054 kg herbivore
Bos javanicus33488 kg
Ciconia epicopus29
Thaumatibis gigantea22
Pseudibis davisoni161.6 kg
Leptoptilos javanicus84.7 kg omnivore
Cervus eldii7
"Rucervus eldii"
Muntiacus vaginalis6
"Muntiacus muntjak": reassignment is based on geography
Canis aureus49.9 kg carnivore-frugivore
Grus antigone46.7 kg
Ephippiorhynchus asiaticus34.1 kg
Pavo muticus3
Viverricula indica33.0 kg invertivore-carnivore
Sturnus nigricollis2
Paradoxurus hermaphroditus22.4 kg frugivore-insectivore
Cuon alpinus214 kg carnivore
Viverra megaspila2
Francolinus pintadeanus1 insectivore-granivore
Felis chaus15.3 kg carnivore
Streptopelia tranquebarica1103 g granivore
Sarcogyps calvus1
Lepus peguensis1
Urva javanica1534 g
"Herpestes javanicus"