NRCS: Difference between revisions
From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs) Created page with "USDA Natural Resource Conservation Service Soil data You can download data from their Web app (WSS) and then (in theory) view it in their desktop app (if you have MS Access)..." |
Brian Wilson (talk | contribs) mNo edit summary |
||
(3 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