Frequently Asked Question
What format should I request my Yield data in?
Last Updated 8 years ago
Q. What format should I request my Yield data in?
A. If a consultant or bureau is supplying your yield data, then having it in a format the FarmStar understands will make life a whole lot easier.
The simplest and most widely supported format is a CSV file - "Comma Separated Values with Headers". This is a basic text file with each item separated by a comma. The first line of the file contains a title describing the contents of each column of data. Also, CSV files are easy to work with using Microsoft Excel. Excel can load and save CSV files.
These files are imported from the Data Manager by selecting the "Comma/Tab Delimited (with Headers)" menu from the "Import Data File" button.
FarmStar will recognise a CSV file as a Yield file if one of the titles contains the word "Yield". Beware that you can only have one column with "Yield" in part of the title. If there is more than one, it uses the last one found. i.e. If you have two titles such as "...,Lint Yield,Cotton Yield,...", then FarmStar will use the "Cotton Yield" column as the Yield column, and the other column will be ignored.
Suggested titles that FarmStar recognises are:
* Latitude
* Longitude
* Easting
* Northing
* Height
* Time
* Mass
* Area
* Yield
* Moisture
* Paddock
* Harvest Rate
* Flow Calibration
* Load
The Yield and Harvest Rate fields are expected to be in T/Ha.
Latitude/Longitude and Eastings/Northings are mutually exclusive. Only one pair of values should exist in the file. If Latitude & Longitude are found, they are expected to be in WGS84. If Eastings & Northings, then the MGA94 coordinate system.
Example file:
East,North,Height,Mass,Area,Yield,Moisture,Paddock,Flow Calibration,Load Number
419786.4,6829856.02,192,0.00335,0.0008,4.1875,15.35087719,J12,17500,1
419788.37,6829856.77,191,0.00517,0.0012,4.30833,16.44398767,J12,17500,1
419789.58,6829855.77,191,0.00827,0.0017,4.8647,18.05555556,J12,17500,1
419791.19,6829855.32,191,0.01789,0.0019,9.41578,19.03037058,J12,17500,1
419795.09,6829854.83,190,0.02058,0.0022,9.35454,19.39082699,J12,17500,1
419800.25,6829853.73,190,0.02322,0.0023,10.09565,19.56330782,J12,17500,1
419805.36,6829852.87,189,0.01631,0.0022,7.41363,19.63541667,J12,17500,1
419810.12,6829851.92,190,0.02275,0.002,11.375,19.70526316,J12,17500,1
419814.9,6829850.97,190,0.01982,0.0023,8.61739,19.75175002,J12,17500,1
419822.09,6829849.59,189,0.01567,0.0022,7.12272,19.77437759,J12,17500,1
419826.5,6829848.75,189,0.01637,0.0022,7.4409,19.79954282,J12,17500,1
419831.4,6829847.63,189,0.01277,0.0021,6.08095,19.81132075,J12,17500,1
419838.77,6829846.07,190,0.0179,0.0021,8.5238,19.82810016,J12,17500,1
419843.17,6829845.25,191,0.01227,0.0022,5.57727,19.83610396,J12,17500,1
A. If a consultant or bureau is supplying your yield data, then having it in a format the FarmStar understands will make life a whole lot easier.
The simplest and most widely supported format is a CSV file - "Comma Separated Values with Headers". This is a basic text file with each item separated by a comma. The first line of the file contains a title describing the contents of each column of data. Also, CSV files are easy to work with using Microsoft Excel. Excel can load and save CSV files.
These files are imported from the Data Manager by selecting the "Comma/Tab Delimited (with Headers)" menu from the "Import Data File" button.
FarmStar will recognise a CSV file as a Yield file if one of the titles contains the word "Yield". Beware that you can only have one column with "Yield" in part of the title. If there is more than one, it uses the last one found. i.e. If you have two titles such as "...,Lint Yield,Cotton Yield,...", then FarmStar will use the "Cotton Yield" column as the Yield column, and the other column will be ignored.
Suggested titles that FarmStar recognises are:
* Latitude
* Longitude
* Easting
* Northing
* Height
* Time
* Mass
* Area
* Yield
* Moisture
* Paddock
* Harvest Rate
* Flow Calibration
* Load
The Yield and Harvest Rate fields are expected to be in T/Ha.
Latitude/Longitude and Eastings/Northings are mutually exclusive. Only one pair of values should exist in the file. If Latitude & Longitude are found, they are expected to be in WGS84. If Eastings & Northings, then the MGA94 coordinate system.
Example file:
East,North,Height,Mass,Area,Yield,Moisture,Paddock,Flow Calibration,Load Number
419786.4,6829856.02,192,0.00335,0.0008,4.1875,15.35087719,J12,17500,1
419788.37,6829856.77,191,0.00517,0.0012,4.30833,16.44398767,J12,17500,1
419789.58,6829855.77,191,0.00827,0.0017,4.8647,18.05555556,J12,17500,1
419791.19,6829855.32,191,0.01789,0.0019,9.41578,19.03037058,J12,17500,1
419795.09,6829854.83,190,0.02058,0.0022,9.35454,19.39082699,J12,17500,1
419800.25,6829853.73,190,0.02322,0.0023,10.09565,19.56330782,J12,17500,1
419805.36,6829852.87,189,0.01631,0.0022,7.41363,19.63541667,J12,17500,1
419810.12,6829851.92,190,0.02275,0.002,11.375,19.70526316,J12,17500,1
419814.9,6829850.97,190,0.01982,0.0023,8.61739,19.75175002,J12,17500,1
419822.09,6829849.59,189,0.01567,0.0022,7.12272,19.77437759,J12,17500,1
419826.5,6829848.75,189,0.01637,0.0022,7.4409,19.79954282,J12,17500,1
419831.4,6829847.63,189,0.01277,0.0021,6.08095,19.81132075,J12,17500,1
419838.77,6829846.07,190,0.0179,0.0021,8.5238,19.82810016,J12,17500,1
419843.17,6829845.25,191,0.01227,0.0022,5.57727,19.83610396,J12,17500,1