10

I am interested in downloading and using the entire USGS SSURGO database.

The California Soil Resource Lab provides instructions on working with these data in R, but it starts with the assumption that I have downloaded tables as .csv files - but doesn't say how to get these files, other than that the metadata is available as an Access template

Can I download the entire SSURGO database? Is it available in formats other than csv + Access?

0

8 Answers 8

10

It is possible to import the SSURGO database into PostgreSQL, it is just not terribly easy. As answered in response to your other question, the SSURGO data can be downloaded by state. The information for some states (e.g., CA) will be too big and will need to be downloaded by county; multiple counties can be selected. Once the downloaded information is extracted from its archive, the spatial data are a collection of shapefiles and the tabular data are a collection of flat ASCII files (fields separated by '|').

The SSURGO metadata explains the relationships of tables (Data Model Diagram and Relations Report), table fields and their respective data type (Tables and Columns Report), and detailed column descriptions (Table Columns Description Report). Using this information it is possible to create the appropriate tables and import both the spatial and tabular data. I was able to import the mupolygon (polygon shapefile), mapunit, component, and coecoclass tables for the western US into PostgreSQL. SQL script for creating the above tables, bash script (rudimentary) for iterating over the downloaded data and importing into PostgreSQL, and SQL script for cleaning up the import.

1
  • There are 69 tables in the ssurgo database. @Brady 's SQL script creates the common ones, but it would be quite a chore manually if you want every table/field. I was able to use the MS Access database template USDA provided with the download and dbSchema (dbschema.com) to copy the tables. In dbSchema, connect to the MS Access database and bring in all of the tables. Don't bother with the tables that begin with "system" or the queries/views. Then go offline with the schema, change the Project Properties to Postgres, connect to Postgres, and sync. Now to create an import script... Sep 18, 2016 at 22:24
5

If you go through the USDA website where they give you access to SSURGO, it's kind of a mess. They make you go all the way down to the county level.

If you go through the NRCS Data Gateway you can define an area of interest with a bounding box. The data is also available for download by state. Over the last couple of months the SSURGO data has been hit or miss (if you go to 'Contact Us' they usually tell you which databases are down).

Just a heads up - the national dataset is going to be pretty substantial when it comes to disk space / network load if you get all of the tabular data too. It might be better to work in chunks anyway in case you lose the connection.

6
  • I actually found a pretty large portion of the contiguous US on our server, but a check at the metadata shows... that there's no metadata (not sure where it came from / how it was assembled)
    – Roy
    Jun 26, 2012 at 15:51
  • I obtained SSURGO from a USDA-ARS faculty at my Land Grant University. It is 160GB. I suspect you could obtain a copy of the database from your local extension agent. There may be a charge, depending on your affiliations. Jun 27, 2012 at 16:56
  • @David and Roy, is the database only available as flat files, or is there a simple way to import it into a RDMS?
    – Abe
    Jun 27, 2012 at 18:15
  • Theres the spatial data, then auxilary tabular data that can be tied in using related tables (relationship classes). If you really want to use access and cut the visual spatial aspect out, use the dbf from the shapefiles.
    – Roy
    Jun 27, 2012 at 18:19
  • I'd actually rather use something linux compatable like PostgresSQL. What do you mean by "tied in using related tables" outside of the context of using a database.
    – Abe
    Jun 27, 2012 at 21:58
2

Unfortunately, I do not think so. At least not at this time. We are trying to work with the data to get best-available estimates of soil parameters for portions of the south central US, and it has been a time-consuming, slow process to both merge the shapefiles together to cover larger areas, and to read the associated tabular data such that it can be converted into the values we need.

2

If you care to go about downloading the individual soil areas from NRCS's Web Soil Survey Portal, you can click the Download Soils Data tab and get the raw tabular and spatial files per area.

I have built a python tool to scan the downloaded, unzipped folders and import the data into a PostGIS database (or update the data therein). You can find the tool here.

1

Abe,

I have worked and performed my SSURGO for the state of New Mexico because I work for NRCS. Before I give you how to do the steps, I ran the internet and found this and this pdf will probably be very useful for you. This is similar what I did.

Tutorial for SSURGO download from Purdue

You will probably need to go to NRCS Geospatial Data Gateway to select all or some soil survey area spatial and tabular SSURGO soils data. This might charge you since you are not part of USDA employee or any Federal agency. You might check that out with the California NRCS for further information. If you know someone or an organization that might have the data and get copy of it.

Once you download all of the spatial and tabular from the data mart. Open the MS Access that you save the template database. You will probably see a warning dialog box and be sure to enable it. Make sure you make a copy and back it up in the event you messed it up.

Before you start importing all the database, it is wise to save a new MS Access database file like this for example SSURGO_CA.mdb.

When you import a database, the easiest way to do is to open the Window Explorer and copy the path of the tabular folder and paste it (on page 8) in the SSURGO Import dialog box. It save me a lot of my time. When it is done imported, make sure you save it as a SSURGO_CA.mdb for each tabular you download.

If you forgot or not sure which soil survey area you have import or not, you can open the access file and look for the names you have imported it there.

Let me know if you need help, Wish you the best luck !

1

SSURGO tables in .csv format can be downloaded from here.

SSURGO map and associated tables can be downloaded in ArcGIS Geodatabase (.gdb) format by following the link here.

0

Note that the links to the CA Soil Resource pages have recently changed. Please use the search feature on the new site to find relevant material. Please see my suggestions in a related question.

0

It is the USDA NRCS Soils Database, not USGS. And, yes, you can obtain the entire dataset, both spatial and attribute.

NRCS Website

This site provides the Ordering Information for the Soil Data Mart database. The SDM is the publication database used by the various web portals.

However, the SDM database is more than you will need and it is best to use the Soil Data Access site to query the specific information you need and download for import into your project.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.