Category Archives: fracking

FracFocus.org Excel-Friendly CSV Download File “under maintenance”

Apologies to all concerned as I’ve undertaken a new “day job” that’s taking all of my time and energy, enough so that I didn’t even notice that FracFocus.org’s download page now states that the Excel-friendly CSV download is “under maintenance.”

I’ll have some Excel  and SQLite-friendly datasets out for y’all’s consumption shortly.  I figure that might help until FracFocus.org gets its act together in the meantime.

Khepry Quixote
2018-03-11

Advertisements

Status Update: ANSS ComCat Earthquakes Pushed to AWS S3 Bucket

A few months ago, I noted that earthquakes for Oklahoma after 2017-03-01 were not showing up in the NCEDC download.  Vexed by this, I immediately went searching for an alternative source of earthquake information.  Finally, I found the ANSS ComCat catalog, but could only access the full download of earthquakes via a ReSTful API that limited rowsets to 20,000 rows per request.  Knowing those limitations, I authored a Python 3 program that would download earthquakes one month at a time, starting from 1900-01-01.

The preceding download has been accomplished and the dataset has been downloaded from 1900-01-01 to the present.  I can confirm that Oklahoma’s information now appears within the dataset from 1974 to the present, hence I’ve pushed the earthquake dataset to the AWS S3 quake-info bucket.  When I’ve done so, I’ll post links to the actual Python projects at GitHub that download (PyQuakeReSTer) and reverse-geocode (PyGeoCoderRev) the data prior to its import into a SQLite3 database for subsequent analysis.

Khepry Quixote
2017-10-10

Status Update: FracFocus.org CSV transformed/augmented with toxicities data pushed to S3 bucket (2017-10-04)

FracFocus.org’s CSV data has been imported, transformed, and augmented with chemical toxicities by the author of this blog resulting in the file available at the link below:

Khepry Quixote
2017-10-06

 

 

Status Update: FracFocus.org CSV transformed/augmented with toxicities data pushed to S3 bucket (2017-09-15)

FracFocus.org’s CSV data has been imported, transformed, and augmented with chemical toxicities by the author of this blog resulting in the file available at the link below:

Khepry Quixote
2017-09-25

 

Status Update: FracFocus.org CSV transformed/augmented data pushed to S3 bucket (2017-09-05)

FracFocus.org’s CSV data has been imported, transformed, and augmented with chemical toxicities by the author of this blog resulting in the file available at the link below:

Khepry Quixote
2017-09-07