Fill the Exp Unit ID table

[saseehav]

PSA is creating a cleaned up version of the former craft v2 enterprise table from Cycles 1-4.

Data columns include:

Exp unit id

• [x] cycle 1-4 from v2 main geojson
• [ ] cycle 5, from sheet

Contract

• [x] cycle 1-4 from v2 main geojson
• [x] cycle 5, from sheet

Scion

• [ ] cycle 1-4 blank until we fill manually
• [ ] cycle 5, from sheet

Rootstock

• [ ] cycle 1-4 blank until we fill manually
• [ ] cycle 5, from sheet

Cofactor

• [ ] cycle 1-4 blank until we fill manually
• [ ] cycle 5, from sheet

Site

• [ ] cycle 1-4 blank until we fill manually
• [ ] cycle 5, from sheet

Reset percentage

• [ ] cycle 1-4 blank until we fill manually
• [ ] cycle 5, from sheet

Trial group (11/11, decided that trial group belongs in exp unit table, instead of the contracts table, even though it is on the contract level).

• [ ] found in v2 main table for cycles 1-4. Currently in number format. We will convert trial group from numerical to english
• [ ] cycle 5, from sheet

Geometry

• [x] cycle 1-4 from v2 main geojson
• [ ] cycle 5, from Pre-audit pending.....

[saseehav]

@brianwdavis would like to write his own utility to do the import of the spatial data from the new geojson so we can import all 3 of those columns together at the same time.

[saseehav]

Sheet for cycle 5 contracts https://docs.google.com/spreadsheets/d/1D8ZYGThzbROuH84VldVCJMo8oasxFzCZ/edit?gid=2135865350#gid=2135865350