"WELL_ID","LONGITUDE","LATITUDE","TOP","BOTTOM","LOG","SOURCE","NAD83_LONGITUDE","NAD83_LATITUDE"
"507831","-98.3359522","38.2611161","0","1","sandy top soil","KGS","-98.3362971","38.2611274"
"507831","-98.3359522","38.2611161","1","8","clay","KGS","-98.3362971","38.2611274"
"507831","-98.3359522","38.2611161","8","33","good sand and gravel","KGS","-98.3362971","38.2611274"
"507831","-98.3359522","38.2611161","33","45","clay and black mud","KGS","-98.3362971","38.2611274"
"507831","-98.3359522","38.2611161","45","60","gravel","KGS","-98.3362971","38.2611274"
"507831","-98.3359522","38.2611161","60","65","shale","KGS","-98.3362971","38.2611274"
"508262","-98.1999597","38.2669882","0","3","top soil","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","3","9","sandy brown clay","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","9","13","brown clay","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","13","45","sand and gravel; medium, clean, coarse","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","45","55","tan clay","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","55","65","sand and gravel; small, medium, clean, coarse","KGS","-98.2003","38.267"
"508262","-98.1999597","38.2669882","65","70","gray clay","KGS","-98.2003","38.267"
"507994","-98.9323298","38.5002851","0","3","top soil","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","3","6","brown clay","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","6","17","tan clay with caliche","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","17","42","white and yellow shale with limestone","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","42","65","black and gray shale with limestone","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","65","120","dark gray shale with hard limestone","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","120","140","gray shale with sandstone","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","140","155","dark gray shale with ironated rock","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","155","170","sandstone with gray shale","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","170","190","coal shale, ironated rock, and coarse sandstone","KGS","-98.9327","38.5003"
"507994","-98.9323298","38.5002851","190","200","red bed","KGS","-98.9327","38.5003"
"508354","-98.5289406","37.824681","0","3","top soil","KGS","-98.5293","37.8247"
"508354","-98.5289406","37.824681","3","9","soft sandy clay","KGS","-98.5293","37.8247"
"508354","-98.5289406","37.824681","9","32","brown clay with caliche","KGS","-98.5293","37.8247"
"508354","-98.5289406","37.824681","32","75","sand and gravel, small to medium, clean, coarse","KGS","-98.5293","37.8247"
"508354","-98.5289406","37.824681","75","80","tan clay","KGS","-98.5293","37.8247"
"508009","-98.762335","38.2899862","0","3","top soil","KGS","-98.7627","38.29"
"508009","-98.762335","38.2899862","3","5","brown clay","KGS","-98.7627","38.29"
"508009","-98.762335","38.2899862","5","30","gray clay","KGS","-98.7627","38.29"
"508009","-98.762335","38.2899862","30","61","sand and gravel; small, medium, clean, loose, coarse","KGS","-98.7627","38.29"
"508009","-98.762335","38.2899862","61","63","gray tan clay","KGS","-98.7627","38.29"
"508009","-98.762335","38.2899862","63","80","sand and gravel; medium, clean, loose, coarse","KGS","-98.7627","38.29"
"508005","-98.8485332","38.3701858","0","3","top soil","KGS","-98.8489","38.3702"
"508005","-98.8485332","38.3701858","3","11","brown clay","KGS","-98.8489","38.3702"
"508005","-98.8485332","38.3701858","11","50","sand and gravel; medium, coarse, clean","KGS","-98.8489","38.3702"
"508005","-98.8485332","38.3701858","50","70","sand and gravel; small, medium, clean, coarse","KGS","-98.8489","38.3702"
"508005","-98.8485332","38.3701858","70","","tan clay","KGS","-98.8489","38.3702"
"508007","-98.5587304","38.2984488","0","3","top soil","KGS","-98.559088","38.298463"
"508007","-98.5587304","38.2984488","3","17","soft sandy clay","KGS","-98.559088","38.298463"
"508007","-98.5587304","38.2984488","17","20","medium sand and gravel with sandy clay","KGS","-98.559088","38.298463"
"508007","-98.5587304","38.2984488","20","30","sand and gravel; medium, clean, coarse","KGS","-98.559088","38.298463"
"508007","-98.5587304","38.2984488","30","40","dark tint sand and medium gravel","KGS","-98.559088","38.298463"
"508007","-98.5587304","38.2984488","40","81","small, medium sand and gravel","KGS","-98.559088","38.298463"
"508008","-98.5636199","38.2909055","0","3","sandy top soil","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","3","17","soft sandy tan clay","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","17","19","gray clay","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","19","36","gray clay, tan sandy clay, caliche, and soft cemented sand","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","36","37","cemented sand","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","37","53","sand and gravel; small, medium, coarse","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","53","66","tan clay streaks with small medium gravel","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","66","78","brown and dark clay","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","78","80","sand and gravel with clay streaks","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","80","103","medium sand and gravel","KGS","-98.5639751","38.2909177"
"508008","-98.5636199","38.2909055","103","112","fine to small sand and gravel","KGS","-98.5639751","38.2909177"
"508209","-99.257808","38.129984","0","3","top soil","KGS","-99.2582","38.13"
"508209","-99.257808","38.129984","3","61","brown clay","KGS","-99.2582","38.13"
"508209","-99.257808","38.129984","61","75","brown clay with fine sand streaks","KGS","-99.2582","38.13"
"508209","-99.257808","38.129984","75","83","broken rock with fine sand","KGS","-99.2582","38.13"
"508209","-99.257808","38.129984","83","85","red bed","KGS","-99.2582","38.13"
"507848","-97.93934","37.9855","0","3","top soil","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","3","17","light gray clay","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","17","21","tan clay","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","21","37","small sand and gravel","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","37","41","tan clay","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","41","45","sand","KGS","-97.9396679","37.9855106"
"507848","-97.93934","37.9855","45","60","small sand and gravel","KGS","-97.9396679","37.9855106"
"507616","-98.04791","37.56081","0","3","top soil","KGS","-98.0482469","37.5608256"
"507616","-98.04791","37.56081","3","10","tan clay","KGS","-98.0482469","37.5608256"
"507616","-98.04791","37.56081","10","21","medium-fine sand and clay mix (70/30)","KGS","-98.0482469","37.5608256"
"507616","-98.04791","37.56081","21","23","tan clay and fine sand","KGS","-98.0482469","37.5608256"
"507616","-98.04791","37.56081","23","39","medium-fine sand","KGS","-98.0482469","37.5608256"
"507616","-98.04791","37.56081","39","45","red shale","KGS","-98.0482469","37.5608256"
"508068","-99.3095056","37.9125817","0","3","top soil","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","3","23","soft sandy clay","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","23","45","sand and gravel; small, medium, clean, coarse","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","45","50","tan clay","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","50","55","sand and gravel; small, medium, clean, coarse","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","55","60","fine to small sand and gravel","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","60","68","sand and gravel; small, medium, clean, coarse","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","68","78","tan clay","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","78","91","small-medium sand and gravel with tan clay streaks","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","91","95.5","Dakota drift with small tan clay streaks","KGS","-99.3099","37.9126"
"508068","-99.3095056","37.9125817","95.5","99","shale","KGS","-99.3099","37.9126"