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=3717 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3717SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3348SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3717 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephas' AND (junior_species='maximus' OR junior_species='maximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elephas' AND (species='maximus' OR species='maximus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephas' AND (junior_species='maximus' OR junior_species='maximus')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='Elephas' AND (species='maximus' OR species='maximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axis' AND (species='axis' OR species='axis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')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='axis' OR species='axis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='mulatta' OR species='mulatta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')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='mulatta' OR species='mulatta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semnopithecus' AND (junior_species='entellus' OR junior_species='entellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semnopithecus' AND (species='entellus' OR species='entellus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semnopithecus' AND (junior_species='entellus' OR junior_species='entellus')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='Semnopithecus' AND (species='entellus' OR species='entellus') 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='Lepus' 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='Lepus' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='nigricollis' OR species='nigricollis') 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='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='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='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='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='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='Urva' AND (junior_species='edwardsii' OR junior_species='edwardsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urva' AND (species='edwardsii' OR species='edwardsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urva' AND (species='edwardsii' OR species='edwardsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urva' AND (junior_species='edwardsii' OR junior_species='edwardsi')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='edwardsii' OR species='edwardsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')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='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavo' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pavo' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pavo' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavo' AND (junior_species='cristatus' OR junior_species='cristatus')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='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='pandicerianus' OR junior_species='pandicerianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='pandicerianus' OR species='pandicerianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='pandicerianus' OR species='pandicerianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='pandicerianus' OR junior_species='pandicerianus')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='pandicerianus' OR species='pandicerianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galloperdix' AND (junior_species='spadicea' OR junior_species='spadicea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galloperdix' AND (species='spadicea' OR species='spadicea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galloperdix' AND (species='spadicea' OR species='spadicea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galloperdix' AND (junior_species='spadicea' OR junior_species='spadicea')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='Galloperdix' AND (species='spadicea' OR species='spadicea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallus' AND (species='gallus' OR species='gallus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallus' AND (species='gallus' OR species='gallus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')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='Gallus' AND (species='gallus' OR species='gallus') 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='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='taurus' OR species='taurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' AND (junior_species='bubalis' OR junior_species='bubalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bubalus' AND (species='bubalis' OR species='bubalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' AND (junior_species='bubalis' OR junior_species='bubalis')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='Bubalus' AND (species='bubalis' OR species='bubalis') 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='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 * FROM register WHERE sample_no=3717 The Ecological Register: Bharatpur and Jagannathprasad
Bharatpur and Jagannathprasad
Basic information
Sample name: Bharatpur and Jagannathprasad

Sample aka: Chandaka-Dampara Wildlife Sanctuary

Reference: S. Debata and K. K. Swain. 2020. Mammalian fauna in an urban influenced zone of Chandaka-Dampara Wildlife Sanctuary in Odisha, India. Journal of Threatened Taxa 12(8):15767-15775 [ER 3348]
Geography
Country: India

State: Odisha


Coordinate: 20.323° N, 85.783° E
Coordinate basis: stated in text as range

Geography comments: "an area of 193.39km2 is situated in Khurda District adjoining Bhubaneswar... The sanctuary exists in two different parts; the major part contains an area of 172.12km2 while the other part, Bharatpur-Jagannathprasad sector is 19.27km2"; the study was confined to the latter

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: wildlife protected area

Substrate: ground surface

MAP: 1542.0

Habitat comments: "The climate of the area is tropical and the three distinct seasons-summer (March-June), monsoon (July-October) and winter (November-February)-are experienced here. The annual mean temperature of the area varies between 12ºC during January to 42ºC during May with an average annual rainfall of 1,542mm. Vegetation of the area is an admixture of mixed deciduous, semi-evergreen and bamboo brakes and the major portion of the area is covered with bushy and shrubby vegetation... Although currently, there is no human habitation and human activities within the area, it is experiencing severe biotic pressure from the growth and development of Bhubaneswar City"
reported temperatures are respectively winter daily lows and summer daily highs

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

Sampling methods: no design,automatic cameras

Sample size: 2179 captures or sightings

Years: 2019

Days: 120

Nets or traps: 9

Net or trap nights: 771

Sampling comments: "The study was carried out for four months (1 January-30 April 2019) by using nine automatically triggered camera traps (Cuddeback and Moultrie, USA). The area was first divided into square shaped 1km2 grids" with "one camera trap in each grid for a minimum of 25 days... we could only sample nine grids at a time... Each photo was rated as an independent capture, if the time between consecutive photographs of the same subject was more than 30 minutes apart... effort resulted in 771.31 trap days"
cattle and water buffalo count is 141 photos, undifferentiated, but RAIs of 15.81 and 2.46 are reported, so the separate counts are 122 and 19
a vehicle count of 676 is also reported; Homo sapiens count is of "human traffic"

Metadata
Sample number: 3717

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-11-05 15:21:01

Modified: 2020-11-05 04:21:33

Abundance distribution
23 species
3 singletons
total count 2179
extrapolated richness: 29.5
Fisher's α: 3.588
geometric series k: 0.7505
Hurlbert's PIE: 0.8609
Shannon's H: 2.2714
Good's u: 0.9986
Each square represents a species. Square sizes are proportional to counts.
Register
Elephas maximus13711 kg grazer-browser
Axis axis30140 kg browser-grazer
Macaca mulatta368.0 kg folivore-frugivore
Semnopithecus entellus210 kg folivore-frugivore
Hystrix indica5213 kg browser
Lepus nigricollis68
Sus scrofa11054 kg herbivore
Felis chaus605.3 kg carnivore
Canis aureus5529.9 kg carnivore-frugivore
Hyaena hyaena130 kg carnivore-insectivore
Viverricula indica603.0 kg invertivore-carnivore
Paradoxurus hermaphroditus12.4 kg frugivore-insectivore
Urva edwardsii6
Mellivora capensis27.7 kg carnivore-invertivore
Pavo cristatus2444.8 kg omnivore
Francolinus pandicerianus13
Galloperdix spadicea4 omnivore
Gallus gallus629.1 g frugivore-granivore
Homo sapiens37964 kg
Bos taurus122337 kg
Bubalus bubalis19425 kg
Canis lupus familiaris13543 kg carnivore
Felis catus5