Species vernacular name in saiku

Question

Hi,

I would like to use the vernacular name for reporting in Saiku. I notice that only the scientific name is available for reporting from the species tables.

I made a new field in OF Collect to automatically populate and store the vernacular name. However, when I export the data to OF Calc and then publish to Saiku the vernacular name that I stored is not visible. I confirmed that the vernacular name is in the results tables in R but is not available in Saiku.

Am I missing an additional step that I need to make the vernacular name visible?

Thank you for your help.

Best regards,

Jonathan

Answer 1 · 2021-09-28T15:55:46

Dear Jonathan,

Unfortunately vernacular names do not show up in Saiku. If you need to report them, you need to join these with the result tables outside of Saiku.

Best regards, Lauri

Answer 2 · 2021-09-28T16:55:15

Hi Lauri,

Thanks for your reply.

I understand that the vernacular names are not populated from the species list into Saiku. I hoped that because I had added an additional field containing the vernacular name in my surveys I would be able to access this from within Saiku. Other fields that are populated at the tree-level (for example tree health data or crown form) are available as Dimensions in Saiku. I notice that they are categorical variables whereas my new vernacular name field is a stored as a character in R. Is this the reason that the field is not available as a Dimension and could there be a workaround to write this field to Saiku as a categorical variable?

Many thanks

Jonathan

Answer 3 · 2021-09-28T17:02:15

1

Accepted answer

Hi Johathan.

Yes, if you change it to categorical variable it will be available in Saiku!

regards, Lauri

Answer 4 · 2021-09-28T17:39:25

Hi Lauri,

Can you suggest a workflow for this? Does the new vernacular name field need to be a categorical variable prior to export from Collect? I hoped that changing the datatype in R might have some effect but it doesn't. The vernacular name field in OF Collect is currently automatically populated based on the users selection of species and I wouldn't want users to have to select from another list.

Thanks

Jonathan

Answer 5 · 2021-09-28T18:29:22

Hi Jonathan,

Your species list is probably so long that it can not be added into Calc as a new category (manually). So the only option is to have this field in Collect. In order to avoid conflicts between current data types, I recommend to create a new categorical variable in Collect, just for reporting, and keep the existing text field as it is now. This categorical variable can be function, and it gets the input value (code) from the species code (i.e. tree_species/@code where 'tree_species' is a attribute name ). When you publish the survey in Collect, this new field should get the value automatically. Check that your function works in Collect.

Export data from Collect and read it into Calc. Rerun the scripts in Calc UI (in order to publish the results to Saiku). You do not need to play with RStudio in this case.

regards, Lauri

Answer 6 · 2021-09-28T20:20:36

1

Accepted answer

Hi Lauri,

This worked perfectly!

Thank you very much for your clear explanation.

Best Regards,

Jonathan

Species vernacular name in saiku

6 Answers

Your answer

Insert a link

Insert an image

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions

Keyboard shortcuts

Anywhere

Lists of questions

Question pages