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=1898 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1898SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1705SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1898 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Giraffa' AND (junior_species='camelopardalis' OR junior_species='camelopardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Giraffa' AND (species='camelopardalis' OR species='camelopardalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Giraffa' AND (junior_species='camelopardalis' OR junior_species='camelopardalis')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='Giraffa' AND (species='camelopardalis' OR species='camelopardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='Bos' AND (species='taurus' OR species='taurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='strepsiceros' OR junior_species='strepsiceros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tragelaphus' AND (species='strepsiceros' OR species='strepsiceros') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='strepsiceros' OR junior_species='strepsiceros')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='Tragelaphus' AND (species='strepsiceros' OR species='strepsiceros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' AND (junior_species='gazella' OR junior_species='gazella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryx' AND (species='gazella' OR species='gazella') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' AND (junior_species='gazella' OR junior_species='gazella')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='Oryx' AND (species='gazella' OR species='gazella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')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='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madoqua' AND (junior_species='kirkii' OR junior_species='kirki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Madoqua' AND (species='kirkii' OR species='kirki') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madoqua' AND (junior_species='kirkii' OR junior_species='kirki')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='Madoqua' AND (species='kirkii' OR species='kirki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phacochoerus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='africanus' OR junior_species='africanus')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='Phacochoerus' AND (species='africanus' OR species='africanus') 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='Parahyaena' AND (junior_species='brunnea' OR junior_species='brunnea')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='Parahyaena' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parahyaena' AND (junior_species='brunnea' OR junior_species='brunnea')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='Parahyaena' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' AND (junior_species='crocuta' OR junior_species='crocuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocuta' AND (species='crocuta' OR species='crocuta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' AND (junior_species='crocuta' OR junior_species='crocuta')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='Crocuta' AND (species='crocuta' OR species='crocuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caracal' AND (junior_species='caracal' OR junior_species='caracal')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caracal' AND (species='caracal' OR species='caracal') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caracal' AND (junior_species='caracal' OR junior_species='caracal')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='Caracal' AND (species='caracal' OR species='caracal') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='lybica' OR species='lybica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='genetta' OR junior_species='genetta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Genetta' AND (species='genetta' OR species='genetta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='genetta' OR junior_species='genetta')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='genetta' OR species='genetta') 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='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='mesomelas' OR species='mesomelas') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')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='Canis' AND (species='mesomelas' OR species='mesomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpestes' AND (junior_species='sanguineus' OR junior_species='sanguineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpestes' AND (species='sanguineus' OR species='sanguineus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpestes' AND (junior_species='sanguineus' OR junior_species='sanguineus')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='Herpestes' AND (species='sanguineus' OR species='sanguineus') 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='Ictonyx' 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='Ictonyx' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictonyx' 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='Ictonyx' AND (species='striatus' OR species='striatus') 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='Lepus' AND (junior_species='saxatilis' OR junior_species='saxatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='saxatilis' OR species='saxatilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='saxatilis' OR junior_species='saxatilis')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='Lepus' AND (species='saxatilis' OR species='saxatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orycteropus' AND (junior_species='afer' OR junior_species='afer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orycteropus' AND (species='afer' OR species='afer') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orycteropus' AND (junior_species='afer' OR junior_species='afer')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='Orycteropus' AND (species='afer' OR species='afer') 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='Numida' AND (junior_species='meleagris' OR junior_species='meleagris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Numida' AND (species='meleagris' OR species='meleagris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Numida' AND (species='meleagris' OR species='meleagris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Numida' AND (junior_species='meleagris' OR junior_species='meleagris')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='Numida' AND (species='meleagris' OR species='meleagris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternistis' AND (junior_species='adspersus' OR junior_species='adspersus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pternistis' AND (species='adspersus' OR species='adspersus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pternistis' AND (species='adspersus' OR species='adspersus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternistis' AND (junior_species='adspersus' OR junior_species='adspersus')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='Pternistis' AND (species='adspersus' OR species='adspersus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophotis' AND (junior_species='ruficrista' OR junior_species='ruficrista')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophotis' AND (species='ruficrista' OR species='ruficrista') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophotis' AND (species='ruficrista' OR species='ruficrista')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophotis' AND (junior_species='ruficrista' OR junior_species='ruficrista')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='Lophotis' AND (species='ruficrista' OR species='ruficrista') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardeotis' AND (junior_species='kori' OR junior_species='korii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ardeotis' AND (species='kori' OR species='korii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ardeotis' AND (species='kori' OR species='korii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardeotis' AND (junior_species='kori' OR junior_species='korii')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='Ardeotis' AND (species='kori' OR species='korii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afrotis' AND (junior_species='afraoides' OR junior_species='afraoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Afrotis' AND (species='afraoides' OR species='afraoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Afrotis' AND (species='afraoides' OR species='afraoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afrotis' AND (junior_species='afraoides' OR junior_species='afraoides')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='Afrotis' AND (species='afraoides' OR species='afraoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='erythrorhynchus' OR junior_species='erythrorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='erythrorhynchus' OR species='erythrorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='erythrorhynchus' OR species='erythrorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='erythrorhynchus' OR junior_species='erythrorhynchus')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='Tockus' AND (species='erythrorhynchus' OR species='erythrorhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='leucomelas' OR junior_species='leucomelas')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='Tockus' AND (species='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='monteiri' OR junior_species='monteirii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='monteiri' OR species='monteirii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='monteiri' OR species='monteirii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='monteiri' OR junior_species='monteirii')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='Tockus' AND (species='monteiri' OR species='monteirii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='capicola' OR junior_species='capicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='capicola' OR species='capicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='capicola' OR species='capicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='capicola' OR junior_species='capicola')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='Streptopelia' AND (species='capicola' OR species='capicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Streptopelia' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniarius' AND (junior_species='atrococcineus' OR junior_species='atrococcineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laniarius' AND (species='atrococcineus' OR species='atrococcineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laniarius' AND (species='atrococcineus' OR species='atrococcineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniarius' AND (junior_species='atrococcineus' OR junior_species='atrococcineus')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='Laniarius' AND (species='atrococcineus' OR species='atrococcineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plocepasser' AND (junior_species='mahali' OR junior_species='mahalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plocepasser' AND (species='mahali' OR species='mahalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plocepasser' AND (species='mahali' OR species='mahalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plocepasser' AND (junior_species='mahali' OR junior_species='mahalii')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='Plocepasser' AND (species='mahali' OR species='mahalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythaixoides' AND (junior_species='concolor' OR junior_species='concolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corythaixoides' AND (species='concolor' OR species='concolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corythaixoides' AND (species='concolor' OR species='concolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythaixoides' AND (junior_species='concolor' OR junior_species='concolor')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='Corythaixoides' AND (species='concolor' OR species='concolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocles' AND (junior_species='bicinctus' OR junior_species='bicinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocles' AND (species='bicinctus' OR species='bicinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocles' AND (species='bicinctus' OR species='bicinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocles' AND (junior_species='bicinctus' OR junior_species='bicinctus')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='Pterocles' AND (species='bicinctus' OR species='bicinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='vaalensis' OR junior_species='vaalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='vaalensis' OR species='vaalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='vaalensis' OR species='vaalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='vaalensis' OR junior_species='vaalensis')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='Anthus' AND (species='vaalensis' OR species='vaalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' 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='Burhinus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Burhinus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' 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='Burhinus' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='coturnix' OR junior_species='coturnix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coturnix' AND (species='coturnix' OR species='coturnix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coturnix' AND (species='coturnix' OR species='coturnix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='coturnix' OR junior_species='coturnix')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='Coturnix' AND (species='coturnix' OR species='coturnix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamprotornis' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamprotornis' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='australis' OR junior_species='australis')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='Lamprotornis' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='adsimilis' OR junior_species='adsimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='adsimilis' OR species='adsimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='adsimilis' OR species='adsimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='adsimilis' OR junior_species='adsimilis')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='Dicrurus' AND (species='adsimilis' OR species='adsimilis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1898 The Ecological Register: Waterberg Escarpment
Waterberg Escarpment
Basic information
Sample name: Waterberg Escarpment

Reference: A. B. Stein, T. K. Fuller, and L. L. Marker. 2008. Opportunistic use of camera traps to assess habitat-specific mammal and bird diversity in northcentral Namibia. Biodiversity and Conservation 17(14):3579-3587 [ER 1705]
Geography
Country: Namibia


Coordinate: -20.46133° S, 17.20812° E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

Disturbance: grazing,hunting

MAT: 21.0

WMT: 24.0

CMT: 16.0

MAP: 532.0

Habitat comments: "The farmlands surrounding the Park are mostly managed for livestock production and also support populations of wildlife for game farming, trophy hunting, and conservation... The area is dominated by Acacia mellifera and Dichrostachys cinerea bush, characterized as the thornveld biome"
climate data are for Grootfontein and are from Mileusnic et al. (2014, Journal of Geochemical Exploration)

Methods
Life forms: carnivores,primates,rodents,ungulates,other large mammals,other small mammals,birds

Sampling methods: no design,automatic cameras

Sample size: 388 captures or sightings

Years: 2006

Nets or traps: 4

Net or trap nights: 201

Camera type: analog

Cameras paired: yes

Trap spacing: 5.4

Sampling comments: four "motion-sensor camera stations" were positioned "between June and October 2006... Each station consisted of two motion-sensor cameras secured to trees at a height of 60 cm, pointing towards the path, but offset from each other at >0.5 m... The minimum distance between nearest stations was 3.0 km and the maximum distance was 7.8 km"

Metadata
Sample number: 1898

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-09 19:54:29

Modified: 2016-12-14 21:56:29

Abundance distribution
41 species
16 singletons
total count 388
extrapolated richness: 80.2
Fisher's α: 11.578
geometric series k: 0.9023
Hurlbert's PIE: 0.9329
Shannon's H: 3.0366
Good's u: 0.9588
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Giraffa camelopardalis1942 kg browser
Bos taurus3337 kg
Tragelaphus strepsiceros30189 kg browser-grazer
Oryx gazella19195 kg grazer-browser
Sylvicapra grimmia113 kg browser-grazer
Madoqua kirkii394.8 kg browser
Phacochoerus africanus1282 kg grazer-browser
"Phacochoerus aethiopicus"
Panthera pardus633 kg carnivore
Parahyaena brunnea1648 kg
"Hyaena brunnea"
Crocuta crocuta266 kg carnivore
Caracal caracal212 kg carnivore
"Felis caracal"
Felis lybica23
Genetta genetta121.7 kg insectivore-frugivore
Mellivora capensis27.7 kg carnivore-invertivore
Canis mesomelas67.9 kg carnivore
Herpestes sanguineus21465 g
Mungos mungo11.5 kg insectivore-carnivore
Ictonyx striatus1753 g invertivore-carnivore
Papio cynocephalus1416 kg browser-grazer
Lepus saxatilis282.0 kg
Orycteropus afer140 kg insectivore
Hystrix africaeaustralis1115 kg browser
Numida meleagris611.3 kg omnivore
Pternistis adspersus19
Lophotis ruficrista17
Ardeotis kori1104 g insectivore
Afrotis afraoides1
Tockus erythrorhynchus1150 g insectivore
Tockus leucomelas1211 g
Tockus monteiri1
Streptopelia capicola7142 g omnivore
Streptopelia senegalensis18.2 g frugivore-granivore
Laniarius atrococcineus8
Plocepasser mahali56.3 g
Corythaixoides concolor7258 g
Pterocles bicinctus1237 g
Anthus vaalensis227.0 g
Burhinus capensis1423 g
Coturnix coturnix190.0 g frugivore-granivore
Lamprotornis australis1
Dicrurus adsimilis1 insectivore