Status Update 2017-05-03: FrackingData_FracFocusRegistry 2017-04 Files Uploaded

As of 03 May 2017, various files (e.g. SQlite, CSV) derived from’s April 2017 FracFocusRegistry have been downloaded, extracted, transformed, loaded, archived, and their respective links posted to FrackingData’s FracFocus Data Page .

This time, FracFocus posted their SQL Server backup on 17 Apr 2017, about 4 weeks later than its previous posting of 17 Mar 2017.

Once again, of significance this time was that the download of the files from the 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.

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 2017-05-03


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s