emo-bon / observatory-profile

Repository for the templates and additional metadata, that are used to semantically uplift emo-bon logsheet data into triples
0 stars 1 forks source link

Adding ROR identifiers to the Observatory metadata sheets #30

Closed cymon closed 1 month ago

cymon commented 1 month ago

It would be good to identify the Organizations in our ro-crates by their ROR ID as in this example here.

Can we add the ROR ID to the Observatory sheets metadata in the Google logsheets?

The problem being, although ROR has an API, it works only when you know the ROR ID, and finding that via other information is not exact.

cpavloud commented 1 month ago

We have used the EDMO record Ids in the Observatory metadata. EDMO = European Directory of Marine Organisations Can this be used instead of the Research Organization Registry (ROR) id or we need to have both?

cymon commented 1 month ago

We have used the EDMO record Ids in the Observatory metadata. EDMO = European Directory of Marine Organisations Can this be used instead of the Research Organization Registry (ROR) id or we need to have both?

OK, they look good; in my opinion they would substitute for the ROR IDs - but maybe we should include both, I'm not sure but we need at least one. Where can I find the EDMO for the stations? Are they in any of the emo bon sheets?

cpavloud commented 1 month ago

In each of the logsheets, in the observatory sheet, there is a column named "organization_edmoid". This is the one you want. E.g. https://docs.google.com/spreadsheets/d/1F4AWv_seI-DQJ_Gp_N2ziwvGyjnc4KC92GGNXrJRek4/edit?gid=2052143695#gid=2052143695

cymon commented 1 month ago

Thanks! Going to use only that ID for the time being