I had a "clean" data set which was run through Petra first. After I excluded some bad data with definition query and also coding with Python within the data tables I was able to get a test plot which worked- YAY!
However, the goal is to take the data straight from Drilling Info and get it to work which I have not yet done. The current problem I'm trying to tackle is to figure out how to load all the
The current problem I'm trying to tackle is to figure out how to load all the data, and to take the last value loaded for SHL and BHL and then convert that to some point where there is only one API for each X,Y data point. This should be able to be accomplished by first loading in the data that is already sorted, but for whatever reason I cannot get it to work correctly. Right now in my data table I have more than 5 entries for some wells due to different permit dates. I only want to end up with one line per API so that I can then use those points to plot. I've decided to "clean" the data as best I can in Excel first by the following methods:
SHL=BHL for vertical wells. No "0" data points in the data table.
If SHL Lon = 0, then make Lat =0 so the coordinates would be 0,0 (SHL) and 0,0 BHL
After doing this in Excel, I still have multiple entries per API #. I tried to load it anyway. If I use the XY to line feature and have more than one BHL or SHL for each API then Arc freaks out and can't process it correctly.
This is my current stopping point and I'm not sure how to proceed from here. I tried to plot by point feature class the SHL and BHL, and then thought I could proceed forward and use the Add XY Coords tool to move forward but that is not working because I still have multiple lines per API.
If you come up with any ideas that would be most helpful. If there was any sort of rhyme or reason to the input data I think I could filter it out. The problem is that what happens a lot is the BHL was given at some date let's say June 1, 2000. Later there were several movements of the permitted surface hole SHL in January 2003 and March 2004. So the result is not one line of data (sorted by last date of permit activity) which would result in the SHL and BHL I need. Perhaps I need to do two different pivot tables, and then do some sort of V Lookup to get them back into a one-line format. I briefly found a sorting tool in pivot tables where you can return the value of the latest sample, but it only worked for one value for each row. I have not yet tested this out but this may be the place I need to go next. Off to the weekend now.