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
Farm-Storm-Clouds-Photo-Eden-Hills
Data ManagementThe Precipitation Problem in Agriculture
April 17, 2018
Precipitation is arguably the most important agricultural weather parameter, yet it is the most difficult variable to precisely measure. For Read More
Facebook-phone
Data ManagementWhat Lessons Can the Ag Industry Learn from the Facebook Data Breach? How to Tell if Your Ag Data is Secure
April 12, 2018
Today, a seemingly endless amount of ag data flows from growers’ fields into a host of technology platforms. It is Read More
Data ManagementREPORT: Bayer’s Digital Farming Business Slated for BASF Takeover
April 11, 2018
Germany’s Bayer plans to sell its digital farming business to BASF as part of changes to concessions it has offered Read More
Grower Retaile iPad
Data ManagementRobust Crop Scouting Requires Advanced Data Collection
April 2, 2018
Disclaimer: I have never been a crop scout. My intolerance for insects insinuating themselves in places that are competing for Read More
Trending Articles
SDSU-drone
Business ManagementInside the Key Strategies For Selling Precision Ag Services
April 13, 2018
In its earliest manifestation, the motive for developing precision agriculture service was entirely pure. Agronomists knew that crops were responding Read More
CROO Robotics’ automated strawberry harvester
Robotics/Labor SaversSpecialty Crops: Get in Gear Now for Agriculture’s Robotic Revolution
April 11, 2018
While the immigration debate rages on in Washington, DC, with little chance for reform in sight, the uncertain labor picture Read More
InSiteDCM
Business ManagementDelivering on Ag Data Value
April 3, 2018
Bruce Baier is another deeply experienced precision agriculture manager who survived the early years of ag technology while riding the Read More
University-of-Georgia-photo-credit-USDA
Business Management25 Best Colleges for Precision Agriculture
March 21, 2018
Choosing the right college is a process. It’s one that I’m just now embarking on with my teenage daughter. Long Read More
Farmer-tablet
Decision Support SoftwareOpinion: The Missing Link in Precision Agriculture
March 15, 2018
The agtech boom over the last two years is indeed astonishing. Farmers are becoming more open to new, emerging technologies Read More
Filling The Planter from Cab
Service ProvidersPrecision Agriculture: What is it?
March 15, 2018
If we look at the title of the article, all of you will come to an answer. These answers will Read More
Latest News
Industry NewsClimate Corp Announces 5 New FieldView Integrations
April 23, 2018
The Climate Corporation announced the addition of five industry-leading partners to The Climate Corporation’s Climate FieldView digital agriculture platform. The Read More
Laura_Crook_WinterWheat_Blackgrass_PrecisionAg
Industry NewsKansas Software Outfit Ag Developer Announces agX Integ…
April 23, 2018
Ag Developer, a Kansas based software development company, is simplifying grower/advisor communications by connecting to the agX Platform, according to Read More
field_in_back_1000_wd-featured-image
Industry NewsAyrstone Introduces High-Speed WiFi System for Farms
April 20, 2018
WiFi has become a necessity, and a proliferation of new WiFi devices have come to market for urban homes and Read More
Indian-Agriculture
AsiaIndian IoT Platform for Pre and Post Harvest Raises See…
April 19, 2018
Indian startup AgNext has raised an undisclosed seed round led by India-focused Agtech VC Omnivore Partners along with Singaporean angel Read More
Bayer-Forward-Farming
Industry NewsMaryland Farm Opens as Hub of Learning about Sustainabl…
April 19, 2018
Fourth-generation Maryland farmer Trey Hill measures the success of his operation not just by how many bushels of corn, soybeans, Read More
THRIVE
Industry NewsAgritech Startup Backers Announce New Corporate Partner…
April 18, 2018
Entering its fourth year, the THRIVE Venture & Innovation platform announced today the nine finalists and investment in its spring Read More
computer-in-field
EventsFinding Our Way in the Business of Precision Agricultur…
April 17, 2018
Service providers are the essential link between precision agriculture products and practices and the farmers who are increasingly relying on Read More
Farm-Storm-Clouds-Photo-Eden-Hills
Data ManagementThe Precipitation Problem in Agriculture
April 17, 2018
Precipitation is arguably the most important agricultural weather parameter, yet it is the most difficult variable to precisely measure. For Read More
Digital-Farming
Business Management7 Factors That Could Make or Break Digital Farming
April 13, 2018
Digital farming is the new technology genie – a genie that is now out of the bottle and cannot be Read More
SDSU-drone
Business ManagementInside the Key Strategies For Selling Precision Ag Serv…
April 13, 2018
In its earliest manifestation, the motive for developing precision agriculture service was entirely pure. Agronomists knew that crops were responding Read More
Facebook-phone
Data ManagementWhat Lessons Can the Ag Industry Learn from the Faceboo…
April 12, 2018
Today, a seemingly endless amount of ag data flows from growers’ fields into a host of technology platforms. It is Read More
DronesWhen High Value Crops Meet Inaccessible Areas: How Dron…
April 12, 2018
Avocados are one of the few crops in Chile that can economically be commercially cultivated on hills. On one hand Read More
Almond-trees-blooming
Sensors/IoTWhy Virtual Sensors Could Save California’s At-Ri…
April 12, 2018
To say that the Golden State can lay claim to the title of king of almonds might be an understatement. Read More
AgJunction, InfoAg 2014, Autosteer, GPS
Industry NewsAgJunction Launches Online Store, Low Cost Guidance Sys…
April 12, 2018
AgJunction today announced the opening of the HandsFreeFarm.com online store to bring low-cost, simple-to-use precision agriculture solutions direct to all Read More
aggateway
Business ManagementAgGateway Encourages Use of Standard Identifiers with A…
April 11, 2018
AgGateway, the non-profit organization with the mission to promote and enable the industry’s transition to digital agriculture, is offering a Read More
Remote-Soil-Sensing-Mapping
Imagery/SensingRemote Soil Sensing Enhances Precision Farming, Promote…
April 11, 2018
Precision agriculture management requires understanding soil at increasingly finer scales. Conventional soil sampling and laboratory analyses often lack this granularity Read More
Data ManagementREPORT: Bayer’s Digital Farming Business Slated f…
April 11, 2018
Germany’s Bayer plans to sell its digital farming business to BASF as part of changes to concessions it has offered Read More
Corn
Industry NewsSentera Announces New FieldAgent Features
April 11, 2018
Sentera announces the availability of high-fidelity crop stand, weed pressure mapping, spot scouting maps, and free local image stitching within Read More