Skip to main content

Soil Test Import And Soil Data

Import lab results, update corrected samples, link sampled zone boundaries and use supported soil data in Phase Spatial.

P
Written by Phase Support

What this is

Soil Test Import brings lab-result spreadsheets and mapped soil-zone boundaries into Phase.

Where to find it

  • Import: MoreData CentresSoil CentreImport soil tests

  • Field view: Map → tap paddock → Soil

Use soil data in Spatial

Phase Ultra Spatial can use supported geolocated pH, Colwell P, Colwell K, organic carbon, sulphur, salinity EC, CEC and aluminium results by sampling year. A layer needs at least three numeric values for the selected metric linked to soil sites with latitude and longitude. Depth controls appear where the source data supports them.

A record matched only by paddock name can appear in Soil Centre but cannot create a Spatial surface without site coordinates.

When a paddock was sampled by management zone instead of individual GPS points, import the zone boundaries and link each boundary to its matching soil result. Those areas can then be used to build a Spatial zone map or prescription.

How it works

  1. Choose Lab results and upload an XLSX, XLS or CSV export.

  2. Map the columns if the file uses different names.

  3. Review the data.

  4. Import the records.

  5. View soil data on the paddock sheet.

Phase supports exports from CSBP, Nutrient Advantage and most Australian soil labs. It uses GPS, paddock boundaries and names to suggest matches. The preview separates new rows, duplicates, unmatched rows and existing samples that can be updated.

If a corrected lab file contains the same lab number and sample identity but new result values, Phase can update that sample instead of creating a duplicate. Always check the preview before confirming.

Link results to zone boundaries

  1. Import the lab results first.

  2. Return to Soil test import and choose Zone boundaries.

  3. Upload a zipped Shapefile, Shapefile components, GeoJSON or KML zone map.

  4. Choose the attribute column that names each zone.

  5. Choose the paddock.

  6. Match every zone to the soil result sampled from that area, or choose Don't import this zone.

  7. Check the map and table, then import.

If a result already has a zone boundary, the review warns that the new boundary will replace it. Soil results left unmatched are not changed.

Tips

  • Check pH, depth, date and location columns before importing.

  • If sample points include latitude and longitude, Phase can use them to place soil sites.

  • Soil sites should associate with paddocks based on their location and boundary.

Depth labels

If the file has separate Depth from and Depth to columns, Phase should be able to create the depth label automatically, such as 0-10 cm.

If the file has one depth label column, map that column to the depth label/range field during import.

If samples do not appear on the paddock

Check:

  • The sample has a location or is matched to the right paddock

  • Latitude and longitude columns are mapped correctly

  • The paddock boundary is correct

  • The selected depth range is visible in the soil view

  • The sample date and data type filters are not hiding the record

If the lab name or some measurements appear missing, open the full sample detail and check the original import mapping. Phase keeps a broader set of lab measurements than the summary cards can show at once.

Did this answer your question?