NRCS: Difference between revisions

From Wildsong
Jump to navigationJump to search
← Older edit
VisualWikitext
Brian Wilson (talk | contribs)
Bureaucrats, restrict, Administrators, uploaders
11,473 edits
mNo edit summary
Brian Wilson (talk | contribs)
Bureaucrats, restrict, Administrators, uploaders
11,473 edits
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:


* So far I cannot view the data in their data viewer.
* 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


# Design areas of interest in ArcMap using shapefiles.
# Go to [https://websoilsurvey.sc.egov.usda.gov/App/WebSoilSurvey.aspx WSS]
# Create one AOI shapefile per county
# Select a county
# Use the shapefiles to define AOI in the web app. [https://websoilsurvey.sc.egov.usda.gov/App/WebSoilSurvey.aspx WSS]
# Download the data
# Download the data
# Load it into ArcMap using their extension
# 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

  1. Go to WSS
  2. Select a county
  3. Download the data
  4. Unzip it
  5. Copy the tabular/mapunit.txt to mapunit.csv
  6. Edit the tabular/mapunit.csv file to add a header line
  7. Join the spatial and mapunit.csv and copy it to a shapefile with ogr2ogr
  8. 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
Retrieved from "https://wiki.wildsong.biz//index.php?title=NRCS&oldid=10108"