As of 18 Aug 2016, various files (e.g. SQlite, CSV) derived from FracFocus.org’s August 2016 FracFocusRegistry have been downloaded, extracted, transformed, loaded, archived, and uploaded to the frackingdata.info/downloads site and their respective links also posted to FrackingData’s FracFocus Data Page .
This time, FracFocus posted their SQL Server backup on 15 Aug 2016, about 4 weeks later than its previous posting of 14 July 2016 (an improvement, yeah!). But, the ZIP archive was flawed in that it contained the July 2016 SQL Server backup instead of the Aug 2016 backup. Sometime in the next two days, after I tweeted about the mistake, FracFocus updated the ZIP archive with the proper file.
Once again, of significance this time was that the download of the files from the FracFocus.org website and their subsequent extract, transform, load, archiving, and exporting to CSV, SQLite, and PostgreSQL files was performed by a Windows batch script without human intervention. This automated method shaved hours from the extract, transform, load, archive, and export process. In addition, the batch script now uses WinSCP to automatically upload the files in question to the http://frackingdata.info/downloads page.
When this Windows batch file is sufficiently stable, and I’ve soft-coded the data-cleansing views into the script itself, I’ll post a link to it in the Source Code section of this blog. Soft-coding of the data-cleansing views is the last hurdle to publishing this script.
Khepry Quixote 2016-08-19