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=1199 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1199SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=847SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1199 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='flavopunctatus' OR junior_species='flavopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='flavopunctatus' OR junior_species='flavopunctatus')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='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praomys' AND (junior_species='jacksoni' OR junior_species='jacksonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praomys' AND (species='jacksoni' OR species='jacksonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praomys' AND (species='jacksoni' OR species='jacksonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praomys' AND (junior_species='jacksoni' OR junior_species='jacksonii')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='Praomys' AND (species='jacksoni' OR species='jacksonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='hindei' OR junior_species='hindeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethomys' AND (species='hindei' OR species='hindeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethomys' AND (species='hindei' OR species='hindeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='hindei' OR junior_species='hindeii')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='Aethomys' AND (species='hindei' OR species='hindeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemniscomys' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lemniscomys' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='striatus' OR junior_species='striatus')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='Lemniscomys' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='sikapusi' OR junior_species='sikapusii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophuromys' AND (species='sikapusi' OR species='sikapusii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophuromys' AND (species='sikapusi' OR species='sikapusii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='sikapusi' OR junior_species='sikapusii')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='Lophuromys' AND (species='sikapusi' OR species='sikapusii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenomys' AND (junior_species='hypoxanthus' OR junior_species='hypoxanthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenomys' AND (species='hypoxanthus' OR species='hypoxanthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenomys' AND (species='hypoxanthus' OR species='hypoxanthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenomys' AND (junior_species='hypoxanthus' OR junior_species='hypoxanthus')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='Oenomys' AND (species='hypoxanthus' OR species='hypoxanthus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='irroratus' OR junior_species='irroratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otomys' AND (species='irroratus' OR species='irroratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otomys' AND (species='irroratus' OR species='irroratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='irroratus' OR junior_species='irroratus')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='Otomys' AND (species='irroratus' OR species='irroratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammomys' AND (junior_species='dolichurus' OR junior_species='dolichurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammomys' AND (species='dolichurus' OR species='dolichurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammomys' AND (species='dolichurus' OR species='dolichurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammomys' AND (junior_species='dolichurus' OR junior_species='dolichurus')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='Grammomys' AND (species='dolichurus' OR species='dolichurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicanthis' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')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='Arvicanthis' AND (species='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')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='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='rattus' OR species='rattus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')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='Rattus' AND (species='rattus' OR species='rattus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='emini' OR junior_species='eminii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraxerus' AND (species='emini' OR species='eminii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraxerus' AND (species='emini' OR species='eminii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='emini' OR junior_species='eminii')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='Paraxerus' AND (species='emini' OR species='eminii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1199 The Ecological Register: Lunyo Forest
Lunyo Forest
Basic information
Sample name: Lunyo Forest

Reference: N. O. Okia. 1992. Aspects of rodent ecology in Lunyo Forest, Uganda. Journal of Tropical Ecology 8(2):153-167 [ER 847]
Geography
Country: Uganda


Coordinate: 0° 5' 0" N, 32° 27' 30" E
Coordinate basis: stated in text

Geography comments: "on the northern shores of Lake Victoria" (coordinate is actually inside the city of Entebbe)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

Disturbance: selective logging

MAT: 21.1

MAP: 1499.0

Habitat comments: "a small lake-shore forest... tall indigenous trees have been cut in many parts so that most of it is now bush with overgrown tree stumps"
MAP (59 inches) and daily min/max ("just over 60º F" and "in the neighbourhood of 80º F") are for Entebbe and are from Baker (1956)

Methods
Life forms: rodents

Sampling methods: quadrat,baited,Havahart traps

Sample size: 772 captures or sightings

Years: 1970 - 1972

Days: 223

Seasons: dry,wet or monsoon

Net or trap nights: 7632

Sampling comments: Havahart traps laid out in a 40 x 110 m grid and baited with "shelled ground nuts, ripe bananas and fresh cassava"
number of traps in use at a time varied from 20 to 49; trap nights laboriously computed from data in Table 1
counts include recaptures

Metadata
Sample number: 1199

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-13 21:15:52

Modified: 2015-10-04 10:02:11

Abundance distribution
12 species
2 singletons
total count 772
extrapolated richness: 18.2
Fisher's α: 2.017
geometric series k: 0.5997
Hurlbert's PIE: 0.7680
Shannon's H: 1.6672
Good's u: 0.9974
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Lophuromys flavopunctatus277
Praomys jacksoni200
Aethomys hindei99
Lemniscomys striatus60
Lophuromys sikapusi67
Oenomys hypoxanthus59
Otomys irroratus2
Grammomys dolichurus1
Arvicanthis niloticus290.6 g
Cricetomys gambianus21.4 kg frugivore-granivore
Rattus rattus2121 g
Paraxerus emini1