0

I would like to access soil data by lat/lon. It looks like this is the US soil web service here. However, I am not sure how to set up the query, the Help page should be helpful but is 100's of pages long. Can anyone give me some pointers for setting up a python script to query a soil database?

R looks like it has a decent interface, maybe I will have to learn R.

  • 1
    Since you've already identified your data source and your question is really more about using a software interface to the database, you might want to post this question in https://stackoverflow.com/. When you ask a question there, make sure you show what you've tried and what you hope to achieve. – sboysel Oct 25 at 4:17
  • 1
    Your request is a classic case for GIS analysis. Try SE Geographic Information Systems – Stu Smith Oct 29 at 5:26
  • sdmdataaccess.sc.egov.usda.gov/WebServiceHelp.aspx may or may not be helpful, but this appears to be a fairly generic WFS/WCS server – Barry Carter Nov 11 at 18:48
1

This is not an answer.

If you visit https://sdmdataaccess.sc.egov.usda.gov/QueryHelp.aspx and download the "Table Column Descriptions Report (741K)" PDF, you will get a list of all tables (and column names) for your data.

You can then go to https://sdmdataaccess.sc.egov.usda.gov/Query.aspx and make queries like SELECT * FROM chaashto. You will have to queue your query and give your email address.

I did this and got back a link to a 30M ZIP file (it's https://sdmdataaccess.sc.egov.usda.gov/SDMQueuedDownloads/SDMQuery229984.zip but may no longer be available) that decompresses to 195M. I have no idea what the data means, but, presumably, you would :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.