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=3205 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3205SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2992SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3205 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matrona' AND (junior_species='basilaris' OR junior_species='basilaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Matrona' AND (species='basilaris' OR species='basilaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Matrona' AND (species='basilaris' OR species='basilaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matrona' AND (junior_species='basilaris' OR junior_species='basilaris')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='Matrona' AND (species='basilaris' OR species='basilaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='tillyardi' OR junior_species='tillyardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aciagrion' AND (species='tillyardi' OR species='tillyardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aciagrion' AND (species='tillyardi' OR species='tillyardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='tillyardi' OR junior_species='tillyardii')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='Aciagrion' AND (species='tillyardi' OR species='tillyardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='pruinosum' OR species='pruinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='pruinosum' OR species='pruinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pruinosum' OR junior_species='pruinosum')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='Pseudagrion' AND (species='pruinosum' OR species='pruinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='immaculifrons' OR junior_species='immaculifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='immaculifrons' OR species='immaculifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='immaculifrons' OR species='immaculifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='immaculifrons' OR junior_species='immaculifrons')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='Anax' AND (species='immaculifrons' OR species='immaculifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalaeschna' AND (junior_species='dinghuensis' OR junior_species='dinghuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalaeschna' AND (species='dinghuensis' OR species='dinghuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cephalaeschna' AND (species='dinghuensis' OR species='dinghuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalaeschna' AND (junior_species='dinghuensis' OR junior_species='dinghuensis')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='Cephalaeschna' AND (species='dinghuensis' OR species='dinghuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisogomphus' AND (junior_species='anderi' OR junior_species='anderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisogomphus' AND (species='anderi' OR species='anderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisogomphus' AND (species='anderi' OR species='anderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisogomphus' AND (junior_species='anderi' OR junior_species='anderii')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='Anisogomphus' AND (species='anderi' OR species='anderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asiagomphus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asiagomphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asiagomphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asiagomphus' AND (junior_species='sp.' OR junior_species='sp.')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='Asiagomphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merogomphus' AND (junior_species='parviei' OR junior_species='parvieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merogomphus' AND (species='parviei' OR species='parvieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merogomphus' AND (species='parviei' OR species='parvieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merogomphus' AND (junior_species='parviei' OR junior_species='parvieii')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='Merogomphus' AND (species='parviei' OR species='parvieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliogomphus' AND (junior_species='retroflexus' OR junior_species='retroflexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliogomphus' AND (species='retroflexus' OR species='retroflexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliogomphus' AND (species='retroflexus' OR species='retroflexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliogomphus' AND (junior_species='retroflexus' OR junior_species='retroflexus')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='Heliogomphus' AND (species='retroflexus' OR species='retroflexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogomphus' AND (junior_species='perforatus' OR junior_species='perforatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogomphus' AND (species='perforatus' OR species='perforatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogomphus' AND (species='perforatus' OR species='perforatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogomphus' AND (junior_species='perforatus' OR junior_species='perforatus')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='Leptogomphus' AND (species='perforatus' OR species='perforatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinictinogomphus' AND (junior_species='clavatus' OR junior_species='clavatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sinictinogomphus' AND (species='clavatus' OR species='clavatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sinictinogomphus' AND (species='clavatus' OR species='clavatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinictinogomphus' AND (junior_species='clavatus' OR junior_species='clavatus')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='Sinictinogomphus' AND (species='clavatus' OR species='clavatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sieboldius' AND (junior_species='alexanderi' OR junior_species='alexanderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sieboldius' AND (species='alexanderi' OR species='alexanderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sieboldius' AND (species='alexanderi' OR species='alexanderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sieboldius' AND (junior_species='alexanderi' OR junior_species='alexanderii')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='Sieboldius' AND (species='alexanderi' OR species='alexanderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotogaster' AND (junior_species='flaveola' OR junior_species='flaveola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anotogaster' AND (species='flaveola' OR species='flaveola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anotogaster' AND (species='flaveola' OR species='flaveola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotogaster' AND (junior_species='flaveola' OR junior_species='flaveola')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='Anotogaster' AND (species='flaveola' OR species='flaveola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='victor' OR junior_species='victor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idionyx' AND (species='victor' OR species='victor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idionyx' AND (species='victor' OR species='victor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='victor' OR junior_species='victor')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='Idionyx' AND (species='victor' OR species='victor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromidia' AND (junior_species='rapida' OR junior_species='rapida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromidia' AND (species='rapida' OR species='rapida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromidia' AND (species='rapida' OR species='rapida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromidia' AND (junior_species='rapida' OR junior_species='rapida')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='Macromidia' AND (species='rapida' OR species='rapida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='urania' OR junior_species='urania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='urania' OR species='urania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='urania' OR species='urania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='urania' OR junior_species='urania')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='Macromia' AND (species='urania' OR species='urania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='eroticum' OR junior_species='eroticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='eroticum' OR species='eroticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='eroticum' OR species='eroticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='eroticum' OR junior_species='eroticum')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='Sympetrum' AND (species='eroticum' OR species='eroticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychothemis' AND (junior_species='testacea' OR junior_species='testacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychothemis' AND (species='testacea' OR species='testacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychothemis' AND (species='testacea' OR species='testacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychothemis' AND (junior_species='testacea' OR junior_species='testacea')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='Onychothemis' AND (species='testacea' OR species='testacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='triangularis' OR junior_species='triangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='triangularis' OR species='triangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='triangularis' OR species='triangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='triangularis' OR junior_species='triangularis')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='Rhyothemis' AND (species='triangularis' OR species='triangularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygonyx' AND (junior_species='takasago' OR junior_species='takasago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygonyx' AND (species='takasago' OR species='takasago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygonyx' AND (species='takasago' OR species='takasago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygonyx' AND (junior_species='takasago' OR junior_species='takasago')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='Zygonyx' AND (species='takasago' OR species='takasago') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3205 The Ecological Register: Dinghu Shan Biosphere Reserve (1993)
Dinghu Shan Biosphere Reserve (1993)
Basic information
Sample name: Dinghu Shan Biosphere Reserve (1993)

Reference: K. D. P. Wilson. 1999. Dragonflies (Odonata) of Dinghu Shan Biosphere Reserve, Guangdong Province, China. International Journal of Odonatology 2(1):23-53 [ER 2992]
Geography
Country: China

State: Guangdong


Coordinate: 23° 10' N, 112° 32' E
Coordinate basis: stated in text as range

Geography comments: "near Zhaoqing, approximately 86 km west of Guangzhou"

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: biosphere reserve

Substrate: ground surface

MAT: 20.9

MAP: 1956.0

Habitat comments: "A high proportion of the 1,155 ha reserve (79%) is covered by subtropical forest which includes areas of primary forest... there is a distinct seasonal pattern, with most rainfall falling in the April to September period"

Methods
Life forms: odonates

Sampling methods: no design

Sample size: 34 individuals

Years: 1993

Sampling comments: no details are given

Metadata
Sample number: 3205

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-02-07 12:05:23

Modified: 2019-02-07 01:05:23

Abundance distribution
20 species
13 singletons
total count 34
extrapolated richness: 96.8
Fisher's α: 20.375
geometric series k: 0.9100
Hurlbert's PIE: 0.9162
Shannon's H: 2.7696
Good's u: 0.6264
Each square represents a species. Square sizes are proportional to counts.
Register