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=1978 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1978SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1774SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1978 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echinosorex' AND (junior_species='gymnurus' OR junior_species='gymnurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Echinosorex' AND (species='gymnurus' OR species='gymnurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echinosorex' AND (junior_species='gymnurus' OR junior_species='gymnurus')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='Echinosorex' AND (species='gymnurus' OR species='gymnurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupaia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='gracilis' OR junior_species='gracilis')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='Tupaia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupaia' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='minor' OR junior_species='minor')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='Tupaia' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='tana' OR junior_species='tana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupaia' AND (species='tana' OR species='tana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='tana' OR junior_species='tana')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='Tupaia' AND (species='tana' OR species='tana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalopachus' AND (junior_species='bancanus' OR junior_species='bancanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalopachus' AND (species='bancanus' OR species='bancanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalopachus' AND (junior_species='bancanus' OR junior_species='bancanus')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='Cephalopachus' AND (species='bancanus' OR species='bancanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Presbytis' AND (junior_species='rubicunda' OR junior_species='rubicunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Presbytis' AND (species='rubicunda' OR species='rubicunda') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Presbytis' AND (junior_species='rubicunda' OR junior_species='rubicunda')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='Presbytis' AND (species='rubicunda' OR species='rubicunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasalis' 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='Nasalis' AND (species='larvatus' OR species='larvatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasalis' 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='Nasalis' AND (species='larvatus' OR species='larvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='fascicularis' OR junior_species='fascicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='fascicularis' OR species='fascicularis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='fascicularis' OR junior_species='fascicularis')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='Macaca' AND (species='fascicularis' OR species='fascicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='nemestrina' OR junior_species='nemestrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='nemestrina' OR species='nemestrina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='nemestrina' OR junior_species='nemestrina')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='Macaca' AND (species='nemestrina' OR species='nemestrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylobates' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylobates' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylobates' AND (junior_species='muelleri' OR junior_species='muellerii')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='Hylobates' AND (species='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pongo' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pongo' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pongo' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')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='Pongo' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manis' AND (junior_species='javanica' OR junior_species='javanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manis' AND (species='javanica' OR species='javanica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manis' AND (junior_species='javanica' OR junior_species='javanica')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='Manis' AND (species='javanica' OR species='javanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopoldamys' AND (junior_species='sabanus' OR junior_species='sabanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopoldamys' AND (species='sabanus' OR species='sabanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopoldamys' AND (junior_species='sabanus' OR junior_species='sabanus')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='Leopoldamys' AND (species='sabanus' OR species='sabanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='exulans' OR junior_species='exulans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='exulans' OR species='exulans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='exulans' OR species='exulans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='exulans' OR junior_species='exulans')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='exulans' OR species='exulans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sundamys' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sundamys' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sundamys' AND (junior_species='muelleri' OR junior_species='muellerii')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='Sundamys' AND (species='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='notatus' OR junior_species='notatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callosciurus' AND (species='notatus' OR species='notatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='notatus' OR junior_species='notatus')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='Callosciurus' AND (species='notatus' OR species='notatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='prevostii' OR junior_species='prevosti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callosciurus' AND (species='prevostii' OR species='prevosti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callosciurus' AND (species='prevostii' OR species='prevosti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callosciurus' AND (junior_species='prevostii' OR junior_species='prevosti')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='Callosciurus' AND (species='prevostii' OR species='prevosti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')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='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichys' AND (junior_species='fasciculata' OR junior_species='fasciculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichys' AND (species='fasciculata' OR species='fasciculata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichys' AND (junior_species='fasciculata' OR junior_species='fasciculata')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='Trichys' AND (species='fasciculata' OR species='fasciculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='crassispinis' OR junior_species='crassispinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='crassispinis' OR species='crassispinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='crassispinis' OR species='crassispinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='crassispinis' OR junior_species='crassispinis')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='crassispinis' OR species='crassispinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helarctos' AND (junior_species='malayanus' OR junior_species='malayanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helarctos' AND (species='malayanus' OR species='malayanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helarctos' AND (junior_species='malayanus' OR junior_species='malayanus')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='Helarctos' AND (species='malayanus' OR species='malayanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')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='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctogalidia' AND (junior_species='trivirgata' OR junior_species='trivirgata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctogalidia' AND (species='trivirgata' OR species='trivirgata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctogalidia' AND (junior_species='trivirgata' OR junior_species='trivirgata')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='Arctogalidia' AND (species='trivirgata' OR species='trivirgata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemigalus' AND (junior_species='derbyanus' OR junior_species='derbyanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemigalus' AND (species='derbyanus' OR species='derbyanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemigalus' AND (species='derbyanus' OR species='derbyanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemigalus' AND (junior_species='derbyanus' OR junior_species='derbyanus')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='Hemigalus' AND (species='derbyanus' OR species='derbyanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')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='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverra' AND (junior_species='tangalunga' OR junior_species='tangalunga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Viverra' AND (species='tangalunga' OR species='tangalunga') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverra' AND (junior_species='tangalunga' OR junior_species='tangalunga')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='Viverra' AND (species='tangalunga' OR species='tangalunga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urva' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urva' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urva' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urva' AND (junior_species='brachyura' OR junior_species='brachyura')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='Urva' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='planiceps' OR junior_species='planiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionailurus' AND (species='planiceps' OR species='planiceps') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='planiceps' OR junior_species='planiceps')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='Prionailurus' AND (species='planiceps' OR species='planiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='barbatus' OR junior_species='barbatus')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='Sus' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragulus' AND (junior_species='napu' OR junior_species='napu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tragulus' AND (species='napu' OR species='napu') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragulus' AND (junior_species='napu' OR junior_species='napu')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='Tragulus' AND (species='napu' OR species='napu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')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='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')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='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muntiacus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Muntiacus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1978 The Ecological Register: PT. REA Kaltim Estates
PT. REA Kaltim Estates
Basic information
Sample name: PT. REA Kaltim Estates

Reference: D. Wahyudi and R. Stuebing. 2013. Camera trapping as a conservation tool in a mixed-use landscape in East Kalimantan. Journal of Indonesian Natural History 1(2):37-46 [ER 1774]
Geography
Country: Indonesia

State: East Kalimantan


Coordinate: 0° 29' 35" N, 116° 15' 29" E
Coordinate basis: stated in text as range

Geography comments: "in the upper region of the Belayan River, a tributary of the Mahakam River"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 26.0

MAP: 4147.0

Habitat comments: "about 18% [of the area] was set aside for conservation... These CRs consist mostly of riparian forests, areas with unique habitats such as peat swamp or wetlands... All have undergone several cycles of licensed mechanical logging, illegal timber harvesting, and in some cases ENSO fires"
climate data are for Tabang and are from Besler (1987, Earth Surface Processes and Landforms)

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

Site area: 5000

Sampling methods: no design,baited,automatic cameras

Sample size: 6339 captures or sightings

Years: 2008 - 2012

Nets or traps: 40

Net or trap nights: 8628

Camera type: digital

Cameras paired: no

Sampling comments: "The study took place within riparian and dryland areas... mostly within the approximately 5,000 hectares of its CRs" using "Trailwatcher© 2035 Digital Scouting System" camera traps; "A total of 40 trail cameras were rotated through the major habitats" with "a scent lure placed into the crevice of a stick ±3m in front of the camera. During the last few months of the study (424 camera days), 17 camera units were set up in trees within the CRs, 10-12m above the ground" (presumably meaning 17 of the 40)

Metadata
Sample number: 1978

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-27 20:37:44

Modified: 2016-12-16 08:23:45

Abundance distribution
33 species
3 singletons
total count 6339
extrapolated richness: 38.8
Fisher's α: 4.559
geometric series k: 0.7965
Hurlbert's PIE: 0.8703
Shannon's H: 2.3981
Good's u: 0.9995
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Echinosorex gymnurus42721 g
Tupaia gracilis2180.1 g frugivore
Tupaia minor4958.0 g frugivore
Tupaia tana31208 g frugivore
Cephalopachus bancanus1125 g insectivore
"Tarsius bancanus"
Presbytis rubicunda76.1 kg frugivore-folivore
Nasalis larvatus113 kg
Macaca fascicularis4384.0 kg frugivore-folivore
Macaca nemestrina14507.7 kg
Hylobates muelleri75.8 kg
Pongo pygmaeus17852 kg frugivore-folivore
Manis javanica84.4 kg insectivore
Leopoldamys sabanus5338 g frugivore-insectivore
Rattus exulans1
Sundamys muelleri4274 g herbivore-insectivore
Callosciurus notatus978280 g frugivore-browser
Callosciurus prevostii13
Hystrix brachyura272
Trichys fasciculata161.7 kg
Hystrix crassispinis274
"Thecurus crassispinis"
Helarctos malayanus4932 kg frugivore-insectivore
Martes flavigula32.8 kg carnivore
Arctogalidia trivirgata402.2 kg frugivore-carnivore
Hemigalus derbyanus23 invertivore
Paradoxurus hermaphroditus392.4 kg frugivore-insectivore
Viverra tangalunga2396.0 kg insectivore-frugivore
Urva brachyura4
"Herpestes brachyurus"
Prionailurus bengalensis1133.4 kg carnivore
Prionailurus planiceps161.8 kg
Sus barbatus1126
Tragulus napu6262.6 kg frugivore
Cervus unicolor89100 kg grazer-browser
Muntiacus sp.176