The article and videos below provide an overview of the various functions and filters within Data Editor. Please reach out to a support representative for specific data editing questions and training.
TABLE OF CONTENTS
- Auto Processing
- Basic Navigation
- Point Editing Filters
- Value Editing Filters
- Calibration Filter
- Area/Polygon Filters
Auto Processing
Data imported to PCT Agcloud (automatic or manual) can be, and often is, automatically processed through a set of filters (default or custom), and layers from that dataset are automatically created.
The default filters applied to yield data are Downsampling, Sort, Overlap (5%), Pass Clip (Start: 3, End: 3; Remove Record Off), Min Max (SD by Machine: 3), and Calibration (Machine Cal) if multiple machines are prese
This autoprocessing will not take place if the imported dataset has a coverage amount of less than 75%, is flawed in some way, or if the import process was stopped or crashed.
If the data was not automatically processed or if further editing is needed, use the filters and functions described below to manually process the data.
If you would like to learn how to customize your own filters to be applied automatically on import, click HERE.
Basic Navigation
To navigate to Data Editor, select 'Data Editor' from the Right-Click Menu in View or from the 'Tools' menu.
Select the Dealer, Grower, and Farm; only one of each can be selected at a time.
If needed, select an operation filter, or leave as 'All'.
Set the season filter (Current is the current year, Last is the previous year, and Archived is all years before the previous).
The filter boxes can be used to search for specific datasets.
To open a dataset, click the '+' button on the left.
To turn on a filter, click the button next to the filter name.
-Note: The order that the filters are in does make a difference. You can change the order of the filters with the up and down arrows on the left.
Samples Tab
The 'Samples' tab displays the point data of the selected attribute. It is used to view the effects of the applied filters on the dataset.
-Note: If a dataset has not been processed, the filtered map on the right will not be displayed.
The displayed attribute in both the Original and Filtered maps can be changed using the dropdowns.
The Sample size, or the size of the points in the map, can be adjusted with the dropdown. Changing the Sample size can be helpful for viewing some datasets.
Below the maps, you can choose to view Statistics, Histograms, or Legends by clicking on the respective tabs.
Layers Tab
The 'Layers' tab is where you can view, create, edit, and delete layers that have been surfaced from a processed dataset.
Select a layer to view and edit.
Here, layers can be created, recreated to display edits, and deleted.
-Note: Layers will not be automatically updated when edits are made to the dataset. They must be manually recreated to reflect those edits.
The Surface Parameters affect the method in which the layer is surfaced from the dataset. The 'Fill to Boundary' box, when checked, will interpolate the data out to the field boundary. The Boundary Method dropdown is typically used for surfacing zone soil samples, using either the 'Zones' or 'Zones Averaged' option. When any adjustment is made, the 'Save' button must be clicked, then the layer must be recreated.
For Yield layers, the totals can be adjusted by multiplying, adding, or subtracting. To edit totals for multiple Yield layers at a time, use the Layer Editor tool. Click HERE to learn more about the Layer Editor tool.
For many Layer types, derivative layers can be created from them. These new layers will show up as a selection at the top when created.
Details Tab
The 'Details' tab will show info regarding the dataset.
Export options for either the original (raw) or filtered (clean) dataset are available.
Advanced Tab
The 'Advanced' tab contains many options for editing one or more datasets and details of those datasets.
The date, season, and crop of the selected dataset can be edited.
For further info, see the descriptions of each of the functions within the tool.
Below are links to articles that cover the most used functions within the 'Advanced' tab:
Point Editing Filters
Downsampling (Automatic)
Sort (Automatic)
Data Shift
Moves data points to account for time and distance inside the machine (ex. from the header to the mass flow sensor). A positive or negative value can be entered.
The '+' button adds a 'Data Shift' filter for each machine so that they can be applied individually.
When yield is shifted, it can misalign with the latency of the moisture sensor. This misalignment is often visible around areas of significant change in yield in the field. The 'Recreate Yield From Flow' option can be used in these cases.
Distance Shift
Moves raw data points by a set distance to create new data points (ex. distance from the tractor to the back of a planter). A positive or negative value can be entered.
Overlap
Removes overlapping points to clean up the raw data set.
The filter will remove points in an area that were recorded by additional passes over that area. The 'Reverse' options will remove the points in that area that were recorded first.
Pass Clip
Trims the ends of passes to remove bad data points from the field edge.
The 'Recreate Pass' option is for monitors that record yield as a single pass. When turned on, it will break this pass into multiple individual "strips" that can then be edited.
'Remove Record Off' will delete points where the machine was 'dead heading'.
Sensor Drift
Adjust the data based on sensor drift. Often used in Electromagnetic sensors, cotton yield monitors, and some grains that cause sensor build-up.
Value Editing Filters
Adjust Add
Adjusts values based on addition.
Adjust Multiply
Adjusts values based on a multiplication factor.
Min Max
Removes outliers from raw data to create a better average across the field.
Variety
Allows you to apply a specific variety to the field.
Calibration Filter
Smart Cal
Used for John Deere Active Yield.
Moisture Cal
'Moisture Cal' normalizes moisture data points, useful when moisture sensors drift.
Machine Cal
'Machine Cal' balances multiple machines. With the 'Machine Name' dropdown left blank, the machines will be balanced to the average. When a certain machine is selected, the machines will be balanced to that machine.
Smart Balance
'Smart Balance' is used for Cotton Yield.
By/Then by
'By' and 'Then by' allow recalibration based on any other attribute.
Type
'Type' uses different statistics to recalibrate. 'Median' is typically the best, but you can choose whichever looks the best.
Min/Max/SD min max
For 'Min', 'Max', and 'SD min max', it is best to set a min/max in the 'Min Max' filter as well as the calibration filters, as re-calibration may adjust some values below 0. This can be applied to a specific machine using the 'Machine Name' dropdown.
Area/Polygon Filters
The 'Delete By Area', 'Edit By Area', 'Multiply By Area', and 'Create Yield Trial' filters all operate based on polygons drawn within the dataset. See the video and descriptions below to see how they function.
-Note: Multiple polygons can be added to one filter using the '+' buttons.
Delete By Area
Allows you to delete specific areas with a drawing tool.
Edit By Area
Allows you to change an attribute in a specific area.
Multiply By Area
Allows you to adjust an attribute value for a specific area.
Create Yield Trial
Allows you to designate trial areas in the dataset using polygons. These trial areas can then be surfaced as their own layer type (Yield Trial). The Yield Trial layer can be used to limit filtering, and it can be more accurate trial analysis since it applies less interpolation between points.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article