We have state and CONUS gSSURGO file geodatabases available for download on our Soils box site. More about gSSURGO here. The file geodatabase contains the spatial data as vector and raster format and includes all the tables. The file geodatabases can be used in a GIS software.
It’s not recommended to join any of the tables but a select couple because of the one-to-many join issues. MUAGGATT and Valu1 tables can be joined by MUKEY with no issues. MUAGGATT is an aggregated table of the most commonly asked for columns of data aggregated together into one table. MUAGGATT contains the map unit names. The Valu1 table is 57 pre-summarized attributes and is discussed more in depth on gSSURGO page. gSSURGO Valu1 table column descriptions PDF.
We are working on a new product called SSURGO Portal. SSURGO Portal is a license free application that allows you to import spatial and tabular SSURGO data into geospatial SQLite SSURGO template databases. There is a ton of info on the webpage, and I recommend reading it all the way through. It provides additional resources. Check out the quick start guide at the top if you want to dive right in. There are Bulk Downloader tools for ArcGIS Pro and QGIS (free software to download) to download several datasets at onetime from Web Soil Survey. You can create your own SQLite database at any size in SSURGO Portal with the spatial data and tables. A newer version to be release soon will include Soil Data Viewer.
