Write Input Table related issue

[Smriti Kandel]

Hi ArcSWAT users,

 I got following message attached in an image while creating tables in write SWAT database table. Please help me how to solve this issue.

I would really appreciate your time.

Thank you.

Best Regards,

Smriti Kandel

[suman....@gmail.com]

Hi Smriti,

From the attached link, you can download the ssurgo database file and put it into the database folder of your swat directory. This should solve your problem.

https://swat.tamu.edu/software/arcswat/

Thanks,

Suman

[anish...@gmail.com]

Hi Smritik and Suman,

I am facing similar error while writing the input table but it mentions 'Syntax error in Insert INTO statement: in,mWriteInputFiles.sol" (screen capture attached). I do have the SSURGO mdb in database (ArcSWAT does create table by the name tbSoilList in the mdb containing soils MUKEY of watershed under study) and there are no blank row or column. 

Could you let me know if I am doing something wrong in the way I am doing things with SSURGO? I unable to understand the issue. 

Thanks,

Anish

[suman budhathoki]

Hi Anish,

Which swat version are you referring to? I did notice that there are some issues in the latest ssurgo database file. I would suggest you use the ssurgo database file of past years (eg. 2018), this should solve your problem.

Thanks,

Suman

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/f5ab1e8c-1c43-4535-adf8-33b95ef042f4n%40googlegroups.com.

[anish...@gmail.com]

Thanks Suman. 

I am using ArcSWAT 2012.10.24 with ArcMap 10.7.1 and using the ssurgo mdb available in the SWAT website (updated July 2020). Do you know where I can get previous SSURGO mdb used by SWAT? 

[Smriti Kandel]

Hi, I am also facing the same problem right now. 

On Thu, Oct 15, 2020 at 11:23 PM anish...@gmail.com <anish...@gmail.com> wrote:

Hi Smritik and Suman,

I am facing similar error while writing the input table but it mentions 'Syntax error in Insert INTO statement: in,mWriteInputFiles.sol" (screen capture attached). I do have the SSURGO mdb in database (ArcSWAT does create table by the name tbSoilList in the mdb containing soils MUKEY of watershed under study) and there are no blank row or column. 

Could you let me know if I am doing something wrong in the way I am doing things? I unable to understand the issue. 

Thanks,

Anish

On Thursday, 15 October, 2020 at 4:26:20 pm UTC-5 suman....@gmail.com wrote:

--

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 view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/4047dbf1-1023-4a50-8c26-b1b8ef48a029n%40googlegroups.com.

--

Smriti Kandel

Graduate Research Assistant

College of Agriculture, Communities and Environment

Kentucky state University

Cell: 502-352 5989

[Suman Budhathoki]

Hi Smriti and Anish,

You can get the old SSURGO database file from someone else who has been using SWAT (not the recently updated database). Its better to use the older version than to spend time in searching for errors in the new table. Check if the one that I have uploaded works for you. In case this database doesn't include all the soil information for your field, you can manually insert that from the updated database table you have.

Thanks,

Suman

 SWAT_US_SSURGO_Soils.mdb

Virus-free. www.avg.com

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/CAOoQaH2L9PzStYPsD1byjAGNSxbJJY3yXVyyTnj9bOhqb8fGTQ%40mail.gmail.com.

[anish...@gmail.com]

Thanks Suman. Finally it worked, only had to update soil. 

I spent a week figuring out this and no use.  Thanks again for the help. 

Happy weekend,

Anish

[suman budhathoki]

No problem. Happy to help. 

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/8488147b-a434-4300-9e9a-4527a2f812e6n%40googlegroups.com.

[Smriti Kandel]

Hi,

  I have been trying to write SWAT database using SSURGO soil. I always get error that some data base is missing in SWAT SSURGO Soils.mbd.  Attached image shows the type of error I got. Could you please help me how to fix this?

Really appreciate your help and time.

Regards,

Smriti Kandel

Graduate Research Assistant

College of Agriculture, Communities and Environment

Kentucky state University

Cell: 502-352 5989

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/CAH%2B5h54-jPHFyx9F2%3DVhddt9Oa-E_2tdtWK475xQC_SWLw631g%40mail.gmail.com.

[anish...@gmail.com]

You should update the soil database as soil 3098716 is not present in your soil database. So you can download the latest soil database from SWAT (https://swat.tamu.edu/software/arcswat/) then search for missing soil and copy-paste the value to your soil database. For example, I have attached the properties for the soil 3098716 

[ramesh...@gmail.com]

Hello

I am getting the same error   'Syntax error in Insert INTO statement: in,mWriteInputFiles.sol"  . The SSURGO mdb is in the ArcSWAT folder.  I was looking at the tbSoilList and wasn't sure exactly what information that gives - in mine it has a few soil mukeys of the study watershed.  Could you tell me what it does?

From my watershed soil file, doesn't seem like there are any soils that are missing in the ssurgo database. But I do keep getting this error.  I am struggling to understand what the issue is.  Any help is appreciated. 

Thanks

Rasika

[anish...@gmail.com]

Hi Rasika,

In thread above Suman has shared an older version of SSURGO database. Use that instead of the latest SSURGO database available, it solve your issue. 

[ramesh...@gmail.com]

I tried that and it worked. Thanks

[collins...@gmail.com]

Hi All,

Am using the older version of the SSURGO database shared by Suman but I still have some missing soils.

Please where do I get the soil properties to update the database?

Thank you,

Collins

[Smriti Kandel]

Hi Collins,

                 That happened to me as well. I realized that error appears if your soil is not 100% covered to watershed. Make sure you check that during HRU analysis.

Regards,

Smriti Kandel

Graduate Research Assistant

College of Agriculture, Communities and Environment

Kentucky state University

Cell: 502-352 5989

--

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 view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/859dec31-cd8e-41cb-8274-db019c2983b6n%40googlegroups.com.

[Stormbrise40]

I resolved the error by rebuilding my soil map. However I now have the following error (see screenshot below). I have seen this error lots on the forum, so I will start looking for a solution for it.

On Wednesday, January 12, 2022 at 6:59:37 PM UTC+1 Stormbrise40 wrote:

Anish I am looking for soil_1298 I have been searching the internet for hours, any idea where I can find the properties for this SSURGO soil? Also, do I just append the text file to my access file as a new record?

[Manoj paudel]

Hello

I am getting the same error   'Syntax error in Insert INTO statement: in,mWriteInputFiles.sol".