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=1897 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1897SELECT 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=1897 ORDER BY register_no ASCSELECT 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='Equus' 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='Equus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='africanus' OR species='africanus') 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='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taurotragus' AND (species='oryx' OR species='oryx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')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='Taurotragus' AND (species='oryx' OR species='oryx') 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='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='Acinonyx' AND (junior_species='jubatus' OR junior_species='jubatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acinonyx' AND (species='jubatus' OR species='jubatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acinonyx' AND (junior_species='jubatus' OR junior_species='jubatus')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='Acinonyx' AND (species='jubatus' OR species='jubatus') 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='Vulpes' AND (junior_species='chama' OR junior_species='chama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='chama' OR species='chama') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='chama' OR junior_species='chama')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='Vulpes' AND (species='chama' OR species='chama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocyon' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otocyon' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocyon' AND (junior_species='megalotis' OR junior_species='megalotis')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='Otocyon' AND (species='megalotis' OR species='megalotis') 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='Pedetes' 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='Pedetes' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedetes' 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='Pedetes' AND (species='capensis' OR species='capensis') 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='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='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='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='Bubo' 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='Bubo' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubo' AND (species='africanus' OR species='africanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubo' 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='Bubo' AND (species='africanus' OR species='africanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamprotornis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamprotornis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='nitens' OR junior_species='nitens')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='nitens' OR species='nitens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1897 The Ecological Register: Waterberg Plateau Park (surrounding flatlands)
Waterberg Plateau Park (surrounding flatlands)
Basic information
Sample name: Waterberg Plateau Park (surrounding flatlands)

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"
MAP 400 to 500 mm

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

Sampling methods: no design,automatic cameras

Sample size: 383 captures or sightings

Years: 2006

Nets or traps: 4

Net or trap nights: 200

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: 1897

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-09 19:44:55

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

Abundance distribution
35 species
6 singletons
total count 383
extrapolated richness: 52.2
Fisher's α: 9.372
geometric series k: 0.8845
Hurlbert's PIE: 0.9318
Shannon's H: 3.0110
Good's u: 0.9844
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bos taurus5337 kg
Equus africanus asinus2287 kg
Tragelaphus strepsiceros17189 kg browser-grazer
Oryx gazella10195 kg grazer-browser
Sylvicapra grimmia513 kg browser-grazer
Madoqua kirkii24.8 kg browser
Taurotragus oryx5393 kg browser-grazer
Phacochoerus africanus2582 kg grazer-browser
"Phacochoerus aethiopicus"
Panthera pardus1933 kg carnivore
Parahyaena brunnea848 kg
"Hyaena brunnea"
Caracal caracal312 kg carnivore
"Felis caracal"
Felis lybica20
Genetta genetta191.7 kg insectivore-frugivore
Acinonyx jubatus142 kg carnivore
Mellivora capensis27.7 kg carnivore-invertivore
Canis mesomelas87.9 kg carnivore
Herpestes sanguineus28465 g
Mungos mungo31.5 kg insectivore-carnivore
Vulpes chama22.7 kg carnivore-frugivore
Otocyon megalotis53.2 kg frugivore-invertivore
Ictonyx striatus2753 g invertivore-carnivore
Papio cynocephalus2116 kg browser-grazer
Lepus saxatilis272.0 kg
Orycteropus afer440 kg insectivore
Pedetes capensis62.4 kg
Hystrix africaeaustralis2815 kg browser
Numida meleagris651.3 kg omnivore
Pternistis adspersus20
Lophotis ruficrista12
Ardeotis kori1104 g insectivore
Tockus leucomelas4211 g
Streptopelia capicola1142 g omnivore
Plocepasser mahali16.3 g
Bubo africanus1 carnivore
Lamprotornis nitens185.6 g