"WELL_ID","LONGITUDE","LATITUDE","TOP","BOTTOM","LOG","SOURCE","NAD83_LONGITUDE","NAD83_LATITUDE"
"511336","-99.3503056","37.3362743","0","3","sandy top soil","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","3","17","sand and gravel; small, medium, clean, loose, coarse","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","17","30","white, tan clay","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","30","45","sand and gravel; small, medium, clean, tight, coarse","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","45","55","brown clay","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","55","68","sand and gravel; small, medium, clean, coarse, tight","KGS","-99.3507","37.3363"
"511336","-99.3503056","37.3362743","68","","dark brown clay","KGS","-99.3507","37.3363"
"511338","-99.1985819","37.2774843","0","3","top soil","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","3","10","sand and gravel; small, medium, red tint, clean, coarse","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","10","22","tan clay","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","22","38","gravel, fine to small, clean, tight","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","38","41","cemented sand","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","41","58","sand and gravel; fine to small, clean, tight","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","58","105","tan clay","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","105","110","sand and gravel; fine to small, clean, tight","KGS","-99.198975","37.277511"
"511338","-99.1985819","37.2774843","110","140","sand and gravel; small, medium, clean, tight, coarse","KGS","-99.198975","37.277511"
"510531","-97.45422","37.63804","0","3","top soil","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","3","10","brown clay","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","10","18","tan clay and fine sand mix (70/30)","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","18","35","small-fine sand","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","35","55","tan clay and fine sand mix (70/30)","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","55","65","gray clay","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","65","73","gray clay and fine sand mix (70/30)","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","73","85","gray clay","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","85","90","gray clay, hard caliche, and fine sand","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","90","101","fine-small sand","KGS","-97.4545423","37.638055"
"510531","-97.45422","37.63804","101","105","weathered shale","KGS","-97.4545423","37.638055"
"511964","-99.064436","38.2333169","0","3","top soil","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","3","22","brown clay","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","22","47","medium to pea-size sand and gravel, coarse, clean","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","47","50","tan clay","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","50","60","small, medium sand and gravel with very small clay streaks","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","60","65","small, medium gravel with heavy white clay, caliche, broken rock, and ironated rock","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","65","75","brown clay and tan clay","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","75","80","sand and gravel; small, medium, clean, coarse","KGS","-99.0648136","38.2333303"
"511964","-99.064436","38.2333169","80","90","tan clay with caliche","KGS","-99.0648136","38.2333303"
"511761","-98.6696354","38.2243857","0","3","sandy top soil","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","3","5","soft sandy clay","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","5","12","gray sandy clay","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","12","42","soft sandy clay","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","42","55","blue green clay","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","55","65","soft sandy clay with fine to small gravel","KGS","-98.67","38.2244"
"511761","-98.6696354","38.2243857","65","80","sand and gravel; small, medium, clean, coarse, loose","KGS","-98.67","38.2244"
"511800","-98.3990857","38.141849","0","1","sandy top soil","KGS","-98.39944","38.141862"
"511800","-98.3990857","38.141849","1","7","brown clay","KGS","-98.39944","38.141862"
"511800","-98.3990857","38.141849","7","21","sandy brown clay","KGS","-98.39944","38.141862"
"511800","-98.3990857","38.141849","21","38","medium to coarse gravel","KGS","-98.39944","38.141862"
"511800","-98.3990857","38.141849","38","40","tan clay","KGS","-98.39944","38.141862"
"511801","-98.08721","38.09295","0","3","top soil","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","3","15","brown clay","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","15","23","tan clay","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","23","25","tan clay and caliche mix","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","25","36","medium-fine sand","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","36","36.5","hard caliche","KGS","-98.0875437","38.0929611"
"511801","-98.08721","38.09295","36.5","38","clay","KGS","-98.0875437","38.0929611"
"511804","-98.7603316","38.0038834","0","3","top soil","KGS","-98.7607","38.0039"
"511804","-98.7603316","38.0038834","3","5","brown clay","KGS","-98.7607","38.0039"
"511804","-98.7603316","38.0038834","5","25","sand and gravel, small, medium, with some clay","KGS","-98.7607","38.0039"
"511804","-98.7603316","38.0038834","25","80","sand and gravel; small, medium, clean, loose, coarse","KGS","-98.7607","38.0039"
"511805","-98.6840314","37.8662823","0","3","top soil","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","3","6","brown clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","6","14","gray clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","14","19","soft sandy clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","19","30","gray tan clay with caliche","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","30","41","sandy clay, green tint","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","41","50","sand and gravel; small, medium, clean, coarse, loose","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","50","55","tan clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","55","57","cemented sand","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","57","85","tan clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","85","95","sand and gravel; small, medium, coarse; with heavy clay","KGS","-98.6844","37.8663"
"511805","-98.6840314","37.8662823","95","118","sand and gravel; small, medium, clean, coarse","KGS","-98.6844","37.8663"
"511967","-99.1957152","38.1326857","0","3","top soil","KGS","-99.1961","38.1327"
"511967","-99.1957152","38.1326857","3","14","brown clay","KGS","-99.1961","38.1327"
"511967","-99.1957152","38.1326857","14","22","medium to pea-size sand and gravel, clean, coarse","KGS","-99.1961","38.1327"
"511967","-99.1957152","38.1326857","22","85","gray clay","KGS","-99.1961","38.1327"
"511967","-99.1957152","38.1326857","85","90","fine to small sand and gravel, clean, loose","KGS","-99.1961","38.1327"
"511967","-99.1957152","38.1326857","90","105","small to some medium sand and gravel with broken ironated rock","KGS","-99.1961","38.1327"
"511376","-99.8167616","37.5654737","0","3","top soil","KGS","-99.8171686","37.5654948"
"511376","-99.8167616","37.5654737","3","95","tan clay with caliche streaks","KGS","-99.8171686","37.5654948"
"511376","-99.8167616","37.5654737","95","117","sandy tan clay","KGS","-99.8171686","37.5654948"
"511376","-99.8167616","37.5654737","117","130","sandy tan clay with cemented sand","KGS","-99.8171686","37.5654948"
"511376","-99.8167616","37.5654737","130","185","sand and gravel; small, medium, clean, coarse","KGS","-99.8171686","37.5654948"
"511376","-99.8167616","37.5654737","185","190","gray shale","KGS","-99.8171686","37.5654948"
"510443","-97.79803","38.10393","0","4","top soil","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","4","18","tan clay and fine sand mix (80/20)","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","18","35","tan clay and fine sand mix (80/20) with streaks of fine sand","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","35","40","dark brown clay, soft","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","40","60","tan clay and fine sand mix with streaks of fine sand","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","60","63","white clay and fine sand mix","KGS","-97.798355","38.1039379"
"510443","-97.79803","38.10393","63","100","tan clay and fine sand mix (80/20)","KGS","-97.798355","38.1039379"
"512473","-98.4248538","38.5694883","0","3","top soil","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","3","4","brown clay","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","4","10","limestone with yellow clay","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","10","45","gray shale","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","45","60","sandstone with broken and ironated rock","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","60","76","sandstone streaks with gray shale","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","76","85","blue shale","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","85","105","red bed","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","105","125","sandstone","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","125","135","sandstone streaks with gray shale","KGS","-98.4252","38.5695"
"512473","-98.4248538","38.5694883","135","160","sandstone","KGS","-98.4252","38.5695"
"511792","-98.685136","38.1922855","0","3","sandy top soil","KGS","-98.6855","38.1923"
"511792","-98.685136","38.1922855","3","42","soft sandy clay","KGS","-98.6855","38.1923"
"511792","-98.685136","38.1922855","42","62","hard tan clay","KGS","-98.6855","38.1923"
"511792","-98.685136","38.1922855","62","76","tan clay with gravel embedded","KGS","-98.6855","38.1923"
"511792","-98.685136","38.1922855","76","100","sand and gravel; small, medium, clean, coarse, tight","KGS","-98.6855","38.1923"
"510569","-98.40781","38.25499","0","3","sandy top soil","KGS","-98.4081536","38.255"
"510569","-98.40781","38.25499","3","30","medium sand and gravel","KGS","-98.4081536","38.255"
"510569","-98.40781","38.25499","30","33","tan clay","KGS","-98.4081536","38.255"
"510569","-98.40781","38.25499","33","40","medium sand and gravel","KGS","-98.4081536","38.255"
"511601","-98.8514372","38.9157869","0","2","top soil","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","2","9","limestone with yellow gumbo clay","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","9","12","hard ironated rock and iron pyrite","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","12","83","black fragile shale with limestone","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","83","115","iron pyrite streaks with black shale","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","115","123","gray shale with sandstone streaks","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","123","135","hard iron pyrite","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","135","140","white clay with limestone","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","140","155","gray shale with iron pyrite","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","155","170","white shale with limestone","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","170","210","red bed with iron pyrite","KGS","-98.8518","38.9158"
"511601","-98.8514372","38.9157869","210","250","fine sandstone with little red bed","KGS","-98.8518","38.9158"
"511337","-99.3491064","37.3332742","0","1","sandy top soil","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","1","4","sand and gravel; small, medium, clean, loose, coarse","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","4","9","soft sandy clay","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","9","30","sand and gravel; small, medium, loose, clean, coarse","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","30","34","small tan clay streak","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","34","89","sand and gravel; small, medium, clean, coarse, tight","KGS","-99.3495","37.3333"
"511337","-99.3491064","37.3332742","89","90","tan clay","KGS","-99.3495","37.3333"
"511340","-99.3464071","37.1998729","0","2","sandy top soil","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","2","14","brown clay","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","14","16","sand and gravel; small, medium, coarse, loose","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","16","23","red bed","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","23","26","yellow shale","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","26","35","sandstone, clean, tight","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","35","38","red bed","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","38","49","sandstone","KGS","-99.3468","37.1999"
"511340","-99.3464071","37.1998729","49","60","sandstone streaks with red bed","KGS","-99.3468","37.1999"
"511793","-98.9080261","38.2433856","0","3","top soil","KGS","-98.9084","38.2434"
"511793","-98.9080261","38.2433856","3","26","soft sandy clay","KGS","-98.9084","38.2434"
"511793","-98.9080261","38.2433856","26","42","sand and gravel; medium, clean, coarse","KGS","-98.9084","38.2434"
"511793","-98.9080261","38.2433856","42","55","tan clay","KGS","-98.9084","38.2434"
"511793","-98.9080261","38.2433856","55","78","sand and gravel; small, medium, clean, coarse","KGS","-98.9084","38.2434"
"511793","-98.9080261","38.2433856","78","80","gray tan clay","KGS","-98.9084","38.2434"
"511339","-99.3516078","37.2739432","0","3","sandy top soil","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","3","15","soft sandy brown clay","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","15","23","brown clay","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","23","31","white clay with small medium gravel","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","31","36","sand and gravel, small, medium, coarse, with cemented sand streaks, hard","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","36","80","cemented sand, soft to hard streaks, with sandy clay and fine sand","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","80","100","sand and gravel, fine to small, clean","KGS","-99.3520006","37.2739674"
"511339","-99.3516078","37.2739432","100","120","sand and gravel, small to medium coarse, clean, tight","KGS","-99.3520006","37.2739674"
"511360","-98.098368","38.6828895","0","3","top soil","KGS","-98.0987","38.6829"
"511360","-98.098368","38.6828895","3","26","sand and gravel; small, medium, clean, loose, coarse","KGS","-98.0987","38.6829"
"511360","-98.098368","38.6828895","26","27","tan clay","KGS","-98.0987","38.6829"
"511360","-98.098368","38.6828895","27","56","sand rock with blue shale","KGS","-98.0987","38.6829"
"511360","-98.098368","38.6828895","56","60","blue shale","KGS","-98.0987","38.6829"
"511355","-99.1302101","37.9410823","0","3","top soil","KGS","-99.1306","37.9411"
"511355","-99.1302101","37.9410823","3","32","soft sandy clay","KGS","-99.1306","37.9411"
"511355","-99.1302101","37.9410823","32","50","tan clay","KGS","-99.1306","37.9411"
"511355","-99.1302101","37.9410823","50","75","sand and gravel; small, medium, clean, coarse, tight","KGS","-99.1306","37.9411"
"511355","-99.1302101","37.9410823","75","77","gray shale","KGS","-99.1306","37.9411"
"511358","-99.2669061","37.789982","0","3","top soil","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","3","9","brown clay","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","9","13","soft sandy clay","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","13","35","sand and gravel; small, medium, clean, coarse","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","35","42","light tan yellow clay","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","42","69","sand and gravel; small, medium, clean, coarse","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","69","96","tan clay","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","96","116","sand and gravel; small, medium, clean, coarse","KGS","-99.2673","37.79"
"511358","-99.2669061","37.789982","116","120","small-medium gravel with heavy clay","KGS","-99.2673","37.79"
"511796","-98.7720332","38.1220838","0","3","top soil","KGS","-98.7724","38.1221"
"511796","-98.7720332","38.1220838","3","8","soft sandy gray clay","KGS","-98.7724","38.1221"
"511796","-98.7720332","38.1220838","8","11","green gray clay","KGS","-98.7724","38.1221"
"511796","-98.7720332","38.1220838","11","50","soft tan sandy clay","KGS","-98.7724","38.1221"
"511796","-98.7720332","38.1220838","50","95","sand and gravel, small, medium, clean, tight, coarse","KGS","-98.7724","38.1221"
"512165","-98.1380623","38.3712882","0","3","top soil","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","3","13","brown clay","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","13","18","limestone and caliche with brown gritty clay","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","18","65","tan clay with caliche","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","65","70","brown gritty clay","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","70","95","tan sticky clay","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","95","107","Dakota drift, broken rock, ironated rock, and sandstone","KGS","-98.1384","38.3713"
"512165","-98.1380623","38.3712882","107","110","green blue shale","KGS","-98.1384","38.3713"
"511803","-98.5857016","38.0847385","0","2","top soil","KGS","-98.5860596","38.0847524"
"511803","-98.5857016","38.0847385","2","14","sand and gravel, medium, clean, loose, coarse","KGS","-98.5860596","38.0847524"
"511803","-98.5857016","38.0847385","14","55","tan clay with caliche","KGS","-98.5860596","38.0847524"
"511803","-98.5857016","38.0847385","55","77","sand and gravel, small, medium, clean, coarse","KGS","-98.5860596","38.0847524"