Create CSV to import data for issue #19

National-Forestry-Authority / brms

1 stars 1 forks source link

Create CSV to import data for issue #19 #65

Open ygoex opened 1 year ago

ygoex commented 1 year ago

[x] Cambrico needs to create a spreadsheet (Google sheet that's easy to share) with multiple tabs that shows the headers of the required data.
[ ] NFA needs to fill data and share it with Cambrico.
[ ] Cambrico needs to import the CFRs from the forest system.
[ ] Cambrico needs to add a CFRs tab on the spreadsheet that has the entity id so NFA can use it.

From Google sheet we can export a CSV with one tab.

We need to create a tab for the CFRs and a tab for the surveys, so the CFRs have a machine name (code) attached to them that is used by surveys. We need to create a field for this code: external ID that has to be unique.

The CFRs can be imported from the forests system.

peacog commented 1 year ago

Hi @LeScruf @pcambra I've created a Google sheet that you should have access to: here Andrew can you take a look and let me know if it's clear what your team need to do to fill in the data on the different sheets? Let me know who needs access to the sheet.

I've been wondering about how to handle Districts and Counties. I have created two separate taxonomy vocabularies but it might make more sense to use just one vocabulary with a hierarchy of Districts > Counties like

I assume it's possible for a reserve to span multiple counties. Could it also span multiple districts?

ygoex commented 1 year ago

Hi @LeScruf, we were wondering if you are working on the spreadsheet shared by @peacog on the comment above or on a copy of this one.

LeScruf commented 1 year ago

The original is the one that will be used.

On Wed, Apr 5, 2023, 11:15 AM Yolanda Goex @.***> wrote:

Hi @LeScruf https://github.com/LeScruf, we were wondering if you are working on the spreadsheet shared by @peacog https://github.com/peacog on the comment above or on a copy of this one.

— Reply to this email directly, view it on GitHub https://github.com/National-Forestry-Authority/brms/issues/65#issuecomment-1497097851, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ3CXMDDTNIR3CSRKJIN43W7US2DANCNFSM6AAAAAAVU34PZI . You are receiving this because you were mentioned.Message ID: @.***>

LeScruf commented 1 year ago

@peacog We are still reviewing the data on this - but hope to have something towards the end of next week. There are 1441 records to get right!

ygoex commented 1 year ago

We are going to take the UUID from BRMS as the unique reference for all the sites.