How to append additional soil records to SWAT_US_SSURGO_Soils.mdb

[Michael Ou]

Hello ArcSWAT users,

In my study area, there are some soil map units (SSURGO) missed in the original SWAT_US_SSURGO_Soils.mdb.

Therefore, I have generated and appended the additional soil records to the table SSURGO_Soils in the Access file SWAT_US_SSURGO_Soils.mdb.

But there is still an error when writing ".Sol" input files, showing "Syntax error in INSERT INTO statement.: IN, mWriteInputFiles.sol".

I wonder whether I have missed any steps or the error is caused by other reasons.

Any help and suggestion would be very much appreciated!

Michael

[Djesser Zechner Sergio]

I had a similar error. You have to fill out all the attributes for each layer. You must not fill out with -99 for those you don't have and you must not leave it in blank.

Michael

--
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.
 
 

--

Djesser Zechner Sergio

Sanitary and Environmental Engineer / UFSC / 2012.2

AMBIPLAN - Engenharia Ambiental SS LTDA and 

SERENCO – Serviços de Engenharia Consultiva SS Ltda

Av. Sete de Setembro, 3566 - Centro -

Curitiba – PR - CEP 80250-210

www.serenco.com.br

+554197111114

+554132339519

dje...@serenco.com.br

djesser...@gmail.com

[Gengxin (Michael) Ou]

Thank you very much Djesser.

This seems to be the reason.

No error after I completed all the fields of each record.

Gengxin (Michael) Ou