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=3567 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3567SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3240SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3567 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='tundrensis' OR junior_species='tundrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='tundrensis' OR species='tundrensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='tundrensis' OR junior_species='tundrensis')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='Sorex' AND (species='tundrensis' OR species='tundrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')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='Sorex' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutissimus' OR junior_species='minutissimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='minutissimus' OR species='minutissimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='minutissimus' OR species='minutissimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutissimus' OR junior_species='minutissimus')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='Sorex' AND (species='minutissimus' OR species='minutissimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='suaveolens' OR junior_species='suaveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='suaveolens' OR junior_species='suaveolens')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='Crocidura' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilus' AND (junior_species='erythrogenys' OR junior_species='erythrogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilus' AND (species='erythrogenys' OR species='erythrogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilus' AND (species='erythrogenys' OR species='erythrogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilus' AND (junior_species='erythrogenys' OR junior_species='erythrogenys')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='Spermophilus' AND (species='erythrogenys' OR species='erythrogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='subtilis' OR junior_species='subtilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sicista' AND (species='subtilis' OR species='subtilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sicista' AND (species='subtilis' OR species='subtilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='subtilis' OR junior_species='subtilis')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='Sicista' AND (species='subtilis' OR species='subtilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='uralensis' OR junior_species='uralensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='uralensis' OR species='uralensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='uralensis' OR species='uralensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='uralensis' OR junior_species='uralensis')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='Apodemus' AND (species='uralensis' OR species='uralensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phodopus' AND (junior_species='sungorus' OR junior_species='sungorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phodopus' AND (species='sungorus' OR species='sungorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phodopus' AND (species='sungorus' OR species='sungorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phodopus' AND (junior_species='sungorus' OR junior_species='sungorus')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='Phodopus' AND (species='sungorus' OR species='sungorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ellobius' AND (junior_species='talpinus' OR junior_species='talpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ellobius' AND (species='talpinus' OR species='talpinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ellobius' AND (species='talpinus' OR species='talpinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ellobius' AND (junior_species='talpinus' OR junior_species='talpinus')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='Ellobius' AND (species='talpinus' OR species='talpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagurus' AND (junior_species='lagurus' OR junior_species='lagurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagurus' AND (species='lagurus' OR species='lagurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagurus' AND (species='lagurus' OR species='lagurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagurus' AND (junior_species='lagurus' OR junior_species='lagurus')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='Lagurus' AND (species='lagurus' OR species='lagurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocranius' AND (species='gregalis' OR species='gregalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')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='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')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='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='arvalis' OR species='arvalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='arvalis' OR species='arvalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')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='Microtus' AND (species='arvalis' OR species='arvalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3567 The Ecological Register: Pavlodar
Pavlodar
Basic information
Sample name: Pavlodar

Reference: T. A. Dupal, Z. M. Sergazinova, N. T. Erzhanov, and Y. N. Litvinov. 2017. Preliminary assessment of changes in the structure of small mammal communities caused by industrial pollution in the north Kazakhstan region. Contemporary Problems of Ecology 10(6):700-706 [ER 3240]
Geography
Country: Kazakhstan


Coordinate: 52° 18' N, 76° 57' E
Coordinate basis: based on nearby landmark

Geography comments: "in industrial area of the city of Pavlodar"
coordinate based on Pavlodar

Environment
Habitat: temperate savanna

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

Habitat comments: "All plots are dominated by steppe plants"

Methods
Life forms: rodents,other small mammals

Sites: 10

Sampling methods: pitfall traps

Sample size: 91 specimens

Years: 2016

Days: 30

Seasons: summer

Net or trap nights: 1142

Sampling comments: "Field operations were conducted from June to August in 2016. Ten plots were laid out within three 'technogenic' (anthropogenic) zones... Species were collected using 50-m-long pitfall traps for 10 days every month. Leaving 5 m from the edge, five cones were pushed (dug) into the trench bottom 10 m apart... A total of 1142 cones-days (c-d) in the anthropogenic and 770 c-d in the reference zones were completed"

Metadata
Sample number: 3567

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-12-23 20:46:50

Modified: 2020-01-14 05:12:49

Abundance distribution
13 species
4 singletons
total count 91
extrapolated richness: 26.1
Fisher's α: 4.150
geometric series k: 0.7369
Hurlbert's PIE: 0.7315
Shannon's H: 1.7532
Good's u: 0.9568
Each square represents a species. Square sizes are proportional to counts.
Register