search

SANBIBiodiversityforLife / speciesstatus

0 stars 0 forks source link

Seakeys threat import #122

Closed rukayaj closed 6 years ago

rukayaj commented 6 years ago

For the NBA, Dewidine needs to have threat codes in the database for marine species. Unfortunately this data wasn't done when the seakeys pages were written or when the marine assessments were done. So Prideel has assigned an intern to look over all of the threat narratives and add coding. The easiest way for her to do it was to use a spreadsheet - they didn't want to use a web interface. Now I have to write a script to take their threat codings and import it into the database. Attached is an example spreadsheet with some data filled in. Seakeys_ThreatData_Capture - prideel.xlsx

rukayaj commented 6 years ago

Dewidine is going to use the spreadsheet for the NBA rather than the database, so it's not that critical that this goes in here.

Dewidine commented 6 years ago

@rukayaj If it can go in it should, I'm working through their feedback now, there are some taxa missing from the website, that we have assessments for, so that's not making sense.

There are taxa in the list exported from the database that was not part of the assessments captured: Clinus musaicus Holleman, von der Heyden & Zsilavecz, Parupeneus fraserorum Randall & King, 2009

rukayaj commented 6 years ago

I have done this, D's comment above is not relevant any more (I was importing everything from seakeys so there were species without assessments in there).