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=828 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=828SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=468SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=828 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araneus' 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='Araneus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araneus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araneus' 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='Araneus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araniella' AND (junior_species='opistographa' OR junior_species='opistographa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Araniella' AND (species='opistographa' OR species='opistographa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araniella' AND (species='opistographa' OR species='opistographa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araniella' AND (junior_species='opistographa' OR junior_species='opistographa')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='Araniella' AND (species='opistographa' OR species='opistographa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='lobata' OR junior_species='lobata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argiope' AND (species='lobata' OR species='lobata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argiope' AND (species='lobata' OR species='lobata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='lobata' OR junior_species='lobata')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='Argiope' AND (species='lobata' OR species='lobata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='effosum' OR junior_species='effosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheiracanthium' AND (species='effosum' OR species='effosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheiracanthium' AND (species='effosum' OR species='effosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='effosum' OR junior_species='effosum')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='Cheiracanthium' AND (species='effosum' OR species='effosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' 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='Clubiona' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' 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='Clubiona' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meioneta' AND (junior_species='rurestris' OR junior_species='rurestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meioneta' AND (species='rurestris' OR species='rurestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meioneta' AND (species='rurestris' OR species='rurestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meioneta' AND (junior_species='rurestris' OR junior_species='rurestris')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='Meioneta' AND (species='rurestris' OR species='rurestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silometopus' AND (junior_species='reussi' OR junior_species='reussii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Silometopus' AND (species='reussi' OR species='reussii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Silometopus' AND (species='reussi' OR species='reussii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silometopus' AND (junior_species='reussi' OR junior_species='reussii')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='Silometopus' AND (species='reussi' OR species='reussii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='heterophthalmus' OR junior_species='heterophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='heterophthalmus' OR junior_species='heterophthalmus')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='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='aureolus' OR junior_species='aureolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodromus' AND (species='aureolus' OR species='aureolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodromus' AND (species='aureolus' OR species='aureolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='aureolus' OR junior_species='aureolus')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='Philodromus' AND (species='aureolus' OR species='aureolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='cespitum' OR junior_species='cespitum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodromus' AND (species='cespitum' OR species='cespitum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodromus' AND (species='cespitum' OR species='cespitum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='cespitum' OR junior_species='cespitum')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='Philodromus' AND (species='cespitum' OR species='cespitum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tibellus' AND (junior_species='oblongus' OR junior_species='oblongus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tibellus' AND (species='oblongus' OR species='oblongus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tibellus' AND (species='oblongus' OR species='oblongus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tibellus' AND (junior_species='oblongus' OR junior_species='oblongus')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='Tibellus' AND (species='oblongus' OR species='oblongus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carrhotus' AND (junior_species='xanthogramma' OR junior_species='xanthogramma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carrhotus' AND (species='xanthogramma' OR species='xanthogramma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carrhotus' AND (species='xanthogramma' OR species='xanthogramma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carrhotus' AND (junior_species='xanthogramma' OR junior_species='xanthogramma')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='Carrhotus' AND (species='xanthogramma' OR species='xanthogramma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eris' AND (junior_species='nidicolens' OR junior_species='nidicolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eris' AND (species='nidicolens' OR species='nidicolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eris' AND (species='nidicolens' OR species='nidicolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eris' AND (junior_species='nidicolens' OR junior_species='nidicolens')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='Eris' AND (species='nidicolens' OR species='nidicolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evarcha' AND (junior_species='falcata' OR junior_species='falcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evarcha' AND (species='falcata' OR species='falcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evarcha' AND (species='falcata' OR species='falcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evarcha' AND (junior_species='falcata' OR junior_species='falcata')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='Evarcha' AND (species='falcata' OR species='falcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudicus' AND (junior_species='encarpatus' OR junior_species='encarpatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudicus' AND (species='encarpatus' OR species='encarpatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudicus' AND (species='encarpatus' OR species='encarpatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudicus' AND (junior_species='encarpatus' OR junior_species='encarpatus')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='Pseudicus' AND (species='encarpatus' OR species='encarpatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='quagga' OR junior_species='quagga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salticus' AND (species='quagga' OR species='quagga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salticus' AND (species='quagga' OR species='quagga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='quagga' OR junior_species='quagga')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='Salticus' AND (species='quagga' OR species='quagga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='scenicus' OR junior_species='scenicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salticus' AND (species='scenicus' OR species='scenicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salticus' AND (species='scenicus' OR species='scenicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='scenicus' OR junior_species='scenicus')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='Salticus' AND (species='scenicus' OR species='scenicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enoplognatha' 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='Enoplognatha' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enoplognatha' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enoplognatha' 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='Enoplognatha' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatoda' AND (junior_species='albomaculata' OR junior_species='albomaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steatoda' AND (species='albomaculata' OR species='albomaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steatoda' AND (species='albomaculata' OR species='albomaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatoda' AND (junior_species='albomaculata' OR junior_species='albomaculata')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='Steatoda' AND (species='albomaculata' OR species='albomaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='impressum' OR junior_species='impressum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='impressum' OR species='impressum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='impressum' OR species='impressum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='impressum' OR junior_species='impressum')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='Theridion' AND (species='impressum' OR species='impressum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='pinastri' OR junior_species='pinastrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='pinastri' OR species='pinastrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='pinastri' OR species='pinastrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='pinastri' OR junior_species='pinastrii')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='Theridion' AND (species='pinastri' OR species='pinastrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='varians' OR junior_species='varians')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='varians' OR species='varians') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='varians' OR species='varians')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='varians' OR junior_species='varians')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='Theridion' AND (species='varians' OR species='varians') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=828 The Ecological Register: Kecskemet-Szarkas (canopy)
Kecskemet-Szarkas (canopy)
Basic information
Sample name: Kecskemet-Szarkas (canopy)

Reference: F. Samu, V. Racz, C. Erdelyi, and K. Balazs. 1997. Spiders of the foliage and herbaceous layer of an IPM apple orchard in Kecskemet-Szarkas, Hungary. Biological Agriculture & Horticulture 15(1-4):131-140 [ER 468]
Geography
Country: Hungary


Coordinate: 46° 54' 22" N, 19° 41' 23" E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Kecskemet

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: canopy

WMT: 22.2

CMT: 0.4

MAP: 509.0

Habitat comments: orchard
climate based on station 12843 (Budapest)

Methods
Life forms: spiders

Sampling methods: no design,hand capture

Sample size: 71 individuals

Years: 1994

Days: 24

Sampling comments: "branch beating"

Metadata
Sample number: 828

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-18 10:54:30

Modified: 2014-04-24 06:21:55

Abundance distribution
22 species
12 singletons
total count 71
extrapolated richness: 75.0
Fisher's α: 10.915
geometric series k: 0.8533
Hurlbert's PIE: 0.8046
Shannon's H: 2.3085
Good's u: 0.8330
Each square represents a species. Square sizes are proportional to counts.
Register