Using Vector Soil Data in a Raster World?

Why spend the time and resources to extract the NRCS ‘Soil SURvey GeOgraphic’ (SSURGO) soil polygons only to display the vector lines as a reference? There is a massive amount of soil information within the SSURGO database, however most precision farming web portals provide the NRCS soil survey vector lines as a reference layer. The USDA Soil Data Mart database (a.k.a. SSURGO) has multiple one-to-many database relationships. This complexity causes a great deal of misunderstanding and frustration for those who attempt to mine data.

For example, the map unit symbol is a label for the soil map and refers to the map unit, commonly referred to in precision web portals as a ‘soil type’. That map unit has multiple soil components referred to as a one-map-unit-to-many components relationship. Most programming staff choose not to extract component soil properties and interpretations even though specific properties and interpretations can add value to the web portals. The image here depicts the multiple soil types (compname) within this particular set of map units (musym).

Table-with-Soil-Types

 

Precision farming relies on various data layers such as satellite imagery, drone imagery, harvest yields, EC mapping, soil sampling, topography, and soil survey data. These are raster and point data layers that can be analyzed to provide a prescription that best addresses the farmer’s bottom line. Two issues of concern for web portal users is the use of vector soil survey polygons as a reference layer (that could be best utilized as a raster data layer) and the lack of appropriate soil information needed to aid the prescription.

A little known soil survey publication product is the gSSURGO database. The gSSURGO is the Gridded Soil SURvey GeOgraphic database, a raster spatial product. The raster layer is delivered as a 10m and 30m gridded product. As a raster product, this allows the GIS user to combine it with the other raster products for additional analysis.

Vector-and-Raster-image

The attribute gSSURGO database is the same information delivered with the SSURGO data. There is an additional table (Value) in gSSURGO that is not provided in the standard SSURGO database. The gSSURGO raster product is a useful tool for those serious in understanding how the soil morphology relates to crop productivity. Combining the raster soil survey data layer with other raster data layers (e.g., yield data, EC mapping, topography, etc.) allows the intersection and analysis of the wide variety of thematic factors to identify features that influence productivity.

The soils database, when properly mined, can provide data layers of the various soil properties for the soil types contained in the soil survey map units. Teasing out the soil types and their specific soil properties provides useful information to those serious in understanding the productivity. Mining the database requires an understanding of the various aggregation methods used to migrate the one-to-many database relationships to a one-to-one map making relationship.

There is a table in the SSURGO and gSSURGO database products named the MUAGGATT (map unit aggregated attribute). This table contains columns of properties and interpretations that are aggregated to the map unit symbol making it easy for users to create property or interpretive maps at the map unit level. Methods of aggregation include: dominant component, dominant condition, weighted average, most limiting, and least limiting. Additionally, the database can be queried to extract useful information to assist in developing prescriptions. For example, this table below contains the available water storage (AWS) for each soil type found in the map unit. The query presents the AWS by the upper 100 cm (40 inches) and for the entire soil profile (as identified in the database).

Table-with-AWS

Other information presented is the Hydrologic Soil Group (used by engineers), the parent material (pm), the landform the soil exists on, along with the soil depth to a restricted layer and the type of restriction. Each of these data are presented for each soil type (compname) within the map unit (musym).

A common question asked is “What is the ONE soil property that most affects productivity?” If one property is selected, it would be available water storage, hence the reason it is queried and presented in this image. This image presents the diversity of AWS across the range of soil types in both the AWS100 cm (40 inches) and in the AWS_profile.

Additionally, this image presents the numerous soils identified within each map unit. Mining the data in this way allows the programmer to develop a variety of map layers to identify the many soil types within the field. Analysis can determine how the morphology of each type influences the field productivity. There are a great deal of soil properties and interpretations that can be queried from the SSURGO database to assist analysis.

Future articles will be written to provide examples of raster-based analysis. For more information on value-added analysis from the SSURGO or gSSURGO database for precision farming web portals, contact Paul R. Finnell at [email protected] or visit prairiehillssoilsconsulting.com or LinkedIn.

Leave a Reply

Data Management Stories
AmericasPrecision Farming Companies to Watch in 2018 (OPINION)
January 17, 2018
My friends, as many of you told me repeatedly throughout the last 12 months, 2017 was an interesting year in Read More
farmer-tractor-ipad
Data ManagementThe Era of Digital Agriculture: Opportunities and Challenges
January 17, 2018
The digital revolution is changing the way agriculture is done. Rapid population growth, changes in market demands, depleting agricultural land, Read More
Data ManagementBlockchain: Making Data Cleaner, More Secure
January 16, 2018
Probably most professionals who deal with business data have at least heard the term “blockchain” bantered about as potentially the Read More
Soybean-field-clouds-Photo-courtesy-of-Earl-R-Shumaker
Data ManagementBetting on Rain? The Accuracy and Reliability of Precipitation Forecasts
January 16, 2018
For you sports junkies out there, if I could prove to you that I can correctly predict winners and losers Read More
Trending Articles
John-Deere-Cab-GPS
Data ManagementPrecision Ag Hardware and Software: A Little Off-Season Maintenance Goes A Long Way
January 11, 2018
All service technicians have heard this line. Most often when spring makes its anticipated return to our lives. It is Read More
Anez-Consulting-Paul-Anez-and-Michael-Dunn
Service ProvidersAnez Consulting: Focus On Fertility
January 9, 2018
Central Minnesota features variability aplenty when it comes to soil characteristics and topography, from flat, black expanses rich in organic Read More
Agrishow2017
Americas5 Best Ag Tech Shows in Brazil
January 8, 2018
Brazil continues to demonstrate its potential in agriculture. Several international companies are investing in our country because we have a Read More
Farmer and computer
Service ProvidersPrecision Agriculture Writers Wanted To Join Our Team in 2018
December 10, 2017
About The Opportunity: PrecisionAg.com is looking for people to join our team in 2018 and submit original content to our Read More
Harvested-Corn-Field-Clouds
Data ManagementWeather Services Advance Precision Agriculture
December 4, 2017
Some estimates suggest over half of growers’ activities are impacted by weather conditions, from field workability to fertility management to harvest Read More
Wheat-an-oats-Daniel-X-ONeil
Data ManagementWill Open-Source Finally Unlock Ag Technology’s Potential?
November 28, 2017
To Aaron Ault’s eyes, ag technology right now is something like a walled garden — not unlike the Microsoft of Read More
Latest News
Lee_Brittany
Specialty CropsFlorida Blue Farms Digging Data for Savings and Profit
January 17, 2018
Brittany Lee is no stranger to land management, writes Frank Giles on GrowingProduce.com. She grew up around it, observing her parents Read More
AmericasPrecision Farming Companies to Watch in 2018 (OPINION)
January 17, 2018
My friends, as many of you told me repeatedly throughout the last 12 months, 2017 was an interesting year in Read More
farmer-tractor-ipad
Data ManagementThe Era of Digital Agriculture: Opportunities and Chall…
January 17, 2018
The digital revolution is changing the way agriculture is done. Rapid population growth, changes in market demands, depleting agricultural land, Read More
Data ManagementBlockchain: Making Data Cleaner, More Secure
January 16, 2018
Probably most professionals who deal with business data have at least heard the term “blockchain” bantered about as potentially the Read More
Soybean-field-clouds-Photo-courtesy-of-Earl-R-Shumaker
Data ManagementBetting on Rain? The Accuracy and Reliability of Precip…
January 16, 2018
For you sports junkies out there, if I could prove to you that I can correctly predict winners and losers Read More
center-pivot-irrigation-drop-sprinklers-on-corn
Precision IrrigationFinding Your Precision Ag Mindset
January 15, 2018
A precision mindset is the most important requirement for successful precision ag technology adoption. One of my first VRI (variable Read More
Drone-and-operator-Photo-courtesy-of-Kray-Technologies
DronesCrop Protection Application by Drone: A Q&A with Kr…
January 15, 2018
January is a busy month for agricultural companies. It’s a month that strong sales can set the mood for the Read More
Data ManagementAgGateway Grain Traceability Proof-of-Concept Seeks Ind…
January 15, 2018
AgGateway’s Precision Agriculture and Grain & Feed councils have issued a call for participation for a proof-of-concept initiative in AgGateway’s Read More
John-Deere-Cab-GPS
Data ManagementPrecision Ag Hardware and Software: A Little Off-Season…
January 11, 2018
All service technicians have heard this line. Most often when spring makes its anticipated return to our lives. It is Read More
Corn-Planter
Grower Services & SolutionsCorn Planter: The Train of Consequences
January 11, 2018
It’s always planter season in our shop but now that harvest is done the corn planter is the next piece Read More
Robotics/Labor SaversSmart Ag Announces Driverless Tractor Automation Platfo…
January 11, 2018
An Iowa technology company has unlocked the tremendous potential for automation in agriculture by developing the first cloud-based platform for Read More
Anez-Consulting-Paul-Anez-and-Michael-Dunn
Service ProvidersAnez Consulting: Focus On Fertility
January 9, 2018
Central Minnesota features variability aplenty when it comes to soil characteristics and topography, from flat, black expanses rich in organic Read More
Agrible
Grower Services & SolutionsAgrible to Launch Retailer Services in 2018
January 9, 2018
It’s a new year, which means new market challenges. Full service retailers are searching for ways to differentiate themselves and Read More
jeremy-speaking
Grower Services & SolutionsGrower and Precision Ag Services: Opportunities Lost
January 9, 2018
I often spend time with growers, talking about their operations, and the processes they go through each season to do Read More
Winters-Farming-farm-manager-Alex-Bergwerff-and-Ranch-Systems-marketing-and-business-development-manager-Hylon-Kaufmann
Precision IrrigationInside California Irrigation: Winters Farming
January 9, 2018
As many of us already know, almonds tend to get a bad rap for their water-use efficiency — or some Read More
Sentera software
DronesSentera Offering Elevation Data Mapping Via AgVault
January 9, 2018
Sentera announces the availability of elevation maps within the Sentera AgVault platform, offering agronomists, crop consultants, and growers additional field Read More
Industry NewsRaven, South Dakota State University Link Up: What You …
January 9, 2018
On Tuesday afternoon Raven and South Dakota State University (SDSU) held a press conference on the SDSU campus in Sioux Read More
Agrishow2017
Americas5 Best Ag Tech Shows in Brazil
January 8, 2018
Brazil continues to demonstrate its potential in agriculture. Several international companies are investing in our country because we have a Read More