Lot-Plantation Links

Maps which verified plantations contributed to which shipment.

Data license: CC-BY-SA-4.0 · Data source: CleantechHUB · About: Methodology documentation

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link lot_id sensor_id volume_kg check_id verification_level
LOT-20260514-001,AGR-CO-0104 LOT-20260514-001 AGR-CO-0104 20000.0 ed893515-28a1-41e0-99b4-53c82f1d17ba sensor_verified
LOT-20260514-001,AGR-CO-0117 LOT-20260514-001 AGR-CO-0117 20000.0 fde433dd-6ee3-4384-8768-c603237f4b46 sensor_verified

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lot_plantations (
            lot_id          TEXT REFERENCES lots(lot_id),
            sensor_id       TEXT,
            volume_kg       REAL,
            check_id        TEXT,
            verification_level TEXT,
            PRIMARY KEY (lot_id, sensor_id)
        );