Replies: 1 comment 2 replies
-
|
There is a table in Soil Data Access called In general SSAs have similar/coincident boundaries with county, but some counties are split into multiple SSAs, and sometimes SSAs contain (parts of) multiple counties. You can use the There are some instances where SSAs only have a portion unmapped--it appears that these partial areas have |
Beta Was this translation helpful? Give feedback.
-
library(soilDB)
x <- SDA_query("SELECT areasymbol, sapubstatuscode, iscomplete FROM sastatusmap")
#> single result set, returning a data.frame
x2 <- x[x$iscomplete == 0, ]
x2[order(x2$areasymbol), ]
#> areasymbol sapubstatuscode iscomplete
#> 2701 AK621 0 0
#> 2700 AK623 0 0
#> 2991 AK644 2 0
#> 892 AK646 2 0
#> 2953 AK650 2 0
#> 2702 AK659 0 0
#> 660 AK693 2 0
#> 2703 AK700 0 0
#> 2704 AK701 0 0
#> 2705 AK702 0 0
#> 2706 AK703 0 0
#> 2707 AK704 0 0
#> 2708 AK705 0 0
#> 2709 AK706 0 0
#> 2710 AK707 0 0
#> 2711 AK708 0 0
#> 2712 AK709 0 0
#> 2713 AK710 0 0
#> 2714 AK711 0 0
#> 832 AK712 0 0
#> 2715 AK713 0 0
#> 2716 AK714 0 0
#> 2717 AK715 0 0
#> 2718 AK717 0 0
#> 2719 AK718 0 0
#> 2720 AK719 0 0
#> 2721 AK720 0 0
#> 2722 AK721 0 0
#> 2723 AK722 0 0
#> 2724 AK723 0 0
#> 2725 AK724 0 0
#> 2726 AK725 0 0
#> 2727 AK726 0 0
#> 3097 AK727 0 0
#> 3098 AK728 0 0
#> 3099 AK729 0 0
#> 104 AK730 0 0
#> 106 AK731 0 0
#> 107 AK732 0 0
#> 833 AK733 0 0
#> 108 AK734 0 0
#> 109 AK735 0 0
#> 111 AK736 0 0
#> 2728 AK737 0 0
#> 830 AK738 0 0
#> 2729 AK739 0 0
#> 2730 AK740 0 0
#> 1215 AK741 0 0
#> 831 AK742 0 0
#> 1216 AK743 0 0
#> 1217 AK744 0 0
#> 1218 AK745 0 0
#> 847 AK751 0 0
#> 848 AK752 0 0
#> 2869 AK754 0 0
#> 2870 AK755 0 0
#> 2871 AK756 0 0
#> 2872 AK757 0 0
#> 2873 AK764 0 0
#> 2874 AK765 0 0
#> 2875 AK766 0 0
#> 2876 AK767 0 0
#> 2877 AK768 0 0
#> 2878 AK769 0 0
#> 2879 AK770 0 0
#> 2880 AK771 0 0
#> 2881 AK772 0 0
#> 2882 AK773 0 0
#> 2883 AK774 0 0
#> 2884 AK775 0 0
#> 2885 AK776 0 0
#> 2886 AK777 0 0
#> 2887 AK778 0 0
#> 2888 AK779 0 0
#> 2889 AK781 0 0
#> 2890 AK782 0 0
#> 2891 AK789 0 0
#> 2892 AK790 0 0
#> 2893 AK791 0 0
#> 2894 AK793 0 0
#> 2895 AK794 0 0
#> 2896 AK795 0 0
#> 2897 AK796 0 0
#> 2898 AK797 0 0
#> 3343 AZ639 2 0
#> 989 AZ647 0 0
#> 1265 AZ648 0 0
#> 3348 AZ687 2 0
#> 3346 AZ691 0 0
#> 1507 AZ693 2 0
#> 3226 AZ695 0 0
#> 1338 AZ723 0 0
#> 2425 CA601 2 0
#> 128 CA663 0 0
#> 1608 CA673 2 0
#> 140 CA682 2 0
#> 145 CA695 2 0
#> 148 CA698 2 0
#> 2521 CA704 0 0
#> 160 CA732 2 0
#> 152 CA793 0 0
#> 155 CA803 2 0
#> 156 CA804 0 0
#> 1998 CA805 2 0
#> 446 CO031 0 0
#> 78 CO657 0 0
#> 1176 FL623 0 0
#> 1177 FL624 0 0
#> 1083 FL687 2 0
#> 1887 GA637 2 0
#> 1888 GA648 2 0
#> 1951 HT600 0 0
#> 1978 ID671 2 0
#> 1091 ID700 0 0
#> 1092 ID701 0 0
#> 1107 ID720 2 0
#> 2263 KY643 2 0
#> 2644 MN031 2 0
#> 1298 MN075 2 0
#> 1316 MN115 2 0
#> 2554 MT606 0 0
#> 1849 MT633 2 0
#> 2555 MT640 0 0
#> 2556 MT642 0 0
#> 1616 NH605 0 0
#> 3047 NM622 0 0
#> 3094 NM694 0 0
#> 3095 NM696 0 0
#> 3037 NV782 0 0
#> 850 NV792 0 0
#> 1029 NY109 2 0
#> 1753 NY664 2 0
#> 991 OR603 0 0
#> 1772 OR605 0 0
#> 993 OR607 2 0
#> 1773 OR608 0 0
#> 3349 OR618 0 0
#> 3238 OR622 0 0
#> 277 OR626 2 0
#> 1349 OR627 0 0
#> 181 OR631 2 0
#> 1561 OR645 2 0
#> 1378 OR657 2 0
#> 2589 OR677 2 0
#> 998 OR680 0 0
#> 1000 OR683 0 0
#> 3125 TN125 2 0
#> 1323 UT607 2 0
#> 1337 UT625 2 0
#> 1341 UT626 2 0
#> 1902 UT636 2 0
#> 1910 UT646 2 0
#> 2652 UT647 2 0
#> 1911 UT648 0 0
#> 1913 UT650 0 0
#> 1914 UT651 2 0
#> 1915 UT653 0 0
#> 3158 VT007 2 0
#> 431 WA706 0 0
#> 418 WA714 2 0
#> 444 WA730 0 0
#> 435 WA760 0 0
#> 2578 WA762 0 0
#> 3290 WI602 2 0
#> 1039 WY603 2 0
#> 1043 WY617 2 0
#> 2916 WY630 2 0
#> 668 WY661 2 0
#> 2899 WY723 2 0
#> 2900 WY737 2 0 |
Beta Was this translation helpful? Give feedback.
-
|
Super helpful! Thank you! |
Beta Was this translation helpful? Give feedback.
-
Is there an easy way to get a list of the US counties that include non-SSURGO areas, as shown in this map?
Or maybe those polygons are survey areas, not counties? Either way, a list would be very helpful.
Beta Was this translation helpful? Give feedback.
All reactions