"WELL_ID","LONGITUDE","LATITUDE","TOP","BOTTOM","LOG","SOURCE","NAD83_LONGITUDE","NAD83_LATITUDE"
"505696","-97.91467","38.03962","0","3","top soil","KGS","-97.9149957","38.0396295"
"505696","-97.91467","38.03962","3","8","brown clay","KGS","-97.9149957","38.0396295"
"505696","-97.91467","38.03962","8","25","medium sand","KGS","-97.9149957","38.0396295"
"505696","-97.91467","38.03962","25","35","fine-small sand","KGS","-97.9149957","38.0396295"
"505696","-97.91467","38.03962","35","66","medium sand","KGS","-97.9149957","38.0396295"
"505696","-97.91467","38.03962","66","67","red shale","KGS","-97.9149957","38.0396295"
"507192","-98.9373362","38.1636178","0","3","top soil","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","3","18","sandy brown clay","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","18","42","sand and gravel","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","42","46","brown clay and sand mixed","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","46","63","medium sand and gravel, loose, clean","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","63","66","brown, green, and blue clay","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","66","70","sand and gravel","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","70","92","brown clay","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","92","97","sand and gravel","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","97","141","brown and white clay","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","141","218","sand and gravel; clean, coarse, loose","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","218","220","brown and gray clay","KGS","-98.9377091","38.1636317"
"507192","-98.9373362","38.1636178","220","","sandy blue gray clay","KGS","-98.9377091","38.1636317"
"506979","-99.3806043","37.7996824","0","3","top soil","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","3","11","hard sticky brown clay","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","11","24","gray clay","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","24","57","sand and gravel; small, medium, clean, coarse","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","57","60","tan clay streak","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","60","70","fine to small sand and gravel, clean","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","70","82","sand and gravel; small, medium, clean, tight, coarse; with cemented sand","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","82","85","fine to small sand and gravel, tight, clean","KGS","-99.381","37.7997"
"506979","-99.3806043","37.7996824","85","95","small-medium sand and gravel with cemented sand and small yellow clay streaks","KGS","-99.381","37.7997"
"506973","-99.0577143","37.7618814","0","3","sandy top soil","KGS","-99.0581","37.7619"
"506973","-99.0577143","37.7618814","3","35","sandy brown and gray clay","KGS","-99.0581","37.7619"
"506973","-99.0577143","37.7618814","35","58","sand and gravel; small, medium, coarse, clean, tight","KGS","-99.0581","37.7619"
"506973","-99.0577143","37.7618814","58","60","yellow clay","KGS","-99.0581","37.7619"
"505674","-97.88584","38.11419","0","5","sandy top soil","KGS","-97.8861655","38.1142002"
"505674","-97.88584","38.11419","5","18","fine sand","KGS","-97.8861655","38.1142002"
"505674","-97.88584","38.11419","18","30","fine sand and tan clay mix (70/30)","KGS","-97.8861655","38.1142002"
"505674","-97.88584","38.11419","30","63","tan clay and fine sand mix","KGS","-97.8861655","38.1142002"
"505674","-97.88584","38.11419","63","90","tan clay and fine sand mix with layers of fine sand","KGS","-97.8861655","38.1142002"
"506992","-99.2939066","37.5915807","0","3","top soil","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","3","16","soft sandy clay","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","16","33","soft silty clay with caliche","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","33","50","soft silty clay and sandy clay","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","50","73","hard tan clay and soft silty clay","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","73","108","sand and gravel, small, medium, clean, tight","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","108","115","tan clay","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","115","116","Dakota drift","KGS","-99.2943","37.5916"
"506992","-99.2939066","37.5915807","116","","gray shale","KGS","-99.2943","37.5916"
"506704","-98.9920258","38.5844856","0","3","top soil","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","3","9","tan clay","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","9","14","sand and gravel, small, medium, clean, loose, coarse","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","14","25","dark gray shale with caliche","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","25","115","soft dark gray shale with limestone","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","115","162","dark gray and light blue shale","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","162","198","soft gray shale with sandstone streaks","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","198","218","gray shale, coal, and sandstone","KGS","-98.9924","38.5845"
"506704","-98.9920258","38.5844856","218","230","red bed","KGS","-98.9924","38.5845"
"507168","-98.7824272","37.8022817","0","3","top sandy soil","KGS","-98.7828","37.8023"
"507168","-98.7824272","37.8022817","3","15","soft brown sandy clay","KGS","-98.7828","37.8023"
"507168","-98.7824272","37.8022817","15","65","hard tan clay","KGS","-98.7828","37.8023"
"507168","-98.7824272","37.8022817","65","75","sand and gravel; medium, loose, clean, coarse","KGS","-98.7828","37.8023"
"507168","-98.7824272","37.8022817","75","80","medium to large sand and gravel; clean, loose, coarse","KGS","-98.7828","37.8023"
"507543","-98.7278274","37.8970828","0","3","sandy top soil","KGS","-98.7282","37.8971"
"507543","-98.7278274","37.8970828","3","15","soft sandy clay","KGS","-98.7282","37.8971"
"507543","-98.7278274","37.8970828","15","65","brown and tan clay","KGS","-98.7282","37.8971"
"507543","-98.7278274","37.8970828","65","78","small-medium sand and gravel with heavy clay streaks","KGS","-98.7282","37.8971"
"507543","-98.7278274","37.8970828","78","100","sand and gravel; small, medium, clean, loose, coarse","KGS","-98.7282","37.8971"
"506972","-99.057816","37.7670695","0","3","sandy top soil","KGS","-99.058201","37.767086"
"506972","-99.057816","37.7670695","3","36","sandy brown and gray clay","KGS","-99.058201","37.767086"
"506972","-99.057816","37.7670695","36","55","sand and gravel; small, medium, coarse, clean, loose","KGS","-99.058201","37.767086"
"506972","-99.057816","37.7670695","55","56","yellow clay lens","KGS","-99.058201","37.767086"
"506972","-99.057816","37.7670695","56","75","sand and gravel; medium, coarse, clean, tight","KGS","-99.058201","37.767086"
"507269","-98.2727541","38.283489","0","3","top soil","KGS","-98.2731","38.2835"
"507269","-98.2727541","38.283489","3","7","brown clay","KGS","-98.2731","38.2835"
"507269","-98.2727541","38.283489","7","59","sand and gravel; small, medium, clean, loose, coarse","KGS","-98.2731","38.2835"
"507269","-98.2727541","38.283489","59","60","yellow clay","KGS","-98.2731","38.2835"
"504405","-99.387204","37.9842817","0","3","top soil","KGS","-99.3876","37.9843"
"504405","-99.387204","37.9842817","3","19","brown clay","KGS","-99.3876","37.9843"
"504405","-99.387204","37.9842817","19","26","medium-coarse sand and gravel, dark tinted, with gray clay streaks","KGS","-99.3876","37.9843"
"504405","-99.387204","37.9842817","26","30","tan clay","KGS","-99.3876","37.9843"
"504405","-99.387204","37.9842817","30","65","sandstone","KGS","-99.3876","37.9843"
"504405","-99.387204","37.9842817","65","70","red bed","KGS","-99.3876","37.9843"