How to transfom german soil data into a classification scheme for the use in KINEROS

[jbren...@gmail.com]

I am working with KINEROS2 and have to prepare the soil data for the parameterization in AGWA. Therefore I have to create lookup tables for the german soil data TBK50.

Are there some experiences on transforming soil classifications and creating user defined soil lookup tables?

Thank you in advance!

[Shea]

I'm not familiar with the TBK50 data set. Natively AGWA supports SSURGO/STATSGO2, STATSGO, and the FAO digital soil map of the world. You can use FAO soils as is for your watershed to do an initial parameterization and simulation if you like, but the resolution is pretty course- I think the mapping resolution is something like 1:5000000.

To use your own dataset in AGWA, you'll need to add an MUKEY field to simulate SSURGO/STATSGO2, an MUID field to mimic STATSGO, or an SNUM field to mimic FAO. Each soils dataset has its own supporting look-up tables that AGWA also uses, so you'll need to crosswalk your data into the appropriate tables and fields accordingly. I'll put together a list of the tables and fields needed for each dataset and post the requirements back later today or tomorrow. Thanks for your patience.

Shea

[Sean Earles]

Are you able to also provide the key fields required for the land use lookup as well? 
Sean

--
You received this message because you are subscribed to the Google Groups "AGWA Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agwa-support...@googlegroups.com.
To post to this group, send email to agwa-s...@googlegroups.com.
Visit this group at https://groups.google.com/group/agwa-support.
To view this discussion on the web visit https://groups.google.com/d/msgid/agwa-support/1270a747-e0ee-435b-8a44-0597c60842a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[An Ho Antonio Taylor]

Would you mind sending to me as well? Thanks 

--

[Sean Earles]

Hi Shea - just curious how you are progressing with this? 

Happy holidays everyone!

Cheers, 
Sean

[Shea]

Hi Sean,

Sorry about the delay, some other projects came up before I was able to put everything together and then the holidays were here. I'm putting the information together right now and will post back tonight or tomorrow.

Shea

[Shea]

The following describes the soil requirements for KINEROS2 in AGWA, organized by the type of input soil dataset. For SSURGO/STATSGO2 (with MUKEY field), these tables are located in the SSURGO Template Access database (typically named “soildb_US_2003.mdb” when downloaded with a soil survey from the Web Soil Survey). For STATSGO (with MUID field), these tables are available in the \AGWA\datafiles\statsgo\ directory of the AGWA home directory, and organized into folders by the state abbreviation, which is the prefix of the values in the MUID field. For FAO (with SNUM field), these tables are available in the \AGWA\datafiles\FAO\ directory of the AGWA home directory.

SSURGO/STATSGO2 (MUKEY field)

Table	Required fields	Description
component	mukey	Soil mapping unit identifier
	cokey	Soil component identifier
	comppct_r	Component percentage of the soil unit
chorizon	cokey	Soil component identifier
	chkey	Soil horizon identifier
	hzdept_r	Depth of upper boundary of current soil horizon. (cm)
	hzdepb_r	Depth of lower boundary of current soil horizon. (cm)
	sieveno10_r	Soil fraction passing a number 10 sieve (2.00mm square opening) as a weight percentage of the less than 3 inch (76.4mm) fraction (i.e. rock = 1 - sieveno10_r/100).
	kwfact	An erodibility factor which quantifies the susceptibility of soil particles to detachment and movement by water. This factor is adjusted for the effect of rock fragments (i.e. USLE K factor, adjusted for rock). ((ton·acre·hour)/(hundreds of acre foot-ton·inch))
	dbthirdbar_r	The oven dry weight of the less than 2 mm soil material per unit volume of soil at a water tension of 1/3 bar (i.e. bulk density). (g/cm3)
chtexturegrp	chkey	Soil horizon identifier.
	texture	Code for the USDA texture for the specified layer or horizon of the soil. Example: Sandy Loam (SL); Loam (L). Also includes terms used to modify texture and terms used in lieu of texture.

 

STATSGO (MUID field)

Table	Required fields	Description
comp.dbf	muid	Soil mapping unit identifier
	seqnum	Sequential number corresponding to the component number for the respective soil unit.
	comppct	Component percentage of the soil unit.
layer.dbf	muid	Soil mapping unit identifier
	seqnum	Sequential number corresponding to the component number for the respective soil unit.
	layernum	Successive layer numbers for the respective soil unit.
	bdh	Maximum value for the range in moist bulk density of the soil layer or horizon. (g/cm3).
	bdl	Minimum value for the range in moist bulk density of the soil layer or horizon. (g/cm3).
	laydeph	The depth to the lower boundary of the soil layer or horizon. (in)
	laydepl	Depth to the upper boundary of the soil layer or horizon. (in)
	texture1	Code for the USDA texture for the specified layer or horizon of the soil. Example: Sandy Loam (SL); Loam (L). Also includes terms used to modify texture and terms used in lieu of texture.
	no10l	The minimum value for the range in percent by weight of the soil material in a layer or horizon which is less than three inches in size and passes a no. 10 sieve.
	no10h	The maximum value for the range in percent by weight of the soil material in a layer or horizon which is less than three inches in size and passes a no. 10 sieve.
	kffact	An erodibility factor which quantifies the susceptibility of soil particles to detachment and movement by water. This factor is used in the Universal Soil Loss Equation to calculate soil loss by water. ((ton·acre·hour)/(hundreds of acre foot-ton·inch))

 

FAO (SNUM field)

Table	Required fields	Description
fao_component.dbf	snum	Soil mapping number identifier
	su1	Soil unit 1, if present.
	per1	Soil unit 1 percentage of total soil, if present.
	su2	Soil unit 2, if present.
	per2	Soil unit 2 percentage of total soil, if present.
	su3	Soil unit 3, if present.
	per3	Soil unit 3 percentage of total soil, if present.
	su4	Soil unit 4, if present.
	per4	Soil unit 4 percentage of total soil, if present.
	su5	Soil unit 5, if present.
	per5	Soil unit 5 percentage of total soil, if present.
	su6	Soil unit 6, if present.
	per6	Soil unit 6 percentage of total soil, if present.
	su7	Soil unit 7, if present.
	per7	Soil unit 7 percentage of total soil, if present.
	su8	Soil unit 8, if present.
	per8	Soil unit 8 percentage of total soil, if present.
fao_properties.dbf	soil_unit	Soil unit
	texture	Code for the USDA texture for the specified layer or horizon of the soil. Example: Sandy Loam (SL); Loam (L). Also includes terms used to modify texture and terms used in lieu of texture.
	sandtop	Weight percentage of sand in the top layer.
	silttop	Weight percentage of silt in the top layer.
	claytop	Weight percentage of clay in the top layer.
	bdtop	Bulk density of the top layer. (g/cm3)
fao_summ.dbf	texture	Code for the USDA texture for the specified layer or horizon of the soil. Example: Sandy Loam (SL); Loam (L). Also includes terms used to modify texture and terms used in lieu of texture.
	sand_top	Weight percentage of sand in the top layer.
	silt_top	Weight percentage of silt in the top layer.
	clay_top	Weight percentage of clay in the top layer.
	bd_top	Bulk density of the top layer. (g/cm3)
	frag_top	Percentage coarse fragments greater than 2mm, in the 0-100cm depth.

On Wednesday, January 2, 2019 at 5:07:12 PM UTC-7, Shea wrote:

Hi Sean,

Sorry about the delay, some other projects came up before I was able to put everything together and then the holidays were here. I'm putting the information together right now and will post back tonight or tomorrow.

Shea

On Friday, December 21, 2018 at 8:11:30 AM UTC-7, Sean Earles wrote:

Hi Shea - just curious how you are progressing with this? 

Happy holidays everyone!

Cheers, 
Sean

On Monday, 10 December 2018 18:05:47 UTC-5, An Ho Antonio Taylor wrote:

Would you mind sending to me as well? Thanks 

[Sean Earles]

Thanks for posting. Are all these fields required to use the KINEROS model? 

Cheers

Sean

--

You received this message because you are subscribed to the Google Groups "AGWA Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agwa-support...@googlegroups.com.
To post to this group, send email to agwa-s...@googlegroups.com.
Visit this group at https://groups.google.com/group/agwa-support.

To view this discussion on the web visit https://groups.google.com/d/msgid/agwa-support/1aa9bc5c-cdcf-4125-9566-0bf59a5f3bbc%40googlegroups.com.

[Shea]

Yes, within each type of soil dataset (SSURGO, STATSGO, or FAO). AGWA doesn't support mixing SSURGO, STATSGO, and FAO soil datasets within a single parameterization without crosswalking them to a common soil identifier field (MUKEY, MUID, or SNUM), so you only need the fields for the dataset that you're using.

I will put together the same information for the other models also and post back next week or the following.

Shea

On Sunday, January 6, 2019 at 11:35:56 AM UTC-7, Sean Earles wrote:

Thanks for posting. Are all these fields required to use the KINEROS model? 

Cheers

Sean

[D R Sena]

Hi Shea,

I am enclosing the dbf files i created for FAO soil for my area. What is wrong in it?

Thanks in advance

DR Sena

 

[Shea]

DR Sena,

The tables you uploaded appear identical to the original AGWA FAO tables. If there is a problem, it may be with your soils map and not the FAO soils look-up tables. If you want to continue troubleshooting that, I suggest creating a new topic and not replying to this one.

Shea