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, the lab's PDF report (or a photo of it) and mapped soil-zone boundaries into Phase.

Soil Centre has four views: Overview for sampling coverage and measured history, Map, Plan for preparing a sampling job (paddocks, sites, depths, instructions and an assignee; collected work stays separate from imported lab results), and Data for the original records with import, editing, deletion and export. Tap a sampling point or zone on a paddock's site map to open that site's results, with chart measurement and depth selectors and a Raw data view of the complete original result.

Where to find it

  • Import: More → Data Centres → Soil Centre → Actions → Import (the page is headed Soil test import)

  • Field view: Map → tap paddock → Soil

The top of Soil Centre

Soil Centre's tabs are Overview, Map, Plan and Data. Under them is the heading with what you're looking at, for example "All farms · All years · All depths", then Filters (with how many are on), Plan sampling and one Actions menu with Import, Export and Quick walkthrough. On Map and Plan, Plan sampling is the button on the map or plan itself rather than in the heading. The paddock trend chart uses colours people with colour blindness can tell apart; a fifth and sixth paddock reuse the first two colours as dashed lines.

Mark events on a paddock's soil chart

To see what happened when a paddock's pH moved, pin a short note to a month on its soil chart, such as "Lime sand spread" in March 2019. Open the paddock on the Map, go to its Soil tab and tap Add marker above the chart. Pick the Month and Year, write what happened, and tap Save. The note shows as a yellow line at that month; point at it, or tap it on a phone, to read it, and tap it then Edit to change or delete it.

Markers are added, changed and removed only on the paddock's Soil tab, by people who can edit the farm. The same lines show, view only, on Soil Centre's overview trends, a paddock's soil detail in Soil Centre and the soil charts in Crop Plan Studio. A marker is only a note: it isn't a job or application record and doesn't change stock or spray records. Deleting a paddock deletes its markers, and Export everything includes them. Phase Agent's paddock soil summary lists the markers in the chart's range, but the Agent can't add, change or delete them.

Soil in Crop Plan Studio's Compare

Plan → Compare → Soil reads every paddock at one depth. A paddock never tested at the chosen depth now shows its most recent test at another depth in the same layer, with the depth printed under the date and under each value, so a 20–30 cm pH is never taken for a 10–20 cm one. Hovering a value spells it out, for example "taken at 20–30 cm: no 10–20 cm test on record", and the note under the table says so. Topsoil never fills in for subsoil or the other way round, and Chart still plots only the chosen depth.

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. Spatial's Layers step says how many soil results on the paddock "can’t be mapped yet" for this reason.

Switch the soil layer on in Spatial's Layers step to see it over the paddock. If you ask Spatial's agent to "make a zone map" with no layers switched on, it uses the newest yield map, or the newest soil test if there is no yield map, and says which it used.

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.

Read the lab's PDF or a photo of it

Soil Centre → Actions → Import → Read a lab report (PDF or photo) takes the report your lab or agronomist sent (Nutrien, CSBP, Elders, Nutrient Advantage, APAL and most Australian labs), or a photo of the results page. Phase AI reads every page into one sample per depth column: paddock, site, depth, date, coordinates where printed, pH (CaCl₂ and water), EC, organic carbon, nitrate and ammonium N, Colwell P and K, PBI, sulfur, CEC and aluminium, with anything else the lab printed kept in the sample's notes.

The review screen shows every value it read in a table, any warnings from the read (a blurred number, a cut-off paddock name), and the same paddock matching, duplicate checks and Import button the spreadsheet import uses; nothing is saved until you have looked at it. Coordinates on the report match sites to paddock boundaries; a report without coordinates imports by paddock name, and those sites need a location before they can build a zone map. The report is filed under Documents as a soil test. While a farm is on trial, Phase reads ten soil reports; a subscription has no limit.

Import a spreadsheet

  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

Soil: linking zone-sampled results to the zone map they came from.
  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?