mlbelobraydi / TXRRC_data_harvest

Script for accessing and organizing oil and gas well data from the Texas Railroad Commission
The Unlicense
32 stars 18 forks source link

Create definition libraries for all 28 sections in the dbf900.ebc.gz file #4

Closed mlbelobraydi closed 4 years ago

mlbelobraydi commented 4 years ago

Creating file that has the definition of all 28 sections.

mlbelobraydi commented 4 years ago

TXRRC wellbore database definitions.txt First 3 complete, only 25 more to go. Not really a fan of the pic_any or pic_numeric types. I think there is probably a better way if pandas or json is used. It is a stand-in now and should be relatively easy to change later.

mlbelobraydi commented 4 years ago

Added a few more to the list. 13 of 28 complete. TXRRC wellbore database definitions.txt

mlbelobraydi commented 4 years ago

20 of 28 complete. TXRRC wellbore database definitions.txt

mlbelobraydi commented 4 years ago

Only 2 left. Why did I leave the longest ones for the last? Separated out the oil and gas sections to make it easier to automate, maybe... I have a request in to TXRRC for the WBNEWLOC_13 section since the Easting and Northing do not seem to be Texas State Plane conversions of the lat long in the files. I have a notebook breaking out the values for testing. TXRRC wellbore database definitions.txt

mlbelobraydi commented 4 years ago

More info on section 13 for the Easting and Northing provided by TXRRC. Coordinates are in TX State Plane Ft NAD27

TXRRC wellbore database definitions.txt

mlbelobraydi commented 4 years ago

First pass complete. Not happy with the way dates are handled and might need to change how the date fields are handled. TXRRC wellbore database definitions.txt

mlbelobraydi commented 4 years ago

https://github.com/mlbelobraydi/TXRRC_data_harvest/blob/master/DefinitionFiles/TXRRC%20wellbore%20database%20definitions.txt Final definition file created and put into the folder under the code section. this is now complete for the ftp://ftpe.rrc.texas.gov/shfwba/dbf900.ebc.gz file