NRCS: Difference between revisions
From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs) mNo edit summary |
Brian Wilson (talk | contribs) mNo edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
Line 3: | Line 3: | ||
Soil data | Soil data | ||
You can download data from their Web | You can download data from their Web Soil Survey page, at https://websoilsurvey.sc.egov.usda.gov/App/HomePage.htm | ||
and then (in theory) view it in their desktop app (if you have MS Access) | and then (in theory) view it in their desktop app (if you have MS Access) | ||
or using their ArcGIS extension. | or using their ArcGIS extension. | ||
* So far I cannot view the data in their data viewer. | |||
* It's because the database is empty. | |||
* To populate the database requires a copy of MS Access, which I don't have. | |||
* So their viewer and extension are useless to me. | |||
Workflow | Workflow | ||
# | # Go to [https://websoilsurvey.sc.egov.usda.gov/App/WebSoilSurvey.aspx WSS] | ||
# Select a county | |||
# Download the data | # Download the data | ||
# | # Unzip it | ||
# Copy the tabular/mapunit.txt to mapunit.csv | |||
# Edit the tabular/mapunit.csv file to add a header line | |||
# Join the spatial and mapunit.csv and copy it to a shapefile with ogr2ogr | |||
# Import the shapefile into the project | |||
ogr2ogr -sql "select inshape.*, joincsv.soiltype, joincsv.hvf from inshape left join 'mapunit.csv'.joincsv on inshape.MUKEY = joincsv.mukey" \ | |||
outshape.shp \ | |||
inshape.shp inshape |
Latest revision as of 02:06, 3 February 2017
USDA Natural Resource Conservation Service
Soil data
You can download data from their Web Soil Survey page, at https://websoilsurvey.sc.egov.usda.gov/App/HomePage.htm and then (in theory) view it in their desktop app (if you have MS Access) or using their ArcGIS extension.
- So far I cannot view the data in their data viewer.
- It's because the database is empty.
- To populate the database requires a copy of MS Access, which I don't have.
- So their viewer and extension are useless to me.
Workflow
- Go to WSS
- Select a county
- Download the data
- Unzip it
- Copy the tabular/mapunit.txt to mapunit.csv
- Edit the tabular/mapunit.csv file to add a header line
- Join the spatial and mapunit.csv and copy it to a shapefile with ogr2ogr
- Import the shapefile into the project
ogr2ogr -sql "select inshape.*, joincsv.soiltype, joincsv.hvf from inshape left join 'mapunit.csv'.joincsv on inshape.MUKEY = joincsv.mukey" \ outshape.shp \ inshape.shp inshape