search

NTNU-VM / natronR

0 stars 0 forks source link

No scientificName column #15

Closed anders-kolstad closed 5 years ago

anders-kolstad commented 5 years ago

Natron has no scientificName column (https://dwc.tdwg.org/terms/#dwc:scientificName). Other columns that could be usefull are genus, specificEpithet, taxonRank, and infraspecificEpithet.

anders-kolstad commented 5 years ago

This would need to go in the Occurences table.

vmzomdav commented 5 years ago

NaTron has "scientificName", "taxonRank" and "genus", these column are in the table lib.Taxa. Taxonomical data are connected to occurrences through the "taxonID". see the database structure at https://natron.vm.ntnu.no/DataDocumentation/rdbms/. specificEpithet and infraspecificEpithet are not yet in NaTron and can be added.

anders-kolstad commented 5 years ago

Two new functions (comp_names and get_taxon_ID) has been added to compare scientific names against the natron taxa register and fetch taxonIDs respectively.