Coordinate: 7° 45' S, 36° 52' E
elevation 290 to 2250 m
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=1945 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1945SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1745SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1945 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='arboreus' OR junior_species='arboreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrohyrax' AND (species='arboreus' OR species='arboreus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='arboreus' OR junior_species='arboreus')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='Dendrohyrax' AND (species='arboreus' OR species='arboreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxodonta' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' AND (junior_species='africana' OR junior_species='africana')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='Loxodonta' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')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='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='cirnei' OR junior_species='cirneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchocyon' AND (species='cirnei' OR species='cirneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchocyon' AND (species='cirnei' OR species='cirneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='cirnei' OR junior_species='cirneii')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='Rhynchocyon' AND (species='cirnei' OR species='cirneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='udzungwensis' OR junior_species='udzungwensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='udzungwensis' OR junior_species='udzungwensis')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='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atilax' AND (junior_species='paludinosus' OR junior_species='paludinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atilax' AND (species='paludinosus' OR species='paludinosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atilax' AND (junior_species='paludinosus' OR junior_species='paludinosus')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='Atilax' AND (species='paludinosus' OR species='paludinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='crassicauda' OR junior_species='crassicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bdeogale' AND (species='crassicauda' OR species='crassicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bdeogale' AND (species='crassicauda' OR species='crassicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='crassicauda' OR junior_species='crassicauda')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='Bdeogale' AND (species='crassicauda' OR species='crassicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Civettictis' AND (junior_species='civetta' OR junior_species='civetta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Civettictis' AND (species='civetta' OR species='civetta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Civettictis' AND (junior_species='civetta' OR junior_species='civetta')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='Civettictis' AND (species='civetta' OR species='civetta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='servalina' OR junior_species='servalina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Genetta' AND (species='servalina' OR species='servalina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='servalina' OR junior_species='servalina')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='Genetta' AND (species='servalina' OR species='servalina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')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='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mungos' AND (junior_species='mungo' OR junior_species='mungo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mungos' AND (species='mungo' OR species='mungo') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mungos' AND (junior_species='mungo' OR junior_species='mungo')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='Mungos' AND (species='mungo' OR species='mungo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')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='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')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='Panthera' AND (species='pardus' OR species='pardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercocebus' AND (junior_species='sanjei' OR junior_species='sanjeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercocebus' AND (species='sanjei' OR species='sanjeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercocebus' AND (species='sanjei' OR species='sanjeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercocebus' AND (junior_species='sanjei' OR junior_species='sanjeii')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='Cercocebus' AND (species='sanjei' OR species='sanjeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercopithecus' AND (junior_species='mitis' OR junior_species='mitis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercopithecus' AND (species='mitis' OR species='mitis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercopithecus' AND (species='mitis' OR species='mitis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercopithecus' AND (junior_species='mitis' OR junior_species='mitis')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='Cercopithecus' AND (species='mitis' OR species='mitis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papio' AND (species='cynocephalus' OR species='cynocephalus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')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='Papio' AND (species='cynocephalus' OR species='cynocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='gordonorum' OR junior_species='gordonorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piliocolobus' AND (species='gordonorum' OR species='gordonorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piliocolobus' AND (species='gordonorum' OR species='gordonorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='gordonorum' OR junior_species='gordonorum')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='Piliocolobus' AND (species='gordonorum' OR species='gordonorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobus' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobus' AND (junior_species='angolensis' OR junior_species='angolensis')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='Colobus' AND (species='angolensis' OR species='angolensis') 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='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')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='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='vexillarius' OR junior_species='vexillarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraxerus' AND (species='vexillarius' OR species='vexillarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraxerus' AND (species='vexillarius' OR species='vexillarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='vexillarius' OR junior_species='vexillarius')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='vexillarius' OR species='vexillarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='harveyi' OR junior_species='harveyii')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='harveyi' OR species='harveyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='harveyi' OR junior_species='harveyii')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cephalophus' AND (species='harveyi' OR species='harveyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='spadix' OR junior_species='spadix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='spadix' OR species='spadix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cephalophus' AND (species='spadix' OR species='spadix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='spadix' OR junior_species='spadix')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='Cephalophus' AND (species='spadix' OR species='spadix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')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='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')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='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')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='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1945