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
Farmer-Tablet
Data ManagementAgriculture’s Next Breakthrough: New Technologies Are Driving Efficiency, Data Insights
July 3, 2018
We live in an exciting time in agriculture. Not only is technology advancing rapidly, but the understanding and comprehension of Read More
Data ManagementThe Most Overlooked Asset in the Agtech Revolution
June 25, 2018
There is no doubt that advancements in genetics, precision agriculture, and innovative farming practices have all played an instrumental role Read More
Soil-Corn-plants-field
Data ManagementRemote Soil-Sensed Management Zones Help Increase Crop Input Efficiency
June 18, 2018
Accurate prescription maps are essential for effective variable rate technology (VRT) fertilizer application. Grid soil sampling is frequently used to Read More
Data ManagementChecking the Box: FBN Garners Ag Data Transparent Certification
May 30, 2018
Farmers Business Network (FBN) recently completed Ag Data Transparent (ADT) third-party certification, affirming that the FBN network’s data and analytics Read More
Trending Articles
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
Topcon X30 Console in cab
EventsAssociation Seeks Definitive Definition of “Precision Agriculture” — What’s Your Vote?
July 2, 2018
More than two-dozen definitions of precision agriculture have been identified through the years — but which is the best and Read More
AmericasRaven Name to Grace New South Dakota State University Facility
June 27, 2018
According to a press release issued by the company, Raven Industries was recognized today in the naming of South Dakota Read More
dropcopter
DronesNew York Apple Orchard Claims World First in Pollination by Drone
June 18, 2018
Beak & Skiff Apple Orchard in LaFayette, NY, is the first orchard in the world to use drones to pollinate Read More
JDandPessl
Sensors/IoTJohn Deere, Pessl Instruments Team Up to Create Opportunities
June 18, 2018
John Deere is best known for its line of tractors, combines, sprayers, and implements. However, in an effort to help Read More
Matt-Waits-featured
Decision Support SoftwareSST’s Matt Waits: Innovative Data Solutions Key to Transforming Global Agriculture
May 31, 2018
Proagrica, part of RELX Group, earlier this year acquired U.S.-based precision agriculture solutions company, SST Software, in a move set Read More
Latest News
Industry NewsFarmobile Acquires Prime Meridian, Taps Cubbage as New …
July 13, 2018
Farmobile today announced an agreement to acquire the assets of Prime Meridian, a precision agriculture data management company based in Read More
group-photo
DronesPrecision Agriculture Takes Flight at North Carolina St…
July 13, 2018
Take a walk into the Suggs Laboratory for Precision Agriculture and Machine Systems and it’s hard not to be impressed, Read More
Skeketee-IC-Weeder
DronesAutomated Weeders Have Arrived in Vegetable Fields
July 12, 2018
The vegetable production areas of the Central Coast of California have lifted vegetable cultivation to a high art, writes Richard Read More
AgJunction, InfoAg 2014, Autosteer, GPS
Industry NewsAgJunction Settles with Raven in Patent Infringement Su…
July 12, 2018
AgJunction Inc., a leader in advanced guidance and autosteering, has settled a patent infringement lawsuit it filed against Raven Industries, Read More
Retailer-Grower-tablet
Business ManagementTaking Measure of the Precision Agriculture Program: 6 …
July 12, 2018
In the overall agriculture market, the rhetoric surrounding emerging technology over the past half-decade has been nothing short of breathless. Read More
raven-slingshot-job-generator-job-sync-1
Industry NewsNew Raven Slingshot Advancements Will Help Save Time, R…
July 11, 2018
Raven Industries, Inc. has announced several new services available on the Slingshot and Viper 4 platforms: Job Generator and Job Read More
Onsite-logo
Industry NewsAgIntegrated Acquires Exclusive Licence to Satshot’s Im…
July 11, 2018
AgIntegrated, Inc. (AGI), a leader in precision ag data integration and software development, and Satshot, a leader and pioneer in Read More
Australian Harvest
Australia/New ZealandAustralian Agritech Plants Blockchain for Efficiency
July 11, 2018
“Agritech” at one time would have meant new equipment such as tractors and combine harvesters, but today it refers to Read More
Tomato-crop-India
AsiaIndia: Using Artificial Intelligence for the Good of Fa…
July 11, 2018
After graduating from IIT-Madras, the first thing that Vivek Rajkumar did was to buy four acres near Thiruvananthapuram and start Read More
BrightFarms
Industry NewsForbes List of Innovative Ag-Tech Companies Includes Gr…
July 9, 2018
Forbes magazine recently posted a list of the 25 most innovative ag-tech startups in 2018, which includes a few companies Read More
AmericasNutrien Ag Solutions Brand, New Digital Platform Launch…
July 9, 2018
Nutrien (formerly Crop Production Services) has officially rebranded its retail business to Nutrien Ag Solutions, aligning the company’s retail operations Read More
ISPA-Yoshua-Bengio
EventsHighlights from the 14th International Conference on Pr…
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
TerrAvion
Industry NewsTerrAvion Integrates Aerial Imagery with John Deere Ope…
July 6, 2018
TerrAvion, Inc., a large volume provider of aerial imagery to agriculture, has announced an integration to allow TerrAvion’s aerial imagery Read More
Farmer-Tablet
Data ManagementAgriculture’s Next Breakthrough: New Technologies…
July 3, 2018
We live in an exciting time in agriculture. Not only is technology advancing rapidly, but the understanding and comprehension of Read More
Nebraska-Storm
Precision IrrigationNotes from the Field: A Look at Irrigation Management P…
July 2, 2018
One of the things I love most about my work is making periodic treks into the field – more often Read More
Topcon X30 Console in cab
EventsAssociation Seeks Definitive Definition of “Preci…
July 2, 2018
More than two-dozen definitions of precision agriculture have been identified through the years — but which is the best and Read More
Industry NewsAg Equipment Manufacturers: 3 Trends to Shape Farming G…
July 2, 2018
Bottom line instead of brand loyalty. Tractors and harvesters will look more like computers. Data will drive productivity. These are Read More
Ag Retailer and Growers with tablet WinField United
Service ProvidersPrecision Ag Technology: Act Like You’ve Been There Bef…
July 2, 2018
One of my dad’s favorite, albeit borrowed, sayings was, “Act like you’ve been there before.” He was mostly referring to Read More