search

trias-project / daisie-checklist

🇪🇺 DAISIE - Inventory of alien species in Europe
https://trias-project.github.io/daisie-checklist/
MIT License
0 stars 2 forks source link

References without species id #21

Closed LienReyserhove closed 4 years ago

LienReyserhove commented 5 years ago

In input_references, about 8000 references have no link with an idspecies or id_sp_region. I find that a bit odd. These references will never be used in the other extensions, as each row contains a idspecies field (which I use to join two tables together). I prefer to throw these references out. In this way, the literature references will include sources that always link to a certain taxon. @DavidRoy?

LienReyserhove commented 5 years ago

I see that this is a result of the way the data was extracted from the database. The references linked to idspecies and id_sp_region are the specific references for the distribution extension, while all other references (those without a idspecies and id_sp_region) apply to all other information (taxon, native ranges, etc.). These are linked to their specific taxonID using sourceid.