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=3153 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3153SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2955SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3153 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='sarpedon' OR species='sarpedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')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='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='xuthus' OR junior_species='xuthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='xuthus' OR species='xuthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='xuthus' OR species='xuthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='xuthus' OR junior_species='xuthus')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='Papilio' AND (species='xuthus' OR species='xuthus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polytes' OR species='polytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polytes' OR species='polytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')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='Papilio' AND (species='polytes' OR species='polytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='rapae' OR species='rapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='rapae' OR species='rapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')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='Pieris' AND (species='rapae' OR species='rapae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')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='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='argiades' OR junior_species='argiades')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Everes' AND (species='argiades' OR species='argiades') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Everes' AND (species='argiades' OR species='argiades')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='argiades' OR junior_species='argiades')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='Everes' AND (species='argiades' OR species='argiades') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='phlaeas' OR species='phlaeas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')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='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudozizeeria' AND (junior_species='maha' OR junior_species='maha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudozizeeria' AND (species='maha' OR species='maha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudozizeeria' AND (species='maha' OR species='maha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudozizeeria' AND (junior_species='maha' OR junior_species='maha')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='Pseudozizeeria' AND (species='maha' OR species='maha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='argiolus' OR species='argiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')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='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tongeia' AND (junior_species='filicaudis' OR junior_species='filicaudis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tongeia' AND (species='filicaudis' OR species='filicaudis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tongeia' AND (species='filicaudis' OR species='filicaudis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tongeia' AND (junior_species='filicaudis' OR junior_species='filicaudis')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='Tongeia' AND (species='filicaudis' OR species='filicaudis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-aureum' OR junior_species='c-aureum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonia' AND (species='c-aureum' OR species='c-aureum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='c-aureum' OR species='c-aureum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-aureum' OR junior_species='c-aureum')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='Polygonia' AND (species='c-aureum' OR species='c-aureum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyreus' AND (junior_species='hyperbius' OR junior_species='hyperbius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyreus' AND (species='hyperbius' OR species='hyperbius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyreus' AND (species='hyperbius' OR species='hyperbius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyreus' AND (junior_species='hyperbius' OR junior_species='hyperbius')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='Argyreus' AND (species='hyperbius' OR species='hyperbius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3153 The Ecological Register: Hefei (urban)
Hefei (urban)
Basic information
Sample name: Hefei (urban)

Reference: Y.-H. Wu, C.-B. Gu, W.-B. Li, N.-Y. Niu, D.-M. Han, and J. Fang. 2016. The influence of urbanization on butterfly diversity in Hefei, Anhui Province. Chinese Journal of Ecology 35(4):992-996 [ER 2955]
Geography
Country: China

State: Anhui


Coordinate: 31° 52' N, 117° 17' E
Coordinate basis: based on nearby landmark

Geography comments: Yaohai Park, Xinghua Park, and Xiaoyaojin
coordinate is based on Hefei

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

MAT: 15.7

MAP: 1000.0

Habitat comments: subtropical humid monsoonal climate

Methods
Life forms: butterflies

Sites: 3

Sampling methods: line transect,butterfly nets

Sample size: 225 individuals

Years: 2010

Days: 24

Seasons: spring,summer,autumn

Sampling comments: collecting was once per month using nets from March to October 2010
three 1 km transects were sampled in each of the three sites

Metadata
Sample number: 3153

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-31 16:03:15

Modified: 2020-01-14 05:11:45

Abundance distribution
12 species
0 singletons
total count 225
extrapolated richness: 13.9
Fisher's α: 2.708
geometric series k: 0.7127
Hurlbert's PIE: 0.7906
Shannon's H: 1.9300
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Graphium sarpedon9
Papilio xuthus8
Papilio polytes9
Pieris rapae83
Eurema hecabe7
Everes argiades2
Lycaena phlaeas9
Pseudozizeeria maha45
Celastrina argiolus5
Tongeia filicaudis8
Polygonia c-aureum34
Argyreus hyperbius6