Building Soil Lookup and Usersoil Tables

[Matthew Lombardo]

Does anyone have experience with building a soil lookup table and usersoil table? Also, does anyone know what parameters in soils.sol are required for computations?  I am using SSURGO data, but my soils are not in the database so I have to make my own lookup csv's. I am trying to model the tables after the two SSURGO soil tables found in the swat_soils.sqlite, and I attached the work that I've done so far. The MUKEY column on my usersoil table is only temporary. Does anyone know if this is the right approach? I wasn't able to find any examples or instructions in a manual anywhere so the SSURGO tables ar all I have to go on. Also, what parameters in soils.sol are required? For example, I have not been able to find the anion_exl (Fraction of porosity (void space) from which anions are excluded) or the USLE_K parameters. There are more I cannot find but these are two examples.

Thank you,

Matt Lombardo