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=3206 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3206SELECT 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=3206 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='Calopteryx' AND (junior_species='melli' OR junior_species='mellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calopteryx' AND (species='melli' OR species='mellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calopteryx' AND (species='melli' OR species='mellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='melli' OR junior_species='mellii')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='Calopteryx' AND (species='melli' OR species='mellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philosina' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philosina' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philosina' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philosina' AND (junior_species='alba' OR junior_species='alba')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='Philosina' AND (species='alba' OR species='alba') 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='Tetracanthagyna' AND (junior_species='waterhousei' OR junior_species='waterhouseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetracanthagyna' AND (species='waterhousei' OR species='waterhouseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetracanthagyna' AND (species='waterhousei' OR species='waterhouseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracanthagyna' AND (junior_species='waterhousei' OR junior_species='waterhouseii')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='Tetracanthagyna' AND (species='waterhousei' OR species='waterhouseii') 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='Burmagomphus' AND (junior_species='vermicularis' OR junior_species='vermicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Burmagomphus' AND (species='vermicularis' OR species='vermicularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Burmagomphus' AND (species='vermicularis' OR species='vermicularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burmagomphus' AND (junior_species='vermicularis' OR junior_species='vermicularis')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='Burmagomphus' AND (species='vermicularis' OR species='vermicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labrogomphus' AND (junior_species='torvus' OR junior_species='torvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Labrogomphus' AND (species='torvus' OR species='torvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Labrogomphus' AND (species='torvus' OR species='torvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labrogomphus' AND (junior_species='torvus' OR junior_species='torvus')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='Labrogomphus' AND (species='torvus' OR species='torvus') 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='Stylurus' AND (junior_species='clathratus' OR junior_species='clathratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='clathratus' OR species='clathratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='clathratus' OR species='clathratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='clathratus' OR junior_species='clathratus')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='Stylurus' AND (species='clathratus' OR species='clathratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='nanningensis' OR junior_species='nanningensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='nanningensis' OR species='nanningensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='nanningensis' OR species='nanningensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='nanningensis' OR junior_species='nanningensis')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='Stylurus' AND (species='nanningensis' OR species='nanningensis') 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='Gomphidia' AND (junior_species='krugeri' OR junior_species='krugerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphidia' AND (species='krugeri' OR species='krugerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphidia' AND (species='krugeri' OR species='krugerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphidia' AND (junior_species='krugeri' OR junior_species='krugerii')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='Gomphidia' AND (species='krugeri' OR species='krugerii') 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='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='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='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=3206 The Ecological Register: Dinghu Shan Biosphere Reserve (1994)
Dinghu Shan Biosphere Reserve (1994)
Basic information
Sample name: Dinghu Shan Biosphere Reserve (1994)

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: 64 individuals

Years: 1994

Sampling comments: no details are given

Metadata
Sample number: 3206

Contributor: John Alroy

Enterer: John Alroy

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

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

Abundance distribution
22 species
9 singletons
total count 64
extrapolated richness: 53.4
Fisher's α: 11.851
geometric series k: 0.9057
Hurlbert's PIE: 0.9261
Shannon's H: 2.8166
Good's u: 0.8613
Each square represents a species. Square sizes are proportional to counts.
Register