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
Harvest
Data ManagementAre You Ready for This Year’s Digital Harvest?
August 15, 2018
As the days in the Northern Hemisphere slowly get shorter, they are getting longer in the Southern Hemisphere and everywhere Read More
Data Science tablet
Data ManagementMicrosoft, Agile Networks Detail Central Ohio Broadband Expansion Project
August 9, 2018
Agile Networks, a leading provider of telecommunications solutions, and Microsoft Corp. has announced a new agreement to bring broadband internet Read More
BigDataSmall2
Data ManagementPrecision Agriculture: A Smaller Approach to Big Data
August 7, 2018
Big data is one of the most buzzed-about concepts in our industry. Rarely do we read a newsletter, attend a Read More
InfoAg Trade show floor
AmericasInfoAg 2018 Deep Dive: Pixels Over Plastic (OPINION)
July 25, 2018
  InfoAg, precision farming’s annual mid-summer blowout, is about a week in the rearview as I type this, a hazy Read More
Trending Articles
1 On 1 With Paul Schrimpf: Simplot’s Allan Fetters
PrecisionAg InstituteOne on One With Simplot’s Allan Fetters
August 8, 2018
Allan Fetters of PrecisionAg Institute partner Simplot Grower Solutions talks about techology trends and key learnings from the recent InfoAg Conference in this exclusive interview with PrecisionAg's Paul Schrimpf. Read More
PrecisionAg InstitutePrecisionAg Institute Whitepaper Library
August 1, 2018
Welcome to the PrecisionAg Institute Whitepaper library! Here you will find free whitepapers and case studies from the PrecisionAg Institute Partners Read More
AmericasIntegrity Ag Group: People Over Precision
July 30, 2018
It’s not every day that this reporter walks into the office of a precision ag dealer, sits across from the Read More
farmer-tractor-tablet
Systems ManagementWhat is Digital Farming — Really?
July 24, 2018
The agricultural community has spent several years synthesizing an operational description for digital farming. In several cases, there have also Read More
Data ManagementInfoAg News: Farmobile Launches DataEngine, Streamlines DataStore Buyer Process
July 17, 2018
Busy times these days out in Leawood, KS, for ag data startup Farmobile, as they continue to – pardon the Read More
ISPA-Yoshua-Bengio
EventsHighlights from the 14th International Conference on Precision Agriculture
July 9, 2018
The 14th International Conference on Precision Agriculture (ICPA) presented by the International Society of Precision Agriculture (ISPA) was held in Montreal, Read More
Latest News
WinField’s Joel Wipperfurth On Empowering Data-Driven Decisions
InfoAg ConferenceOne on One with Joel Wipperfurth, Winfield United
August 15, 2018
Winfield United's Joel Wipperfurth discusses ag technology trends and topics during last month’s InfoAg Conference. Read More
Geosys
Industry NewsUrtheCast to Acquire Geosys from Land O’Lakes in …
August 15, 2018
UrtheCast Corp. and Land O’Lakes, Inc. today announced they have entered a binding term sheet for the purchase of Geosys Read More
Harvest
Data ManagementAre You Ready for This Year’s Digital Harvest?
August 15, 2018
As the days in the Northern Hemisphere slowly get shorter, they are getting longer in the Southern Hemisphere and everywhere Read More
Wheelman-Pro
Industry NewsAgJunction Expands Automatic Steering Market to Smaller…
August 14, 2018
AgJunction, the autosteering company, has introduced Wheelman, a new way for farmers to automatically and accurately steer farm equipment at Read More
Drip-irrigation
Precision IrrigationFertigation as a Precision Agriculture Tool
August 14, 2018
Fertigation is a fertilizer application method in which dissolved fertilizers are delivered to the crop through the irrigation system. This Read More
Events5 Reasons You Should Attend Growing Innovations
August 13, 2018
The specialty crop market is wracked by unprecedented change: labor scarcity, water shortages, pressing demands for increased quality and transparency Read More
Data Science tablet
Data ManagementMicrosoft, Agile Networks Detail Central Ohio Broadband…
August 9, 2018
Agile Networks, a leading provider of telecommunications solutions, and Microsoft Corp. has announced a new agreement to bring broadband internet Read More
AmericasIvy Tech Opens Center of Excellence to Train Tomorrow&#…
August 9, 2018
Students interested in careers in precision agriculture equipment technology or diesel technology now have the opportunity to pursue certificates, technical Read More
1 On 1 With Paul Schrimpf: Simplot’s Allan Fetters
PrecisionAg InstituteOne on One With Simplot’s Allan Fetters
August 8, 2018
Allan Fetters of PrecisionAg Institute partner Simplot Grower Solutions talks about techology trends and key learnings from the recent InfoAg Conference in this exclusive interview with PrecisionAg's Paul Schrimpf. Read More
Corn field sunset
Industry NewsTrimble RTX Correction Technology Now Delivers Two Cent…
August 7, 2018
Trimble has announced that its Trimble RTX GNSS corrections technology can now achieve horizontal accuracies of better than two centimeters. Read More
Sentera-Gimbaled-Quad-Sensor
Sensors/IoTSentera Gimbaled Quad Sensor Optimizes Crop Health Data…
August 7, 2018
Sentera’s Quad sensor is now available in an integrated gimbal-stabilized package for DJI Inspire and Matrice drones. Featuring four fully-customizable Read More
BigDataSmall2
Data ManagementPrecision Agriculture: A Smaller Approach to Big Data
August 7, 2018
Big data is one of the most buzzed-about concepts in our industry. Rarely do we read a newsletter, attend a Read More
Grower-Retailer
Industry NewsAgworld, K-coe Isom Form Strategic Partnership
August 6, 2018
Agworld and K-coe Isom have announced a strategic partnership that will see them integrating business advisory and technology to deliver Read More
Industry NewsAgEagle Acquires Agribotix
August 6, 2018
AgEagle Aerial Systems has signed an agreement to acquire substantially all of the assets of Agribotix, a Boulder, CO-based drone-enabled Read More
Digital-Farming
Systems ManagementImplementing Digital Farming’s Five Major Needs
August 2, 2018
Building a house starts with a plan and then a foundation; it does not start with doors and windows. From Read More
PrecisionAg InstitutePrecisionAg Institute Whitepaper Library
August 1, 2018
Welcome to the PrecisionAg Institute Whitepaper library! Here you will find free whitepapers and case studies from the PrecisionAg Institute Partners Read More
Bruce-Erickson-video
Excellence AwardsPassion for Teaching: Purdue’s Bruce Erickson
August 1, 2018
PrecisionAg Award of Excellence recipient Bruce Erickson is driven to share his knowledge of precision technologies and techniques with students, as well as the larger agriculture community. Read More
Newell-Kitchen
Excellence AwardsChasing the Mystery Behind Soil Variability: Newell Kit…
August 1, 2018
Newell Kitchen of the University of Missouri, recipient of the Legacy award in the 2018 PrecisionAg Award of Excellence program, has worked for decades to employ technology in unlocking the secrets hidden in farm fields. Read More