SMS Map Skills is a series of step by step instructions for unique mapping tasks to get the most out of the extensive power of AgLeader’s SMS software suite.
Someone gave you some coordinates to find in a field…… So how do you get a bunch of coordinates into a more usable format for mapping and navigation?
Intro: When you have been provided with some coordinates to find in a field, it is usually because they have used some barely capable ‘free’ app that cannot make a transferable file, such as an industry standard shapefile set. Or they do not know how, or do not have the tools for this common practice of making shapefiles to communicate with others who have geographic programs that “speak” in mapfiles. Two of the most common shareable files are Shapefiles (a 3 or 4 file set all of which must be sent and stored together), or KML (KMZ) files which are the Google format.
- Create a spreadsheet and enter or copy / paste the coordinate pairs. Give yourself a header with latitude, longitude and a location number such as sample ID or other identifier. Your column order does not really matter. Be logical. NOTE that the coordinates are expressed in decimal degrees. This is the most common format used in agriculture. The beauty of this format is that the coordinates are NUMERICAL, whereas coordinates expressed as degrees minutes seconds are treated as text and not as easily used for this method.**
2. Next save this created file as a CSV, not an xls or xlsx. CSVs or Comma Separated Values is a widely understood simple text format that many programs, including Google Earth can import. Pay attention to where you are saving the file so you can find it when ready to import into SMS.
3. Next open your SMS project. Select READ FILES and select Text files, and highlight the CSV format.
4. You will be presented with a preview of the file and since it is a CSV, SMS will know it and the correct settings, like knowing there is a header line should be set for you.
5. The next window that opens in a text file import is the one where we indentify which column is latitude and which is longitude. (Many files come in with variations such as x, y or lon, lat as the header so you are confirming it.) Once selected, tap finish.
6. You will now be presented with a preview of the file’s geography. Tap next.
7. Choose the type of SMS operation you want to make with the file. Generic is fine or if these are sample locations that will eventually receive soil test data from a lab, select soil sampling operation.
8. You will be presented with an optional items to import, and if you had a column (as in the example) of a location number you can assign it to an SMS attribute such as Soil Sample ID or description etc.
9. Lastly, add it to your management hierarchy, where it will be stored and available for you to EXPORT as a shapefile in a customary manner to send to your logging device of choice. This layer can also be sent out to AgLeader AgFiniti map view!
10. Display in map form as you would any other layer, print or export as required.
**There are a number of utilities found on the internet for converting coordinate formats https://www.rapidtables.com/convert/number/degrees-minutes-seconds-to-degrees.html
Tip: If you add the Growername, Farmname and Fieldname to the spreadsheet you can assign those columns to the management items for an auto assignment to the hierarchy. This is helpful if you are doing a large number of these and want to employ the batch import.
If you are doing this multiple times, tell your coordinate provider to look into changing their settings to display decimal degrees!