CNN API - include `image`, `common name` into the response

[grindarius]

So I have discovered some ways that we can make this happen and check some statsistics on the database. it looks like

• Core and Arbimon does not share any of the species/classifications data together, there's no way to reference them other than lower(species_name) between the 2 databases.
• Core only have 31 images existing currently out of around 11k species (typeid = 8).
• But core does have good information related to the alternative names (common name) inside classification_alternative_names.

I think that arbimon is the best source of these information. My thoughts on this is to make GET /classifier-jobs/{jobId}/species also return the scientific name back, then we can lookup those scientific names inside arbimon database one page at a time using lower(scientific_name).

On how to find the scientific name on core side, we can recursively query back the parent_id until you met with type_id = 8 then get the first name from classification_alternative_names table. Which to be honest this looks slow and will lead to hand written sql. However, I will look into this further tomorrow.

[grindarius]

The other way we could make this work is to create a cron job and fill core with species information data, probably from GBIF

[naluinui]

Oh I didn't realize this get into the sprint. Thanks for doing some research. We can work on the solution next sprint.

[koonchaya]

@grindarius What do we have left to close this task?