This repository contains ArcGIS Tools that query soil pedons from the National Soils Information System (NASIS) and compiles a spatial dataset from them.
1
stars
1
forks
source link
The following tables have no records being retrieved from NASIS #6
This represents a pedon data dump from 12/16/2017 and the following tables with 0 records added have yet to be added to the NASIS reports - to be completed by Jason Nemecek @jneme910
Importing Pedon Data into FGDB
Table Physical Name Table Alias Name
=================================================
area Area Records Added: 0
areatype Area Type Records Added: 0
basalareatreescounted Basal Area Trees Counted Records Added: 0
beltdata Belt Data Records Added: 0
belttransectsummary Belt Transect Summary Records Added: 0
comparativeyielddata Comparative Yield Data Records Added: 0
comparativeyieldrefquadrats Comparative Yield Reference Quadrats Records Added: 0
croptreedetails Crop Tree Details Records Added: 0
croptreesubplotdetails Crop Tree Subplot Details Records Added: 0
croptreesummary Crop Tree Summary Records Added: 0
croptreetotals Crop Tree Totals Records Added: 0
daubenmirecancovclasssumm Daubenmire Canopy Cover Class Summary Records Added: 0
daubenmirecancovquaddetail Daubenmire Canopy Cover Quad Details Records Added: 0
densityquadratdetails Density Quadrat Details Records Added: 0
dwrquadratdetails Dry Weight Rank Quadrat Details Records Added: 0
ecologicalsite Ecological Site Records Added: 0
frequencyquadratdetails Frequency Quadrat Details Records Added: 0
groundcovdetails Ground Cover Details Records Added: 0
groundsurfcovdetails Ground Surface Cover Details Records Added: 0
ncsslayerlabdata NCSS Layer Lab Data Records Added: 347,248
ncsspedonlabdata NCSS Pedon Lab Data Records Added: 347,248
nestedfreqquadratdetails Nested Frequency Quadrat Details Records Added: 0
nestedfrequencysummary Nested Frequency Summary Records Added: 0
pediagfeatures Pedon Diagnostic Features Records Added: 862,656
pedon Pedon Records Added: 635,186
pedondbcolumnmetadata Pedon Database Column Metadata Records Added: 0
pedondbtablemetadata Pedon Database Table Metadata Records Added: 0
pefmp Pedon Field Measured Property Records Added: 74,530
pehydricfieldindicator Pedon Hydric Field Indicator Records Added: 9,114
peinfiltrationch Pedon Infiltration Constant Head Records Added: 0
peinfiltrationchdata Pedon Infiltration Constant Head Data Records Added: 0
peinfiltrationfh Pedon Infiltration Falling Head Records Added: 0
peinfiltrationfhdata Pedon Infiltration Falling Head Data Records Added: 0
peinfiltrationsummary Pedon Infiltration Summary Records Added: 101
pepenetrationresistance Pedon Penetration Resistance Records Added: 0
perestrictions Pedon Restrictions Records Added: 85,515
pesoilstability Pedon Soil Stability Records Added: 0
petaxhistfmmin Pedon Taxonomic History Family Mineralogy Records Added: 455,637
petaxhistmoistcl Pedon Taxonomic History Moisture Class Records Added: 358,243
petaxhistory Pedon Taxonomic History Records Added: 839,485
petext Pedon Text Records Added: 182,732
petxhistfmother Pedon Taxonomic History Family Other Criteria Records Added: 114,958
phcemagent Pedon Horizon Cementing Agent Records Added: 11,857
phcoledata Pedon Horizon COLE Data Records Added: 47
phcolor Pedon Horizon Color Records Added: 3,477,088
phconccolor Pedon Horizon Concentrations Color Records Added: 54,360
phconcs Pedon Horizon Concentrations Records Added: 365,309
phcracks Pedon Horizon Cracks Records Added: 920
phdb Pedon Horizon Bulk Density Records Added: 122,517
phdbcompliantcavity Pedon Horizon Bulk Density Compliant Cavity Records Added: 0
phdbcore Pedon Horizon Bulk Density Core Records Added: 56,039
phdbcorereading Pedon Horizon Bulk Density Core Reading Records Added: 75,995
phdbscoop Pedon Horizon Bulk Density Scoop Records Added: 31,670
phdbscoopreading Pedon Horizon Bulk Density Scoop Reading Records Added: 123,076
phdesgnsuffix Pedon Horizon Designation Suffix Records Added: 1,485,440
phfeatcolor Pedon Horizon Features Color Records Added: 4,084
phfeatures Pedon Horizon Features Records Added: 18,423
phfmp Pedon Horizon Field Measured Property Records Added: 32,241
phfrags Pedon Horizon Fragments Records Added: 1,425,574
phgrcountdata Pedon Horizon Grain Count Data Records Added: 0
phgrcountsummary Pedon Horizon Grain Count Summary Records Added: 0
phhuarts Pedon Horizon Human Artifacts Records Added: 1,591
phhydrometeranalysis Pedon Horizon Hydrometer Analysis Records Added: 634
phhydrometerdata Pedon Horizon Hydrometer Data Records Added: 2,069
phksatamoozedata Pedon Horizon Ksat Amoozemeter Data Records Added: 0
phksatamoozemeter Pedon Horizon Ksat Amoozemeter Records Added: 108
phksatring Pedon Horizon Ksat Ring Records Added: 0
phksatringdata Pedon Horizon Ksat Ring Data Records Added: 0
phksatsummary Pedon Horizon Ksat Summary Records Added: 216
phlabresults Pedon Horizon Lab Results Records Added: 177,634
phmottles Pedon Horizon Mottles Records Added: 243,101
phorizon Pedon Horizon Records Added: 2,805,867
phpores Pedon Horizon Pores Records Added: 614,498
phpvsf Pedon Horizon Ped Void Surface Features Records Added: 672,332
phpvsfcolor Pedon Horizon Ped Void Surface Features Color Records Added: 310,209
phrdxfeatures Pedon Horizon Redoximorphic Features Records Added: 719,384
phredoxfcolor Pedon Horizon Redoximorphic Features Color Records Added: 625,916
phroots Pedon Horizon Roots Records Added: 1,595,182
phsample Pedon Horizon Sample Records Added: 481,319
phstructure Pedon Horizon Soil Structure Records Added: 2,211,773
phtext Pedon Horizon Text Records Added: 537,987
phtexture Pedon Horizon Texture Records Added: 2,715,042
phtexturemod Pedon Horizon Texture Modifier Records Added: 532,061
phvnirscan Pedon Horizon VNIR Scan Records Added: 0
phvnirscanresult Pedon Horizon VNIR Scan Result Records Added: 0
plantprodquadratdetails Plant Production Quadrat Details Records Added: 0
plotdisturbance Plot Disturbance Records Added: 0
plotgrazinguse Plot Grazing Use Records Added: 0
plotmainforeststanddetails Main Forest Stand Details Records Added: 0
plotplantinventory Plot Plant Inventory Records Added: 0
plotplanttypecanopycover Plot Plant Type Canopy Cover Records Added: 0
plotsamplingprotocolused Plot Sampling Protocol Used Records Added: 0
plotspeciesbasalarea Plot Species Basal Area Records Added: 0
plottreeinventory Plot Tree Inventory Records Added: 0
plottreescounted Plot Trees Counted Records Added: 0
plottreesiteindexdetails Plot Tree Site Index Details Records Added: 0
plottreesiteindexsummary Plot Tree Site Index Summary Records Added: 0
plottreesummary Plot Tree Summary Records Added: 0
pointplantcoverdetails Point Plant Cover Details Records Added: 0
site Site Records Added: 635,186
siteaoverlap Site Area Overlap Records Added: 1,578,404
siteassoc Site Association Records Added: 0
siteassocsite Site Association Site Records Added: 0
siteassocsoi Site Associated Soils Records Added: 139,495
siteassoctext Site Association Text Records Added: 0
sitebedrock Site Bedrock Records Added: 168,271
siteecositehistory Site Ecological Site History Records Added: 35,790
siteerosionacc Site Erosion Accelerated Records Added: 37,613
sitegeomordesc Site Geomorphic Description Records Added: 736,837
siteiristubedata Site IRIS Tube Data Records Added: 25
sitemuoverlap Site Mapunit Overlap Records Added: 229,076
siteobs Site Observation Records Added: 635,186
siteobstext Site Observation Text Records Added: 134,560
siteothvegclass Site Other Vegetative Classification Records Added: 3,084
sitepm Site Parent Material Records Added: 587,043
sitesoilmoist Site Soil Moisture Records Added: 71,131
sitesoiltemp Site Soil Temperature Records Added: 30,767
sitesurffrags Site Surface Fragments Records Added: 205,190
sitetext Site Text Records Added: 89,966
sitetreescounted Site Trees Counted Records Added: 0
siteusgsquadrangleoverlap Site USGS Quadrangle Overlap Records Added: 0
sitewoodybasalarea Site Woody Basal Area Records Added: 0
soilmoistmonitordata Soil Moisture Monitor Data Records Added: 5
soilmonitordata Soil Monitor Data Records Added: 743
soiltempmonitordata Soil Temperature Monitor Data Records Added: 0
subplotplantdetails Subplot Plant Details Records Added: 0
totalquadratharvest Total Quadrat Harvest Records Added: 0
transect Transect Records Added: 210,118
transectestcomposition Transect Estimated Composition Records Added: 61,653
transectgapdetails Transect Gap Details Records Added: 0
transectgroundcover Transect Ground Cover Records Added: 0
transectgroundcoverdatalegacy Transect Ground Cover Data - Legacy Records Added: 0
transectgroundsurfcover Transect Ground Surface Cover Records Added: 0
transectoverstorycanopycover Transect Overstory Canopy Cover Records Added: 0
transectsamplingprotocolused Transect Sampling Protocol Used Records Added: 0
transectstandingbiomassdetails Transect Standing Biomass Details Records Added: 0
transecttext Transect Text Records Added: 99,723
vegplot Vegetation Plot Records Added: 0
vegplottext Vegetation Plot Text Records Added: 0
vegtransect Vegetation Transect Records Added: 0
vegtransectplantsummary Vegetation Transect Plant Summary Records Added: 0
vegtransecttext Vegetation Transect Text Records Added: 0
windbreakrowdata Windbreak Row Data Records Added: 0
This represents a pedon data dump from 12/16/2017 and the following tables with 0 records added have yet to be added to the NASIS reports - to be completed by Jason Nemecek @jneme910
Importing Pedon Data into FGDB