select co_fips, st_pointonsurface(soil_geom.geometry) from map_soils_weps, soil_geom where map_soils_weps.musym = soil_geom.musym and map_soils_weps.mukey = soil_geom.mukey and map_soils_weps.co_fips = soil_geom.areasymbol and cokey='551660:807339';
r2gis=# select co_fips, st_x(st_centroid(soil_geom.geometry)) as x, st_y(st_centroid(soil_geom.geometry)) as y from map_soils_weps, soil_geom where map_soils_weps.musym = soil_geom.musym and map_soils_weps.mukey = soil_geom.mukey and map_soils_weps.co_fips = soil_geom.areasymbol and cokey='551660:807339';

select co_fips, count(soil_geom.geometry) 
from map_soils_weps, soil_geom
where map_soils_weps.musym = soil_geom.musym 
and map_soils_weps.mukey = soil_geom.mukey
and map_soils_weps.co_fips = soil_geom.areasymbol 
and cokey in ('551660:807339', '887050:1185340', '577749:1183015', '648688:1184822', '184118:281262', '807185:1309934', '106695:158138', '290320:331847', '825389:894527', '1858873:1665392', '296061:330613', '490474:700491', '63750:81364', '150740:212639', '2371515:648562', '2388922:1777572', '82469:120629', '68187:94898', '183901:913872', '886795:1586052', '1452662:1298507', '458473:621106', '173885:253569', '352865:473173', '470652:663701', '1427196:886547', '469544:92043', '154927:224901', '346008:438182', '83009:122718', '486998:694853', '632890:893825', '537117:775612', '159729:236918', '130068:184082', '484692:689990', '556322:814218', '342993:428481', '497489:728573', '1697503:1473385', '399440:529168', '465287:643234', '62374:78065', '1588831:1650585', '337560:1667029', '1603444:1454658', '2217160:585074', '94173:140463', '292729:345419', '485257:691603', '2424286:1811565', '398694:535408', '1380664:136125', '490699:701367', '501968:736742', '78302:108948', '331415:376187', '184938:244742', '187823:1845844', '356204:464330', '135376:1225310', '427611:585544', '461710:632232', '1861729:1662721', '382385:507299', '521178:1069880', '1529926:1189774', '699581:1073875', '1427835:267701', '140111:1102981', '110423:157378', '417079:570513', '190673:1403337', '816787:324181', '119282:1086579', '625299:899584', '407454:550655', '376197:504166', '1381704:516673', '447574:1254975', '741454:230819', '809245:1172464', '336912:1667584', '539196:779539', '73260:100904', '56193:59940', '2462220:1854075', '470545:664616', '2228260:162086', '2474879:1860548', '489115:698856', '644430:924177', '432696:593714', '58285:66190', '1596092:1381019', '510579:724829', '1154001:1241659', '1901570:738908', '1603138:400596', '396224:530963', '132299:186859', '343013:428510', '417517:567818', '348534:446372', '1468842:135410', '1407804:351207', '355916:474375', '526422:764915', '429744:589845', '62012:76512', '777390:847533', '712004:1260140', '352855:473123', '551262:806304', '54440:56303', '344168:431159', '130596:184736', '1531748:1397791', '2486211:1366459', '404762:546293', '68487:95379', '535522:1364943', '210524:288006', '183414:265332', '406256:548671', '289590:327950', '992987:1189411', '2108905:265360', '117479:1345476', '354734:463498', '171484:250548', '165193:243573', '396308:531025', '118829:1074300', '286088:321178', '681011:284612', '462683:636011', '345436:436084', '1384406:1254589', '462804:636402', '1150952:138633', '284504:312933', '146608:234303', '994301:1183870', '1676464:1258509', '482141:686751', '574058:1260162', '349433:449457', '94948:142791', '187561:1819014', '415213:565801', '2515673:1689328', '2228898:162069', '189102:272363', '344022:430839', '958983:1424510', '78036:129357', '354590:461605', '65107:88650', '76359:105941', '397462:529765', '471652:662836', '427894:585779', '1699359:150619', '330768:377963', '1507981:652676', '1385725:104887', '2217168:585066', '2250466:1687749', '1861125:1662244', '356264:462079', '184547:1248032', '245029:278365', '94730:142303', '353817:467604', '798390:1157457', '1904130:1366474', '154566:223949', '169000:246472', '537814:776325', '94720:142275', '1020159:1206515', '1451369:491008', '2494111:1892399', '1537460:1401626', '354324:473891', '144412:196590', '616289:874161', '513958:752014', '1528925:1340397', '518424:1061516', '154065:222067', '506718:732750', '2025102:1737358', '1426897:858846', '105459:156412', '553321:812955', '53363:54963', '1014558:1204881', '2379469:1773168', '341663:1531647', '469650:658059', '80005:1257970', '458191:619991', '1483175:1325609', '514413:752629', '429077:588367', '1715704:1764664', '992808:1671720', '1480328:138934', '469793:656905', '406330:548827', '416578:572770', '283218:311170', '2420531:1716756', '1910250:1221996', '403780:544552', '1507901:652535', '413425:1427524', '320371:1483733', '497132:726775', '161432:239346', '623415:506577', '483341:688404', '552713:810203', '499264:1453567', '740154:923149', '52254:53872', '416593:1066066', '135425:1230678', '582043:194386', '488019:695819', '352193:456569', '395463:603050', '294083:352964', '451010:1098224', '413413:1427747', '455492:609398', '188091:270931', '292581:344682', '1444065:1328341', '406987:550198', '2230258:1374816', '482725:687726', '886938:1200757', '995690:1191213', '779883:618752', '507884:746738', '397442:529695', '160992:238706', '80501:113496', '1603650:1480275', '2437033:1708965', '525280:763810', '415114:565747', '567617:1372814', '187704:270404', '272622:237708', '517058:1105725', '81332:116925', '354311:926653', '630149:889584', '456626:612674', '399252:536820', '462115:634450', '413262:594385', '460767:629375', '156828:939986', '187895:270672', '49339:47091', '244837:284442', '61774:75703', '1588598:1662892', '1528397:1190510', '639214:908309', '356197:464280', '408926:553289', '522853:761072', '640617:1180073', '282543:309072', '159624:236880', '888428:1402338', '466045:644969', '79547:111150', '537842:776360', '188277:271167', '825385:894505', '1714797:1596305', '2440762:1798093', '427669:585632', '459016:624436', '975448:1193470', '2219760:147309', '1699803:152280', '700439:1075054', '65091:86813', '355325:470536', '1860598:1656230', '294475:355197', '505426:743736', '1152104:137805', '361098:481058', '505190:746970', '2437459:1604391', '198849:284020', '355766:466655', '642153:1241533', '463256:637628', '817734:1379572', '295157:357763', '487254:695104', '1150754:137816', '2219727:147406', '356720:460701', '332080:382908', '459001:622809', '1152291:162484', '506744:732593', '995595:1183225', '61575:74713', '515785:754087', '79501:111026', '95481:144708', '347117:441276', '61657:75107', '404345:545527', '2377556:226279', '352662:458903', '375802:502528', '155748:227355', '1412786:1186673', '145326:198092', '168437:246095', '355877:473608', '482681:687660', '1904539:1718610', '155340:225989', '616093:1097523', '286795:322866', '292005:341589', '1385509:95187', '462307:635389', '68035:94274', '354615:470142', '2217280:584363', '186290:268073', '2217288:585723', '725839:619300', '496430:724505', '67196:94027', '537823:776338', '347405:442537', '2422605:1315908', '482435:687166', '409273:553914', '341027:1619288', '502187:736789', '471268:666497', '293005:1207421', '1699347:150593', '1869052:1689462', '106548:157933', '1482169:1402329', '1474180:1355626', '347563:442942', '150909:213551', '345958:438041', '212464:270054', '104603:154233', '2108955:776373', '188247:271121', '1588834:1650589', '409163:553635', '2403885:1720445', '518831:757189', '2440701:1796871', '482675:687651', '186545:1845686', '515812:754129', '994093:1198255', '2436979:1704683', '77261:107398', '1152360:135813', '345933:437963', '467957:650447', '186883:1846084', '187598:1819409', '337761:1679662', '356722:460712', '60924:71785', '2024054:884567', '160710:238370', '504033:741359', '188385:271311', '190177:274050', '2108922:265294', '463166:637439', '80242:112860', '343426:429455', '471646:662826', '516537:1090295', '464885:642380', '484803:690151', '336987:1681767', '100240:149971', '189859:273631', '54386:56221', '189046:272275', '1692626:151953', '553864:812345', '2229683:1395283', '2229372:1761868', '120523:1075937', '186380:268222', '458777:622218', '1724583:1615653', '635622:900354', '162974:1374575', '172122:251551', '66945:91199', '464608:641715', '1425973:86370', '618695:875875', '2219776:147665', '272659:239794', '182192:264601', '1912723:1176463', '1670106:642528', '567271:827265', '357465:476500', '410269:555939', '382086:511627', '2420286:1466300', '445578:569900', '457970:619083', '1861057:1659877', '1407277:1303131', '816783:324177', '2453158:193918', '1143990:284625', '67749:94647', '544912:791894', '189861:273634', '352650:458874', '2023829:1734970', '543211:790457', '54004:55864', '469750:656541', '184759:1246175', '76154:106181', '481857:686444', '76692:1051048', '395251:527534', '149383:206462', '340229:1662149', '2377846:1777669', '71474:99163', '416107:566765', '417314:571869', '2422524:1808392', '375765:502340', '291684:339758', '344040:430885', '461144:631875', '412077:559197', '57667:65572', '503829:740925', '816777:324170', '1587413:1119477', '356557:459941', '242381:280968', '461017:630269', '357791:477007', '487524:695441', '355915:474371', '412083:559207', '183146:265229', '346682:439697', '63122:81248', '1144403:1210308', '169089:246262', '402194:541780', '191297:275443', '406274:548729', '53963:55819', '188027:270845', '1152171:134561', '1711683:1693434', '2423381:1813351', '397258:533171', '711883:1259904', '490645:701201', '301321:343778', '460553:628978', '75736:105201', '400596:538336', '345860:437709', '343624:429788', '457610:617671', '351874:1679900', '188396:271323', '75797:1564462', '126278:179530', '168512:246051', '395332:1340531', '381738:507020', '2437268:1606781', '71104:98577', '1390118:1166363', '75861:1565172', '569753:1542791', '1482797:1205197', '186339:268176', '114077:1845101', '789852:295981', '487564:695496', '262328:265314', '402365:542037', '417259:571597', '457371:616858', '348252:445639', '456128:612360', '285679:319419', '1381572:1678703', '262428:874152', '154198:222352', '467163:659640', '2216107:148159', '69218:96427', '354244:1052700', '348054:444154', '457697:618037', '169320:246837', '162313:1393219', '119470:171646', '287783:324065', '147369:203820', '1861728:1659629', '506771:732482', '68629:95791', '295347:358763', '825383:323954', '356434:459273', '1479640:1356036', '2218730:151107', '1912474:1727784', '171755:251011', '455434:1788365', '285984:321965', '487578:695508', '190822:275174', '544076:790882', '152723:218514', '2507860:1902022', '1407931:1458233', '354578:461541', '292658:345052', '55632:57649', '1459270:1349775', '297079:1675982', '1860832:1682091', '1475350:134349', '1702958:196629', '399791:1258863', '344057:430928', '2025138:1737070', '565960:825104', '345646:436903', '2423378:1812618', '2400834:1449390', '398974:536073', '456428:613224', '54492:56370', '94721:142279', '84636:126810', '56943:62910', '1713613:1653236', '410147:555656', '115640:1199178', '620187:207270', '1946662:445186', '295291:358476', '2479801:1274591', '471170:666083', '168557:245943', '62262:77070', '2437272:1724126', '376910:520068', '496658:725253', '355442:474211', '1468829:135370', '464055:640199', '75879:857640', '1912788:1422386', '817734:1171057', '198816:281184', '1473296:1354843', '1543913:1421355', '463706:638961', '190595:274822', '295973:362168', '457246:616153', '470922:664210', '353456:470084', '571647:835505', '147706:204766', '120445:1077504', '199128:874118', '81006:114461', '355999:916699', '459623:625802', '243001:281188', '1692001:148264', '1382492:516619', '346613:440066', '564583:822285', '403828:544660', '813988:626824', '471040:660231', '468417:650952', '504231:741706', '184773:1319747', '56954:62485', '187553:1818972', '78321:109404', '2406910:1753536', '117437:1294906', '426914:584582', '333122:383761', '119316:928119', '289425:327173', '396561:532026', '241399:1401968', '354261:464934', '482655:687610', '353256:463208', '1385733:104898', '481390:685273', '96884:145452', '567429:827517', '397090:533451', '1542507:1351142', '1089437:1216833', '2474889:1860434', '418253:568222', '191993:1846463', '403470:543848', '2434718:1835182', '813833:625623', '578646:1239645', '174871:254619', '294744:356370', '56323:60313', '1857714:1560088', '345783:437437', '411775:558610', '78261:108785', '548121:1461350', '74014:102493', '161806:240098', '553843:812249', '79097:109937', '354220:464736', '1900095:1708854', '69806:97218', '482581:687437', '483317:688375', '435050:910721', '64108:82893', '115977:1201298', '2228211:162887', '470225:664788', '1912680:229425', '460925:629944', '2217312:1462141', '1903412:1716408', '100611:150813', '1677541:1363405', '352589:458650', '341857:424396', '186483:268336', '550918:804626', '81071:114401', '360302:1666738', '211759:255081', '1868123:751989', '1382093:137435', '1601003:265280', '111209:1172371', '199184:284398', '118978:1082949', '899769:1188461', '486956:694802', '1653635:588801', '331229:381108', '2219336:146145', '2023929:1769588', '79540:111001', '81271:115884', '1603506:1274589', '64490:84753', '436722:600797', '54481:56428', '797956:1255980', '542784:788555', '485995:692767', '1670188:637670', '1145510:1268739', '1723564:1671471', '467823:650304', '186185:267944', '550189:802487', '1720660:1608919', '54396:56234', '482214:686864', '55555:57478', '1606126:1212457', '2216654:585630', '341324:1666451', '84579:126562', '156494:1176145', '1669822:153972', '81509:163441', '695333:175497', '2485528:899871', '415985:566743', '385274:506147', '191634:275671', '467006:646473', '189081:272328', '517288:1090222', '82502:120138', '574565:1186674', '522099:760061', '457609:617666', '562845:770318', '518468:1061585', '887291:1245073', '375581:501299', '416124:566792', '1413785:250915', '462150:634687', '490723:701458', '147796:205063', '470358:663071', '1591121:890479', '570517:833288', '83954:1214032', '83258:122659', '1150695:139090', '1017797:1145161', '78242:108718', '106390:157752', '515825:754146', '79121:109979', '120908:928677', '1381276:516769', '188763:271826', '309500:1141881', '64122:82914', '1606053:1432184', '153265:220141', '516518:1132879', '635624:900360', '497928:729860', '459227:624018', '1882857:779630', '170929:249600', '1473455:138886', '406354:548914', '112793:1330581', '648693:1186700', '464611:641723', '244919:280006', '59723:879527', '111299:163838', '82365:119862', '1606020:1274672', '464933:642460', '171853:251168', '2436310:229240', '94533:141496', '526269:764752', '396338:531237', '397301:533269', '536487:774765', '2437354:1603944', '2397958:1785360', '119168:1081398', '171284:250207', '548129:1461356', '1669770:1071255', '402694:542424', '1704484:1566350', '282524:309609', '1014555:1217047', '323199:397352', '83097:122859', '887104:1183031', '1420578:251414', '506244:745323', '170224:248368', '347932:444616', '457268:616336', '309733:347462', '1384977:1301667', '417051:570384', '160203:283326', '170277:248464', '309551:345788', '174135:285637', '1907896:1686927', '1653786:152207', '505486:743971', '58055:71253', '249072:243396', '435853:599303', '536629:774966', '2420761:193916', '1612923:238903', '188459:271407', '110409:157313', '284808:314692', '336592:390147', '1387178:163156', '1692156:151038', '82483:120683', '517472:1115240', '748988:1413353', '2432660:1828334', '696147:1069447', '398262:534467', '1857498:247915', '404161:545203', '2452985:1849635', '2422502:1845900', '52702:54236', '53324:54907', '76150:105779', '95536:144865', '83838:123912', '753210:1178926', '516259:754650', '1528414:1188765', '1592408:1178059', '459612:625721', '458921:622683', '2496278:1835755', '695403:1091361', '2216406:587661', '242961:278672', '78253:108755', '84825:126011', '145923:200957', '1910177:1728724', '345288:434982', '272548:237788', '466789:654961', '519246:1094261', '1384617:451467', '74612:103540', '1710138:229142', '481664:685700', '1861624:1659582', '497359:1811685', '75633:105065', '886632:1194658', '465280:643215', '457049:615104', '345642:436886', '67083:90589', '164299:242735', '65082:88500', '116782:166894', '1861584:1658933', '426959:584786', '151091:214502', '410136:555638', '75901:105514', '79304:110143', '1899972:847565', '64516:84918', '428966:588215', '293073:347304', '341873:424441', '503736:740735', '350824:452109', '1677040:589030', '56069:58957', '406518:549150', '1589046:1682379', '629749:745322', '193297:277457', '162557:240956', '1387201:1266890', '53344:54935', '1898197:1741777', '1023361:884987', '2504827:664874', '157188:230819', '79087:109918', '2485923:1872246', '894204:1183153', '1720823:245507', '179684:261421', '467101:647099', '345478:436220', '465094:642770', '464719:641994', '417258:571589', '352499:1659642', '2479637:1724747', '397771:531769', '497529:728636', '465049:642689', '1718337:1651305', '349942:451245', '355764:466644', '629981:744185', '817643:480741', '520761:1064255', '887822:1191321', '2437898:1845984', '409252:553762', '76784:106879', '182193:264602', '403450:543844', '105288:156008', '352664:458906', '84674:126967', '520709:1064138', '456599:612575', '79609:111752', '82139:119166', '95456:144630', '212436:270016', '119623:171774', '482740:687750', '352695:459003', '431502:592770', '456610:612618', '1444989:904125', '408012:551749', '549652:800654', '407995:551717', '455972:613811', '1868828:645064', '187748:270456', '362389:1463180', '184827:1183897', '704314:1076805', '1398045:774405', '146569:227259', '887006:1245390', '728433:1055641', '130996:185178', '1153281:1984448', '1455126:1342275', '1946784:1755277', '403225:543356', '346255:439434', '62237:76967', '2420269:1789838', '1713673:1664566', '463904:639656', '131167:185381', '291924:341058', '119001:1086207', '375761:502320', '294772:356402', '287736:324013', '1651412:1732041', '537445:775989', '639255:1198751', '383029:515515', '536986:775414', '209033:259697', '608933:1286689', '505522:744104', '151048:214308', '99743:149092', '188892:272095', '345716:437191', '514580:752902', '294200:353637', '1480079:135448', '634377:265343', '338513:1674999', '146765:202842', '159963:244389', '330072:376391', '56564:61177', '405654:547661', '191882:276086', '2486279:205769', '94412:141152', '348000:444914', '2480937:1728424', '507822:746508', '355237:465687', '316592:337407', '353833:467667', '301683:338586', '417736:569281', '150544:211454', '547101:1208061')
group by co_fips;

insert into jims_soils (cokey)
values 
('551660:807339', '887050:1185340', '577749:1183015', '648688:1184822', '184118:281262', '807185:1309934', '106695:158138', '290320:331847', '825389:894527', '1858873:1665392', '296061:330613', '490474:700491', '63750:81364', '150740:212639', '2371515:648562', '2388922:1777572', '82469:120629', '68187:94898', '183901:913872', '886795:1586052', '1452662:1298507', '458473:621106', '173885:253569', '352865:473173', '470652:663701', '1427196:886547', '469544:92043', '154927:224901', '346008:438182', '83009:122718', '486998:694853', '632890:893825', '537117:775612', '159729:236918', '130068:184082', '484692:689990', '556322:814218', '342993:428481', '497489:728573', '1697503:1473385', '399440:529168', '465287:643234', '62374:78065', '1588831:1650585', '337560:1667029', '1603444:1454658', '2217160:585074', '94173:140463', '292729:345419', '485257:691603', '2424286:1811565', '398694:535408', '1380664:136125', '490699:701367', '501968:736742', '78302:108948', '331415:376187', '184938:244742', '187823:1845844', '356204:464330', '135376:1225310', '427611:585544', '461710:632232', '1861729:1662721', '382385:507299', '521178:1069880', '1529926:1189774', '699581:1073875', '1427835:267701', '140111:1102981', '110423:157378', '417079:570513', '190673:1403337', '816787:324181', '119282:1086579', '625299:899584', '407454:550655', '376197:504166', '1381704:516673', '447574:1254975', '741454:230819', '809245:1172464', '336912:1667584', '539196:779539', '73260:100904', '56193:59940', '2462220:1854075', '470545:664616', '2228260:162086', '2474879:1860548', '489115:698856', '644430:924177', '432696:593714', '58285:66190', '1596092:1381019', '510579:724829', '1154001:1241659', '1901570:738908', '1603138:400596', '396224:530963', '132299:186859', '343013:428510', '417517:567818', '348534:446372', '1468842:135410', '1407804:351207', '355916:474375', '526422:764915', '429744:589845', '62012:76512', '777390:847533', '712004:1260140', '352855:473123', '551262:806304', '54440:56303', '344168:431159', '130596:184736', '1531748:1397791', '2486211:1366459', '404762:546293', '68487:95379', '535522:1364943', '210524:288006', '183414:265332', '406256:548671', '289590:327950', '992987:1189411', '2108905:265360', '117479:1345476', '354734:463498', '171484:250548', '165193:243573', '396308:531025', '118829:1074300', '286088:321178', '681011:284612', '462683:636011', '345436:436084', '1384406:1254589', '462804:636402', '1150952:138633', '284504:312933', '146608:234303', '994301:1183870', '1676464:1258509', '482141:686751', '574058:1260162', '349433:449457', '94948:142791', '187561:1819014', '415213:565801', '2515673:1689328', '2228898:162069', '189102:272363', '344022:430839', '958983:1424510', '78036:129357', '354590:461605', '65107:88650', '76359:105941', '397462:529765', '471652:662836', '427894:585779', '1699359:150619', '330768:377963', '1507981:652676', '1385725:104887', '2217168:585066', '2250466:1687749', '1861125:1662244', '356264:462079', '184547:1248032', '245029:278365', '94730:142303', '353817:467604', '798390:1157457', '1904130:1366474', '154566:223949', '169000:246472', '537814:776325', '94720:142275', '1020159:1206515', '1451369:491008', '2494111:1892399', '1537460:1401626', '354324:473891', '144412:196590', '616289:874161', '513958:752014', '1528925:1340397', '518424:1061516', '154065:222067', '506718:732750', '2025102:1737358', '1426897:858846', '105459:156412', '553321:812955', '53363:54963', '1014558:1204881', '2379469:1773168', '341663:1531647', '469650:658059', '80005:1257970', '458191:619991', '1483175:1325609', '514413:752629', '429077:588367', '1715704:1764664', '992808:1671720', '1480328:138934', '469793:656905', '406330:548827', '416578:572770', '283218:311170', '2420531:1716756', '1910250:1221996', '403780:544552', '1507901:652535', '413425:1427524', '320371:1483733', '497132:726775', '161432:239346', '623415:506577', '483341:688404', '552713:810203', '499264:1453567', '740154:923149', '52254:53872', '416593:1066066', '135425:1230678', '582043:194386', '488019:695819', '352193:456569', '395463:603050', '294083:352964', '451010:1098224', '413413:1427747', '455492:609398', '188091:270931', '292581:344682', '1444065:1328341', '406987:550198', '2230258:1374816', '482725:687726', '886938:1200757', '995690:1191213', '779883:618752', '507884:746738', '397442:529695', '160992:238706', '80501:113496', '1603650:1480275', '2437033:1708965', '525280:763810', '415114:565747', '567617:1372814', '187704:270404', '272622:237708', '517058:1105725', '81332:116925', '354311:926653', '630149:889584', '456626:612674', '399252:536820', '462115:634450', '413262:594385', '460767:629375', '156828:939986', '187895:270672', '49339:47091', '244837:284442', '61774:75703', '1588598:1662892', '1528397:1190510', '639214:908309', '356197:464280', '408926:553289', '522853:761072', '640617:1180073', '282543:309072', '159624:236880', '888428:1402338', '466045:644969', '79547:111150', '537842:776360', '188277:271167', '825385:894505', '1714797:1596305', '2440762:1798093', '427669:585632', '459016:624436', '975448:1193470', '2219760:147309', '1699803:152280', '700439:1075054', '65091:86813', '355325:470536', '1860598:1656230', '294475:355197', '505426:743736', '1152104:137805', '361098:481058', '505190:746970', '2437459:1604391', '198849:284020', '355766:466655', '642153:1241533', '463256:637628', '817734:1379572', '295157:357763', '487254:695104', '1150754:137816', '2219727:147406', '356720:460701', '332080:382908', '459001:622809', '1152291:162484', '506744:732593', '995595:1183225', '61575:74713', '515785:754087', '79501:111026', '95481:144708', '347117:441276', '61657:75107', '404345:545527', '2377556:226279', '352662:458903', '375802:502528', '155748:227355', '1412786:1186673', '145326:198092', '168437:246095', '355877:473608', '482681:687660', '1904539:1718610', '155340:225989', '616093:1097523', '286795:322866', '292005:341589', '1385509:95187', '462307:635389', '68035:94274', '354615:470142', '2217280:584363', '186290:268073', '2217288:585723', '725839:619300', '496430:724505', '67196:94027', '537823:776338', '347405:442537', '2422605:1315908', '482435:687166', '409273:553914', '341027:1619288', '502187:736789', '471268:666497', '293005:1207421', '1699347:150593', '1869052:1689462', '106548:157933', '1482169:1402329', '1474180:1355626', '347563:442942', '150909:213551', '345958:438041', '212464:270054', '104603:154233', '2108955:776373', '188247:271121', '1588834:1650589', '409163:553635', '2403885:1720445', '518831:757189', '2440701:1796871', '482675:687651', '186545:1845686', '515812:754129', '994093:1198255', '2436979:1704683', '77261:107398', '1152360:135813', '345933:437963', '467957:650447', '186883:1846084', '187598:1819409', '337761:1679662', '356722:460712', '60924:71785', '2024054:884567', '160710:238370', '504033:741359', '188385:271311', '190177:274050', '2108922:265294', '463166:637439', '80242:112860', '343426:429455', '471646:662826', '516537:1090295', '464885:642380', '484803:690151', '336987:1681767', '100240:149971', '189859:273631', '54386:56221', '189046:272275', '1692626:151953', '553864:812345', '2229683:1395283', '2229372:1761868', '120523:1075937', '186380:268222', '458777:622218', '1724583:1615653', '635622:900354', '162974:1374575', '172122:251551', '66945:91199', '464608:641715', '1425973:86370', '618695:875875', '2219776:147665', '272659:239794', '182192:264601', '1912723:1176463', '1670106:642528', '567271:827265', '357465:476500', '410269:555939', '382086:511627', '2420286:1466300', '445578:569900', '457970:619083', '1861057:1659877', '1407277:1303131', '816783:324177', '2453158:193918', '1143990:284625', '67749:94647', '544912:791894', '189861:273634', '352650:458874', '2023829:1734970', '543211:790457', '54004:55864', '469750:656541', '184759:1246175', '76154:106181', '481857:686444', '76692:1051048', '395251:527534', '149383:206462', '340229:1662149', '2377846:1777669', '71474:99163', '416107:566765', '417314:571869', '2422524:1808392', '375765:502340', '291684:339758', '344040:430885', '461144:631875', '412077:559197', '57667:65572', '503829:740925', '816777:324170', '1587413:1119477', '356557:459941', '242381:280968', '461017:630269', '357791:477007', '487524:695441', '355915:474371', '412083:559207', '183146:265229', '346682:439697', '63122:81248', '1144403:1210308', '169089:246262', '402194:541780', '191297:275443', '406274:548729', '53963:55819', '188027:270845', '1152171:134561', '1711683:1693434', '2423381:1813351', '397258:533171', '711883:1259904', '490645:701201', '301321:343778', '460553:628978', '75736:105201', '400596:538336', '345860:437709', '343624:429788', '457610:617671', '351874:1679900', '188396:271323', '75797:1564462', '126278:179530', '168512:246051', '395332:1340531', '381738:507020', '2437268:1606781', '71104:98577', '1390118:1166363', '75861:1565172', '569753:1542791', '1482797:1205197', '186339:268176', '114077:1845101', '789852:295981', '487564:695496', '262328:265314', '402365:542037', '417259:571597', '457371:616858', '348252:445639', '456128:612360', '285679:319419', '1381572:1678703', '262428:874152', '154198:222352', '467163:659640', '2216107:148159', '69218:96427', '354244:1052700', '348054:444154', '457697:618037', '169320:246837', '162313:1393219', '119470:171646', '287783:324065', '147369:203820', '1861728:1659629', '506771:732482', '68629:95791', '295347:358763', '825383:323954', '356434:459273', '1479640:1356036', '2218730:151107', '1912474:1727784', '171755:251011', '455434:1788365', '285984:321965', '487578:695508', '190822:275174', '544076:790882', '152723:218514', '2507860:1902022', '1407931:1458233', '354578:461541', '292658:345052', '55632:57649', '1459270:1349775', '297079:1675982', '1860832:1682091', '1475350:134349', '1702958:196629', '399791:1258863', '344057:430928', '2025138:1737070', '565960:825104', '345646:436903', '2423378:1812618', '2400834:1449390', '398974:536073', '456428:613224', '54492:56370', '94721:142279', '84636:126810', '56943:62910', '1713613:1653236', '410147:555656', '115640:1199178', '620187:207270', '1946662:445186', '295291:358476', '2479801:1274591', '471170:666083', '168557:245943', '62262:77070', '2437272:1724126', '376910:520068', '496658:725253', '355442:474211', '1468829:135370', '464055:640199', '75879:857640', '1912788:1422386', '817734:1171057', '198816:281184', '1473296:1354843', '1543913:1421355', '463706:638961', '190595:274822', '295973:362168', '457246:616153', '470922:664210', '353456:470084', '571647:835505', '147706:204766', '120445:1077504', '199128:874118', '81006:114461', '355999:916699', '459623:625802', '243001:281188', '1692001:148264', '1382492:516619', '346613:440066', '564583:822285', '403828:544660', '813988:626824', '471040:660231', '468417:650952', '504231:741706', '184773:1319747', '56954:62485', '187553:1818972', '78321:109404', '2406910:1753536', '117437:1294906', '426914:584582', '333122:383761', '119316:928119', '289425:327173', '396561:532026', '241399:1401968', '354261:464934', '482655:687610', '353256:463208', '1385733:104898', '481390:685273', '96884:145452', '567429:827517', '397090:533451', '1542507:1351142', '1089437:1216833', '2474889:1860434', '418253:568222', '191993:1846463', '403470:543848', '2434718:1835182', '813833:625623', '578646:1239645', '174871:254619', '294744:356370', '56323:60313', '1857714:1560088', '345783:437437', '411775:558610', '78261:108785', '548121:1461350', '74014:102493', '161806:240098', '553843:812249', '79097:109937', '354220:464736', '1900095:1708854', '69806:97218', '482581:687437', '483317:688375', '435050:910721', '64108:82893', '115977:1201298', '2228211:162887', '470225:664788', '1912680:229425', '460925:629944', '2217312:1462141', '1903412:1716408', '100611:150813', '1677541:1363405', '352589:458650', '341857:424396', '186483:268336', '550918:804626', '81071:114401', '360302:1666738', '211759:255081', '1868123:751989', '1382093:137435', '1601003:265280', '111209:1172371', '199184:284398', '118978:1082949', '899769:1188461', '486956:694802', '1653635:588801', '331229:381108', '2219336:146145', '2023929:1769588', '79540:111001', '81271:115884', '1603506:1274589', '64490:84753', '436722:600797', '54481:56428', '797956:1255980', '542784:788555', '485995:692767', '1670188:637670', '1145510:1268739', '1723564:1671471', '467823:650304', '186185:267944', '550189:802487', '1720660:1608919', '54396:56234', '482214:686864', '55555:57478', '1606126:1212457', '2216654:585630', '341324:1666451', '84579:126562', '156494:1176145', '1669822:153972', '81509:163441', '695333:175497', '2485528:899871', '415985:566743', '385274:506147', '191634:275671', '467006:646473', '189081:272328', '517288:1090222', '82502:120138', '574565:1186674', '522099:760061', '457609:617666', '562845:770318', '518468:1061585', '887291:1245073', '375581:501299', '416124:566792', '1413785:250915', '462150:634687', '490723:701458', '147796:205063', '470358:663071', '1591121:890479', '570517:833288', '83954:1214032', '83258:122659', '1150695:139090', '1017797:1145161', '78242:108718', '106390:157752', '515825:754146', '79121:109979', '120908:928677', '1381276:516769', '188763:271826', '309500:1141881', '64122:82914', '1606053:1432184', '153265:220141', '516518:1132879', '635624:900360', '497928:729860', '459227:624018', '1882857:779630', '170929:249600', '1473455:138886', '406354:548914', '112793:1330581', '648693:1186700', '464611:641723', '244919:280006', '59723:879527', '111299:163838', '82365:119862', '1606020:1274672', '464933:642460', '171853:251168', '2436310:229240', '94533:141496', '526269:764752', '396338:531237', '397301:533269', '536487:774765', '2437354:1603944', '2397958:1785360', '119168:1081398', '171284:250207', '548129:1461356', '1669770:1071255', '402694:542424', '1704484:1566350', '282524:309609', '1014555:1217047', '323199:397352', '83097:122859', '887104:1183031', '1420578:251414', '506244:745323', '170224:248368', '347932:444616', '457268:616336', '309733:347462', '1384977:1301667', '417051:570384', '160203:283326', '170277:248464', '309551:345788', '174135:285637', '1907896:1686927', '1653786:152207', '505486:743971', '58055:71253', '249072:243396', '435853:599303', '536629:774966', '2420761:193916', '1612923:238903', '188459:271407', '110409:157313', '284808:314692', '336592:390147', '1387178:163156', '1692156:151038', '82483:120683', '517472:1115240', '748988:1413353', '2432660:1828334', '696147:1069447', '398262:534467', '1857498:247915', '404161:545203', '2452985:1849635', '2422502:1845900', '52702:54236', '53324:54907', '76150:105779', '95536:144865', '83838:123912', '753210:1178926', '516259:754650', '1528414:1188765', '1592408:1178059', '459612:625721', '458921:622683', '2496278:1835755', '695403:1091361', '2216406:587661', '242961:278672', '78253:108755', '84825:126011', '145923:200957', '1910177:1728724', '345288:434982', '272548:237788', '466789:654961', '519246:1094261', '1384617:451467', '74612:103540', '1710138:229142', '481664:685700', '1861624:1659582', '497359:1811685', '75633:105065', '886632:1194658', '465280:643215', '457049:615104', '345642:436886', '67083:90589', '164299:242735', '65082:88500', '116782:166894', '1861584:1658933', '426959:584786', '151091:214502', '410136:555638', '75901:105514', '79304:110143', '1899972:847565', '64516:84918', '428966:588215', '293073:347304', '341873:424441', '503736:740735', '350824:452109', '1677040:589030', '56069:58957', '406518:549150', '1589046:1682379', '629749:745322', '193297:277457', '162557:240956', '1387201:1266890', '53344:54935', '1898197:1741777', '1023361:884987', '2504827:664874', '157188:230819', '79087:109918', '2485923:1872246', '894204:1183153', '1720823:245507', '179684:261421', '467101:647099', '345478:436220', '465094:642770', '464719:641994', '417258:571589', '352499:1659642', '2479637:1724747', '397771:531769', '497529:728636', '465049:642689', '1718337:1651305', '349942:451245', '355764:466644', '629981:744185', '817643:480741', '520761:1064255', '887822:1191321', '2437898:1845984', '409252:553762', '76784:106879', '182193:264602', '403450:543844', '105288:156008', '352664:458906', '84674:126967', '520709:1064138', '456599:612575', '79609:111752', '82139:119166', '95456:144630', '212436:270016', '119623:171774', '482740:687750', '352695:459003', '431502:592770', '456610:612618', '1444989:904125', '408012:551749', '549652:800654', '407995:551717', '455972:613811', '1868828:645064', '187748:270456', '362389:1463180', '184827:1183897', '704314:1076805', '1398045:774405', '146569:227259', '887006:1245390', '728433:1055641', '130996:185178', '1153281:1984448', '1455126:1342275', '1946784:1755277', '403225:543356', '346255:439434', '62237:76967', '2420269:1789838', '1713673:1664566', '463904:639656', '131167:185381', '291924:341058', '119001:1086207', '375761:502320', '294772:356402', '287736:324013', '1651412:1732041', '537445:775989', '639255:1198751', '383029:515515', '536986:775414', '209033:259697', '608933:1286689', '505522:744104', '151048:214308', '99743:149092', '188892:272095', '345716:437191', '514580:752902', '294200:353637', '1480079:135448', '634377:265343', '338513:1674999', '146765:202842', '159963:244389', '330072:376391', '56564:61177', '405654:547661', '191882:276086', '2486279:205769', '94412:141152', '348000:444914', '2480937:1728424', '507822:746508', '355237:465687', '316592:337407', '353833:467667', '301683:338586', '417736:569281', '150544:211454', '547101:1208061');


select co_fips, count(soil_geom.geometry) 
from map_soils_weps, soil_geom
where map_soils_weps.musym = soil_geom.musym 
and map_soils_weps.mukey = soil_geom.mukey
and map_soils_weps.co_fips = soil_geom.areasymbol 
and map_soils_weps.cokey in (select cokey from jims_soils)
group by map_soils_weps.co_fips;

select distinct cokey from map_soils_weps, soil_geom where map_soils_weps.musym = soil_geom.musym and map_soils_weps.mukey = soil_geom.mukey and map_soils_weps.co_fips = soil_geom.areasymbol and map_soils_weps.cokey in (select cokey from jims_soils) and st_x(st_centroid(soil_geom.geometry)) > -103.0 and st_x(st_centroid(soil_geom.geometry)) < -96.0;

