PastureMap lets you upload your own soil data so you can view this information on a map. We accept soil data in CSV format. See below for a sample file you can use to properly format your data. Your CSV file must have a header row with the following fields:
- Date: The date the sample was collected (e.g. 3/24/2018)
- Point.Name: A unique identifier for a soil measurement point (e.g. TOKA-001). This is used to track multiple measurements at the same point to see changes over time. This can be any value you like. We suggest using a prefix unique to your ranch followed by a number.
- Latitude: Latitude coordinate of the soil sampling point (e.g. 37.24593821). If two rows have the same value for Point.Name, the latitude and longitude must match. Latitude and longitude are only required the first time a Point.Name appears.
- Longitude: Longitude coordinate of the soil sampling point (e.g. -122.5028349).
- Bulk.Density: Bulk density in g/cm^3 (e.g. 1.16).
- Carbon.0.10.cm: Soil carbon percentage between 0 and 10 cm depth (e.g. 3.61).
- Carbon.10.40.cm: Soil carbon percentage between 10 and 40 cm depth (e.g. 2.82).
- Infilt2: Water infiltration time in minutes for 2.5 cm of water to be absorbed into the ground (e.g. 17.49).
Each row in the CSV file after the header row represents a single summarized soil sample for a given date and sampling point. If no data is available for soil carbon, bulk density, or water infiltration time for a particular soil sample, the value in the CSV file should be "NA".
Point Blue Conservation Science publishes a very detailed Rangeland Monitoring Network Handbook with more information about how to collect these measurements for your ranch.
Step 1: Download the soil data template
Click here to download the soil data template CSV file to your computer.
Step 2: Open the template
Click on the Soil Data Template.csv file you downloaded to open this CSV file in Microsoft Excel, Google Sheets, or another spreadsheet app of your choice. It should look like this:
Step 3: Enter your data into the template
Replace rows 2-6 of the template with your actual soil data. You can enter as many rows as you want. Each row in the spreadsheet represents a single soil point to display in PastureMap. Make sure row 1 still contains the header text "Date", "Point.Name", etc. The values in each cell of the spreadsheet must match the header labels.
Step 4: Save your data as a CSV file.
Click on File and select Save As...
Make sure the file type is Comma Separated Values (.csv). Click Save.
Step 5: Send us your CSV file
Email us at email@example.com and attach the CSV file you just saved. We will import your soil data into your PastureMap account.
Step 6: View your soil data
After we import your data, each soil point will appear on your map in PastureMap as a shovel icon. Click on the shovel icon to see Soil Carbon and Bulk Density data and trends over time.