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.

Improve this question
3
  • 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, 2019 at 4:17
  • 1
    Your request is a classic case for GIS analysis. Try SE Geographic Information Systems
    – Stu Smith
    Oct 29, 2019 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
    – user3856
    Nov 11, 2019 at 18:48

1 Answer 1

Reset to default
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 :)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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