In [258]:
import pandas as pd
import numpy as np
import csv

directory = "\\\isgs-sinkhole\geophysics\Balikian\ISWS State Well Data\Reclassified_Data\\"

datafile = '3StartSpec_Join_Logs-Dict.txt'
WellData = 'WellXYZ.txt'
Classifier = 'Lithology_Interp_FineCoarse.txt'
In [259]:
#Read in well location data
WellXYZ = pd.read_csv(directory+WellData, usecols=['ID','API','LATITUDE', 'LONGITUDE', 'SURF_ELEV_ft'], sep=',' )
del WellXYZ['ID']
WellXYZ.head()
Out[259]:
API LATITUDE LONGITUDE SURF_ELEV_ft
0 120333071500 38.923294 -87.737657 603.67
1 120333072100 38.896763 -87.746863 513.81
2 120390005600 40.276271 -88.814961 770.33
3 120390006800 40.279958 -88.810223 772.36
4 120390040300 40.276241 -88.860433 799.78
In [260]:
#Read in classifications
COARSECODE = pd.read_csv(directory+Classifier, sep='\t',usecols=['INTERPRETED', 'LITHOLOGY', 'COARSECODE', 'TARGET'])
In [261]:
with open(directory+datafile, newline='') as csvfile:
    test = csv.reader(csvfile, delimiter=',', quotechar='"')
    headers = next(test)
    lines = [r for r in test]
In [264]:
data = pd.DataFrame(lines, dtype = 'str')
In [265]:
data.columns = headers
In [266]:
data.head()
Out[266]:
API_Number TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED
0 121114109700 10 36 gravel GRAVEL GRAVEL 1
1 121114109700 36 98 clay CLAY CLAY 1
2 121114109700 98 103 sand w/gravel SAND WITH GRAVEL GRAVEL -1
3 121114109700 103 237 clay CLAY CLAY 1
4 121114109700 237 250 limestone BEDROCK LIMESTONE SHALE BEDROCK 1
In [267]:
datatypes = {'API_NUMBER': 'int64', 
             'TOP':'float', 
             'BOTTOM':'float', 
             'FORMATION_SHORT':'str',
             'LITHOLOGY':'str',
             'COLOR':'str',
             'CONSISTENCY' :'str',
             'MOD1':'str',
             'MOD2':'str',
             'INTERPRETED':'str',
             'COMPLETED':'int32'
            }
datatypes
Out[267]:
{'API_NUMBER': 'int64',
 'TOP': 'float',
 'BOTTOM': 'float',
 'FORMATION_SHORT': 'str',
 'LITHOLOGY': 'str',
 'COLOR': 'str',
 'CONSISTENCY': 'str',
 'MOD1': 'str',
 'MOD2': 'str',
 'INTERPRETED': 'str',
 'COMPLETED': 'int32'}
In [268]:
data.astype('str')
Out[268]:
API_Number TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED
0 121114109700 10 36 gravel GRAVEL GRAVEL 1
1 121114109700 36 98 clay CLAY CLAY 1
2 121114109700 98 103 sand w/gravel SAND WITH GRAVEL GRAVEL -1
3 121114109700 103 237 clay CLAY CLAY 1
4 121114109700 237 250 limestone BEDROCK LIMESTONE SHALE BEDROCK 1
5 121114109800 0 5 red clay CLAY RED CLAY 1
6 121114109800 5 30 sandy gravel dirty GRAVEL SANDY GRAVEL -1
7 121114109800 30 35 gray clay CLAY GRAY CLAY 1
8 121114109800 35 40 sand SAND SAND -1
9 121114109800 40 44 gravel red sharp GRAVEL RED GRAVEL -1
10 121114109800 44 50 gravel black & white GRAVEL BLACK GRAVEL -1
11 121114109900 0 2 topsoil SOIL SOIL 1
12 121114109900 2 5 clay CLAY CLAY 1
13 121114109900 5 57 gravel & sand SAND AND GRAVEL GRAVEL 1
14 121114109900 57 59 clay CLAY CLAY 1
15 121114109900 59 68 gravel GRAVEL GRAVEL 1
16 121114110000 0 10 black dirt DIRT BLACK SOIL 1
17 121114110000 10 39 soft gray clay CLAY GRAY SOFT CLAY 1
18 121114110000 39 46 gravel GRAVEL GRAVEL 1
19 121114110100 0 2 black dirt & gravel DIRT AND GRAVEL BLACK GRAVEL -1
20 121114110100 2 17 gravel & sand SAND AND GRAVEL GRAVEL 1
21 121114110100 17 105 clay CLAY CLAY 1
22 121114110100 105 109 gravel GRAVEL GRAVEL 1
23 121114110100 109 161 clay CLAY CLAY 1
24 121114110100 161 162 limestone shelf BEDROCK LIMESTONE LEDGES BEDROCK -1
25 121114110100 162 163 paste & limestone BEDROCK LIMESTONE BEDROCK -1
26 121114110100 163 178 limestone BEDROCK LIMESTONE SHALE BEDROCK 1
27 121114110200 0 15 clay & gravel CLAY AND GRAVEL CLAY AND GRAVEL MIX 1
28 121114110200 15 30 gravel & boulders GRAVEL WITH BOULDERS BOULDERY BOULDERY MATERIAL -1
29 121114110200 30 90 gravel & sand SAND AND GRAVEL GRAVEL 1
... ... ... ... ... ... ... ... ... ... ... ...
1824925 480590599900 59 174 blue clay & gravel CLAY AND GRAVEL BLUE CLAY AND GRAVEL MIX 1
1824926 480590599900 90 110 blue clay CLAY GRAY CLAY -1
1824927 480590600100 0 280 struck limestone at
1824928 480590600100 280 280 drift GENERIC GENERIC 1
1824929 480590601300 7 15 brown clay CLAY BROWN CLAY 1
1824930 480590601300 8 8 topsoil SOIL SOIL 1
1824931 480590601300 9 150 gravel GRAVEL GRAVEL 1
1824932 480590601300 17 112 red clay CLAY RED CLAY 1
1824933 480590601300 29 141 sand SAND SAND -1
1824934 480590601300 80 95 blue clay CLAY GRAY CLAY -1
1824935 480590601700 2 2 topsoil SOIL SOIL 1
1824936 480590601700 7 153 dirty gravel GRAVEL DIRTY GRAVEL -1
1824937 480590601700 16 18 yellow clay CLAY YELLOW CLAY 1
1824938 480590601700 21 217 rock BEDROCK BEDROCK 1
1824939 480590601700 22 111 soft dirty sand SAND SOFT DIRTY SAND -1
1824940 480590601700 35 146 blue clay CLAY GRAY CLAY -1
1824941 480590601700 43 196 blue clay CLAY GRAY CLAY -1
1824942 480590601700 71 89 blue clay CLAY GRAY CLAY -1
1824943 480590602400 1 1 topsoil SOIL SOIL 1
1824944 480590602400 2 222 limestone BEDROCK LIMESTONE SHALE BEDROCK 1
1824945 480590602400 14 175 sand SAND SAND -1
1824946 480590602400 25 26 subsoil SOIL SOIL -1
1824947 480590602400 45 220 hardpan SOIL HARDPAN SOIL 1
1824948 480590602400 135 161 blue clay CLAY GRAY CLAY -1
1824949 480590602600 12 291 limestone BEDROCK LIMESTONE SHALE BEDROCK 1
1824950 480590602600 19 279 gravel & dirty sand SAND AND GRAVEL DIRTY GRAVEL -1
1824951 480590602600 20 20 topsoil & clay CLAY CLAY -1
1824952 480590602600 20 260 red clay & gravel CLAY AND GRAVEL RED CLAY AND GRAVEL MIX -1
1824953 480590602600 60 240 fine sand SAND SAND 1
1824954 480590602600 160 180 blue clay CLAY GRAY CLAY -1

1824955 rows × 11 columns

In [272]:
data.API_Number = pd.to_numeric(data.API_Number, errors='coerce')
data.TOP = pd.to_numeric(data.TOP, errors = 'coerce')
data.BOTTOM = pd.to_numeric(data.BOTTOM, errors = 'coerce')
data.COMPLETED = pd.to_numeric(data.COMPLETED, errors = 'coerce')
In [273]:
data.dtypes
Out[273]:
API_Number           int64
TOP                float64
BOTTOM             float64
FORMATION_SHORT     object
LITHOLOGY           object
COLOR               object
CONSISTENCY         object
MOD1                object
MOD2                object
INTERPRETED         object
COMPLETED          float64
dtype: object
In [274]:
#add elevations

#dataXYZ = data.set_index('API_Number').join(WellXYZ.set_index('API'))
#dataXYZ = data.join(WellXYZ.set_index('API'), on='API_Number')
WellXYZ.dtypes
Out[274]:
API               int64
LATITUDE        float64
LONGITUDE       float64
SURF_ELEV_ft    float64
dtype: object
In [275]:
dataXYZJoin = data.set_index('API_Number').join(WellXYZ.set_index('API'))
In [276]:
dataXYZJoin
Out[276]:
TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft
120010000300 0.0 18.0 interval drift? NaN 40.079858 -90.913587 586.73
120010000300 18.0 20.0 Colchester No. 2 coal,Penn. carb NaN 40.079858 -90.913587 586.73
120010000300 20.0 20.0 fire clay at CLAY FIRECLAY CLAY -1.0 40.079858 -90.913587 586.73
120010000800 0.0 175.0 interval UNKNOWN UNKNOWN -1.0 40.039934 -90.923914 746.05
120010000800 175.0 175.0 coal No. 2 possibly at NaN 40.039934 -90.923914 746.05
120010000900 0.0 133.0 interval ? NaN 40.032768 -90.943348 740.93
120010000900 133.0 135.0 coal BEDROCK COAL BEDROCK 1.0 40.032768 -90.943348 740.93
120010000900 135.0 136.0 fire clay BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93
120010001000 0.0 135.0 interval UNKNOWN UNKNOWN -1.0 40.034531 -90.936092 739.90
120010001000 135.0 137.0 coal,Pennsylvanian or Carbondale NaN 40.034531 -90.936092 739.90
120010001000 137.0 139.0 fire clay BEDROCK BEDROCK 1.0 40.034531 -90.936092 739.90
120010001100 0.0 37.0 clay & coal CLAY AND STONE COAL BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97
120010001100 37.0 39.0 limestone, nodular BEDROCK LIMESTONE BEDROCK -1.0 40.029328 -90.962715 698.97
120010001100 39.0 51.0 clay & soapstone CLAY AND STONE SHALE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97
120010001100 51.0 145.0 interval UNKNOWN UNKNOWN -1.0 40.029328 -90.962715 698.97
120010001100 145.0 148.0 coal & underclay BEDROCK COAL AND FIRECLAY BEDROCK -1.0 40.029328 -90.962715 698.97
120010001200 0.0 35.0 interval UNKNOWN UNKNOWN -1.0 40.105970 -91.054776 696.32
120010001200 35.0 36.0 black slate BEDROCK BLACK SLATE BEDROCK 1.0 40.105970 -91.054776 696.32
120010001200 36.0 37.0 coal BEDROCK COAL BEDROCK 1.0 40.105970 -91.054776 696.32
120010001400 0.0 15.0 till,sy,ltl gvl,lim brn CLAY CLAY 0.0 40.021306 -91.086866 735.45
120010001400 15.0 45.0 till,sy,ltl gvl,lim brn,but calcareous CLAY CLAY 0.0 40.021306 -91.086866 735.45
120010001400 45.0 60.0 till,sy,ltl gvl,lim brn brnsh gry CLAY CLAY 0.0 40.021306 -91.086866 735.45
120010001400 60.0 65.0 till,sy,ltl gvl,greenish-gray CLAY CLAY 0.0 40.021306 -91.086866 735.45
120010001400 65.0 70.0 till,s,ltl gvl,grn-gry, calc, lime CLAY CLAY 0.0 40.021306 -91.086866 735.45
120010001400 70.0 85.0 sh,slgtly sy,brnsh gry,fm to wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
120010001400 85.0 105.0 sh,sty,slgtly sy,slgtly calc,med gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
120010001400 105.0 120.0 sh,blk,lamd,fm;a ltl ls,argil,blk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
120010001400 120.0 125.0 sh,sty,calc,dk gry,wk;sh,sy,ylsh gry BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
120010001400 125.0 130.0 sh,blk,fm;sh,sty,dk gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
120010001400 130.0 135.0 sh,blk;sh,sty,dk gry;ls,argil,vy f,crinl BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45
... ... ... ... ... ... ... ... ... ... ... ... ... ...
480590599900 59.0 174.0 blue clay & gravel CLAY AND GRAVEL BLUE CLAY AND GRAVEL MIX 1.0 NaN NaN NaN
480590599900 90.0 110.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590600100 0.0 280.0 struck limestone at NaN NaN NaN NaN
480590600100 280.0 280.0 drift GENERIC GENERIC 1.0 NaN NaN NaN
480590601300 7.0 15.0 brown clay CLAY BROWN CLAY 1.0 NaN NaN NaN
480590601300 8.0 8.0 topsoil SOIL SOIL 1.0 NaN NaN NaN
480590601300 9.0 150.0 gravel GRAVEL GRAVEL 1.0 NaN NaN NaN
480590601300 17.0 112.0 red clay CLAY RED CLAY 1.0 NaN NaN NaN
480590601300 29.0 141.0 sand SAND SAND -1.0 NaN NaN NaN
480590601300 80.0 95.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590601700 2.0 2.0 topsoil SOIL SOIL 1.0 NaN NaN NaN
480590601700 7.0 153.0 dirty gravel GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN
480590601700 16.0 18.0 yellow clay CLAY YELLOW CLAY 1.0 NaN NaN NaN
480590601700 21.0 217.0 rock BEDROCK BEDROCK 1.0 NaN NaN NaN
480590601700 22.0 111.0 soft dirty sand SAND SOFT DIRTY SAND -1.0 NaN NaN NaN
480590601700 35.0 146.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590601700 43.0 196.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590601700 71.0 89.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590602400 1.0 1.0 topsoil SOIL SOIL 1.0 NaN NaN NaN
480590602400 2.0 222.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN
480590602400 14.0 175.0 sand SAND SAND -1.0 NaN NaN NaN
480590602400 25.0 26.0 subsoil SOIL SOIL -1.0 NaN NaN NaN
480590602400 45.0 220.0 hardpan SOIL HARDPAN SOIL 1.0 NaN NaN NaN
480590602400 135.0 161.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN
480590602600 12.0 291.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN
480590602600 19.0 279.0 gravel & dirty sand SAND AND GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN
480590602600 20.0 20.0 topsoil & clay CLAY CLAY -1.0 NaN NaN NaN
480590602600 20.0 260.0 red clay & gravel CLAY AND GRAVEL RED CLAY AND GRAVEL MIX -1.0 NaN NaN NaN
480590602600 60.0 240.0 fine sand SAND SAND 1.0 NaN NaN NaN
480590602600 160.0 180.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN

1824955 rows × 13 columns

In [277]:
#Create columns for elevation of intervals (for later calculation)
dataXYZJoin['TOP_ELEV_ft'] = 0
dataXYZJoin['BOT_ELEV_ft'] = 0
In [278]:
#Create new data frame (DataXYZ) to preserve old one
dataXYZ = dataXYZJoin
dataXYZ
Out[278]:
TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft
120010000300 0.0 18.0 interval drift? NaN 40.079858 -90.913587 586.73 0 0
120010000300 18.0 20.0 Colchester No. 2 coal,Penn. carb NaN 40.079858 -90.913587 586.73 0 0
120010000300 20.0 20.0 fire clay at CLAY FIRECLAY CLAY -1.0 40.079858 -90.913587 586.73 0 0
120010000800 0.0 175.0 interval UNKNOWN UNKNOWN -1.0 40.039934 -90.923914 746.05 0 0
120010000800 175.0 175.0 coal No. 2 possibly at NaN 40.039934 -90.923914 746.05 0 0
120010000900 0.0 133.0 interval ? NaN 40.032768 -90.943348 740.93 0 0
120010000900 133.0 135.0 coal BEDROCK COAL BEDROCK 1.0 40.032768 -90.943348 740.93 0 0
120010000900 135.0 136.0 fire clay BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93 0 0
120010001000 0.0 135.0 interval UNKNOWN UNKNOWN -1.0 40.034531 -90.936092 739.90 0 0
120010001000 135.0 137.0 coal,Pennsylvanian or Carbondale NaN 40.034531 -90.936092 739.90 0 0
120010001000 137.0 139.0 fire clay BEDROCK BEDROCK 1.0 40.034531 -90.936092 739.90 0 0
120010001100 0.0 37.0 clay & coal CLAY AND STONE COAL BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 0 0
120010001100 37.0 39.0 limestone, nodular BEDROCK LIMESTONE BEDROCK -1.0 40.029328 -90.962715 698.97 0 0
120010001100 39.0 51.0 clay & soapstone CLAY AND STONE SHALE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 0 0
120010001100 51.0 145.0 interval UNKNOWN UNKNOWN -1.0 40.029328 -90.962715 698.97 0 0
120010001100 145.0 148.0 coal & underclay BEDROCK COAL AND FIRECLAY BEDROCK -1.0 40.029328 -90.962715 698.97 0 0
120010001200 0.0 35.0 interval UNKNOWN UNKNOWN -1.0 40.105970 -91.054776 696.32 0 0
120010001200 35.0 36.0 black slate BEDROCK BLACK SLATE BEDROCK 1.0 40.105970 -91.054776 696.32 0 0
120010001200 36.0 37.0 coal BEDROCK COAL BEDROCK 1.0 40.105970 -91.054776 696.32 0 0
120010001400 0.0 15.0 till,sy,ltl gvl,lim brn CLAY CLAY 0.0 40.021306 -91.086866 735.45 0 0
120010001400 15.0 45.0 till,sy,ltl gvl,lim brn,but calcareous CLAY CLAY 0.0 40.021306 -91.086866 735.45 0 0
120010001400 45.0 60.0 till,sy,ltl gvl,lim brn brnsh gry CLAY CLAY 0.0 40.021306 -91.086866 735.45 0 0
120010001400 60.0 65.0 till,sy,ltl gvl,greenish-gray CLAY CLAY 0.0 40.021306 -91.086866 735.45 0 0
120010001400 65.0 70.0 till,s,ltl gvl,grn-gry, calc, lime CLAY CLAY 0.0 40.021306 -91.086866 735.45 0 0
120010001400 70.0 85.0 sh,slgtly sy,brnsh gry,fm to wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
120010001400 85.0 105.0 sh,sty,slgtly sy,slgtly calc,med gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
120010001400 105.0 120.0 sh,blk,lamd,fm;a ltl ls,argil,blk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
120010001400 120.0 125.0 sh,sty,calc,dk gry,wk;sh,sy,ylsh gry BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
120010001400 125.0 130.0 sh,blk,fm;sh,sty,dk gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
120010001400 130.0 135.0 sh,blk;sh,sty,dk gry;ls,argil,vy f,crinl BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 0 0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
480590599900 59.0 174.0 blue clay & gravel CLAY AND GRAVEL BLUE CLAY AND GRAVEL MIX 1.0 NaN NaN NaN 0 0
480590599900 90.0 110.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590600100 0.0 280.0 struck limestone at NaN NaN NaN NaN 0 0
480590600100 280.0 280.0 drift GENERIC GENERIC 1.0 NaN NaN NaN 0 0
480590601300 7.0 15.0 brown clay CLAY BROWN CLAY 1.0 NaN NaN NaN 0 0
480590601300 8.0 8.0 topsoil SOIL SOIL 1.0 NaN NaN NaN 0 0
480590601300 9.0 150.0 gravel GRAVEL GRAVEL 1.0 NaN NaN NaN 0 0
480590601300 17.0 112.0 red clay CLAY RED CLAY 1.0 NaN NaN NaN 0 0
480590601300 29.0 141.0 sand SAND SAND -1.0 NaN NaN NaN 0 0
480590601300 80.0 95.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590601700 2.0 2.0 topsoil SOIL SOIL 1.0 NaN NaN NaN 0 0
480590601700 7.0 153.0 dirty gravel GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN 0 0
480590601700 16.0 18.0 yellow clay CLAY YELLOW CLAY 1.0 NaN NaN NaN 0 0
480590601700 21.0 217.0 rock BEDROCK BEDROCK 1.0 NaN NaN NaN 0 0
480590601700 22.0 111.0 soft dirty sand SAND SOFT DIRTY SAND -1.0 NaN NaN NaN 0 0
480590601700 35.0 146.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590601700 43.0 196.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590601700 71.0 89.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590602400 1.0 1.0 topsoil SOIL SOIL 1.0 NaN NaN NaN 0 0
480590602400 2.0 222.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN 0 0
480590602400 14.0 175.0 sand SAND SAND -1.0 NaN NaN NaN 0 0
480590602400 25.0 26.0 subsoil SOIL SOIL -1.0 NaN NaN NaN 0 0
480590602400 45.0 220.0 hardpan SOIL HARDPAN SOIL 1.0 NaN NaN NaN 0 0
480590602400 135.0 161.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0
480590602600 12.0 291.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN 0 0
480590602600 19.0 279.0 gravel & dirty sand SAND AND GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN 0 0
480590602600 20.0 20.0 topsoil & clay CLAY CLAY -1.0 NaN NaN NaN 0 0
480590602600 20.0 260.0 red clay & gravel CLAY AND GRAVEL RED CLAY AND GRAVEL MIX -1.0 NaN NaN NaN 0 0
480590602600 60.0 240.0 fine sand SAND SAND 1.0 NaN NaN NaN 0 0
480590602600 160.0 180.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN 0 0

1824955 rows × 15 columns

In [279]:
#Calculate interval elevations
dataXYZ.iloc[:, 13] = dataXYZJoin.iloc[:, 12]-dataXYZJoin.iloc[:, 0]
dataXYZ.iloc[:, 14] = dataXYZJoin.iloc[:, 12]-dataXYZJoin.iloc[:, 1]
In [280]:
dataXYZ
Out[280]:
TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft
120010000300 0.0 18.0 interval drift? NaN 40.079858 -90.913587 586.73 586.73 568.73
120010000300 18.0 20.0 Colchester No. 2 coal,Penn. carb NaN 40.079858 -90.913587 586.73 568.73 566.73
120010000300 20.0 20.0 fire clay at CLAY FIRECLAY CLAY -1.0 40.079858 -90.913587 586.73 566.73 566.73
120010000800 0.0 175.0 interval UNKNOWN UNKNOWN -1.0 40.039934 -90.923914 746.05 746.05 571.05
120010000800 175.0 175.0 coal No. 2 possibly at NaN 40.039934 -90.923914 746.05 571.05 571.05
120010000900 0.0 133.0 interval ? NaN 40.032768 -90.943348 740.93 740.93 607.93
120010000900 133.0 135.0 coal BEDROCK COAL BEDROCK 1.0 40.032768 -90.943348 740.93 607.93 605.93
120010000900 135.0 136.0 fire clay BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93 605.93 604.93
120010001000 0.0 135.0 interval UNKNOWN UNKNOWN -1.0 40.034531 -90.936092 739.90 739.90 604.90
120010001000 135.0 137.0 coal,Pennsylvanian or Carbondale NaN 40.034531 -90.936092 739.90 604.90 602.90
120010001000 137.0 139.0 fire clay BEDROCK BEDROCK 1.0 40.034531 -90.936092 739.90 602.90 600.90
120010001100 0.0 37.0 clay & coal CLAY AND STONE COAL BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97
120010001100 37.0 39.0 limestone, nodular BEDROCK LIMESTONE BEDROCK -1.0 40.029328 -90.962715 698.97 661.97 659.97
120010001100 39.0 51.0 clay & soapstone CLAY AND STONE SHALE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 659.97 647.97
120010001100 51.0 145.0 interval UNKNOWN UNKNOWN -1.0 40.029328 -90.962715 698.97 647.97 553.97
120010001100 145.0 148.0 coal & underclay BEDROCK COAL AND FIRECLAY BEDROCK -1.0 40.029328 -90.962715 698.97 553.97 550.97
120010001200 0.0 35.0 interval UNKNOWN UNKNOWN -1.0 40.105970 -91.054776 696.32 696.32 661.32
120010001200 35.0 36.0 black slate BEDROCK BLACK SLATE BEDROCK 1.0 40.105970 -91.054776 696.32 661.32 660.32
120010001200 36.0 37.0 coal BEDROCK COAL BEDROCK 1.0 40.105970 -91.054776 696.32 660.32 659.32
120010001400 0.0 15.0 till,sy,ltl gvl,lim brn CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45
120010001400 15.0 45.0 till,sy,ltl gvl,lim brn,but calcareous CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45
120010001400 45.0 60.0 till,sy,ltl gvl,lim brn brnsh gry CLAY CLAY 0.0 40.021306 -91.086866 735.45 690.45 675.45
120010001400 60.0 65.0 till,sy,ltl gvl,greenish-gray CLAY CLAY 0.0 40.021306 -91.086866 735.45 675.45 670.45
120010001400 65.0 70.0 till,s,ltl gvl,grn-gry, calc, lime CLAY CLAY 0.0 40.021306 -91.086866 735.45 670.45 665.45
120010001400 70.0 85.0 sh,slgtly sy,brnsh gry,fm to wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 665.45 650.45
120010001400 85.0 105.0 sh,sty,slgtly sy,slgtly calc,med gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 650.45 630.45
120010001400 105.0 120.0 sh,blk,lamd,fm;a ltl ls,argil,blk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 630.45 615.45
120010001400 120.0 125.0 sh,sty,calc,dk gry,wk;sh,sy,ylsh gry BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 615.45 610.45
120010001400 125.0 130.0 sh,blk,fm;sh,sty,dk gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 610.45 605.45
120010001400 130.0 135.0 sh,blk;sh,sty,dk gry;ls,argil,vy f,crinl BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 605.45 600.45
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
480590599900 59.0 174.0 blue clay & gravel CLAY AND GRAVEL BLUE CLAY AND GRAVEL MIX 1.0 NaN NaN NaN NaN NaN
480590599900 90.0 110.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590600100 0.0 280.0 struck limestone at NaN NaN NaN NaN NaN NaN
480590600100 280.0 280.0 drift GENERIC GENERIC 1.0 NaN NaN NaN NaN NaN
480590601300 7.0 15.0 brown clay CLAY BROWN CLAY 1.0 NaN NaN NaN NaN NaN
480590601300 8.0 8.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
480590601300 9.0 150.0 gravel GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN
480590601300 17.0 112.0 red clay CLAY RED CLAY 1.0 NaN NaN NaN NaN NaN
480590601300 29.0 141.0 sand SAND SAND -1.0 NaN NaN NaN NaN NaN
480590601300 80.0 95.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590601700 2.0 2.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
480590601700 7.0 153.0 dirty gravel GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN NaN NaN
480590601700 16.0 18.0 yellow clay CLAY YELLOW CLAY 1.0 NaN NaN NaN NaN NaN
480590601700 21.0 217.0 rock BEDROCK BEDROCK 1.0 NaN NaN NaN NaN NaN
480590601700 22.0 111.0 soft dirty sand SAND SOFT DIRTY SAND -1.0 NaN NaN NaN NaN NaN
480590601700 35.0 146.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590601700 43.0 196.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590601700 71.0 89.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590602400 1.0 1.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
480590602400 2.0 222.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN NaN NaN
480590602400 14.0 175.0 sand SAND SAND -1.0 NaN NaN NaN NaN NaN
480590602400 25.0 26.0 subsoil SOIL SOIL -1.0 NaN NaN NaN NaN NaN
480590602400 45.0 220.0 hardpan SOIL HARDPAN SOIL 1.0 NaN NaN NaN NaN NaN
480590602400 135.0 161.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
480590602600 12.0 291.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN NaN NaN
480590602600 19.0 279.0 gravel & dirty sand SAND AND GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN NaN NaN
480590602600 20.0 20.0 topsoil & clay CLAY CLAY -1.0 NaN NaN NaN NaN NaN
480590602600 20.0 260.0 red clay & gravel CLAY AND GRAVEL RED CLAY AND GRAVEL MIX -1.0 NaN NaN NaN NaN NaN
480590602600 60.0 240.0 fine sand SAND SAND 1.0 NaN NaN NaN NaN NaN
480590602600 160.0 180.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN

1824955 rows × 15 columns

In [281]:
#Test exporting data to CSV
WellXYZ.to_csv('WellXYZ_outTest.txt', quoting=1, quotechar='"',)
In [282]:
#Reset index after join and make index (API) one of the columns
dataXYZ = dataXYZ.reset_index()
dataXYZ.rename(columns={'index': 'API_Number'}, inplace=True)
dataXYZ
Out[282]:
API_Number TOP BOTTOM FORMATION_SHORT LITHOLOGY COLOR CONSISTENCY MOD1 MOD2 INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft
0 120010000300 0.0 18.0 interval drift? NaN 40.079858 -90.913587 586.73 586.73 568.73
1 120010000300 18.0 20.0 Colchester No. 2 coal,Penn. carb NaN 40.079858 -90.913587 586.73 568.73 566.73
2 120010000300 20.0 20.0 fire clay at CLAY FIRECLAY CLAY -1.0 40.079858 -90.913587 586.73 566.73 566.73
3 120010000800 0.0 175.0 interval UNKNOWN UNKNOWN -1.0 40.039934 -90.923914 746.05 746.05 571.05
4 120010000800 175.0 175.0 coal No. 2 possibly at NaN 40.039934 -90.923914 746.05 571.05 571.05
5 120010000900 0.0 133.0 interval ? NaN 40.032768 -90.943348 740.93 740.93 607.93
6 120010000900 133.0 135.0 coal BEDROCK COAL BEDROCK 1.0 40.032768 -90.943348 740.93 607.93 605.93
7 120010000900 135.0 136.0 fire clay BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93 605.93 604.93
8 120010001000 0.0 135.0 interval UNKNOWN UNKNOWN -1.0 40.034531 -90.936092 739.90 739.90 604.90
9 120010001000 135.0 137.0 coal,Pennsylvanian or Carbondale NaN 40.034531 -90.936092 739.90 604.90 602.90
10 120010001000 137.0 139.0 fire clay BEDROCK BEDROCK 1.0 40.034531 -90.936092 739.90 602.90 600.90
11 120010001100 0.0 37.0 clay & coal CLAY AND STONE COAL BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97
12 120010001100 37.0 39.0 limestone, nodular BEDROCK LIMESTONE BEDROCK -1.0 40.029328 -90.962715 698.97 661.97 659.97
13 120010001100 39.0 51.0 clay & soapstone CLAY AND STONE SHALE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 659.97 647.97
14 120010001100 51.0 145.0 interval UNKNOWN UNKNOWN -1.0 40.029328 -90.962715 698.97 647.97 553.97
15 120010001100 145.0 148.0 coal & underclay BEDROCK COAL AND FIRECLAY BEDROCK -1.0 40.029328 -90.962715 698.97 553.97 550.97
16 120010001200 0.0 35.0 interval UNKNOWN UNKNOWN -1.0 40.105970 -91.054776 696.32 696.32 661.32
17 120010001200 35.0 36.0 black slate BEDROCK BLACK SLATE BEDROCK 1.0 40.105970 -91.054776 696.32 661.32 660.32
18 120010001200 36.0 37.0 coal BEDROCK COAL BEDROCK 1.0 40.105970 -91.054776 696.32 660.32 659.32
19 120010001400 0.0 15.0 till,sy,ltl gvl,lim brn CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45
20 120010001400 15.0 45.0 till,sy,ltl gvl,lim brn,but calcareous CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45
21 120010001400 45.0 60.0 till,sy,ltl gvl,lim brn brnsh gry CLAY CLAY 0.0 40.021306 -91.086866 735.45 690.45 675.45
22 120010001400 60.0 65.0 till,sy,ltl gvl,greenish-gray CLAY CLAY 0.0 40.021306 -91.086866 735.45 675.45 670.45
23 120010001400 65.0 70.0 till,s,ltl gvl,grn-gry, calc, lime CLAY CLAY 0.0 40.021306 -91.086866 735.45 670.45 665.45
24 120010001400 70.0 85.0 sh,slgtly sy,brnsh gry,fm to wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 665.45 650.45
25 120010001400 85.0 105.0 sh,sty,slgtly sy,slgtly calc,med gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 650.45 630.45
26 120010001400 105.0 120.0 sh,blk,lamd,fm;a ltl ls,argil,blk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 630.45 615.45
27 120010001400 120.0 125.0 sh,sty,calc,dk gry,wk;sh,sy,ylsh gry BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 615.45 610.45
28 120010001400 125.0 130.0 sh,blk,fm;sh,sty,dk gry,wk BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 610.45 605.45
29 120010001400 130.0 135.0 sh,blk;sh,sty,dk gry;ls,argil,vy f,crinl BEDROCK SHALE BEDROCK NaN 40.021306 -91.086866 735.45 605.45 600.45
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1824925 480590599900 59.0 174.0 blue clay & gravel CLAY AND GRAVEL BLUE CLAY AND GRAVEL MIX 1.0 NaN NaN NaN NaN NaN
1824926 480590599900 90.0 110.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824927 480590600100 0.0 280.0 struck limestone at NaN NaN NaN NaN NaN NaN
1824928 480590600100 280.0 280.0 drift GENERIC GENERIC 1.0 NaN NaN NaN NaN NaN
1824929 480590601300 7.0 15.0 brown clay CLAY BROWN CLAY 1.0 NaN NaN NaN NaN NaN
1824930 480590601300 8.0 8.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
1824931 480590601300 9.0 150.0 gravel GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN
1824932 480590601300 17.0 112.0 red clay CLAY RED CLAY 1.0 NaN NaN NaN NaN NaN
1824933 480590601300 29.0 141.0 sand SAND SAND -1.0 NaN NaN NaN NaN NaN
1824934 480590601300 80.0 95.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824935 480590601700 2.0 2.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
1824936 480590601700 7.0 153.0 dirty gravel GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN NaN NaN
1824937 480590601700 16.0 18.0 yellow clay CLAY YELLOW CLAY 1.0 NaN NaN NaN NaN NaN
1824938 480590601700 21.0 217.0 rock BEDROCK BEDROCK 1.0 NaN NaN NaN NaN NaN
1824939 480590601700 22.0 111.0 soft dirty sand SAND SOFT DIRTY SAND -1.0 NaN NaN NaN NaN NaN
1824940 480590601700 35.0 146.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824941 480590601700 43.0 196.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824942 480590601700 71.0 89.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824943 480590602400 1.0 1.0 topsoil SOIL SOIL 1.0 NaN NaN NaN NaN NaN
1824944 480590602400 2.0 222.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN NaN NaN
1824945 480590602400 14.0 175.0 sand SAND SAND -1.0 NaN NaN NaN NaN NaN
1824946 480590602400 25.0 26.0 subsoil SOIL SOIL -1.0 NaN NaN NaN NaN NaN
1824947 480590602400 45.0 220.0 hardpan SOIL HARDPAN SOIL 1.0 NaN NaN NaN NaN NaN
1824948 480590602400 135.0 161.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN
1824949 480590602600 12.0 291.0 limestone BEDROCK LIMESTONE SHALE BEDROCK 1.0 NaN NaN NaN NaN NaN
1824950 480590602600 19.0 279.0 gravel & dirty sand SAND AND GRAVEL DIRTY GRAVEL -1.0 NaN NaN NaN NaN NaN
1824951 480590602600 20.0 20.0 topsoil & clay CLAY CLAY -1.0 NaN NaN NaN NaN NaN
1824952 480590602600 20.0 260.0 red clay & gravel CLAY AND GRAVEL RED CLAY AND GRAVEL MIX -1.0 NaN NaN NaN NaN NaN
1824953 480590602600 60.0 240.0 fine sand SAND SAND 1.0 NaN NaN NaN NaN NaN
1824954 480590602600 160.0 180.0 blue clay CLAY GRAY CLAY -1.0 NaN NaN NaN NaN NaN

1824955 rows × 16 columns

In [283]:
#Export formatted dataset
dataXYZ.to_csv('AllData_XYZ.txt',quoting=1, quotechar='"')
In [284]:
#Create new data set to preserve old (will be truncated)
wellLithData = dataXYZJoin
In [285]:
len(wellLithData)
Out[285]:
1824955
In [286]:
#Trim dataset of unnecessary information for these purposes
del wellLithData['FORMATION_SHORT']
del wellLithData['COLOR']
del wellLithData['CONSISTENCY']
del wellLithData['MOD1']
del wellLithData['MOD2']
In [287]:
#Export truncated data
wellLithData.to_csv('AllData_XYZ_truncated.txt', quoting=1, quotechar='"',)
In [288]:
COARSECODE
Out[288]:
INTERPRETED LITHOLOGY COARSECODE TARGET
0 BEDROCK BEDROCK DoNotUse -1
1 BEDROCK FIRECLAY DoNotUse -1
2 BEDROCK VOID DoNotUse -1
3 BEDROCK AND OTHER CLAY AND STONE Fine 0
4 BEDROCK AND OTHER DIRT AND BEDROCK DoNotUse -1
5 BEDROCK AND OTHER DIRT AND STONE DoNotUse -1
6 BEDROCK AND OTHER GRAVEL AND STONE Coarse 1
7 BOULDERY MATERIAL BOULDER Coarse 1
8 BOULDERY MATERIAL BOULDERS AND CLAY Fine 0
9 BOULDERY MATERIAL GRAVEL WITH BOULDERS Coarse 1
10 CLAY CLAY Fine 0
11 CLAY DIRT AND CLAY Fine 0
12 CLAY AND GRAVEL MIX CLAY AND GRAVEL Fine 0
13 CLAY AND GRAVEL MIX CLAY WITH GRAVEL Fine 0
14 CLAY AND GRAVEL MIX MUD AND GRAVEL Fine 0
15 CLAY AND SAND MIX CLAY AND SAND Fine 0
16 CLAY AND SAND MIX CLAY WITH SAND Fine 0
17 CLAY AND SAND MIX MUD AND SAND Fine 0
18 CLAY WITH GRAVEL SEAMS CLAY WITH GRAVEL SEAMS Fine 0
19 CLAY WITH SAND SEAMS CLAY WITH SAND STREAKS Fine 0
20 FILL FILL DoNotUse -1
21 GENERIC DRIFT DoNotUse -1
22 GENERIC MUD DoNotUse -1
23 GRAVEL DIRT AND GRAVEL Coarse 1
24 GRAVEL GRAVEL Coarse 1
25 GRAVEL GRAVEL WITH SAND Coarse 1
26 GRAVEL AND CLAY MIX GRAVEL AND CLAY Fine 0
27 GRAVEL AND CLAY GRAVEL WITH CLAY Fine 0
28 GRAVEL WITH CLAY SEAMS GRAVEL WITH CLAY STREAKS Fine 0
29 ORGANIC MATERIAL MARL Fine 0
30 ORGANIC MATERIAL ORGANIC MATERIAL Fine 0
31 SAND DIRT AND SAND Coarse 1
32 SAND SAND Coarse 1
33 SAND AND CLAY MIX SAND AND CLAY Fine 0
34 SAND AND CLAY MIX SAND WITH CLAY Fine 0
35 SAND AND GRAVEL SAND AND GRAVEL Coarse 1
36 SAND AND GRAVEL SAND WITH GRAVEL Coarse 1
37 SAND WITH CLAY SEAMS SAND WITH CLAY STREAKS Fine 0
38 SILT SILT Fine 0
39 SILT AND GRAVEL MIX SILT AND GRAVEL Fine 0
40 SILT AND SAND MIX SILT AND SAND Fine 0
41 SILT AND SAND MIX SILT WITH SAND SEAMS Fine 0
42 SOIL DIRT DoNotUse -1
43 SOIL SOIL DoNotUse -1
44 UNKNOWN UNKNOWN DoNotUse -1
In [289]:
Coarse_List = COARSECODE.loc[COARSECODE['COARSECODE'] == 'Coarse']['LITHOLOGY']
In [290]:
Coarse_List
Out[290]:
6         GRAVEL AND STONE
7                  BOULDER
9     GRAVEL WITH BOULDERS
23         DIRT AND GRAVEL
24                  GRAVEL
25        GRAVEL WITH SAND
31           DIRT AND SAND
32                    SAND
35         SAND AND GRAVEL
36        SAND WITH GRAVEL
Name: LITHOLOGY, dtype: object
In [291]:
Fine_List = COARSECODE.loc[COARSECODE['COARSECODE'] == 'Fine']['LITHOLOGY']
Fine_List
Out[291]:
3               CLAY AND STONE
8            BOULDERS AND CLAY
10                        CLAY
11               DIRT AND CLAY
12             CLAY AND GRAVEL
13            CLAY WITH GRAVEL
14              MUD AND GRAVEL
15               CLAY AND SAND
16              CLAY WITH SAND
17                MUD AND SAND
18      CLAY WITH GRAVEL SEAMS
19      CLAY WITH SAND STREAKS
26             GRAVEL AND CLAY
27            GRAVEL WITH CLAY
28    GRAVEL WITH CLAY STREAKS
29                        MARL
30            ORGANIC MATERIAL
33               SAND AND CLAY
34              SAND WITH CLAY
37      SAND WITH CLAY STREAKS
38                        SILT
39             SILT AND GRAVEL
40               SILT AND SAND
41        SILT WITH SAND SEAMS
Name: LITHOLOGY, dtype: object
In [292]:
Bedrock_list = COARSECODE.loc[COARSECODE['INTERPRETED'] == 'BEDROCK']['LITHOLOGY']
Bedrock_list
Out[292]:
0     BEDROCK
1    FIRECLAY
2        VOID
Name: LITHOLOGY, dtype: object
In [293]:
#Create binary code for coarse/fine data
Code1 = pd.DataFrame(wellLithData.loc[: , 'LITHOLOGY'].isin(Coarse_List) * 2) + pd.DataFrame(wellLithData.loc[: , 'LITHOLOGY'].isin(Fine_List) * 1) - 1
In [294]:
Code1.columns = ['Target']
In [295]:
dfOrig = wellLithData
len(dfOrig)
Out[295]:
1824955
In [296]:
print('Code1Len: '+str(len(Code1['Target'])))
print('dfOrigLen: '+str(len(dfOrig['TOP'])))
Code1Len: 1824955
dfOrigLen: 1824955
In [297]:
dfOrig['Target'] = Code1['Target'].values
In [298]:
dfOrig
Out[298]:
TOP BOTTOM LITHOLOGY INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft Target
120010000300 0.0 18.0 NaN 40.079858 -90.913587 586.73 586.73 568.73 -1
120010000300 18.0 20.0 NaN 40.079858 -90.913587 586.73 568.73 566.73 -1
120010000300 20.0 20.0 CLAY CLAY -1.0 40.079858 -90.913587 586.73 566.73 566.73 0
120010000800 0.0 175.0 UNKNOWN UNKNOWN -1.0 40.039934 -90.923914 746.05 746.05 571.05 -1
120010000800 175.0 175.0 NaN 40.039934 -90.923914 746.05 571.05 571.05 -1
120010000900 0.0 133.0 NaN 40.032768 -90.943348 740.93 740.93 607.93 -1
120010000900 133.0 135.0 BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93 607.93 605.93 -1
120010000900 135.0 136.0 BEDROCK BEDROCK 1.0 40.032768 -90.943348 740.93 605.93 604.93 -1
120010001000 0.0 135.0 UNKNOWN UNKNOWN -1.0 40.034531 -90.936092 739.90 739.90 604.90 -1
120010001000 135.0 137.0 NaN 40.034531 -90.936092 739.90 604.90 602.90 -1
120010001000 137.0 139.0 BEDROCK BEDROCK 1.0 40.034531 -90.936092 739.90 602.90 600.90 -1
120010001100 0.0 37.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97 0
120010001100 37.0 39.0 BEDROCK BEDROCK -1.0 40.029328 -90.962715 698.97 661.97 659.97 -1
120010001100 39.0 51.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 659.97 647.97 0
120010001100 51.0 145.0 UNKNOWN UNKNOWN -1.0 40.029328 -90.962715 698.97 647.97 553.97 -1
120010001100 145.0 148.0 BEDROCK BEDROCK -1.0 40.029328 -90.962715 698.97 553.97 550.97 -1
120010001200 0.0 35.0 UNKNOWN UNKNOWN -1.0 40.105970 -91.054776 696.32 696.32 661.32 -1
120010001200 35.0 36.0 BEDROCK BEDROCK 1.0 40.105970 -91.054776 696.32 661.32 660.32 -1
120010001200 36.0 37.0 BEDROCK BEDROCK 1.0 40.105970 -91.054776 696.32 660.32 659.32 -1
120010001400 0.0 15.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45 0
120010001400 15.0 45.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45 0
120010001400 45.0 60.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 690.45 675.45 0
120010001400 60.0 65.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 675.45 670.45 0
120010001400 65.0 70.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 670.45 665.45 0
120010001400 70.0 85.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 665.45 650.45 -1
120010001400 85.0 105.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 650.45 630.45 -1
120010001400 105.0 120.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 630.45 615.45 -1
120010001400 120.0 125.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 615.45 610.45 -1
120010001400 125.0 130.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 610.45 605.45 -1
120010001400 130.0 135.0 BEDROCK BEDROCK NaN 40.021306 -91.086866 735.45 605.45 600.45 -1
... ... ... ... ... ... ... ... ... ... ... ...
480590599900 59.0 174.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX 1.0 NaN NaN NaN NaN NaN 0
480590599900 90.0 110.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590600100 0.0 280.0 NaN NaN NaN NaN NaN NaN -1
480590600100 280.0 280.0 GENERIC GENERIC 1.0 NaN NaN NaN NaN NaN -1
480590601300 7.0 15.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0
480590601300 8.0 8.0 SOIL SOIL 1.0 NaN NaN NaN NaN NaN -1
480590601300 9.0 150.0 GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1
480590601300 17.0 112.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0
480590601300 29.0 141.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1
480590601300 80.0 95.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590601700 2.0 2.0 SOIL SOIL 1.0 NaN NaN NaN NaN NaN -1
480590601700 7.0 153.0 GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1
480590601700 16.0 18.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0
480590601700 21.0 217.0 BEDROCK BEDROCK 1.0 NaN NaN NaN NaN NaN -1
480590601700 22.0 111.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1
480590601700 35.0 146.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590601700 43.0 196.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590601700 71.0 89.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590602400 1.0 1.0 SOIL SOIL 1.0 NaN NaN NaN NaN NaN -1
480590602400 2.0 222.0 BEDROCK BEDROCK 1.0 NaN NaN NaN NaN NaN -1
480590602400 14.0 175.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1
480590602400 25.0 26.0 SOIL SOIL -1.0 NaN NaN NaN NaN NaN -1
480590602400 45.0 220.0 SOIL SOIL 1.0 NaN NaN NaN NaN NaN -1
480590602400 135.0 161.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590602600 12.0 291.0 BEDROCK BEDROCK 1.0 NaN NaN NaN NaN NaN -1
480590602600 19.0 279.0 SAND AND GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1
480590602600 20.0 20.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0
480590602600 20.0 260.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX -1.0 NaN NaN NaN NaN NaN 0
480590602600 60.0 240.0 SAND SAND 1.0 NaN NaN NaN NaN NaN 1
480590602600 160.0 180.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0

1824955 rows × 11 columns

In [299]:
dfOrig['API_Number'] = dfOrig.index
len(dfOrig)
Out[299]:
1824955
In [300]:
# have a simple look on the stats on TopEle of all the records with target value of 1/0
dfOrig.loc[(dfOrig['Target'].isin([1,0]))]['TOP_ELEV_ft'].describe()
Out[300]:
count    914981.000000
mean        633.177610
std         179.577085
min       -3744.560000
25%         561.350000
50%         641.790000
75%         725.020000
max        1172.920000
Name: TOP_ELEV_ft, dtype: float64
In [304]:
#Number of Unique Well APIs
UniqueWells = df['API_Number'].unique()
len(UniqueWells)
Out[304]:
255952
In [305]:
df = dfOrig.loc[(dfOrig['Target'].isin([1,0]))]
#df = df.loc[(df['COMPLETED'].isin([1,0,-1]))]
len(df)
Out[305]:
923964
In [306]:
len(df.loc[(df['Target'].isin([1]))]['TOP_ELEV_ft'])
Out[306]:
344322
In [307]:
UniqueWells = df.index.unique()
len(UniqueWells)
Out[307]:
255952
In [308]:
# check if there is any overlapping range with same API
err_API = set()
print('Number of Unique API:', df.index.unique().shape)
for i in df.index.unique():
    API_group = df.loc[df.index == i].sort_values(by=['TOP_ELEV_ft'], ascending=False)
    API_records = API_group.loc[:,['TOP_ELEV_ft','BOT_ELEV_ft']].values.tolist()
    #print('checking API:', i)
    for j in range(len(API_records)-1):
        if API_records[j+1][0] - API_records[j][1] > 0:
            print(j,'Overlappin Intervals!',API_records[j+1][0],API_records[j][1])
            err_API.add(i)
Number of Unique API: (255952,)
0 Overlappin Intervals! 321.76 306.76
1 Overlappin Intervals! 320.76 295.76
2 Overlappin Intervals! 311.76 300.76
0 Overlappin Intervals! 516.47 508.47
1 Overlappin Intervals! 503.47 474.47
0 Overlappin Intervals! 807.42 792.42
0 Overlappin Intervals! 737.1 736.1
0 Overlappin Intervals! 888.63 883.63
0 Overlappin Intervals! 778.81 720.81
1 Overlappin Intervals! 763.81 738.81
0 Overlappin Intervals! 760.37 740.37
1 Overlappin Intervals! 745.37 700.37
1 Overlappin Intervals! 795.75 722.75
0 Overlappin Intervals! 742.72 725.72
0 Overlappin Intervals! 880.7 877.7
0 Overlappin Intervals! 770.42 768.42
2 Overlappin Intervals! 754.42 743.42
3 Overlappin Intervals! 753.42 719.42
0 Overlappin Intervals! 742.32 687.32
1 Overlappin Intervals! 717.32 622.32
2 Overlappin Intervals! 697.32 642.32
0 Overlappin Intervals! 825.69 765.69
1 Overlappin Intervals! 820.69 700.69
2 Overlappin Intervals! 780.69 755.69
3 Overlappin Intervals! 765.69 705.69
0 Overlappin Intervals! 894.85 892.85
2 Overlappin Intervals! 862.85 852.85
0 Overlappin Intervals! 822.86 772.86
1 Overlappin Intervals! 807.58 801.58
1 Overlappin Intervals! 495.66999999999996 420.66999999999996
1 Overlappin Intervals! 495.66999999999996 420.66999999999996
3 Overlappin Intervals! 751.94 619.94
0 Overlappin Intervals! 602.44 462.44000000000005
1 Overlappin Intervals! 598.44 477.44000000000005
2 Overlappin Intervals! 531.44 502.44000000000005
11 Overlappin Intervals! 495.77 470.77
0 Overlappin Intervals! 660.91 644.91
1 Overlappin Intervals! 648.91 590.91
0 Overlappin Intervals! 708.2 459.20000000000005
7 Overlappin Intervals! 588.81 586.81
9 Overlappin Intervals! 586.81 578.81
0 Overlappin Intervals! 790.32 633.32
11 Overlappin Intervals! 533.76 457.76
13 Overlappin Intervals! 539.69 531.69
0 Overlappin Intervals! 663.88 659.88
1 Overlappin Intervals! 659.88 473.88
2 Overlappin Intervals! 580.79 560.79
4 Overlappin Intervals! 667.25 510.25
11 Overlappin Intervals! 552.35 521.35
12 Overlappin Intervals! 521.35 447.35
2 Overlappin Intervals! 590.91 573.91
4 Overlappin Intervals! 573.91 535.91
12 Overlappin Intervals! 477.19000000000005 447.19000000000005
3 Overlappin Intervals! 621.92 609.92
1 Overlappin Intervals! 620.66 565.66
2 Overlappin Intervals! 565.66 454.65999999999997
4 Overlappin Intervals! 545.83 500.83000000000004
5 Overlappin Intervals! 500.83000000000004 472.83000000000004
12 Overlappin Intervals! 532.2 525.2
0 Overlappin Intervals! 492.29 478.29
0 Overlappin Intervals! 855.88 832.88
4 Overlappin Intervals! 567.55 540.55
12 Overlappin Intervals! 376.63 375.63
6 Overlappin Intervals! 409.49 385.49
19 Overlappin Intervals! 497.71000000000004 487.71000000000004
0 Overlappin Intervals! 698.88 674.88
12 Overlappin Intervals! 597.68 594.68
12 Overlappin Intervals! 599.98 593.98
2 Overlappin Intervals! 716.83 711.83
1 Overlappin Intervals! 728.3 718.13
3 Overlappin Intervals! 713.13 695.3
6 Overlappin Intervals! 689.8 676.3
8 Overlappin Intervals! 676.3 665.88
9 Overlappin Intervals! 665.88 655.05
11 Overlappin Intervals! 655.05 618.88
16 Overlappin Intervals! 618.88 608.38
18 Overlappin Intervals! 608.38 602.96
20 Overlappin Intervals! 597.55 587.63
21 Overlappin Intervals! 587.63 571.38
23 Overlappin Intervals! 571.38 565.88
26 Overlappin Intervals! 560.55 549.71
29 Overlappin Intervals! 549.71 537.71
31 Overlappin Intervals! 537.71 527.88
1 Overlappin Intervals! 724.9100000000001 714.4100000000001
3 Overlappin Intervals! 714.4100000000001 703.75
5 Overlappin Intervals! 703.75 693.58
7 Overlappin Intervals! 693.58 683.58
10 Overlappin Intervals! 675.25 643.08
12 Overlappin Intervals! 637.0 621.5
14 Overlappin Intervals! 621.5 612.1600000000001
17 Overlappin Intervals! 609.08 591.58
18 Overlappin Intervals! 591.58 587.08
19 Overlappin Intervals! 587.08 580.4100000000001
22 Overlappin Intervals! 580.4100000000001 574.83
24 Overlappin Intervals! 574.83 569.83
0 Overlappin Intervals! 728.82 718.74
2 Overlappin Intervals! 718.74 708.57
4 Overlappin Intervals! 708.57 669.49
7 Overlappin Intervals! 669.49 664.1500000000001
10 Overlappin Intervals! 653.74 621.49
12 Overlappin Intervals! 621.49 616.1500000000001
14 Overlappin Intervals! 616.1500000000001 602.82
16 Overlappin Intervals! 602.82 584.32
17 Overlappin Intervals! 584.32 582.82
18 Overlappin Intervals! 582.82 578.82
21 Overlappin Intervals! 573.32 568.82
25 Overlappin Intervals! 533.82 466.82000000000005
2 Overlappin Intervals! 680.01 660.01
3 Overlappin Intervals! 588.79 582.79
10 Overlappin Intervals! 549.79 540.79
12 Overlappin Intervals! 558.11 557.11
2 Overlappin Intervals! 768.37 736.37
1 Overlappin Intervals! 657.58 638.58
7 Overlappin Intervals! 733.25 723.25
5 Overlappin Intervals! 605.52 597.52
0 Overlappin Intervals! 697.53 694.53
0 Overlappin Intervals! 681.27 601.27
2 Overlappin Intervals! 612.19 582.19
0 Overlappin Intervals! 664.93 661.93
0 Overlappin Intervals! 663.82 653.82
0 Overlappin Intervals! 663.78 660.78
12 Overlappin Intervals! 602.71 587.71
5 Overlappin Intervals! 607.94 578.94
4 Overlappin Intervals! 625.87 617.87
5 Overlappin Intervals! 617.87 603.87
1 Overlappin Intervals! 576.88 575.88
0 Overlappin Intervals! 683.81 674.81
1 Overlappin Intervals! 674.81 630.81
4 Overlappin Intervals! 643.81 641.81
5 Overlappin Intervals! 640.11 639.11
9 Overlappin Intervals! 636.11 633.11
4 Overlappin Intervals! 532.72 519.72
1 Overlappin Intervals! 648.27 618.27
2 Overlappin Intervals! 618.27 563.27
0 Overlappin Intervals! 660.14 631.14
1 Overlappin Intervals! 631.14 582.14
2 Overlappin Intervals! 648.09 635.09
5 Overlappin Intervals! 626.98 615.98
2 Overlappin Intervals! 633.12 623.12
5 Overlappin Intervals! 611.12 596.12
7 Overlappin Intervals! 596.12 589.12
9 Overlappin Intervals! 589.12 584.12
2 Overlappin Intervals! 619.26 612.26
3 Overlappin Intervals! 612.26 609.26
5 Overlappin Intervals! 609.26 605.26
0 Overlappin Intervals! 663.89 593.89
5 Overlappin Intervals! 615.72 609.72
1 Overlappin Intervals! 661.72 650.72
11 Overlappin Intervals! 634.87 631.87
3 Overlappin Intervals! 647.3 622.3
1 Overlappin Intervals! 669.07 659.07
2 Overlappin Intervals! 659.07 574.07
1 Overlappin Intervals! 721.86 720.86
3 Overlappin Intervals! 716.86 713.86
4 Overlappin Intervals! 671.02 670.02
6 Overlappin Intervals! 670.02 669.02
0 Overlappin Intervals! 690.94 583.94
5 Overlappin Intervals! 582.22 581.22
5 Overlappin Intervals! 734.34 733.34
2 Overlappin Intervals! 737.34 734.34
1 Overlappin Intervals! 569.66 558.66
5 Overlappin Intervals! 531.74 491.74
13 Overlappin Intervals! 623.58 615.58
0 Overlappin Intervals! 731.13 515.13
1 Overlappin Intervals! 731.13 715.13
2 Overlappin Intervals! 731.13 600.13
0 Overlappin Intervals! 666.49 658.49
3 Overlappin Intervals! 610.74 603.74
0 Overlappin Intervals! 714.81 685.81
2 Overlappin Intervals! 685.81 673.81
5 Overlappin Intervals! 638.81 552.31
7 Overlappin Intervals! 543.31 528.81
2 Overlappin Intervals! 735.66 727.16
3 Overlappin Intervals! 727.16 704.66
6 Overlappin Intervals! 695.66 674.16
7 Overlappin Intervals! 674.16 664.66
8 Overlappin Intervals! 664.66 660.16
11 Overlappin Intervals! 652.16 651.66
12 Overlappin Intervals! 650.16 631.16
13 Overlappin Intervals! 631.16 630.16
14 Overlappin Intervals! 630.16 620.16
16 Overlappin Intervals! 575.16 555.16
18 Overlappin Intervals! 555.16 545.16
19 Overlappin Intervals! 545.16 539.96
20 Overlappin Intervals! 539.96 530.16
22 Overlappin Intervals! 530.16 522.66
23 Overlappin Intervals! 522.66 495.15999999999997
25 Overlappin Intervals! 476.15999999999997 456.15999999999997
27 Overlappin Intervals! 466.65999999999997 456.15999999999997
0 Overlappin Intervals! 670.23 668.63
2 Overlappin Intervals! 668.53 664.53
1 Overlappin Intervals! 670.78 669.28
2 Overlappin Intervals! 668.98 663.88
4 Overlappin Intervals! 663.88 662.38
5 Overlappin Intervals! 662.38 660.08
0 Overlappin Intervals! 677.9100000000001 677.51
1 Overlappin Intervals! 676.71 672.8100000000001
2 Overlappin Intervals! 763.83 753.83
1 Overlappin Intervals! 767.59 767.39
2 Overlappin Intervals! 767.39 757.89
0 Overlappin Intervals! 765.68 764.98
1 Overlappin Intervals! 763.1999999999999 759.9
0 Overlappin Intervals! 706.95 705.95
13 Overlappin Intervals! 558.83 552.83
3 Overlappin Intervals! 552.41 540.41
6 Overlappin Intervals! 570.52 565.52
0 Overlappin Intervals! 606.89 597.89
1 Overlappin Intervals! 597.89 575.89
0 Overlappin Intervals! 597.19 576.19
1 Overlappin Intervals! 605.7 582.7
0 Overlappin Intervals! 541.99 435.99
1 Overlappin Intervals! 444.23 424.23
2 Overlappin Intervals! 420.4 410.4
3 Overlappin Intervals! 410.4 390.4
0 Overlappin Intervals! 456.23 434.23
0 Overlappin Intervals! 455.79 438.79
0 Overlappin Intervals! 653.25 603.25
3 Overlappin Intervals! 704.92 668.92
0 Overlappin Intervals! 646.17 640.17
0 Overlappin Intervals! 641.16 637.16
0 Overlappin Intervals! 690.98 642.98
0 Overlappin Intervals! 721.29 634.29
0 Overlappin Intervals! 725.97 601.97
0 Overlappin Intervals! 674.12 618.12
0 Overlappin Intervals! 681.33 647.33
0 Overlappin Intervals! 688.63 648.63
0 Overlappin Intervals! 665.13 661.13
0 Overlappin Intervals! 669.54 664.54
0 Overlappin Intervals! 819.25 658.25
0 Overlappin Intervals! 590.76 573.76
0 Overlappin Intervals! 655.58 645.58
1 Overlappin Intervals! 645.58 644.58
4 Overlappin Intervals! 602.58 595.58
1 Overlappin Intervals! 614.39 609.39
5 Overlappin Intervals! 673.17 671.17
0 Overlappin Intervals! 871.91 864.91
1 Overlappin Intervals! 864.91 836.91
6 Overlappin Intervals! 836.91 831.91
8 Overlappin Intervals! 811.91 806.91
10 Overlappin Intervals! 806.91 796.91
13 Overlappin Intervals! 796.91 791.91
14 Overlappin Intervals! 791.91 751.91
16 Overlappin Intervals! 751.91 718.91
20 Overlappin Intervals! 718.91 691.91
0 Overlappin Intervals! 736.28 726.28
2 Overlappin Intervals! 726.28 711.28
4 Overlappin Intervals! 686.28 601.28
7 Overlappin Intervals! 601.28 586.28
0 Overlappin Intervals! 646.67 616.67
1 Overlappin Intervals! 606.67 586.67
0 Overlappin Intervals! 710.14 700.14
1 Overlappin Intervals! 700.14 610.14
0 Overlappin Intervals! 788.44 688.44
1 Overlappin Intervals! 683.44 583.44
0 Overlappin Intervals! 681.82 641.82
1 Overlappin Intervals! 641.82 599.82
0 Overlappin Intervals! 650.01 646.01
0 Overlappin Intervals! 649.01 640.01
1 Overlappin Intervals! 585.52 580.52
2 Overlappin Intervals! 788.42 785.42
8 Overlappin Intervals! 642.95 641.95
3 Overlappin Intervals! 683.86 672.86
0 Overlappin Intervals! 832.53 812.53
1 Overlappin Intervals! 812.53 692.53
4 Overlappin Intervals! 659.68 628.68
0 Overlappin Intervals! 857.16 720.66
3 Overlappin Intervals! 712.16 707.16
4 Overlappin Intervals! 707.16 700.16
5 Overlappin Intervals! 700.16 644.16
8 Overlappin Intervals! 615.16 604.66
0 Overlappin Intervals! 840.15 810.15
2 Overlappin Intervals! 810.15 780.15
4 Overlappin Intervals! 758.15 701.15
0 Overlappin Intervals! 640.78 610.78
1 Overlappin Intervals! 610.78 553.78
0 Overlappin Intervals! 574.98 449.98
0 Overlappin Intervals! 781.16 728.16
0 Overlappin Intervals! 871.24 856.24
1 Overlappin Intervals! 856.24 741.24
10 Overlappin Intervals! 585.61 582.61
2 Overlappin Intervals! 693.71 650.71
4 Overlappin Intervals! 657.83 656.83
7 Overlappin Intervals! 607.06 603.06
10 Overlappin Intervals! 662.8 661.8
3 Overlappin Intervals! 621.58 618.58
4 Overlappin Intervals! 718.11 704.11
3 Overlappin Intervals! 707.47 704.47
3 Overlappin Intervals! 700.45 697.45
2 Overlappin Intervals! 673.38 670.38
3 Overlappin Intervals! 706.69 702.69
4 Overlappin Intervals! 702.69 553.69
1 Overlappin Intervals! 707.84 701.84
2 Overlappin Intervals! 701.84 634.84
12 Overlappin Intervals! 493.86 478.86
0 Overlappin Intervals! 772.16 768.16
5 Overlappin Intervals! 585.49 479.49
5 Overlappin Intervals! 574.44 573.44
0 Overlappin Intervals! 676.04 666.04
5 Overlappin Intervals! 623.28 619.28
0 Overlappin Intervals! 649.79 635.79
1 Overlappin Intervals! 462.04999999999995 458.04999999999995
0 Overlappin Intervals! 627.14 525.14
0 Overlappin Intervals! 639.39 591.39
0 Overlappin Intervals! 727.04 706.04
1 Overlappin Intervals! 720.04 718.04
2 Overlappin Intervals! 718.04 705.04
0 Overlappin Intervals! 768.54 620.54
1 Overlappin Intervals! 754.62 753.62
1 Overlappin Intervals! 765.62 760.62
3 Overlappin Intervals! 689.1 684.1
0 Overlappin Intervals! 736.23 735.83
1 Overlappin Intervals! 732.73 731.13
0 Overlappin Intervals! 743.24 742.54
0 Overlappin Intervals! 725.98 720.88
4 Overlappin Intervals! 744.29 744.1899999999999
2 Overlappin Intervals! 733.13 732.73
0 Overlappin Intervals! 766.26 764.76
2 Overlappin Intervals! 750.96 750.16
3 Overlappin Intervals! 746.26 712.76
5 Overlappin Intervals! 741.26 739.96
6 Overlappin Intervals! 736.26 729.76
11 Overlappin Intervals! 696.26 693.76
4 Overlappin Intervals! 553.71 549.71
0 Overlappin Intervals! 657.05 577.05
0 Overlappin Intervals! 657.7 653.7
1 Overlappin Intervals! 653.7 635.7
2 Overlappin Intervals! 608.35 603.35
0 Overlappin Intervals! 664.48 663.48
1 Overlappin Intervals! 663.48 643.48
2 Overlappin Intervals! 659.48 650.48
3 Overlappin Intervals! 650.48 615.48
1 Overlappin Intervals! 707.78 664.78
2 Overlappin Intervals! 674.78 669.78
0 Overlappin Intervals! 652.81 598.81
0 Overlappin Intervals! 637.7 619.7
2 Overlappin Intervals! 594.17 576.17
1 Overlappin Intervals! 703.99 697.99
1 Overlappin Intervals! 615.95 614.95
11 Overlappin Intervals! -2472.79 -2481.79
11 Overlappin Intervals! -1906.83 -1923.83
0 Overlappin Intervals! 570.54 516.54
0 Overlappin Intervals! 591.89 576.89
2 Overlappin Intervals! 553.47 543.47
0 Overlappin Intervals! 537.65 532.65
2 Overlappin Intervals! 469.68 467.68
6 Overlappin Intervals! 495.05999999999995 492.05999999999995
0 Overlappin Intervals! 580.34 504.34000000000003
0 Overlappin Intervals! 757.73 747.73
1 Overlappin Intervals! 750.73 747.73
2 Overlappin Intervals! 748.73 731.73
3 Overlappin Intervals! 747.73 738.73
5 Overlappin Intervals! 738.73 712.73
7 Overlappin Intervals! 727.73 712.73
8 Overlappin Intervals! 712.73 697.73
9 Overlappin Intervals! 712.73 699.73
12 Overlappin Intervals! 692.73 688.73
13 Overlappin Intervals! 688.73 687.73
14 Overlappin Intervals! 687.73 682.73
15 Overlappin Intervals! 682.73 667.73
17 Overlappin Intervals! 667.73 645.73
20 Overlappin Intervals! 645.73 637.73
21 Overlappin Intervals! 637.73 612.73
24 Overlappin Intervals! 612.73 572.73
26 Overlappin Intervals! 602.73 597.73
28 Overlappin Intervals! 572.73 570.73
29 Overlappin Intervals! 570.73 532.73
33 Overlappin Intervals! 522.73 517.73
34 Overlappin Intervals! 517.73 512.73
35 Overlappin Intervals! 512.73 427.73
37 Overlappin Intervals! 427.73 412.73
38 Overlappin Intervals! 427.73 412.73
4 Overlappin Intervals! 695.61 690.61
11 Overlappin Intervals! 533.38 501.38
0 Overlappin Intervals! 761.47 601.47
1 Overlappin Intervals! 754.81 704.81
6 Overlappin Intervals! 582.31 581.31
3 Overlappin Intervals! 604.76 601.76
3 Overlappin Intervals! 620.8 619.8
0 Overlappin Intervals! 348.23 338.23
10 Overlappin Intervals! 517.05 512.05
11 Overlappin Intervals! 512.05 497.04999999999995
0 Overlappin Intervals! 430.11 375.11
0 Overlappin Intervals! 542.34 539.34
1 Overlappin Intervals! 679.47 678.47
0 Overlappin Intervals! 560.02 544.02
1 Overlappin Intervals! 544.02 501.02
0 Overlappin Intervals! 561.1 502.1
0 Overlappin Intervals! 806.95 803.95
0 Overlappin Intervals! 630.24 506.24
0 Overlappin Intervals! 712.15 555.15
0 Overlappin Intervals! 662.11 517.11
1 Overlappin Intervals! 634.92 624.92
0 Overlappin Intervals! 699.97 694.97
0 Overlappin Intervals! 697.87 694.97
0 Overlappin Intervals! 496.61 480.61
1 Overlappin Intervals! 480.61 453.61
1 Overlappin Intervals! 698.13 695.13
0 Overlappin Intervals! 399.98 363.98
1 Overlappin Intervals! 363.98 306.98
0 Overlappin Intervals! 483.67 471.67
0 Overlappin Intervals! 603.44 552.44
0 Overlappin Intervals! 910.31 904.31
2 Overlappin Intervals! 878.22 870.22
0 Overlappin Intervals! 919.74 897.74
0 Overlappin Intervals! 866.56 794.56
1 Overlappin Intervals! 866.56 843.56
2 Overlappin Intervals! 866.56 853.56
3 Overlappin Intervals! 866.56 852.56
4 Overlappin Intervals! 866.56 822.56
4 Overlappin Intervals! 904.01 792.01
1 Overlappin Intervals! 780.71 727.71
3 Overlappin Intervals! 742.92 740.92
0 Overlappin Intervals! 870.84 853.84
1 Overlappin Intervals! 878.62 875.42
5 Overlappin Intervals! 882.08 881.33
1 Overlappin Intervals! 605.63 570.63
0 Overlappin Intervals! 647.6 607.6
1 Overlappin Intervals! 607.6 574.6
0 Overlappin Intervals! 664.9 609.9
1 Overlappin Intervals! 609.9 604.9
2 Overlappin Intervals! 604.9 570.9
1 Overlappin Intervals! 639.59 636.59
0 Overlappin Intervals! 675.99 625.49
1 Overlappin Intervals! 742.28 738.78
0 Overlappin Intervals! 698.8100000000001 694.3100000000001
3 Overlappin Intervals! 694.3100000000001 690.91
5 Overlappin Intervals! 690.91 688.3100000000001
4 Overlappin Intervals! 654.1 652.75
0 Overlappin Intervals! 794.68 754.68
2 Overlappin Intervals! 754.68 744.68
4 Overlappin Intervals! 734.68 714.68
6 Overlappin Intervals! 714.68 704.68
8 Overlappin Intervals! 704.68 674.68
11 Overlappin Intervals! 664.68 654.68
13 Overlappin Intervals! 654.68 634.68
16 Overlappin Intervals! 624.68 616.68
0 Overlappin Intervals! 806.87 797.87
2 Overlappin Intervals! 769.87 759.87
4 Overlappin Intervals! 734.87 714.87
7 Overlappin Intervals! 709.87 701.87
8 Overlappin Intervals! 701.87 676.87
10 Overlappin Intervals! 676.87 671.87
11 Overlappin Intervals! 671.87 656.87
13 Overlappin Intervals! 656.87 649.87
0 Overlappin Intervals! 871.08 861.08
2 Overlappin Intervals! 851.08 841.08
4 Overlappin Intervals! 791.08 731.08
7 Overlappin Intervals! 731.08 721.08
8 Overlappin Intervals! 721.08 671.08
14 Overlappin Intervals! 671.08 661.08
15 Overlappin Intervals! 661.08 651.08
17 Overlappin Intervals! 651.08 641.08
19 Overlappin Intervals! 641.08 634.08
20 Overlappin Intervals! 634.08 631.08
22 Overlappin Intervals! 629.08 624.08
0 Overlappin Intervals! 800.63 780.63
2 Overlappin Intervals! 780.63 730.63
5 Overlappin Intervals! 722.63 676.63
0 Overlappin Intervals! 823.61 798.61
4 Overlappin Intervals! 798.61 778.61
8 Overlappin Intervals! 778.61 765.61
11 Overlappin Intervals! 765.61 722.61
17 Overlappin Intervals! 722.61 717.61
19 Overlappin Intervals! 717.61 709.61
20 Overlappin Intervals! 705.61 697.61
23 Overlappin Intervals! 697.61 694.61
24 Overlappin Intervals! 694.61 677.61
28 Overlappin Intervals! 677.61 666.61
30 Overlappin Intervals! 666.61 659.61
0 Overlappin Intervals! 730.07 670.07
2 Overlappin Intervals! 670.07 630.07
6 Overlappin Intervals! 630.07 572.07
0 Overlappin Intervals! 756.22 747.22
2 Overlappin Intervals! 747.22 675.22
4 Overlappin Intervals! 675.22 666.22
0 Overlappin Intervals! 887.53 866.53
3 Overlappin Intervals! 866.53 863.53
4 Overlappin Intervals! 839.53 740.53
7 Overlappin Intervals! 708.53 687.53
14 Overlappin Intervals! 627.53 602.53
0 Overlappin Intervals! 535.19 531.19
1 Overlappin Intervals! 640.45 639.45
0 Overlappin Intervals! 699.68 692.68
2 Overlappin Intervals! 692.68 672.68
3 Overlappin Intervals! 692.68 566.68
5 Overlappin Intervals! 672.68 566.68
0 Overlappin Intervals! 713.41 711.41
2 Overlappin Intervals! 711.41 695.41
4 Overlappin Intervals! 695.41 668.41
6 Overlappin Intervals! 668.41 649.41
7 Overlappin Intervals! 649.41 611.41
10 Overlappin Intervals! 611.41 609.41
12 Overlappin Intervals! 609.41 603.41
14 Overlappin Intervals! 603.41 601.41
16 Overlappin Intervals! 601.41 596.41
17 Overlappin Intervals! 596.41 595.41
19 Overlappin Intervals! 594.41 593.41
0 Overlappin Intervals! 665.76 663.76
2 Overlappin Intervals! 663.76 643.76
4 Overlappin Intervals! 643.76 600.76
5 Overlappin Intervals! 600.76 550.76
6 Overlappin Intervals! 550.76 511.76
0 Overlappin Intervals! 702.13 692.13
1 Overlappin Intervals! 692.13 642.13
3 Overlappin Intervals! 642.13 632.13
4 Overlappin Intervals! 642.13 632.13
5 Overlappin Intervals! 632.13 622.13
6 Overlappin Intervals! 632.13 622.13
8 Overlappin Intervals! 622.13 612.13
9 Overlappin Intervals! 622.13 552.13
10 Overlappin Intervals! 612.13 532.13
11 Overlappin Intervals! 552.13 532.13
0 Overlappin Intervals! 657.18 652.18
1 Overlappin Intervals! 652.18 532.18
0 Overlappin Intervals! 682.52 535.52
1 Overlappin Intervals! 682.52 535.52
0 Overlappin Intervals! 712.61 662.61
1 Overlappin Intervals! 712.61 704.61
2 Overlappin Intervals! 712.61 572.61
3 Overlappin Intervals! 704.61 597.61
0 Overlappin Intervals! 637.86 633.36
2 Overlappin Intervals! 632.86 629.36
4 Overlappin Intervals! 629.36 626.36
5 Overlappin Intervals! 625.36 617.36
8 Overlappin Intervals! 615.36 613.36
10 Overlappin Intervals! 612.86 607.86
12 Overlappin Intervals! 607.86 603.36
15 Overlappin Intervals! 602.86 600.36
17 Overlappin Intervals! 600.36 598.36
19 Overlappin Intervals! 597.86 595.36
21 Overlappin Intervals! 595.36 593.36
23 Overlappin Intervals! 592.86 590.86
24 Overlappin Intervals! 590.86 588.86
25 Overlappin Intervals! 587.86 573.36
28 Overlappin Intervals! 572.86 568.36
30 Overlappin Intervals! 567.86 563.86
0 Overlappin Intervals! 764.68 757.68
2 Overlappin Intervals! 757.68 755.68
4 Overlappin Intervals! 755.68 750.18
6 Overlappin Intervals! 750.18 745.18
8 Overlappin Intervals! 745.18 735.18
12 Overlappin Intervals! 735.18 730.18
14 Overlappin Intervals! 730.18 722.68
17 Overlappin Intervals! 722.68 719.68
19 Overlappin Intervals! 719.68 705.18
22 Overlappin Intervals! 705.18 700.18
23 Overlappin Intervals! 700.18 682.18
26 Overlappin Intervals! 682.18 681.18
27 Overlappin Intervals! 681.18 672.68
28 Overlappin Intervals! 672.68 664.18
29 Overlappin Intervals! 664.18 648.18
31 Overlappin Intervals! 648.18 643.18
33 Overlappin Intervals! 643.18 637.68
35 Overlappin Intervals! 637.68 624.18
37 Overlappin Intervals! 624.18 619.68
39 Overlappin Intervals! 619.68 611.18
40 Overlappin Intervals! 611.18 606.18
41 Overlappin Intervals! 606.18 604.18
42 Overlappin Intervals! 604.18 592.18
0 Overlappin Intervals! 730.8 723.8
3 Overlappin Intervals! 723.8 706.8
4 Overlappin Intervals! 703.3 663.3
8 Overlappin Intervals! 663.3 660.3
10 Overlappin Intervals! 658.3 648.3
11 Overlappin Intervals! 648.3 646.8
13 Overlappin Intervals! 638.3 628.3
15 Overlappin Intervals! 628.3 621.8
17 Overlappin Intervals! 618.3 616.8
19 Overlappin Intervals! 613.3 610.3
20 Overlappin Intervals! 610.3 601.8
22 Overlappin Intervals! 598.3 571.3
24 Overlappin Intervals! 571.3 541.8
27 Overlappin Intervals! 538.3 535.3
0 Overlappin Intervals! 695.19 640.19
3 Overlappin Intervals! 640.19 630.19
5 Overlappin Intervals! 630.19 625.19
7 Overlappin Intervals! 625.19 615.19
9 Overlappin Intervals! 615.19 555.19
0 Overlappin Intervals! 665.45 488.45000000000005
0 Overlappin Intervals! 636.22 548.22
2 Overlappin Intervals! 639.41 344.40999999999997
0 Overlappin Intervals! 602.06 595.06
1 Overlappin Intervals! 595.06 589.06
2 Overlappin Intervals! 637.16 629.16
2 Overlappin Intervals! 700.95 640.95
6 Overlappin Intervals! 696.27 695.27
0 Overlappin Intervals! 844.24 605.24
3 Overlappin Intervals! 608.67 605.67
2 Overlappin Intervals! 635.73 629.73
7 Overlappin Intervals! 605.1 604.1
13 Overlappin Intervals! 656.9 655.9
11 Overlappin Intervals! 673.55 672.55
0 Overlappin Intervals! 772.8 765.8
1 Overlappin Intervals! 765.8 760.8
2 Overlappin Intervals! 760.8 597.8
1 Overlappin Intervals! 757.43 661.43
0 Overlappin Intervals! 797.59 660.59
7 Overlappin Intervals! 637.99 636.99
37 Overlappin Intervals! 689.72 686.72
0 Overlappin Intervals! 661.58 654.58
1 Overlappin Intervals! 701.81 696.81
6 Overlappin Intervals! 668.81 667.81
45 Overlappin Intervals! 742.27 741.27
1 Overlappin Intervals! 786.02 785.42
3 Overlappin Intervals! 784.72 784.62
5 Overlappin Intervals! 784.22 784.02
7 Overlappin Intervals! 783.52 781.92
11 Overlappin Intervals! 753.5 753.0
1 Overlappin Intervals! 703.04 691.79
4 Overlappin Intervals! 683.04 671.79
0 Overlappin Intervals! 795.73 699.73
6 Overlappin Intervals! 699.73 699.23
7 Overlappin Intervals! 695.03 654.73
10 Overlappin Intervals! 599.73 585.73
13 Overlappin Intervals! 564.73 554.73
0 Overlappin Intervals! 788.76 758.76
2 Overlappin Intervals! 756.76 683.76
13 Overlappin Intervals! 683.76 674.76
14 Overlappin Intervals! 674.76 653.76
18 Overlappin Intervals! 640.76 621.76
22 Overlappin Intervals! 545.76 544.76
0 Overlappin Intervals! 786.56 724.06
14 Overlappin Intervals! 724.06 722.56
15 Overlappin Intervals! 722.56 701.56
22 Overlappin Intervals! 696.56 691.56
24 Overlappin Intervals! 690.56 681.56
33 Overlappin Intervals! 561.56 536.56
37 Overlappin Intervals! 536.56 531.56
38 Overlappin Intervals! 531.56 526.56
3 Overlappin Intervals! 792.72 771.72
6 Overlappin Intervals! 771.72 767.72
11 Overlappin Intervals! 740.72 698.72
15 Overlappin Intervals! 695.72 688.72
17 Overlappin Intervals! 688.72 688.22
20 Overlappin Intervals! 665.72 662.72
25 Overlappin Intervals! 622.22 603.72
28 Overlappin Intervals! 602.72 597.22
0 Overlappin Intervals! 798.76 788.76
1 Overlappin Intervals! 788.76 757.76
6 Overlappin Intervals! 738.76 717.76
8 Overlappin Intervals! 716.76 707.76
11 Overlappin Intervals! 691.76 688.76
13 Overlappin Intervals! 688.76 687.76
14 Overlappin Intervals! 678.76 672.76
1 Overlappin Intervals! 777.4100000000001 757.71
5 Overlappin Intervals! 751.71 740.71
7 Overlappin Intervals! 737.71 730.71
9 Overlappin Intervals! 729.71 720.71
11 Overlappin Intervals! 705.71 691.71
14 Overlappin Intervals! 690.71 680.71
0 Overlappin Intervals! 776.63 765.63
1 Overlappin Intervals! 765.63 715.63
3 Overlappin Intervals! 715.63 712.63
4 Overlappin Intervals! 712.63 665.63
12 Overlappin Intervals! 651.63 564.63
17 Overlappin Intervals! 559.63 553.13
2 Overlappin Intervals! 575.63 552.63
3 Overlappin Intervals! 685.49 630.49
8 Overlappin Intervals! 630.49 626.49
11 Overlappin Intervals! 565.49 552.49
13 Overlappin Intervals! 530.49 524.99
0 Overlappin Intervals! 776.31 775.31
1 Overlappin Intervals! 775.31 763.81
4 Overlappin Intervals! 752.31 721.31
6 Overlappin Intervals! 715.31 704.31
8 Overlappin Intervals! 704.31 686.31
10 Overlappin Intervals! 673.31 658.31
18 Overlappin Intervals! 541.31 529.31
0 Overlappin Intervals! 799.82 775.82
1 Overlappin Intervals! 775.82 732.82
2 Overlappin Intervals! 732.82 710.82
3 Overlappin Intervals! 710.82 685.82
10 Overlappin Intervals! 585.82 584.82
11 Overlappin Intervals! 584.82 583.82
4 Overlappin Intervals! 677.55 674.55
7 Overlappin Intervals! 534.55 518.55
3 Overlappin Intervals! 804.4 799.4
7 Overlappin Intervals! 736.4 729.4
8 Overlappin Intervals! 729.4 719.4
12 Overlappin Intervals! 658.4 656.9
13 Overlappin Intervals! 656.9 636.4
3 Overlappin Intervals! 745.78 734.78
11 Overlappin Intervals! 625.78 624.78
0 Overlappin Intervals! 747.14 739.14
3 Overlappin Intervals! 687.14 680.14
4 Overlappin Intervals! 680.14 679.14
7 Overlappin Intervals! 641.14 640.14
8 Overlappin Intervals! 640.14 614.14
11 Overlappin Intervals! 583.14 554.64
1 Overlappin Intervals! 680.44 634.44
2 Overlappin Intervals! 757.59 747.59
2 Overlappin Intervals! 776.5 711.5
3 Overlappin Intervals! 711.5 699.5
4 Overlappin Intervals! 699.5 668.5
9 Overlappin Intervals! 595.5 591.5
10 Overlappin Intervals! 591.5 586.5
0 Overlappin Intervals! 778.16 768.16
4 Overlappin Intervals! 689.16 666.16
0 Overlappin Intervals! 753.61 747.61
2 Overlappin Intervals! 739.61 687.61
5 Overlappin Intervals! 622.61 608.61
0 Overlappin Intervals! 837.83 793.33
1 Overlappin Intervals! 793.33 773.33
1 Overlappin Intervals! 766.24 696.24
4 Overlappin Intervals! 692.24 653.24
9 Overlappin Intervals! 648.24 603.24
10 Overlappin Intervals! 603.24 521.24
14 Overlappin Intervals! 521.24 518.24
0 Overlappin Intervals! 649.5 636.5
3 Overlappin Intervals! 554.5 550.9
4 Overlappin Intervals! 550.9 542.5
0 Overlappin Intervals! 770.85 736.35
4 Overlappin Intervals! 721.35 714.35
5 Overlappin Intervals! 714.35 666.35
6 Overlappin Intervals! 666.35 665.35
7 Overlappin Intervals! 662.35 652.35
9 Overlappin Intervals! 633.35 611.35
11 Overlappin Intervals! 586.35 582.1500000000001
0 Overlappin Intervals! 771.69 755.69
1 Overlappin Intervals! 755.69 745.69
1 Overlappin Intervals! 773.62 689.12
5 Overlappin Intervals! 689.12 684.12
6 Overlappin Intervals! 684.12 659.12
0 Overlappin Intervals! 708.4300000000001 687.83
2 Overlappin Intervals! 680.83 672.83
3 Overlappin Intervals! 672.83 669.83
5 Overlappin Intervals! 663.83 660.83
6 Overlappin Intervals! 660.83 654.83
8 Overlappin Intervals! 615.83 606.83
10 Overlappin Intervals! 606.83 596.33
1 Overlappin Intervals! 752.38 740.88
2 Overlappin Intervals! 735.18 721.88
4 Overlappin Intervals! 696.88 693.88
5 Overlappin Intervals! 693.88 671.38
8 Overlappin Intervals! 654.88 653.18
9 Overlappin Intervals! 653.18 641.88
13 Overlappin Intervals! 599.88 594.38
1 Overlappin Intervals! 853.48 841.48
2 Overlappin Intervals! 841.48 772.48
3 Overlappin Intervals! 772.48 746.48
4 Overlappin Intervals! 746.48 703.48
7 Overlappin Intervals! 695.48 694.88
8 Overlappin Intervals! 694.88 685.48
11 Overlappin Intervals! 680.48 674.98
12 Overlappin Intervals! 674.98 673.48
3 Overlappin Intervals! 578.63 547.63
3 Overlappin Intervals! 731.41 561.41
0 Overlappin Intervals! 720.63 716.63
1 Overlappin Intervals! 716.63 713.63
7 Overlappin Intervals! 620.11 619.11
1 Overlappin Intervals! 618.32 612.32
2 Overlappin Intervals! 612.32 606.32
5 Overlappin Intervals! 627.32 626.32
1 Overlappin Intervals! 620.64 552.64
5 Overlappin Intervals! 552.64 523.64
2 Overlappin Intervals! 545.13 535.13
0 Overlappin Intervals! 642.75 638.75
1 Overlappin Intervals! 638.75 562.75
2 Overlappin Intervals! 679.76 656.76
1 Overlappin Intervals! 611.77 560.77
5 Overlappin Intervals! 642.21 639.21
6 Overlappin Intervals! 639.21 615.21
3 Overlappin Intervals! 649.24 640.24
6 Overlappin Intervals! 663.79 652.79
3 Overlappin Intervals! 379.86 370.86
0 Overlappin Intervals! 447.01 429.01
3 Overlappin Intervals! 763.24 759.24
4 Overlappin Intervals! 747.25 743.25
0 Overlappin Intervals! 776.79 774.79
1 Overlappin Intervals! 655.63 653.63
5 Overlappin Intervals! 618.25 617.25
9 Overlappin Intervals! 604.55 602.55
3 Overlappin Intervals! 632.38 631.38
7 Overlappin Intervals! 611.56 610.56
6 Overlappin Intervals! 619.54 617.54
17 Overlappin Intervals! 667.37 662.77
18 Overlappin Intervals! 667.37 662.77
1 Overlappin Intervals! 671.92 669.92
1 Overlappin Intervals! 532.37 509.37
0 Overlappin Intervals! 539.55 536.55
0 Overlappin Intervals! 604.12 553.12
4 Overlappin Intervals! 561.69 552.69
2 Overlappin Intervals! 524.85 520.85
3 Overlappin Intervals! 585.57 584.57
6 Overlappin Intervals! 520.02 519.02
3 Overlappin Intervals! 553.81 552.81
0 Overlappin Intervals! 564.84 561.84
1 Overlappin Intervals! 561.84 542.84
2 Overlappin Intervals! 543.05 498.04999999999995
2 Overlappin Intervals! 527.72 525.72
0 Overlappin Intervals! 591.01 589.01
1 Overlappin Intervals! 589.01 524.01
0 Overlappin Intervals! 574.76 572.76
1 Overlappin Intervals! 572.76 450.76
0 Overlappin Intervals! 594.83 592.83
1 Overlappin Intervals! 592.83 570.83
1 Overlappin Intervals! 527.06 427.05999999999995
0 Overlappin Intervals! 690.46 664.46
0 Overlappin Intervals! 925.11 915.11
4 Overlappin Intervals! 875.11 870.11
5 Overlappin Intervals! 870.11 865.11
6 Overlappin Intervals! 865.11 860.11
7 Overlappin Intervals! 860.11 825.11
9 Overlappin Intervals! 825.11 770.11
11 Overlappin Intervals! 745.11 735.11
2 Overlappin Intervals! 865.91 854.91
3 Overlappin Intervals! 868.0 859.0
3 Overlappin Intervals! 773.94 718.94
4 Overlappin Intervals! 718.94 652.94
0 Overlappin Intervals! 933.9 928.9
1 Overlappin Intervals! 928.9 888.9
3 Overlappin Intervals! 813.9 808.9
0 Overlappin Intervals! 678.0 665.0
1 Overlappin Intervals! 665.0 662.0
2 Overlappin Intervals! 656.5 656.0
3 Overlappin Intervals! 656.0 635.0
3 Overlappin Intervals! 789.43 777.43
4 Overlappin Intervals! 777.43 679.43
1 Overlappin Intervals! 720.7 700.7
2 Overlappin Intervals! 700.7 690.7
4 Overlappin Intervals! 690.7 660.7
5 Overlappin Intervals! 660.7 610.7
9 Overlappin Intervals! 600.7 580.7
12 Overlappin Intervals! 580.7 560.7
14 Overlappin Intervals! 560.7 515.7
17 Overlappin Intervals! 515.7 500.70000000000005
1 Overlappin Intervals! 755.71 745.71
3 Overlappin Intervals! 745.71 716.71
4 Overlappin Intervals! 716.71 670.71
6 Overlappin Intervals! 680.71 670.71
7 Overlappin Intervals! 670.71 669.71
8 Overlappin Intervals! 670.71 665.71
9 Overlappin Intervals! 665.71 657.71
10 Overlappin Intervals! 665.71 657.71
13 Overlappin Intervals! 653.71 645.71
3 Overlappin Intervals! 793.23 728.23
0 Overlappin Intervals! 744.68 740.68
2 Overlappin Intervals! 740.68 665.68
0 Overlappin Intervals! 730.36 661.36
2 Overlappin Intervals! 803.73 796.73
0 Overlappin Intervals! 784.84 709.84
2 Overlappin Intervals! 925.84 879.84
0 Overlappin Intervals! 860.88 858.38
1 Overlappin Intervals! 858.38 855.38
3 Overlappin Intervals! 855.38 846.88
5 Overlappin Intervals! 846.88 839.38
8 Overlappin Intervals! 839.38 836.38
0 Overlappin Intervals! 749.74 739.74
3 Overlappin Intervals! 767.59 766.59
4 Overlappin Intervals! 765.59 664.59
2 Overlappin Intervals! 737.8 727.8
4 Overlappin Intervals! 727.8 659.8
0 Overlappin Intervals! 784.55 677.55
3 Overlappin Intervals! 719.26 715.26
0 Overlappin Intervals! 851.86 785.86
0 Overlappin Intervals! 769.42 708.42
4 Overlappin Intervals! 860.73 833.73
3 Overlappin Intervals! 709.04 697.04
2 Overlappin Intervals! 695.93 692.93
0 Overlappin Intervals! 920.88 915.88
1 Overlappin Intervals! 738.25 688.25
4 Overlappin Intervals! 914.52 859.52
4 Overlappin Intervals! 755.79 751.79
0 Overlappin Intervals! 877.88 849.88
2 Overlappin Intervals! 723.52 712.52
0 Overlappin Intervals! 777.8 762.8
0 Overlappin Intervals! 862.71 860.21
0 Overlappin Intervals! 854.43 853.93
0 Overlappin Intervals! 900.71 890.71
1 Overlappin Intervals! 890.71 854.71
2 Overlappin Intervals! 879.97 869.97
5 Overlappin Intervals! 789.85 786.85
6 Overlappin Intervals! 786.85 775.85
4 Overlappin Intervals! 804.61 798.61
1 Overlappin Intervals! 799.58 763.58
4 Overlappin Intervals! 750.58 749.58
5 Overlappin Intervals! 749.58 748.58
7 Overlappin Intervals! 733.58 716.58
15 Overlappin Intervals! 709.58 705.58
16 Overlappin Intervals! 705.58 704.58
18 Overlappin Intervals! 704.58 700.58
19 Overlappin Intervals! 700.58 664.58
24 Overlappin Intervals! 661.58 649.58
28 Overlappin Intervals! 642.58 640.58
29 Overlappin Intervals! 640.58 627.58
4 Overlappin Intervals! 846.25 841.25
1 Overlappin Intervals! 828.68 810.18
3 Overlappin Intervals! 792.68 788.18
4 Overlappin Intervals! 788.18 768.18
5 Overlappin Intervals! 763.18 675.18
11 Overlappin Intervals! 640.18 627.18
3 Overlappin Intervals! 818.2 798.2
4 Overlappin Intervals! 798.2 738.2
7 Overlappin Intervals! 729.5 723.2
8 Overlappin Intervals! 723.2 623.2
1 Overlappin Intervals! 886.81 872.81
3 Overlappin Intervals! 764.81 737.81
6 Overlappin Intervals! 737.81 729.81
11 Overlappin Intervals! 651.51 632.81
1 Overlappin Intervals! 827.04 807.04
5 Overlappin Intervals! 767.04 747.04
6 Overlappin Intervals! 747.04 735.04
7 Overlappin Intervals! 735.04 711.04
10 Overlappin Intervals! 645.04 627.04
6 Overlappin Intervals! 744.48 735.48
1 Overlappin Intervals! 810.72 670.72
0 Overlappin Intervals! 849.19 739.19
2 Overlappin Intervals! 851.52 838.52
5 Overlappin Intervals! 711.39 698.39
7 Overlappin Intervals! 588.37 585.37
0 Overlappin Intervals! 692.84 632.84
6 Overlappin Intervals! 757.94 714.94
3 Overlappin Intervals! 595.86 544.86
12 Overlappin Intervals! 527.76 523.76
4 Overlappin Intervals! 717.05 716.05
1 Overlappin Intervals! 777.24 763.24
2 Overlappin Intervals! 699.12 679.12
0 Overlappin Intervals! 789.18 728.18
0 Overlappin Intervals! 850.42 846.42
1 Overlappin Intervals! 846.42 826.42
10 Overlappin Intervals! 697.73 695.73
1 Overlappin Intervals! 743.03 740.03
7 Overlappin Intervals! 659.46 658.46
8 Overlappin Intervals! 685.74 665.74
0 Overlappin Intervals! 692.42 663.42
1 Overlappin Intervals! 663.42 643.42
3 Overlappin Intervals! 671.87 648.87
11 Overlappin Intervals! 556.73 547.73
0 Overlappin Intervals! 768.86 725.86
6 Overlappin Intervals! 741.05 731.05
13 Overlappin Intervals! 688.02 687.02
18 Overlappin Intervals! 487.26 471.26
19 Overlappin Intervals! 471.26 426.26
15 Overlappin Intervals! 605.78 596.78
16 Overlappin Intervals! 596.78 560.78
10 Overlappin Intervals! 646.46 640.46
10 Overlappin Intervals! 599.13 595.13
0 Overlappin Intervals! 747.95 652.95
12 Overlappin Intervals! 541.76 521.76
13 Overlappin Intervals! 521.76 511.76
0 Overlappin Intervals! 896.79 883.79
5 Overlappin Intervals! 653.5 617.5
11 Overlappin Intervals! 660.02 649.02
4 Overlappin Intervals! 740.05 688.05
9 Overlappin Intervals! 562.18 555.18
2 Overlappin Intervals! 814.41 806.41
0 Overlappin Intervals! 807.54 801.54
1 Overlappin Intervals! 801.54 777.54
11 Overlappin Intervals! 588.27 568.27
3 Overlappin Intervals! 591.99 588.99
0 Overlappin Intervals! 648.54 470.53999999999996
0 Overlappin Intervals! 679.6 637.6
3 Overlappin Intervals! 637.6 591.6
0 Overlappin Intervals! 633.12 561.12
1 Overlappin Intervals! 621.12 524.12
8 Overlappin Intervals! 556.12 537.12
2 Overlappin Intervals! 597.73 596.73
14 Overlappin Intervals! 578.87 577.87
0 Overlappin Intervals! 599.68 484.67999999999995
0 Overlappin Intervals! 597.61 545.61
7 Overlappin Intervals! 582.25 575.25
4 Overlappin Intervals! 576.74 562.74
5 Overlappin Intervals! 543.99 542.99
12 Overlappin Intervals! 607.39 606.39
14 Overlappin Intervals! 606.39 602.39
16 Overlappin Intervals! 601.39 600.39
4 Overlappin Intervals! 646.49 645.49
9 Overlappin Intervals! 589.24 580.24
3 Overlappin Intervals! 627.72 622.72
0 Overlappin Intervals! 737.86 646.86
1 Overlappin Intervals! 719.86 655.86
0 Overlappin Intervals! 672.87 600.87
0 Overlappin Intervals! 668.35 600.35
5 Overlappin Intervals! 576.35 571.35
0 Overlappin Intervals! 673.33 536.33
0 Overlappin Intervals! 657.16 541.16
5 Overlappin Intervals! 572.74 571.74
0 Overlappin Intervals! 594.19 572.19
0 Overlappin Intervals! 600.86 593.86
1 Overlappin Intervals! 593.86 560.86
3 Overlappin Intervals! 573.88 567.88
6 Overlappin Intervals! 565.29 560.29
0 Overlappin Intervals! 584.04 575.04
1 Overlappin Intervals! 575.04 572.04
3 Overlappin Intervals! 608.67 604.67
2 Overlappin Intervals! 605.66 600.66
0 Overlappin Intervals! 672.71 668.21
2 Overlappin Intervals! 668.21 662.01
4 Overlappin Intervals! 662.01 658.21
7 Overlappin Intervals! 658.21 653.21
10 Overlappin Intervals! 653.21 652.71
11 Overlappin Intervals! 652.71 647.71
17 Overlappin Intervals! 634.71 633.71
18 Overlappin Intervals! 633.71 632.71
19 Overlappin Intervals! 632.71 628.71
20 Overlappin Intervals! 628.71 625.71
24 Overlappin Intervals! 617.71 616.21
25 Overlappin Intervals! 616.21 612.71
27 Overlappin Intervals! 612.71 602.61
38 Overlappin Intervals! 592.71 587.71
41 Overlappin Intervals! 572.71 567.71
3 Overlappin Intervals! 345.61 311.61
1 Overlappin Intervals! 627.19 613.19
1 Overlappin Intervals! 558.75 557.75
2 Overlappin Intervals! 549.75 522.75
0 Overlappin Intervals! 416.97 381.97
0 Overlappin Intervals! 438.93 408.93
0 Overlappin Intervals! 384.29 329.29
2 Overlappin Intervals! 462.44 460.44
1 Overlappin Intervals! 358.73 329.73
0 Overlappin Intervals! 449.54 420.54
0 Overlappin Intervals! 514.32 504.32000000000005
0 Overlappin Intervals! 446.05 440.05
0 Overlappin Intervals! 466.17 451.17
0 Overlappin Intervals! 573.65 522.65
3 Overlappin Intervals! 446.92 441.92
0 Overlappin Intervals! 504.15999999999997 501.15999999999997
0 Overlappin Intervals! 484.12 478.12
4 Overlappin Intervals! 409.15 399.15
0 Overlappin Intervals! 424.13 411.13
3 Overlappin Intervals! 402.13 380.13
3 Overlappin Intervals! 413.13 410.13
3 Overlappin Intervals! 413.13 410.13
3 Overlappin Intervals! 413.13 410.13
8 Overlappin Intervals! 395.13 394.13
7 Overlappin Intervals! 399.13 394.13
7 Overlappin Intervals! 399.13 394.13
3 Overlappin Intervals! 388.13 371.13
2 Overlappin Intervals! 413.13 412.13
0 Overlappin Intervals! 473.04 468.04
16 Overlappin Intervals! 401.82000000000005 355.82000000000005
0 Overlappin Intervals! 707.55 598.55
0 Overlappin Intervals! 822.9 496.9
5 Overlappin Intervals! 439.91 439.82000000000005
10 Overlappin Intervals! 452.86 442.86
1 Overlappin Intervals! 452.97 392.97
0 Overlappin Intervals! 458.05 448.05
13 Overlappin Intervals! 408.96 405.96
2 Overlappin Intervals! 401.02 385.02
2 Overlappin Intervals! 489.1 479.1
3 Overlappin Intervals! 474.1 459.1
7 Overlappin Intervals! 416.61 406.61
0 Overlappin Intervals! 466.89 457.89
0 Overlappin Intervals! 435.68 414.68
0 Overlappin Intervals! 337.97 318.97
3 Overlappin Intervals! 534.68 459.67999999999995
0 Overlappin Intervals! 569.56 547.56
2 Overlappin Intervals! 547.56 517.56
0 Overlappin Intervals! 566.76 559.76
1 Overlappin Intervals! 559.76 496.76
0 Overlappin Intervals! 614.19 611.19
0 Overlappin Intervals! 606.61 585.61
4 Overlappin Intervals! 547.07 524.07
3 Overlappin Intervals! 584.74 579.74
4 Overlappin Intervals! 738.0 737.0
1 Overlappin Intervals! 390.13 382.13
0 Overlappin Intervals! 626.06 557.06
0 Overlappin Intervals! 626.0200000000001 620.5200000000001
2 Overlappin Intervals! 620.5200000000001 618.69
4 Overlappin Intervals! 618.69 617.0200000000001
12 Overlappin Intervals! 587.94 587.69
13 Overlappin Intervals! 587.5200000000001 574.0200000000001
0 Overlappin Intervals! 640.69 624.69
3 Overlappin Intervals! 268.25 256.25
0 Overlappin Intervals! 722.58 709.58
0 Overlappin Intervals! 644.52 624.52
1 Overlappin Intervals! 624.52 601.52
1 Overlappin Intervals! 600.62 599.62
1 Overlappin Intervals! 645.81 642.81
1 Overlappin Intervals! 614.12 591.12
0 Overlappin Intervals! 557.78 543.78
0 Overlappin Intervals! 665.18 661.18
2 Overlappin Intervals! 625.11 624.11
0 Overlappin Intervals! 650.94 639.94
0 Overlappin Intervals! 679.22 649.22
2 Overlappin Intervals! 638.23 630.23
0 Overlappin Intervals! 610.1 571.1
0 Overlappin Intervals! 649.82 634.82
1 Overlappin Intervals! 641.93 640.93
0 Overlappin Intervals! 658.99 553.99
3 Overlappin Intervals! 629.54 552.54
1 Overlappin Intervals! 653.73 645.73
0 Overlappin Intervals! 691.16 621.16
0 Overlappin Intervals! 444.61 435.61
2 Overlappin Intervals! 747.8 612.8
5 Overlappin Intervals! 657.66 656.66
13 Overlappin Intervals! 648.66 647.66
6 Overlappin Intervals! 524.53 521.53
2 Overlappin Intervals! 509.13 498.13
6 Overlappin Intervals! 487.15999999999997 484.15999999999997
2 Overlappin Intervals! 557.39 538.39
8 Overlappin Intervals! 592.63 588.63
0 Overlappin Intervals! 661.5 602.5
0 Overlappin Intervals! 561.29 472.28999999999996
0 Overlappin Intervals! 559.94 458.94000000000005
0 Overlappin Intervals! 649.14 544.14
8 Overlappin Intervals! 461.53 457.53
9 Overlappin Intervals! 457.53 417.53
0 Overlappin Intervals! 763.58 760.58
38 Overlappin Intervals! 530.58 529.58
0 Overlappin Intervals! 775.94 742.94
0 Overlappin Intervals! 536.92 517.92
1 Overlappin Intervals! 517.92 356.91999999999996
0 Overlappin Intervals! 482.62 473.62
1 Overlappin Intervals! 473.62 429.62
0 Overlappin Intervals! 652.98 649.98
1 Overlappin Intervals! 648.98 351.98
2 Overlappin Intervals! 679.49 624.49
4 Overlappin Intervals! 589.34 587.34
2 Overlappin Intervals! 622.93 604.93
4 Overlappin Intervals! 637.75 633.75
12 Overlappin Intervals! 571.75 554.75
10 Overlappin Intervals! 626.12 623.12
16 Overlappin Intervals! 602.12 575.12
5 Overlappin Intervals! 641.43 638.43
7 Overlappin Intervals! 604.74 601.74
2 Overlappin Intervals! 629.78 585.78
7 Overlappin Intervals! 603.16 598.16
9 Overlappin Intervals! 598.16 591.16
1 Overlappin Intervals! 709.17 701.17
2 Overlappin Intervals! 685.31 683.31
6 Overlappin Intervals! 658.31 650.31
11 Overlappin Intervals! 630.31 622.31
18 Overlappin Intervals! 571.31 561.31
0 Overlappin Intervals! 715.17 533.17
10 Overlappin Intervals! 570.13 526.13
2 Overlappin Intervals! 629.24 626.74
3 Overlappin Intervals! 626.74 513.74
0 Overlappin Intervals! 744.92 717.92
0 Overlappin Intervals! 457.47 427.47
0 Overlappin Intervals! 439.69 430.69
3 Overlappin Intervals! 332.63 287.63
0 Overlappin Intervals! 310.16 -39.839999999999975
12 Overlappin Intervals! 578.09 559.09
3 Overlappin Intervals! 537.99 506.99
5 Overlappin Intervals! 603.26 589.26
5 Overlappin Intervals! 615.49 532.49
6 Overlappin Intervals! 557.49 457.49
7 Overlappin Intervals! 532.49 413.49
12 Overlappin Intervals! 466.73 461.73
5 Overlappin Intervals! 541.25 540.17
10 Overlappin Intervals! 502.83 478.0
0 Overlappin Intervals! 404.36 394.36
2 Overlappin Intervals! 350.32 335.32
0 Overlappin Intervals! 473.64 472.64
2 Overlappin Intervals! 623.12 614.12
2 Overlappin Intervals! 430.2 429.2
10 Overlappin Intervals! 349.77 348.77
7 Overlappin Intervals! 359.47 358.47
0 Overlappin Intervals! 458.52 451.52
0 Overlappin Intervals! 416.29 411.29
1 Overlappin Intervals! 416.29 401.29
2 Overlappin Intervals! 351.29 308.29
0 Overlappin Intervals! 399.11 398.11
1 Overlappin Intervals! 398.11 356.11
0 Overlappin Intervals! 435.09 434.09
0 Overlappin Intervals! 425.16 412.16
0 Overlappin Intervals! 414.06 408.06
0 Overlappin Intervals! 467.46 442.46
0 Overlappin Intervals! 579.89 545.89
1 Overlappin Intervals! 574.89 561.89
0 Overlappin Intervals! 526.59 501.59000000000003
1 Overlappin Intervals! 501.59000000000003 478.59000000000003
5 Overlappin Intervals! 547.85 536.85
2 Overlappin Intervals! 549.7 548.7
2 Overlappin Intervals! 561.71 548.71
0 Overlappin Intervals! 500.53 491.53
1 Overlappin Intervals! 578.41 567.41
0 Overlappin Intervals! 585.54 566.54
1 Overlappin Intervals! 571.67 570.67
0 Overlappin Intervals! 625.91 590.91
2 Overlappin Intervals! 601.01 496.01
5 Overlappin Intervals! 586.01 581.01
17 Overlappin Intervals! 516.01 511.01
23 Overlappin Intervals! 486.01 481.01
4 Overlappin Intervals! 584.73 578.73
0 Overlappin Intervals! 635.86 533.86
1 Overlappin Intervals! 633.86 542.86
0 Overlappin Intervals! 686.44 602.44
1 Overlappin Intervals! 674.44 601.44
3 Overlappin Intervals! 607.13 598.13
4 Overlappin Intervals! 606.98 604.98
1 Overlappin Intervals! 615.56 555.56
3 Overlappin Intervals! 603.91 543.91
0 Overlappin Intervals! 689.08 579.08
0 Overlappin Intervals! 702.83 605.83
1 Overlappin Intervals! 702.83 640.83
2 Overlappin Intervals! 702.83 609.83
3 Overlappin Intervals! 702.83 648.83
4 Overlappin Intervals! 702.83 605.83
5 Overlappin Intervals! 699.83 647.83
0 Overlappin Intervals! 606.13 605.13
0 Overlappin Intervals! 595.7 594.7
1 Overlappin Intervals! 619.51 614.51
4 Overlappin Intervals! 552.88 544.88
0 Overlappin Intervals! 602.97 598.97
1 Overlappin Intervals! 598.97 586.97
3 Overlappin Intervals! 665.36 663.36
1 Overlappin Intervals! 836.15 830.15
0 Overlappin Intervals! 759.45 756.45
1 Overlappin Intervals! 756.45 755.45
1 Overlappin Intervals! 694.58 692.58
2 Overlappin Intervals! 692.58 669.58
12 Overlappin Intervals! 547.58 545.58
15 Overlappin Intervals! 482.58000000000004 481.58000000000004
13 Overlappin Intervals! 462.69000000000005 444.69000000000005
16 Overlappin Intervals! 436.69000000000005 433.69000000000005
18 Overlappin Intervals! 433.69000000000005 423.69000000000005
23 Overlappin Intervals! 397.69000000000005 386.69000000000005
0 Overlappin Intervals! 700.33 610.33
0 Overlappin Intervals! 534.06 525.06
2 Overlappin Intervals! 525.06 496.05999999999995
4 Overlappin Intervals! 496.05999999999995 437.05999999999995
5 Overlappin Intervals! 437.05999999999995 433.05999999999995
6 Overlappin Intervals! 433.05999999999995 422.05999999999995
1 Overlappin Intervals! 597.96 503.96000000000004
4 Overlappin Intervals! 351.76 350.76
0 Overlappin Intervals! 441.16 427.16
1 Overlappin Intervals! 427.16 423.16
2 Overlappin Intervals! 423.16 415.16
3 Overlappin Intervals! 415.16 411.16
5 Overlappin Intervals! 411.16 387.16
7 Overlappin Intervals! 387.16 383.16
8 Overlappin Intervals! 383.16 361.16
0 Overlappin Intervals! 443.99 433.99
1 Overlappin Intervals! 433.99 431.99
2 Overlappin Intervals! 431.99 424.99
3 Overlappin Intervals! 424.99 422.99
4 Overlappin Intervals! 422.99 410.99
5 Overlappin Intervals! 410.99 408.99
6 Overlappin Intervals! 408.99 393.99
8 Overlappin Intervals! 393.99 391.99
9 Overlappin Intervals! 391.99 388.99
10 Overlappin Intervals! 388.99 386.99
11 Overlappin Intervals! 386.99 383.99
12 Overlappin Intervals! 383.99 381.99
14 Overlappin Intervals! 381.99 366.99
0 Overlappin Intervals! 451.2 449.2
2 Overlappin Intervals! 449.2 443.2
4 Overlappin Intervals! 443.2 403.2
1 Overlappin Intervals! 442.05 438.05
2 Overlappin Intervals! 438.05 434.05
3 Overlappin Intervals! 434.05 431.05
4 Overlappin Intervals! 431.05 427.05
5 Overlappin Intervals! 427.05 417.05
6 Overlappin Intervals! 417.05 413.05
8 Overlappin Intervals! 413.05 397.05
10 Overlappin Intervals! 397.05 393.05
12 Overlappin Intervals! 393.05 385.05
14 Overlappin Intervals! 385.05 381.05
0 Overlappin Intervals! 445.07 443.07
1 Overlappin Intervals! 443.07 415.07
2 Overlappin Intervals! 415.07 413.07
3 Overlappin Intervals! 413.07 405.07
4 Overlappin Intervals! 405.07 403.07
0 Overlappin Intervals! 446.86 440.86
2 Overlappin Intervals! 440.86 427.86
4 Overlappin Intervals! 427.86 423.86
6 Overlappin Intervals! 423.86 417.86
8 Overlappin Intervals! 417.86 409.86
10 Overlappin Intervals! 409.86 404.86
1 Overlappin Intervals! 444.07 442.07
2 Overlappin Intervals! 442.07 409.07
23 Overlappin Intervals! 623.68 620.68
15 Overlappin Intervals! 674.14 673.14
0 Overlappin Intervals! 801.84 791.84
0 Overlappin Intervals! 608.63 511.63
0 Overlappin Intervals! 656.87 626.87
0 Overlappin Intervals! 671.16 525.16
0 Overlappin Intervals! 827.63 811.63
0 Overlappin Intervals! 652.99 604.99
2 Overlappin Intervals! 566.25 543.25
4 Overlappin Intervals! 492.40999999999997 487.40999999999997
0 Overlappin Intervals! 668.11 664.11
5 Overlappin Intervals! 560.63 551.63
2 Overlappin Intervals! 608.75 518.75
0 Overlappin Intervals! 705.05 689.05
1 Overlappin Intervals! 689.05 550.05
25 Overlappin Intervals! 428.53999999999996 426.53999999999996
4 Overlappin Intervals! 590.15 571.15
6 Overlappin Intervals! 431.27 423.27
0 Overlappin Intervals! 580.94 513.94
1 Overlappin Intervals! 572.72 571.72
0 Overlappin Intervals! 506.97 448.97
0 Overlappin Intervals! 728.22 555.22
15 Overlappin Intervals! 445.57000000000005 444.57000000000005
10 Overlappin Intervals! 489.9 488.9
11 Overlappin Intervals! 488.9 446.9
13 Overlappin Intervals! 532.01 526.01
16 Overlappin Intervals! 472.85 470.85
8 Overlappin Intervals! 592.17 580.17
9 Overlappin Intervals! 482.15 435.15
0 Overlappin Intervals! 515.56 425.55999999999995
0 Overlappin Intervals! 529.81 489.80999999999995
3 Overlappin Intervals! 675.17 526.17
0 Overlappin Intervals! 673.75 671.75
1 Overlappin Intervals! 672.75 670.75
2 Overlappin Intervals! 667.75 655.75
3 Overlappin Intervals! 603.75 575.75
4 Overlappin Intervals! 568.81 567.81
4 Overlappin Intervals! 579.22 577.22
0 Overlappin Intervals! 666.11 576.11
3 Overlappin Intervals! 637.3 634.3
5 Overlappin Intervals! 590.39 530.39
1 Overlappin Intervals! 650.34 645.34
1 Overlappin Intervals! 709.02 591.02
0 Overlappin Intervals! 686.43 644.43
0 Overlappin Intervals! 630.18 601.18
0 Overlappin Intervals! 655.22 646.22
0 Overlappin Intervals! 613.19 611.19
1 Overlappin Intervals! 613.19 612.19
2 Overlappin Intervals! 613.19 608.19
3 Overlappin Intervals! 613.19 605.19
4 Overlappin Intervals! 612.19 604.19
5 Overlappin Intervals! 608.19 607.19
0 Overlappin Intervals! 627.62 620.62
1 Overlappin Intervals! 627.62 623.62
2 Overlappin Intervals! 627.62 622.62
1 Overlappin Intervals! 606.29 605.29
0 Overlappin Intervals! 607.35 603.35
1 Overlappin Intervals! 603.35 600.35
0 Overlappin Intervals! 630.8 626.8
5 Overlappin Intervals! 603.27 602.27
13 Overlappin Intervals! 597.27 596.27
5 Overlappin Intervals! 603.96 602.96
1 Overlappin Intervals! 612.38 611.38
1 Overlappin Intervals! 588.2 580.2
6 Overlappin Intervals! 525.68 524.68
0 Overlappin Intervals! 652.55 610.55
4 Overlappin Intervals! 641.32 626.32
3 Overlappin Intervals! 651.84 637.84
0 Overlappin Intervals! 603.1 602.6
1 Overlappin Intervals! 603.1 598.1
0 Overlappin Intervals! 479.34 461.34
1 Overlappin Intervals! 461.34 404.34
0 Overlappin Intervals! 762.77 668.77
0 Overlappin Intervals! 733.64 693.64
1 Overlappin Intervals! 709.97 697.97
0 Overlappin Intervals! 739.9 619.9
0 Overlappin Intervals! 626.09 581.09
1 Overlappin Intervals! 581.09 509.09000000000003
4 Overlappin Intervals! 505.85 495.85
4 Overlappin Intervals! 510.30999999999995 499.30999999999995
4 Overlappin Intervals! 520.75 518.75
3 Overlappin Intervals! 536.38 530.38
2 Overlappin Intervals! 540.15 538.15
0 Overlappin Intervals! 690.05 675.05
2 Overlappin Intervals! 665.05 635.05
4 Overlappin Intervals! 635.05 625.05
0 Overlappin Intervals! 535.72 534.72
1 Overlappin Intervals! 525.66 524.66
1 Overlappin Intervals! 539.5 538.5
0 Overlappin Intervals! 732.34 672.34
0 Overlappin Intervals! 669.3 667.3
1 Overlappin Intervals! 669.3 664.3
3 Overlappin Intervals! 667.3 649.3
4 Overlappin Intervals! 664.3 649.3
6 Overlappin Intervals! 649.3 641.8
7 Overlappin Intervals! 649.3 638.8
8 Overlappin Intervals! 638.8 626.3
9 Overlappin Intervals! 632.8 626.3
22 Overlappin Intervals! 563.55 545.3
23 Overlappin Intervals! 563.55 545.3
24 Overlappin Intervals! 545.3 544.8
26 Overlappin Intervals! 544.3 537.3
27 Overlappin Intervals! 544.3 537.3
5 Overlappin Intervals! 527.59 525.59
4 Overlappin Intervals! 548.15 540.15
1 Overlappin Intervals! 659.01 641.01
0 Overlappin Intervals! 545.8 544.8
1 Overlappin Intervals! 530.04 529.04
1 Overlappin Intervals! 524.8 523.8
4 Overlappin Intervals! 525.42 523.42
2 Overlappin Intervals! 529.66 527.66
9 Overlappin Intervals! 516.66 508.65999999999997
1 Overlappin Intervals! 635.98 505.98
0 Overlappin Intervals! 658.2 640.2
0 Overlappin Intervals! 568.41 565.41
2 Overlappin Intervals! 626.63 616.63
0 Overlappin Intervals! 879.36 764.36
1 Overlappin Intervals! 666.7 663.7
1 Overlappin Intervals! 788.77 768.77
10 Overlappin Intervals! 490.98 482.98
11 Overlappin Intervals! 482.98 481.98
3 Overlappin Intervals! 609.06 592.06
2 Overlappin Intervals! 722.77 685.77
3 Overlappin Intervals! 685.77 460.77
2 Overlappin Intervals! 715.2 707.2
0 Overlappin Intervals! 723.45 703.45
1 Overlappin Intervals! 703.45 619.45
2 Overlappin Intervals! 652.52 589.52
0 Overlappin Intervals! 684.66 667.66
1 Overlappin Intervals! 667.66 626.66
0 Overlappin Intervals! 706.17 594.17
0 Overlappin Intervals! 720.05 663.05
3 Overlappin Intervals! 713.66 682.66
0 Overlappin Intervals! 720.3 540.3
1 Overlappin Intervals! 429.56 424.56
0 Overlappin Intervals! 689.81 548.81
0 Overlappin Intervals! 728.9200000000001 97.72000000000003
4 Overlappin Intervals! 721.22 720.72
1 Overlappin Intervals! 732.9 731.9
13 Overlappin Intervals! 574.35 571.35
15 Overlappin Intervals! 571.35 564.35
5 Overlappin Intervals! 585.83 581.83
6 Overlappin Intervals! 581.83 528.83
4 Overlappin Intervals! 684.49 676.49
6 Overlappin Intervals! 676.49 666.49
7 Overlappin Intervals! 638.12 634.12
8 Overlappin Intervals! 634.12 633.12
0 Overlappin Intervals! 734.96 719.96
1 Overlappin Intervals! 719.96 603.96
0 Overlappin Intervals! 448.51 408.51
In [309]:
err_API
Out[309]:
{120032029000,
 120052279400,
 120072183200,
 120072184300,
 120072186800,
 120072188500,
 120072188600,
 120072190200,
 120072192400,
 120072193500,
 120072195200,
 120072196200,
 120072197400,
 120072198400,
 120072285800,
 120072351600,
 120112189900,
 120112190000,
 120112191000,
 120112191400,
 120112191900,
 120112194400,
 120112196400,
 120112202600,
 120112208500,
 120112220000,
 120112224100,
 120112224700,
 120112225000,
 120112225100,
 120112231000,
 120112254100,
 120112293800,
 120112297500,
 120112318900,
 120112319900,
 120112361600,
 120132021600,
 120152098400,
 120152139900,
 120170002400,
 120172119800,
 120190000300,
 120190008100,
 120190010100,
 120190036600,
 120190040500,
 120190045000,
 120190045100,
 120190045200,
 120190045300,
 120190045500,
 120190047900,
 120190051100,
 120190081900,
 120190091200,
 120190098100,
 120190102200,
 120190103700,
 120190104000,
 120190104100,
 120190104700,
 120190105200,
 120190106000,
 120190147800,
 120192165200,
 120192167900,
 120192190600,
 120192192800,
 120192192900,
 120192225200,
 120192234600,
 120192247000,
 120192254900,
 120192262300,
 120192262400,
 120192262500,
 120192262600,
 120192262800,
 120192360500,
 120192369500,
 120192381300,
 120192400400,
 120192434300,
 120192434400,
 120192445200,
 120192449600,
 120192453100,
 120192469600,
 120192469700,
 120192504000,
 120192509900,
 120192552700,
 120192604400,
 120192616300,
 120192641300,
 120192642900,
 120192651100,
 120192654200,
 120192654300,
 120192654500,
 120192670900,
 120192671000,
 120192671100,
 120192671200,
 120192755500,
 120192770000,
 120210000400,
 120210130600,
 120212473200,
 120212481200,
 120212535300,
 120232565700,
 120252820100,
 120270002000,
 120272432700,
 120272470300,
 120290072100,
 120290193300,
 120290226700,
 120290226800,
 120292242300,
 120292263400,
 120292263600,
 120292271100,
 120292274900,
 120292275000,
 120292370500,
 120292370600,
 120310108000,
 120310119700,
 120310165900,
 120310182200,
 120310354600,
 120310355300,
 120310358300,
 120310368700,
 120310404500,
 120312474400,
 120313100800,
 120313139600,
 120313139800,
 120313145300,
 120313222900,
 120313340900,
 120313347700,
 120313352200,
 120313418200,
 120313469400,
 120313469700,
 120352195500,
 120352196500,
 120372152300,
 120372258300,
 120372341400,
 120390018200,
 120390021800,
 120390021900,
 120390027400,
 120390030200,
 120390032700,
 120390032900,
 120390034000,
 120392104200,
 120392163700,
 120392170900,
 120392174600,
 120392177100,
 120392182100,
 120410057100,
 120410073900,
 120412134300,
 120412137400,
 120412177200,
 120412236000,
 120412246100,
 120430161800,
 120432995500,
 120433121300,
 120433121400,
 120433124500,
 120433148700,
 120433148900,
 120433149000,
 120433149600,
 120433149700,
 120433172300,
 120450035500,
 120450058500,
 120450108700,
 120452137100,
 120452138900,
 120452142400,
 120452150200,
 120452245600,
 120452268800,
 120452279800,
 120452279900,
 120470116600,
 120470116700,
 120492485800,
 120492497100,
 120510473700,
 120512479500,
 120512742000,
 120512743700,
 120512861400,
 120530000500,
 120530007900,
 120532052000,
 120532058000,
 120532123200,
 120570025200,
 120570025600,
 120570135000,
 120590166000,
 120610003500,
 120612095400,
 120632333100,
 120672069900,
 120712098700,
 120712103400,
 120732183900,
 120752162100,
 120752182800,
 120752183300,
 120752333100,
 120752375700,
 120752375900,
 120772583600,
 120772583800,
 120772651700,
 120792509900,
 120852077400,
 120852183600,
 120892826300,
 120892939000,
 120893000700,
 120893173100,
 120893431900,
 120893451700,
 120893502800,
 120893569900,
 120893570000,
 120910061700,
 120910080100,
 120912363400,
 120912386700,
 120932466400,
 120932469800,
 120932469900,
 120932470100,
 120970026400,
 120970027200,
 120970028400,
 120970028700,
 120970028900,
 120970029900,
 120970031500,
 120970036100,
 120970042100,
 120970045400,
 120970065100,
 120970068500,
 120970074000,
 120970075100,
 120970075300,
 120970075700,
 120970140900,
 120970180700,
 120970180800,
 120970187900,
 120970367500,
 120972410500,
 120972499600,
 120972563000,
 120972567800,
 120972594100,
 120972699700,
 120972700100,
 120972700500,
 120973294800,
 120973297000,
 120973430400,
 120973479600,
 120973479800,
 120973663100,
 120973841400,
 120973849300,
 120973888800,
 120973936400,
 120974003900,
 120974033900,
 120974034100,
 120974270400,
 120974270600,
 120974281500,
 120974298200,
 120974475000,
 120974475100,
 120974475200,
 120974718600,
 120974718700,
 120974718900,
 120974719500,
 120974730700,
 120974824000,
 120974824200,
 120974824700,
 120974824900,
 120974826900,
 120974827000,
 120974829200,
 120974839000,
 120974839100,
 120974893000,
 120974893100,
 120974893200,
 120974909300,
 120974917900,
 120974918000,
 120974918100,
 120974918200,
 120974986600,
 120974987000,
 120974987600,
 120974996300,
 120975001200,
 120975071200,
 120975222000,
 120992343000,
 120992422500,
 120992427100,
 120992484200,
 120992502800,
 120992536800,
 120992695500,
 120992724500,
 120992833400,
 120992841500,
 120992863300,
 121013144800,
 121013200100,
 121032127700,
 121032174900,
 121032261800,
 121052162300,
 121052300600,
 121052303100,
 121052303400,
 121052313800,
 121052314000,
 121052337300,
 121052382800,
 121070000200,
 121070002500,
 121070002900,
 121070005000,
 121070012800,
 121070024600,
 121070030000,
 121070030700,
 121072077900,
 121072169400,
 121072277800,
 121072281900,
 121072282300,
 121072283100,
 121092079500,
 121092269200,
 121110002600,
 121110010800,
 121110010900,
 121110049900,
 121110067800,
 121110068800,
 121110092000,
 121110095100,
 121110097200,
 121110099100,
 121110104100,
 121110104800,
 121110142100,
 121112219200,
 121112230100,
 121112274300,
 121112275500,
 121112280400,
 121112327000,
 121112421800,
 121112684200,
 121112744100,
 121113071300,
 121113197900,
 121113232800,
 121113333300,
 121113345100,
 121113392700,
 121113396600,
 121113396900,
 121113413200,
 121113571400,
 121113599500,
 121113710800,
 121113711200,
 121113808600,
 121113925500,
 121113965200,
 121114001200,
 121114023800,
 121114163500,
 121114219300,
 121114219400,
 121114219600,
 121114219800,
 121114356100,
 121114519900,
 121114566100,
 121130006400,
 121130011000,
 121130012800,
 121130013200,
 121130017700,
 121130023100,
 121130024400,
 121130026100,
 121130028600,
 121130030200,
 121130058700,
 121130059000,
 121130086600,
 121130097500,
 121132115700,
 121132123400,
 121132124300,
 121132206400,
 121132214900,
 121132215600,
 121132222500,
 121132236400,
 121132258000,
 121132307800,
 121132347000,
 121132364600,
 121132419500,
 121132427100,
 121132434700,
 121132435300,
 121132436400,
 121132436600,
 121132481000,
 121132501900,
 121132509000,
 121150013300,
 121150013900,
 121150015600,
 121150021500,
 121150022400,
 121150025400,
 121150025500,
 121150025800,
 121150028000,
 121150028200,
 121150029400,
 121150030400,
 121150031200,
 121150031700,
 121150042200,
 121150042900,
 121150044000,
 121150047700,
 121150047900,
 121150048900,
 121150049000,
 121150053800,
 121150072900,
 121150086500,
 121152134600,
 121152180500,
 121152183500,
 121152187000,
 121152246400,
 121152337800,
 121170012700,
 121172384000,
 121190110500,
 121190153000,
 121190161600,
 121190191500,
 121190244100,
 121192470200,
 121192490000,
 121192543400,
 121192572200,
 121192573000,
 121192595600,
 121192595800,
 121192680800,
 121192682900,
 121192857800,
 121192871200,
 121192889500,
 121192889600,
 121192889700,
 121192889800,
 121192891100,
 121192892700,
 121192892800,
 121192898800,
 121192919500,
 121210501500,
 121230000700,
 121230010300,
 121232044300,
 121232052000,
 121232116200,
 121252116700,
 121252117700,
 121252188600,
 121252221700,
 121252279700,
 121252297000,
 121252297600,
 121252302100,
 121272048100,
 121292026700,
 121292032300,
 121292078300,
 121292125100,
 121292141300,
 121292150300,
 121292166700,
 121310048900,
 121330062800,
 121350011000,
 121350031400,
 121350031700,
 121350091500,
 121352183900,
 121352204400,
 121352208500,
 121352208700,
 121352229800,
 121352366600,
 121352395700,
 121352396300,
 121352401400,
 121352412400,
 121372110400,
 121372160600,
 121392041500,
 121392050200,
 121392078900,
 121392084900,
 121392094400,
 121392125600,
 121430070100,
 121430086500,
 121430101100,
 121430101200,
 121430140800,
 121430144000,
 121432194600,
 121432209700,
 121432234600,
 121432523800,
 121432523900,
 121432524200,
 121433425500,
 121433434800,
 121433457900,
 121433477300,
 121433482500,
 121433488700,
 121470001700,
 121470015300,
 121470016600,
 121470019900,
 121472050900,
 121472051100,
 121472051200,
 121472053400,
 121472074100,
 121472092800,
 121472097700,
 121472104800,
 121472114000,
 121472115400,
 121472132100,
 121490035500,
 121492068400,
 121492171900,
 121532031800,
 121532089300,
 121550016000,
 121552035700,
 121552036200,
 121552036800,
 121552050700,
 121552062000,
 121570247400,
 121572307600,
 121572571900,
 121612263400,
 121630143300,
 121630189700,
 121630318700,
 121632380900,
 121632561600,
 121632642600,
 121632758600,
 121632795400,
 121633090500,
 121633103600,
 121670020400,
 121670049500,
 121672277000,
 121672298800,
 121672299700,
 121672302800,
 121672386900,
 121672582100,
 121672670300,
 121730056700,
 121730057500,
 121730064000,
 121730084300,
 121730090900,
 121730113000,
 121730113500,
 121730134000,
 121730165400,
 121730172000,
 121732203900,
 121732213100,
 121732219000,
 121732235000,
 121732357400,
 121732407900,
 121750001600,
 121770045400,
 121772158400,
 121790004000,
 121790004300,
 121790006400,
 121790008800,
 121790015500,
 121790018100,
 121790020100,
 121790020200,
 121790020400,
 121790020600,
 121790020700,
 121790021000,
 121790021500,
 121790031500,
 121790031700,
 121790061300,
 121790071000,
 121790076500,
 121792100800,
 121792108000,
 121792133700,
 121792162800,
 121792162900,
 121792176000,
 121792208600,
 121792216700,
 121792226300,
 121792233400,
 121792247000,
 121792258000,
 121792259500,
 121792259700,
 121792271100,
 121792287000,
 121792325100,
 121792347700,
 121792368600,
 121792510000,
 121792515200,
 121792517400,
 121792533000,
 121792533700,
 121792549900,
 121830000000,
 121830098700,
 121830105000,
 121830111000,
 121830112200,
 121830114400,
 121830137800,
 121830185600,
 121832210000,
 121832221100,
 121832222700,
 121832245900,
 121832246000,
 121832246100,
 121832246300,
 121832246400,
 121832246700,
 121832246800,
 121832247000,
 121832285300,
 121832331200,
 121832361400,
 121832633900,
 121832634200,
 121832641200,
 121852741500,
 121870008800,
 121870046700,
 121872066100,
 121872066300,
 121952254800,
 121952366700,
 121952462100,
 121970003000,
 121970004700,
 121970021200,
 121970062100,
 121970072900,
 121970077000,
 121970083300,
 121970126900,
 121970129800,
 121973223500,
 121973225300,
 121973280100,
 121973310700,
 121973316400,
 121973339400,
 121973347200,
 121973347300,
 121973416500,
 121973418700,
 121974032600,
 121974217400,
 122012645800,
 122012737400,
 122013097000,
 122030029000,
 122030037200,
 122030043600,
 122032057000,
 122032059200,
 122032066100,
 122032085600,
 122032166300,
 122032183600,
 122032194400,
 122032204600,
 122032209500,
 122032218900,
 122032228800,
 122032268100,
 122032280200,
 122032280300,
 122032289700,
 122032330800,
 122032335300,
 130832888600}
In [310]:
len(err_API)
Out[310]:
763
In [311]:
with open("errAPI.csv", 'w', newline='') as myfile:
     wr = csv.writer(myfile)
     wr.writerow(list(err_API))
In [312]:
#make dataframe with data, including errors so df can be manipulated
dfErrAPI = df
In [313]:
# exclude those api with wrong records
df = df.loc[~df.index.isin(list(err_API))]
In [314]:
#df['API_Number'] = df.index
#df = df.reset_index(drop=True)
df
Out[314]:
TOP BOTTOM LITHOLOGY INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft Target API_Number
120010000300 20.0 20.0 CLAY CLAY -1.0 40.079858 -90.913587 586.73 566.73 566.73 0 120010000300
120010001100 0.0 37.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97 0 120010001100
120010001100 39.0 51.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 659.97 647.97 0 120010001100
120010001400 0.0 15.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45 0 120010001400
120010001400 15.0 45.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45 0 120010001400
120010001400 45.0 60.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 690.45 675.45 0 120010001400
120010001400 60.0 65.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 675.45 670.45 0 120010001400
120010001400 65.0 70.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 670.45 665.45 0 120010001400
120010001499 0.0 15.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
120010001499 15.0 45.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
120010001499 45.0 60.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
120010001499 60.0 65.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
120010001499 65.0 70.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
120010001700 0.0 60.0 CLAY CLAY -1.0 40.159168 -90.946914 681.10 681.10 621.10 0 120010001700
120010001700 60.0 66.0 SAND AND GRAVEL SAND AND GRAVEL 1.0 40.159168 -90.946914 681.10 621.10 615.10 1 120010001700
120010001800 1.0 15.0 CLAY CLAY 1.0 40.160208 -90.946058 681.68 680.68 666.68 0 120010001800
120010001800 15.0 65.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 666.68 616.68 0 120010001800
120010001800 100.0 120.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 581.68 561.68 0 120010001800
120010002500 0.0 60.0 CLAY CLAY 1.0 40.147742 -91.117894 685.99 685.99 625.99 0 120010002500
120010002500 60.0 120.0 CLAY CLAY -1.0 40.147742 -91.117894 685.99 625.99 565.99 0 120010002500
120010002500 123.0 143.0 SAND SAND 1.0 40.147742 -91.117894 685.99 562.99 542.99 1 120010002500
120010002500 143.0 150.0 GRAVEL GRAVEL 1.0 40.147742 -91.117894 685.99 542.99 535.99 1 120010002500
120010002900 20.0 23.0 SILT AND SAND SILT AND SAND 0.0 39.879224 -90.933490 624.61 604.61 601.61 0 120010002900
120010003000 0.0 20.0 CLAY CLAY 1.0 39.862127 -91.121321 755.58 755.58 735.58 0 120010003000
120010003000 20.0 70.0 SAND SAND -1.0 39.862127 -91.121321 755.58 735.58 685.58 1 120010003000
120010003100 4.0 55.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.864507 -91.195828 749.20 745.20 694.20 0 120010003100
120010003100 55.0 68.0 SAND SAND -1.0 39.864507 -91.195828 749.20 694.20 681.20 1 120010003100
120010003200 7.0 38.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.820554 -90.991140 782.35 775.35 744.35 0 120010003200
120010004500 0.0 45.0 CLAY CLAY -1.0 40.158644 -91.221868 647.07 647.07 602.07 0 120010004500
120010004500 45.0 80.0 CLAY CLAY -1.0 40.158644 -91.221868 647.07 602.07 567.07 0 120010004500
... ... ... ... ... ... ... ... ... ... ... ... ...
480590599400 26.0 152.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599400
480590599400 97.0 112.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599400
480590599700 4.0 72.0 GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590599700
480590599700 10.0 10.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
480590599700 28.0 184.0 SAND AND GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590599700
480590599700 38.0 156.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599700
480590599700 46.0 118.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
480590599700 58.0 68.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
480590599900 5.0 115.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590599900
480590599900 20.0 20.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599900
480590599900 59.0 174.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX 1.0 NaN NaN NaN NaN NaN 0 480590599900
480590599900 90.0 110.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599900
480590601300 7.0 15.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601300
480590601300 9.0 150.0 GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590601300
480590601300 17.0 112.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601300
480590601300 29.0 141.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590601300
480590601300 80.0 95.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601300
480590601700 7.0 153.0 GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1 480590601700
480590601700 16.0 18.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601700
480590601700 22.0 111.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590601700
480590601700 35.0 146.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
480590601700 43.0 196.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
480590601700 71.0 89.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
480590602400 14.0 175.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590602400
480590602400 135.0 161.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602400
480590602600 19.0 279.0 SAND AND GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1 480590602600
480590602600 20.0 20.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602600
480590602600 20.0 260.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX -1.0 NaN NaN NaN NaN NaN 0 480590602600
480590602600 60.0 240.0 SAND SAND 1.0 NaN NaN NaN NaN NaN 1 480590602600
480590602600 160.0 180.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602600

916893 rows × 12 columns

In [316]:
len(df)
Out[316]:
916893
In [315]:
UniqueWells = df['API_Number'].unique()
len(UniqueWells)
Out[315]:
255189
In [324]:
df = df.reset_index(drop=True)
df
Out[324]:
TOP BOTTOM LITHOLOGY INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft Target API_Number
0 20.0 20.0 CLAY CLAY -1.0 40.079858 -90.913587 586.73 566.73 566.73 0 120010000300
1 0.0 37.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97 0 120010001100
2 39.0 51.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 659.97 647.97 0 120010001100
3 0.0 15.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45 0 120010001400
4 15.0 45.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45 0 120010001400
5 45.0 60.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 690.45 675.45 0 120010001400
6 60.0 65.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 675.45 670.45 0 120010001400
7 65.0 70.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 670.45 665.45 0 120010001400
8 0.0 15.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
9 15.0 45.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
10 45.0 60.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
11 60.0 65.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
12 65.0 70.0 CLAY CLAY 0.0 NaN NaN NaN NaN NaN 0 120010001499
13 0.0 60.0 CLAY CLAY -1.0 40.159168 -90.946914 681.10 681.10 621.10 0 120010001700
14 60.0 66.0 SAND AND GRAVEL SAND AND GRAVEL 1.0 40.159168 -90.946914 681.10 621.10 615.10 1 120010001700
15 1.0 15.0 CLAY CLAY 1.0 40.160208 -90.946058 681.68 680.68 666.68 0 120010001800
16 15.0 65.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 666.68 616.68 0 120010001800
17 100.0 120.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 581.68 561.68 0 120010001800
18 0.0 60.0 CLAY CLAY 1.0 40.147742 -91.117894 685.99 685.99 625.99 0 120010002500
19 60.0 120.0 CLAY CLAY -1.0 40.147742 -91.117894 685.99 625.99 565.99 0 120010002500
20 123.0 143.0 SAND SAND 1.0 40.147742 -91.117894 685.99 562.99 542.99 1 120010002500
21 143.0 150.0 GRAVEL GRAVEL 1.0 40.147742 -91.117894 685.99 542.99 535.99 1 120010002500
22 20.0 23.0 SILT AND SAND SILT AND SAND 0.0 39.879224 -90.933490 624.61 604.61 601.61 0 120010002900
23 0.0 20.0 CLAY CLAY 1.0 39.862127 -91.121321 755.58 755.58 735.58 0 120010003000
24 20.0 70.0 SAND SAND -1.0 39.862127 -91.121321 755.58 735.58 685.58 1 120010003000
25 4.0 55.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.864507 -91.195828 749.20 745.20 694.20 0 120010003100
26 55.0 68.0 SAND SAND -1.0 39.864507 -91.195828 749.20 694.20 681.20 1 120010003100
27 7.0 38.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.820554 -90.991140 782.35 775.35 744.35 0 120010003200
28 0.0 45.0 CLAY CLAY -1.0 40.158644 -91.221868 647.07 647.07 602.07 0 120010004500
29 45.0 80.0 CLAY CLAY -1.0 40.158644 -91.221868 647.07 602.07 567.07 0 120010004500
... ... ... ... ... ... ... ... ... ... ... ... ...
916863 26.0 152.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599400
916864 97.0 112.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599400
916865 4.0 72.0 GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590599700
916866 10.0 10.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
916867 28.0 184.0 SAND AND GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590599700
916868 38.0 156.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599700
916869 46.0 118.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
916870 58.0 68.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599700
916871 5.0 115.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590599900
916872 20.0 20.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590599900
916873 59.0 174.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX 1.0 NaN NaN NaN NaN NaN 0 480590599900
916874 90.0 110.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590599900
916875 7.0 15.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601300
916876 9.0 150.0 GRAVEL GRAVEL 1.0 NaN NaN NaN NaN NaN 1 480590601300
916877 17.0 112.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601300
916878 29.0 141.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590601300
916879 80.0 95.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601300
916880 7.0 153.0 GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1 480590601700
916881 16.0 18.0 CLAY CLAY 1.0 NaN NaN NaN NaN NaN 0 480590601700
916882 22.0 111.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590601700
916883 35.0 146.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
916884 43.0 196.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
916885 71.0 89.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590601700
916886 14.0 175.0 SAND SAND -1.0 NaN NaN NaN NaN NaN 1 480590602400
916887 135.0 161.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602400
916888 19.0 279.0 SAND AND GRAVEL GRAVEL -1.0 NaN NaN NaN NaN NaN 1 480590602600
916889 20.0 20.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602600
916890 20.0 260.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX -1.0 NaN NaN NaN NaN NaN 0 480590602600
916891 60.0 240.0 SAND SAND 1.0 NaN NaN NaN NaN NaN 1 480590602600
916892 160.0 180.0 CLAY CLAY -1.0 NaN NaN NaN NaN NaN 0 480590602600

916893 rows × 12 columns

In [318]:
# write a program to export the result of elevation surface down thickness (50 feet interval * 10 intervals)
def Elevation_surfacedown(df, interval=25, layers=1):
    #records1 = intervals that go through the top of the layer and bottom is within layer
    records1 = df.loc[(df['TOP_ELEV_ft'] > df['SURF_ELEV_ft']-interval*(layers-1)) & (df['BOT_ELEV_ft'] < df['SURF_ELEV_ft']-interval*(layers-1)) & (df['BOT_ELEV_ft'] >= df['SURF_ELEV_ft']-interval*layers) & (df['BOT_ELEV_ft'] <= df['TOP_ELEV_ft'])]
    thickness1 = pd.DataFrame((records1['SURF_ELEV_ft']-interval*(layers-1)-records1.loc[: , 'BOT_ELEV_ft']) * records1['Target'])
    thickness1.columns = ['thickness']
    records1 = records1.join(thickness1)
    
    #records2 = entire interval is within layer
    records2 = df.loc[(df['TOP_ELEV_ft'] <= df['SURF_ELEV_ft']-interval*(layers-1)) & (df['BOT_ELEV_ft'] >= df['SURF_ELEV_ft']-interval*layers) & (df['BOT_ELEV_ft'] <= df['TOP_ELEV_ft'])]
    thickness2 = pd.DataFrame((records2.loc[: , 'TOP_ELEV_ft'] - records2.loc[: , 'BOT_ELEV_ft']) * records2['Target'])
    thickness2.columns = ['thickness']
    records2 = records2.join(thickness2)
    
    #records3 = intervals with top within layer and bottom of interval going through bottom of layer
    records3 = df.loc[(df['TOP_ELEV_ft'] > df['SURF_ELEV_ft']-interval*layers) & (df['BOT_ELEV_ft'] < df['SURF_ELEV_ft']-interval*layers) & (df['TOP_ELEV_ft'] <= df['SURF_ELEV_ft']-interval*(layers-1)) & (df['BOT_ELEV_ft'] <= df['TOP_ELEV_ft'])]
    thickness3 = pd.DataFrame((records3.loc[: , 'TOP_ELEV_ft'] - (records3['SURF_ELEV_ft']-interval*layers))*records3['Target'])
    thickness3.columns = ['thickness']
    records3 = records3.join(thickness3)
    
    #records4 = interval goes through entire layer
    records4 = df.loc[(df['TOP_ELEV_ft'] > df['SURF_ELEV_ft']-interval*(layers-1)) & (df['BOT_ELEV_ft'] < df['SURF_ELEV_ft']-interval*layers) & (df['BOT_ELEV_ft'] <= df['TOP_ELEV_ft'])] 
    thickness4 = pd.DataFrame((records4.loc[: , 'BOT_ELEV_ft']*0 + interval) * records4['Target'])
    thickness4.columns = ['thickness']
    records4 = records4.join(thickness4)
    
    #Wells that exit layer bottom
    thruWellAPIs = pd.DataFrame(records3['API_Number'].append(records4['API_Number']))
    thruWellAPIs.columns = ['thruAPI']
    
    #Combine multiple records that go through single layer
    res = records1.append(records2).append(records3).append(records4)
    res = res.loc[res['API_Number'].isin(list(thruWellAPIs['thruAPI']))]
    res_df = res.groupby(['API_Number','LATITUDE','LONGITUDE']).sum()[['thickness']]
    
    #Find Max Depth for each Well
    #maxDepths = pd.DataFrame(df.groupby('API_Number').min()['BOT_ELEV_ft'])
    #maxDepths.columns = ['Well_maxDepth']  
    
    #res_df = res_df.join(maxDepths)
    
    thickness_per = pd.DataFrame(res_df.loc[: , 'thickness']/interval)
    thickness_per.columns = ['thick_per']
    res_df = res_df.join(thickness_per)
    
    #Add layer column to indicate which layer it is in
    layer = pd.DataFrame(res_df.loc[: , 'thickness']*0+layers) #makes layer same length as res_df and adds iteration (layer) value
    layer.columns = ['layer'] #name the column
    res_df = res_df.join(layer) #append layer column to res_df
    resLayer = pd.DataFrame(res.loc[: , 'thickness']*0+layers)
    resLayer.columns = ['layer']
    res = res.join(resLayer)

    #res is dataFrame with all original data plus target thickness and layer per interval
    #res_df is smaller dataFrame with only XYZ, API, and target thickness, thickPercent, and layer number
    
    return res, res_df
In [319]:
# experiment with the first layer
res, res_df = Elevation_surfacedown(df, layers=1)
len(res_df)
Out[319]:
189240
In [320]:
len(res)
Out[320]:
4573557
In [321]:
res
Out[321]:
TOP BOTTOM LITHOLOGY INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft Target API_Number thickness layer
120010001100 0.0 37.0 CLAY AND STONE BEDROCK AND OTHER -1.0 40.029328 -90.962715 698.97 698.97 661.97 0 120010001100 0.0 1.0
120010001400 0.0 15.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45 0 120010001400 0.0 1.0
120010001400 0.0 15.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 735.45 720.45 0 120010001400 0.0 1.0
120010001400 15.0 45.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45 0 120010001400 0.0 1.0
120010001400 15.0 45.0 CLAY CLAY 0.0 40.021306 -91.086866 735.45 720.45 690.45 0 120010001400 0.0 1.0
120010001700 0.0 60.0 CLAY CLAY -1.0 40.159168 -90.946914 681.10 681.10 621.10 0 120010001700 0.0 1.0
120010001800 1.0 15.0 CLAY CLAY 1.0 40.160208 -90.946058 681.68 680.68 666.68 0 120010001800 0.0 1.0
120010001800 1.0 15.0 CLAY CLAY 1.0 40.160208 -90.946058 681.68 680.68 666.68 0 120010001800 0.0 1.0
120010001800 15.0 65.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 666.68 616.68 0 120010001800 0.0 1.0
120010001800 15.0 65.0 CLAY CLAY -1.0 40.160208 -90.946058 681.68 666.68 616.68 0 120010001800 0.0 1.0
120010002500 0.0 60.0 CLAY CLAY 1.0 40.147742 -91.117894 685.99 685.99 625.99 0 120010002500 0.0 1.0
120010003000 0.0 20.0 CLAY CLAY 1.0 39.862127 -91.121321 755.58 755.58 735.58 0 120010003000 0.0 1.0
120010003000 0.0 20.0 CLAY CLAY 1.0 39.862127 -91.121321 755.58 755.58 735.58 0 120010003000 0.0 1.0
120010003000 20.0 70.0 SAND SAND -1.0 39.862127 -91.121321 755.58 735.58 685.58 1 120010003000 5.0 1.0
120010003000 20.0 70.0 SAND SAND -1.0 39.862127 -91.121321 755.58 735.58 685.58 1 120010003000 5.0 1.0
120010003100 4.0 55.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.864507 -91.195828 749.20 745.20 694.20 0 120010003100 0.0 1.0
120010003200 7.0 38.0 CLAY AND SAND CLAY AND SAND MIX 1.0 39.820554 -90.991140 782.35 775.35 744.35 0 120010003200 0.0 1.0
120010004500 0.0 45.0 CLAY CLAY -1.0 40.158644 -91.221868 647.07 647.07 602.07 0 120010004500 0.0 1.0
120010004600 0.0 65.0 CLAY CLAY 1.0 40.158096 -91.220257 646.67 646.67 581.67 0 120010004600 0.0 1.0
120010005700 0.0 8.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 646.73 638.73 0 120010005700 0.0 1.0
120010005700 0.0 8.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 646.73 638.73 0 120010005700 0.0 1.0
120010005700 23.0 30.0 CLAY CLAY -1.0 39.930157 -91.366787 646.73 623.73 616.73 0 120010005700 0.0 1.0
120010005700 23.0 30.0 CLAY CLAY -1.0 39.930157 -91.366787 646.73 623.73 616.73 0 120010005700 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
120010006300 13.0 18.0 CLAY CLAY 0.0 39.930157 -91.366787 646.73 633.73 628.73 0 120010006300 0.0 1.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
122033219200 17.0 42.0 CLAY CLAY 1.0 40.905694 -89.388994 644.27 627.27 602.27 0 122033219200 0.0 1.0
122033219300 0.0 17.0 CLAY CLAY 1.0 40.906713 -89.395899 631.75 631.75 614.75 0 122033219300 0.0 1.0
122033219300 0.0 17.0 CLAY CLAY 1.0 40.906713 -89.395899 631.75 631.75 614.75 0 122033219300 0.0 1.0
122033219300 17.0 116.0 CLAY CLAY -1.0 40.906713 -89.395899 631.75 614.75 515.75 0 122033219300 0.0 1.0
122033219300 17.0 116.0 CLAY CLAY -1.0 40.906713 -89.395899 631.75 614.75 515.75 0 122033219300 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 0.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 4.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 4.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 4.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 4.0 1.0
122033226400 0.0 10.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 721.28 711.28 0 122033226400 4.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 0.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 0.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 0.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 0.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 0.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 4.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 4.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 4.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 4.0 1.0
122033226400 10.0 14.0 GRAVEL GRAVEL 1.0 40.671807 -89.060295 721.28 711.28 707.28 1 122033226400 4.0 1.0
122033226400 14.0 67.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 707.28 654.28 0 122033226400 0.0 1.0
122033226400 14.0 67.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 707.28 654.28 0 122033226400 0.0 1.0
122033226400 14.0 67.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 707.28 654.28 0 122033226400 0.0 1.0
122033226400 14.0 67.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 707.28 654.28 0 122033226400 0.0 1.0
122033226400 14.0 67.0 CLAY CLAY 1.0 40.671807 -89.060295 721.28 707.28 654.28 0 122033226400 0.0 1.0

4573557 rows × 14 columns

In [325]:
res_df['layer'].describe()
Out[325]:
count    189240.0
mean          1.0
std           0.0
min           1.0
25%           1.0
50%           1.0
75%           1.0
max           1.0
Name: layer, dtype: float64
In [164]:
res.sort_values(by=['thickness'])
Out[164]:
TOP BOTTOM LITHOLOGY INTERPRETED COMPLETED LATITUDE LONGITUDE SURF_ELEV_ft TOP_ELEV_ft BOT_ELEV_ft Target API_Number thickness layer
42563 12.0 35.0 CLAY AND GRAVEL CLAY AND GRAVEL MIX -1.0 40.140919 -87.950980 667.74 655.74 632.74 0 120190072800 0.0 1.0
236430 0.0 50.0 CLAY CLAY -1.0 37.726256 -89.381039 562.96 562.96 512.96 0 120772570400 0.0 1.0
236429 0.0 75.0 CLAY CLAY -1.0 37.745424 -89.425565 408.02 408.02 333.02 0 120772570300 0.0 1.0
236428 0.0 58.0 CLAY CLAY -1.0 37.766303 -89.436702 435.52 435.52 377.52 0 120772570200 0.0 1.0
236427 0.0 33.0 CLAY CLAY -1.0 37.769736 -89.434328 478.09 478.09 445.09 0 120772570100 0.0 1.0
236426 0.0 68.0 CLAY CLAY -1.0 37.770898 -89.403361 519.79 519.79 451.79 0 120772570000 0.0 1.0
236425 0.0 48.0 CLAY CLAY -1.0 37.700868 -89.334942 506.68 506.68 458.68 0 120772569900 0.0 1.0
236434 0.0 33.0 CLAY CLAY -1.0 37.659561 -89.176750 510.17 510.17 477.17 0 120772570600 0.0 1.0
236424 0.0 65.0 CLAY CLAY -1.0 37.695526 -89.346606 602.26 602.26 537.26 0 120772569800 0.0 1.0
236422 0.0 40.0 CLAY CLAY -1.0 37.701672 -89.374489 588.50 588.50 548.50 0 120772569600 0.0 1.0
236421 0.0 35.0 CLAY CLAY -1.0 37.716446 -89.374317 577.55 577.55 542.55 0 120772569500 0.0 1.0
236420 0.0 61.0 CLAY CLAY -1.0 37.702678 -89.344232 559.42 559.42 498.42 0 120772569400 0.0 1.0
236419 0.0 31.0 CLAY CLAY -1.0 37.725469 -89.311166 466.04 466.04 435.04 0 120772569300 0.0 1.0
236418 0.0 35.0 CLAY CLAY -1.0 37.721400 -89.344080 498.49 498.49 463.49 0 120772569200 0.0 1.0
236417 0.0 30.0 CLAY CLAY -1.0 37.721400 -89.344080 498.49 498.49 468.49 0 120772569100 0.0 1.0
236423 0.0 52.0 CLAY CLAY -1.0 37.695811 -89.362805 558.92 558.92 506.92 0 120772569700 0.0 1.0
236436 18.0 35.0 CLAY CLAY -1.0 37.647051 -89.232698 619.60 601.60 584.60 0 120772570700 0.0 1.0
236437 0.0 35.0 CLAY CLAY -1.0 37.613127 -89.348527 614.93 614.93 579.93 0 120772570800 0.0 1.0
236438 0.0 31.0 CLAY CLAY -1.0 37.631477 -89.299207 601.47 601.47 570.47 0 120772570900 0.0 1.0
236468 22.0 71.0 CLAY CLAY -1.0 37.805135 -89.290209 377.35 355.35 306.35 0 120772573300 0.0 1.0
236465 12.0 36.0 CLAY AND SAND CLAY AND SAND MIX -1.0 37.857073 -89.272812 427.92 415.92 391.92 0 120772573200 0.0 1.0
236463 0.0 26.0 CLAY CLAY -1.0 37.875193 -89.615462 680.67 680.67 654.67 0 120772573100 0.0 1.0
236461 0.0 35.0 CLAY CLAY -1.0 37.880876 -89.540267 542.68 542.68 507.68 0 120772572900 0.0 1.0
236459 20.0 32.0 CLAY AND SAND CLAY AND SAND MIX -1.0 37.891761 -89.531140 529.85 509.85 497.85 0 120772572700 0.0 1.0
236455 0.0 36.0 CLAY CLAY -1.0 37.921026 -89.549807 544.92 544.92 508.92 0 120772572500 0.0 1.0
236454 0.0 32.0 CLAY CLAY -1.0 37.932156 -89.568256 518.57 518.57 486.57 0 120772572300 0.0 1.0
236453 0.0 40.0 CLAY CLAY -1.0 37.905306 -89.374345 365.62 365.62 325.62 0 120772572100 0.0 1.0
236452 0.0 45.0 CLAY CLAY -1.0 37.919042 -89.436406 477.96 477.96 432.96 0 120772572000 0.0 1.0
236451 0.0 36.0 CLAY CLAY -1.0 37.910367 -89.388249 394.37 394.37 358.37 0 120772571900 0.0 1.0
236448 21.0 68.0 CLAY CLAY -1.0 37.941935 -89.204958 389.77 368.77 321.77 0 120772571700 0.0 1.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
443603 0.0 58.0 GRAVEL GRAVEL -1.0 40.770512 -88.816164 733.10 733.10 675.10 1 121052218700 25.0 1.0
631999 0.0 40.0 SAND SAND -1.0 40.415441 -89.798339 502.51 502.51 462.51 1 121252211500 25.0 1.0
632126 0.0 50.0 SAND SAND -1.0 40.324320 -89.801633 500.89 500.89 450.89 1 121252214100 25.0 1.0
633913 0.0 35.0 SAND SAND -1.0 40.159317 -90.169200 460.33 460.33 425.33 1 121252245200 25.0 1.0
633789 0.0 28.0 SAND SAND -1.0 40.107667 -90.199417 488.65 488.65 460.65 1 121252243100 25.0 1.0
441263 0.0 40.0 SAND SAND -1.0 41.666583 -89.431250 737.52 737.52 697.52 1 121032410300 25.0 1.0
633442 0.0 35.0 SAND SAND -1.0 40.287091 -89.978644 494.27 494.27 459.27 1 121252237300 25.0 1.0
633441 0.0 36.0 SAND SAND -1.0 40.303450 -90.043370 469.17 469.17 433.17 1 121252237200 25.0 1.0
441674 0.0 26.0 SAND SAND -1.0 41.642194 -89.618889 665.17 665.17 639.17 1 121032417500 25.0 1.0
441890 0.0 45.0 SAND AND GRAVEL GRAVEL -1.0 41.791389 -89.583528 657.34 657.34 612.34 1 121032422600 25.0 1.0
633272 0.0 52.0 SAND SAND -1.0 40.299506 -90.045785 469.94 469.94 417.94 1 121252234800 25.0 1.0
633242 0.0 48.0 SAND SAND -1.0 40.302833 -90.065599 453.51 453.51 405.51 1 121252234300 25.0 1.0
633046 0.0 42.0 SAND SAND -1.0 40.313954 -88.119865 718.82 718.82 676.82 1 121252231500 25.0 1.0
115786 0.0 40.0 SAND SAND -1.0 41.614793 -87.697423 609.60 609.60 569.60 1 120313163500 25.0 1.0
632838 0.0 67.0 SAND SAND -1.0 40.294189 -90.059859 477.73 477.73 410.73 1 121252227800 25.0 1.0
632818 0.0 35.0 SAND SAND -1.0 40.434011 -89.845826 510.48 510.48 475.48 1 121252227200 25.0 1.0
632704 0.0 42.0 SAND SAND -1.0 40.373356 -89.947193 496.96 496.96 454.96 1 121252225100 25.0 1.0
632703 0.0 68.0 SAND AND GRAVEL GRAVEL -1.0 40.307210 -90.052261 472.16 472.16 404.16 1 121252225000 25.0 1.0
632661 0.0 35.0 SAND SAND -1.0 40.286883 -89.910104 497.15 497.15 462.15 1 121252224200 25.0 1.0
442111 0.0 40.0 SAND AND GRAVEL GRAVEL -1.0 41.796667 -89.603333 650.51 650.51 610.51 1 121032429100 25.0 1.0
632629 0.0 46.0 SAND SAND -1.0 40.416008 -89.864874 509.62 509.62 463.62 1 121252223800 25.0 1.0
632626 0.0 58.0 SAND SAND -1.0 40.419023 -89.831405 495.34 495.34 437.34 1 121252223700 25.0 1.0
632620 0.0 27.0 SAND SAND -1.0 40.429249 -89.896223 498.66 498.66 471.66 1 121252223600 25.0 1.0
632582 0.0 35.0 SAND SAND -1.0 40.350365 -89.749256 516.15 516.15 481.15 1 121252223000 25.0 1.0
632496 0.0 65.0 SAND SAND -1.0 40.165510 -89.966229 503.32 503.32 438.32 1 121252221100 25.0 1.0
632445 0.0 35.0 SAND SAND -1.0 40.416006 -89.864877 509.62 509.62 474.62 1 121252220000 25.0 1.0
632266 0.0 37.0 SAND SAND -1.0 40.193207 -90.137480 454.60 454.60 417.60 1 121252216700 25.0 1.0
443175 0.0 245.0 SAND AND GRAVEL GRAVEL -1.0 40.765615 -88.909280 718.56 718.56 473.56 1 121052204700 25.0 1.0
631345 0.0 26.0 SAND SAND -1.0 40.431195 -89.879176 538.45 538.45 512.45 1 121252190700 25.0 1.0
506161 0.0 85.0 SAND AND GRAVEL GRAVEL -1.0 42.196113 -88.310326 844.49 844.49 759.49 1 121113260000 25.0 1.0

361252 rows × 14 columns

In [326]:
# export the results from the range we want to csv
for i in np.arange(1,23):
    interval = 25
    res, res_df = Elevation_surfacedown(df, interval, layers = i)
    outputname = 'Data\\DepthThickness\\CoarseThick_Depth_'+str(i*interval-interval)+'ft.csv'
    resOutputname = 'Data\\DepthThickness\\CoarseThick_Depth_'+str(i*interval-interval)+'ft_allColumns.csv'
    res_df.to_csv(outputname)
    res.to_csv(resOutputname)
    # export df as table
In [52]:
res_whole
Out[52]:
API_Number Lat Lon TopEle BotEle SurEle Lithology Completed Formation Target thickness layer
10018 120670020100 40.230081 -90.940343 662.9 657.9 662.86 CLAY -1 gumbo 0 0.00 1.0
12131 120930035300 41.674018 -88.550338 661.6 655.6 661.56 CLAY -1 soil & clay 0 0.00 1.0
12246 120930043300 41.639719 -88.565974 640.5 634.5 640.46 CLAY -1 soil & clay 0 0.00 1.0
12457 120970025500 42.234202 -88.161677 794.9 777.9 794.87 CLAY -1 till calc ylsh brn brnsh gry 0 0.00 1.0
13070 120350079300 39.306013 -88.058280 594.3 589.3 594.25 CLAY 0 till silty yellowish orange 0 0.00 1.0
15825 121152113500 39.802908 -88.966363 715.5 701.5 715.46 CLAY -1 clay 0 0.00 1.0
15841 121190163300 38.877684 -90.102901 441.0 437.0 440.98 SAND -1 sand fine 1 3.98 1.0
16461 121190034300 38.758931 -89.883904 528.8 518.8 528.79 CLAY -1 clay gray 0 0.00 1.0
16619 121190100500 38.992864 -89.732916 607.8 595.8 607.78 CLAY AND GRAVEL -1 clay & gravel 0 0.00 1.0
16713 121130017900 40.499914 -89.079611 788.3 772.3 788.28 CLAY -1 yellow clay 0 0.00 1.0
16743 121130021900 40.530959 -89.207264 756.5 736.5 756.48 CLAY -1 soil & clay 0 0.00 1.0
25753 120210129000 39.581904 -89.298010 605.8 595.8 605.76 CLAY -1 clay yellow 0 0.00 1.0
26311 120230144300 39.423110 -88.012098 654.4 647.4 654.39 CLAY -1 soil & clay 0 0.00 1.0
26661 120270298600 38.719180 -89.372395 459.7 439.7 459.69 CLAY -1 clay 0 0.00 1.0
27502 120210243400 39.437005 -89.129227 665.0 645.0 664.98 CLAY -1 soil & yellow clay 0 0.00 1.0
28836 121330025400 38.348549 -90.155518 682.4 661.4 682.36 CLAY -1 soil & clay 0 0.00 1.0
28902 121330025700 38.393951 -90.178153 674.5 660.5 674.49 CLAY -1 clay & soil 0 0.00 1.0
29647 121350021600 39.420631 -89.661203 635.0 630.0 634.95 CLAY -1 till yellow non-calcareous 0 0.00 1.0
29726 121350044500 39.202962 -89.657751 676.8 672.8 676.78 SILT -1 loess 0 0.00 1.0
29814 121350120200 39.379974 -89.689048 638.1 619.1 638.05 CLAY -1 yellow clay 0 0.00 1.0
30857 121630049100 38.403255 -89.918890 479.0 457.0 478.95 CLAY -1 clay yellow 0 0.00 1.0
31766 121630142600 38.640898 -89.916162 479.3 467.3 479.27 CLAY -1 clay 0 0.00 1.0
32143 121630208100 38.338456 -89.909587 390.9 370.9 390.86 CLAY -1 surface clay 0 0.00 1.0
33769 121630225300 38.231333 -89.704531 518.4 503.4 518.38 CLAY -1 clay 0 0.00 1.0
33786 121630226500 38.338604 -89.898034 392.0 385.0 391.96 CLAY -1 clay 0 0.00 1.0
33886 121630220900 38.236825 -89.706867 518.4 513.4 518.38 CLAY -1 clay 0 0.00 1.0
36656 121113524900 42.186976 -88.367352 893.2 890.2 893.19 CLAY -1 sandy brown clay 0 0.00 1.0
37150 121570203100 38.210968 -89.612275 520.3 505.3 520.28 CLAY -1 clay 0 0.00 1.0
37719 121832219700 40.083362 -87.564729 651.9 636.9 651.89 CLAY 0 till calc loam ox 2.5Y5/4 Batestown 0 0.00 1.0
37729 121670088000 39.746634 -89.441846 576.8 558.8 576.75 CLAY -1 clay 0 0.00 1.0
... ... ... ... ... ... ... ... ... ... ... ... ...
222887 120632315600 41.346686 -88.288037 89.8 -148.2 534.83 SAND -1 sand 1 25.00 22.0
226685 120712086900 40.650465 -91.033098 474.0 -16.0 684.02 CLAY AND STONE -1 clay & shale 0 0.00 22.0
239594 121970025100 41.443508 -88.160268 42.8 -87.2 522.82 SAND -1 sand medium 1 25.00 22.0
243000 121970054200 41.448434 -88.176178 34.2 -239.8 504.24 SAND -1 sand 1 25.00 22.0
250082 121970322100 41.287963 -88.147205 59.7 9.7 559.74 SAND -1 sand 1 25.00 22.0
258256 121970133100 41.304696 -88.146994 59.4 -103.6 559.40 SAND -1 sand 1 25.00 22.0
262767 121972559100 41.451256 -88.177631 68.6 -327.4 533.61 SAND -1 sand 1 25.00 22.0
404614 120910003900 41.042587 -88.109667 151.6 26.6 675.56 SAND -1 Sand 1 25.00 22.0
524685 121170020300 39.044782 -89.812164 58.4 -81.6 573.35 SAND -1 sand 1 25.00 22.0
536396 120932447400 41.680400 -88.405280 156.1 -148.9 636.08 SAND -1 sand 1 25.00 22.0
573553 120190015500 40.274615 -88.412911 393.9 48.9 733.90 SAND -1 sand 1 25.00 22.0
598568 120072469300 42.286290 -88.896401 414.3 224.3 794.31 SAND -1 tan sand 1 25.00 22.0
626983 120893332300 41.944068 -88.336620 260.5 115.5 740.52 CLAY -1 brown clay 0 0.00 22.0
657770 121350012500 39.004620 -89.613595 271.0 -14.0 596.01 SAND -1 sand 1 25.00 22.0
708485 121792497800 40.524631 -89.459132 473.1 -246.9 666.08 SAND AND GRAVEL -1 sand & gravel 1 25.00 22.0
768920 121973728100 41.443072 -88.158482 95.0 -45.0 594.99 SAND -1 sand 1 25.00 22.0
805180 120192163000 39.886182 -88.064830 416.0 -31.0 668.97 SAND AND GRAVEL -1 sand and gravel at 1 25.00 22.0
888698 121030030700 41.834842 -89.455128 540.0 189.0 784.02 SAND -1 sand 1 25.00 22.0
970722 120330711500 39.074299 -87.899788 512.0 -418.0 512.00 SAND -1 sand 1 25.00 22.0
1078057 122013095000 42.225013 -89.005556 479.9 231.9 806.86 SAND -1 sand 1 25.00 22.0
1078075 122013095200 42.309149 -88.972216 537.3 257.3 897.28 SAND -1 sand 1 25.00 22.0
1082752 122012990300 42.252886 -88.985184 484.4 249.4 804.44 SAND -1 sand 1 25.00 22.0
1137746 120370063201 41.947544 -88.775847 871.8 154.8 871.77 SAND -1 sand 1 25.00 22.0
1203297 121932928500 38.114919 -88.196783 -52.5 -108.5 447.54 SAND -1 white sand 1 25.00 22.0
1228183 121030043500 41.779318 -89.554099 311.1 151.1 701.12 SAND -1 sand 1 25.00 22.0
1280898 120893247100 42.138646 -88.505130 605.1 382.1 980.14 CLAY WITH SAND STREAKS -1 buff colored lime with very hard seams 0 0.00 22.0
1476917 121973676500 41.448413 -88.233104 27.7 -74.3 520.69 SAND -1 sand 1 25.00 22.0
1707753 120850005600 42.477204 -90.440019 482.0 314.0 867.00 SAND -1 sand 1 25.00 22.0
1716983 121110088900 42.253640 -88.619221 306.7 226.7 826.74 SAND -1 sand 1 25.00 22.0
1757939 121973994100 41.458764 -88.184041 88.9 -96.1 568.94 SAND -1 sand 1 25.00 22.0

1636878 rows × 12 columns