Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
add comment

4 Answers

up vote 2 down vote accepted

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

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.

share|improve this answer
    
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 '12 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. –  David Jun 27 '12 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 '12 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 '12 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 '12 at 21:58
show 1 more comment

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 !

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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