search

trias-project / alien-species-checklist

🐞 Proof of concept for a checklist of alien species in Belgium
MIT License
3 stars 2 forks source link

Populate scientificName #42

Closed peterdesmet closed 8 years ago

peterdesmet commented 8 years ago

Create a scientificName for all records in concatenated where there currently isn't one. Since none of those have a subspecies, this can be done quite easily:

  1. Filter on blank scientificName
  2. Edit cells > Transform
  3. value: cells["genus"].value + " " + cells["specificEpithet"].value

Make sure to escape quotes before importing the file, so we don't get this in taxonID:

plants "Populus x jackii Sargent ""Gileadensis"" (P. balsamifera x deltoides)" Salicaceae Nat.? Hort. D NAM X 2010 N?

peterdesmet commented 8 years ago

I have completed this task. The steps are saved in https://github.com/LifeWatchINBO/alien-species-checklist/blob/master/data/concatenated.json