Load Wetlab Data
Wet laboratory (Agrolab) data contains chemically determined soil properties measured per sample — pH, organic carbon, nitrogen, texture fractions, ions, and more. Each measurement is anchored to a sample through an observation log that records which laboratory protocol and provision were used.
All wetlab loading is driven by:
./ai4sh/import_data/load_ai4sh_wetlab_data.ipynb
Two tables, two source files
Wetlab loading populates two database tables from two Excel files:
| Excel file | Database table | Description |
|---|---|---|
AI4SH_observation_log_agrolab.xlsx |
observation.observation_log |
Links sampling logs to the Agrolab provision, plus lab handling metadata |
AI4SH_observation_agrolab.xlsx |
observation.observation |
One row per sample per measured property |
Source directory: ./ai4sh/import_data/wetlab/agrolab/excel/
Both files are translated in a single process file call, then managed separately.
Required loading sequence
- Translate Agrolab wetlab data — translate both Excel files to JSON in one call
- Manage Agrolab observation log — insert observation log records linking sampling logs to the Agrolab provision
- Manage Agrolab observation — insert individual soil property measurements
Prerequisites
Load sample data must be complete. Observation utility records (provision, provision_indicator, preparation, preservation, storage, transportation) must exist from Load utility data.