Opens in Excel, Google Sheets or LibreOffice. When it comes back filled in, drop it into the checker as it is: it becomes GeoJSON for the Information System, every plot is checked against its rules, and the other columns stay with each plot.

ColumnForWhat to enter
PlotID requiredWhereYour code for the plot. Repeat it on every corner row of a polygon.
CornerNoWhere1, 2, 3… for a polygon's corners in order around the edge. Leave empty for a point.
latitude requiredWhereDecimal degrees, at least 6 decimals, south negative. Example: 6.123456.
longitude requiredWhereDecimal degrees, at least 6 decimals, west negative. Example: -5.123456.
ProducerNameInformation SystemThe farmer, cooperative or forest owner who produced it.
ProducerCountry requiredInformation SystemTwo-letter country code where it was produced: CI, BR, VN.
ProductionPlaceInformation SystemName of the farm, plot or forest concession.
AreaInformation SystemHectares. Needed for a plot given as a point; plots over 4 ha (not cattle) need corners instead.
Commodity requiredYour recordscocoa, coffee, soy, palm oil, rubber, wood or cattle.
HSCodeYour recordsThe HS or CN code of the product delivered, for example 1801 or 4412.
ProductionFrom requiredYour recordsFirst day of harvest or production, YYYY-MM-DD.
ProductionToYour recordsLast day, YYYY-MM-DD. Same as ProductionFrom for a single harvest.
SupplierName requiredYour recordsThe company you buy from, if it is not the producer.
SupplierCountryYour recordsTwo-letter country code of the supplier.
SupplierEmailYour recordsThe contact for questions about this plot.
BatchReferenceYour recordsThe lot, batch or invoice number the plot went into.
EvidenceDocumentYour recordsFile name of the permit, title or certificate that backs this plot.
NotesYour recordsAnything else the buyer should know.

How it works

What the Information System requires

Why a spreadsheet works

Most suppliers keep plots in a spreadsheet, a GPS app or Google Earth, not GeoJSON. Asking for a CSV with named columns gets you plots in a shape you can check, without teaching every cooperative a new format. The checker also opens KML, shapefiles and GPS tracks if that is what a supplier already has.

The order of latitude and longitude

The template asks for latitude and longitude in separate, named columns, so the order never has to be guessed. The checker writes them in the order GeoJSON needs, longitude first.

Sources

Last verified against these sources on .