SSURGO Databse

[Evan Ross]

When writing the soil input table, SWAT is looking for the ArcSWAT SSURGO database. It seems the default database that comes with SWAT is statsgo? How do I go about getting the SSURGO database?

I have two separate .mdb files that I used to download the soils data. Can these be combined in some way to create this database?

Thank you.

[Grey Evenson]

Hi Evan,

The database may be found on the arcswat page (http://swat.tamu.edu/software/arcswat/).  Download and put into the ArcSWAT databases folder.

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To post to this group, send email to arc...@googlegroups.com.
Visit this group at http://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/groups/opt_out.

[Seyoum Gebremariam]

After downloading the database, you need to generate your own soil raster that matches the database--that is key element using SSURGO

[Dan Auerbach]

Little bit of thread drift here, but I prefer to bump a related topic over starting a new one...

I've found that some of my soils (i.e., MUKEY's) aren't in the SSURGO mdb available from the main site linked above. This then throws an error when ArcSWAT tries to build the .sol table in my project database. However, I see some data for these MUKEY values in the original tables that I have from NRCS (e.g., in the 'comp' table for the survey area).

I can probably get something to run w/a work-around (add appropriately indexed 'dummy' rows w/null parameter values to the master database and go from there), but can anyone point me to the update process for the 'master' DB (the one available for others to download)? Is there a script that the team can use to append soil classes? Hopefully all 300K don't have to be rewritten each time there's a release?

I may give this a try:

http://hydrologicou.wordpress.com/software/swat-soil/

But it looks written to generate a usersoil table. Since most of my soils are already correctly in the main database, I'd rather update that and save others the trouble in the future...

cheers,

Dan

[Grey Evenson]

Hi Dan,

Perhaps I'm misunderstanding what you're looking for and that is likely the case as my solution seems too simple.  But can you not simply execute an append operation in ms access - i.e. have a table of your new soil classes (with all columns as they exist in the arcswat surrgo database) and then simply append that to the table?  Certainly you need to appropriately build those rows and I don't know of any short cuts there but after that ms access provides the append functionality as is.

...though maybe I'm simply misunderstanding what you're going for.

Either way, good luck!  

--

[Dan Auerbach]

Grey,

Thanks for the response. That's more or less what I've done to get running, just pasted in the necessary placeholder records.

The question was about 1) best options to actually build the table/rows you refer to (i.e., with the right columns/parameters) from the 'raw' SSURGO tabular data and 2) assuming I do that, whether there's a standard procedure to get the updates into the 'shared' mdb available for all to download...

cheers,

D

[Dan Auerbach]

For the record: I had good results w/the XLS sheet/macro linked above...kudos to Gengxin (Michael) Ou.

I'd add to the instructions on his source page that it worked for me to export the required tables (chfrag, chorizon, component, muattag) as .txt from a GSSURGO database in Arc, then directly import them into the appropriate sheets in the worksheet. 16 soil types was basically instantaneous to run, and they're now added to my 'Master' SSURGO database in the ArcSWAT directory.

Still happy to try to update the file available from the main SWAT site...

D