This may be better for Engineering? Not sure.
Background: Previously I have downloaded SSURGO soil data for the state of Pennsylvania by downloading each county and merging the shapefiles. I then combined the mapunit and muaggatt tables and joined them with the spatial data based on the soil name (e.g. "GbC", "WhB"). I use this to create thematic maps of Farmland classification and Hydric conditions programmatically using arcpy.
Goal: Now I would like to do the same to create thematic maps of Hydrologic Soil Classification. It looks like the appropriate table is comp.txt however this table doesn't appear to have a similar soil name field.
Question: Has anyone done this before? That is, linked SSURGO soil spatial data to appropriate tables to display Hydrologic Soil Classification? Or does anyone have guidance on any pathways that would be best to look into?
As pointed out in the answer to the question linked below, some have used PostgreSQL to connect to GIS, (would be fantastic) but I have no experience using databases and I can't find any descriptions of how exactly to do this. Can I download the entire NRCS SSURGO database?