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
Field
Data ManagementThe Climate Corp., Deveron Form Drone Analytics Partnership
November 16, 2017
The Climate Corp., a subsidiary of Monsanto Co., has announced a partnership with Deveron UAS Corp., that will deliver farmers Read More
Soybean-Field-Photo-Barbara-Eckstein
Data ManagementWeather Forecasting: How Does It Work, and How Reliable Is It?
November 14, 2017
Do you ever wonder exactly how the weather forecast is made? And how good are they, really? In last month’s Read More
Data ManagementAgGateway Grain Transfer Proof of Concept Shows Promise
November 10, 2017
We talk about closed-loop systems quite a bit in modern production agriculture. Having a closed-loop, or completely self-contained, system is Read More
Spray Drift
Business ManagementProtecting Your Business with Ag Data: What Dicamba Can Teach Us (Guest Column)
November 9, 2017
All over the country, in ag communities large and small, farmers are reporting crop damage, neighbors are fighting, lawsuits and Read More
Trending Articles
Blue River Tech See and Spray prototype in CA
Business ManagementIs the Agtech Startup Boom Over?
November 13, 2017
In the past few months there has been a flurry of acquisitions of agtech startups by major players in the Read More
Spray Drift
Business ManagementProtecting Your Business with Ag Data: What Dicamba Can Teach Us (Guest Column)
November 9, 2017
All over the country, in ag communities large and small, farmers are reporting crop damage, neighbors are fighting, lawsuits and Read More
Kokoda-Trek2
Australia/New ZealandPrecision Agriculture in Papua New Guinea
November 2, 2017
I recently spent two weeks in the Central Highlands area of Papua New Guinea (PNG) on the Kokoda Track. The Read More
Robotic-Field-Scanner
Specialty CropsOpinion: Agriculture’s Big Data is Coming to You
October 20, 2017
If you think your world is changing at a dizzying pace, you ain’t seen nothin’ yet. That’s my takeaway from Read More
Brazil-Soybean-field
AmericasIPNI Brazil: Precision Agriculture to Improve Nutrient Use Efficiency
October 16, 2017
As I mentioned in my last article, the IPNI Brazil Symposium on Precision Agriculture was held in early October in Read More
Decision Support SoftwareFarmers Edge, Service Provider Talk High-Frequency Imagery Deal
October 11, 2017
As the domestic ag tech market continues to mature and develop as we barrel into 2018, another intriguing partnership has Read More
Latest News
DronesDrones Play Critical Role in Ohio Agricultural Research
November 17, 2017
The Springfield Beckley-Municipal Airport now has a new hangar for unmanned aircraft and precision agriculture, writes Allyson Brown on GovTech.com. Read More
Iowa-Farmer China
AsiaIowa Farm a Model for Modernizing China Agriculture
November 16, 2017
The buddy seat on Rick Kimberley’s combine-harvester is a fine vantage point from which to observe precision farming. The combine’s Read More
Field
Data ManagementThe Climate Corp., Deveron Form Drone Analytics Partner…
November 16, 2017
The Climate Corp., a subsidiary of Monsanto Co., has announced a partnership with Deveron UAS Corp., that will deliver farmers Read More
aggateway
Service ProvidersAgGateway Recognizes Leaders at 2017 Annual Conference
November 16, 2017
At its annual conference last week, AgGateway honored individuals and companies that are advancing electronic connectivity efforts in agriculture and Read More
corn field
UncategorizedTopcon Agriculture Prepares to Release Horizon 4.02
November 15, 2017
Topcon Agriculture has announced the addition of new functions including Auto Turn and Steer to Boundary applications in its upcoming Read More
Used Combine
Service ProvidersFinding New Precision Ag Opportunities in Older Equipme…
November 15, 2017
Whether to buy new or used equipment has been and continues to be an important topic for growers. When it Read More
John-Deere-Air-Carts
Systems ManagementJohn Deere 1910 Air Carts Can Now Be Retrofitted with S…
November 14, 2017
Intelligent Agricultural Solutions, LLC (Intelligent Ag), a leader in electronics innovations for modern farming, has released Engage Zone Control, the Read More
Climate FieldView Script Creator
EuropeThe Climate Corp. Expands Global Digital Agriculture Pl…
November 14, 2017
The Climate Corp., a subsidiary of Monsanto Co., has announced at Agritechnica, the world’s leading trade fair for agricultural machinery, Read More
Soybean-Field-Photo-Barbara-Eckstein
Data ManagementWeather Forecasting: How Does It Work, and How Reliable…
November 14, 2017
Do you ever wonder exactly how the weather forecast is made? And how good are they, really? In last month’s Read More
Topcon_TAP
Decision Support SoftwareTopcon Agriculture Introduces New Connected Agricultura…
November 13, 2017
Topcon Agriculture has introduced TAP, the Topcon Agriculture Platform, a cloud-based agricultural ecosystem designed to provide real-time monitoring and data Read More
Topcon A6
Systems ManagementTopcon Agriculture Adds ISOBUS Communication to Opus Co…
November 13, 2017
Topcon Agriculture has added industry-leading ISOBUS universal terminal and task controller functionality to the Opus A6 and A8 consoles. The Read More
Blue River Tech See and Spray prototype in CA
Business ManagementIs the Agtech Startup Boom Over?
November 13, 2017
In the past few months there has been a flurry of acquisitions of agtech startups by major players in the Read More
Data ManagementAgGateway Grain Transfer Proof of Concept Shows Promise
November 10, 2017
We talk about closed-loop systems quite a bit in modern production agriculture. Having a closed-loop, or completely self-contained, system is Read More
Spray Drift
Business ManagementProtecting Your Business with Ag Data: What Dicamba Can…
November 9, 2017
All over the country, in ag communities large and small, farmers are reporting crop damage, neighbors are fighting, lawsuits and Read More
Farmers Business Network, FBN Procurement
Industry NewsFarmers Business Network Details Updated FBN Direct Sho…
November 8, 2017
Farmer’s Business Network, Inc. is modernizing the way farmers shop with a new e-commerce platform designed and engineered exclusively for Read More
Excellence AwardsNominations Open For 2018 PrecisionAg Awards Of Excelle…
November 8, 2017
The PrecisionAg Award of Excellence program sheds light on some of the most important people and programs that have helped agriculture realize the full benefits of technology to improve agronomy, efficiency, and stewardship in crop production. Read More
Data ManagementDJI Announces FlightHub Drone Operations Management Pla…
November 7, 2017
DJI showcased new hardware and software advancements that make it easier for businesses across multiple industries to incorporate drones into Read More
Deere-Combine
Data ManagementTech’s Perspective: Closeout to #Harvest2017
November 7, 2017
As the harvest season comes to a close, a quick look at Twitter gives us some insights into how things Read More