ncss-tech / NASIS-Pedons

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

Pedon Quality Control #9

Open jneme910 opened 6 years ago

jneme910 commented 6 years ago

The following list of potential quality control checks should first be grouped by table to maximize querying and reporting efficiency.

  1. A check for duplicate User Site IDs
  2. A check for multiple pedons same location, except for the Santa pedons.
  3. Multiple pedons with OSD checked by Soil Series
    • Pedon Table -> Pedon Type = 'OSD pedon'
  4. 1 sample per horizon

  5. find pedon with duplicate horizon depths
  6. duplicate lab sample number
  7. bottom depth null
  8. check classification fields
  9. check depths
  10. check designation fields
  11. check texture fields
  12. component pedon rv status
  13. designation master is null
  14. duplicate lat/long
  15. duplicate mapunit symbols
  16. duplicate upedonids
  17. duplicate usiteid
  18. duplicate utm locations
  19. find component coverkind crop not consistent with kind2
  20. find component cover grass not consistent with kind2
  21. find component cover trees not consistent with kind2
  22. find Cr depth not match bedrock, paralithic rest
  23. find frag. vols. >75
  24. find frag. vol. not consistent with by modifier
  25. find frag. vol. not consistent with cb modifier
  26. find frag. vol. not consistent with cn modifier
  27. find frag. vol. not consistent with gr modifier
  28. find frag. vol. not consistent with st modifier
  29. find fragment size high out of range
  30. find fragment size low out of range
  31. find horizons depth not match fragipan restrictions
  32. find horizons where hznames are equal
  33. find horizons where rv thickness not match depths
  34. find horizons with flat rock modifers and nonflat shape
  35. find horizons with flat rock modifier and nonflat sizes
  36. find horizons with fragment shape flat and nonflat size
  37. find horizons with fragment shape nonflat and flat size
  38. find horizons with nonflat rock modifers and flat shape
  39. find horizons with structure and C
  40. find landform not equal to 1
  41. find landscape not equal to 1
  42. find parent material group name not calculated
  43. find temp class not equal to temp regime
  44. longdir is east
  45. moisture class vs tax class
  46. mottles are not null
  47. nonexistent diagnostic table
  48. nonexistent horizon tables
  49. nonexistent mineralogy table
  50. nonexistent moistureclass table
  51. nonexistent parent material table
  52. nonexistent restriction table
  53. nonexistent sample table
  54. nonexistent site area overlap table
  55. nonexistent site erosion table
  56. nonexistent site geomorphic table
  57. nonexistent site mapunit overlap table
  58. nonexistent suffix table
  59. nonexistent surface fragments table
  60. null fields in color table
  61. null fields in concentrations color table
  62. null fields in concentrations table
  63. null fields in designation suffix table
  64. null fields in diagnostic table
  65. null fields in fragments table
  66. null fields in horizon table
  67. null fields in mineralogy table
  68. null fields in moisture class table
  69. null fields in pedon table
  70. null fields in pores table
  71. null fields in redox feature table
  72. null fields in redox features color table
  73. null fields in restriction table
  74. null fields in roots table
  75. null fields in site overlap table
  76. null fields in site table
  77. null fields in structure table
  78. null fields in surface fragments table
  79. null fields in texture modifier table
  80. null fields in texture table
  81. null fields in void surface features color table
  82. null fields in void surface features table
  83. pedon taxonomy not calculated
  84. phsample number is null and labnumber is not null
  85. psc bottom 102
  86. usiteid not match upedonid
jneme910 commented 6 years ago
  1. Add Soil Taxonomy Check and classify it to the first couple of levels