- Manual operations involving the downloaded FracFocus.org SQL Server 2012 backup file.
- SQL Server
- Download latest FracFocus.org data SQL Server 2012 backup file(s).
- Open SQL Server 2012 Management Studio (SSMS)
- Rename current SQL Server 2012 FracFocusRegistry database to another name (e.g. FracFocusRegistry_yyyy_mm)
- Restore the latest FracFocus.org data backup file (BAK), which should create a database entitled “FracFocusRegistry”.
- If desired:
- create primary keys, indexes, and views, as seems fit.
- export the tables to tab-delimited CSV files via queries that compensate for “undesirable” characters (e.g. TABs, LINEFEEDs) embedded within any of the data columns.
- Navigate to the FrackingData_RZ database
- Export data to CSV files using the following views:
- dbo.vue_RegistryUpload_Cleanse_Columns_for_Export
- dbo.vue_RegistryUploadIngredients_Cleanse_Columns_for_Export
- dbo.vue_RegistryUploadPurpose_Cleanse_Columns_for_Export
- Microsoft Access
- Open Microsoft Access 2013
- Create a new ACCDB database, e.g. FracFocusRegistry_yyyy_mm.accdb
- Using ODBC, import the FracFocusRegistry SQL Server 2012 database into the new ACCDB database.
- If desired, create primary keys, indexes, and queries, as seems fit.
- “Save As…” a new MDB database.
- Exit the ACCDB database.
- Zip the resulting ACCDB database with 7-Zip
- Zip the resulting MDB database with 7-Zip
- SQLite 3
- Copy the current FracFocusRegistry.sqlite database to another name (e.g. FracFocusRegistry_yyyy_mm.sqlite)
- Open SQLiteStudio 3
- Using the existing FracFocusRegistry.sqlite database
- Truncate the following tables
- delete from RegistryUpload
- delete from RegistryUploadIngredients
- delete from RegistryUpdatePurpose
- Right-click on each of the tables, and import into it using its respective CSV file
- VACUUM the database
- Zip the resulting database with 7-Zip
- PostgreSQL
- Copy the current FracFocusRegistry database to another name (e.g. FracFocusRegistry_yyyy_mm)
- Open PgAdmin III
- Using the existing FracFocusRegistry database
- Truncate the following tables
- truncate table RegistryUpload
- truncate table RegistryUploadIngredients
- truncate table RegistryUpdatePurpose
- Right-click on each of the tables, and import into it using its respective CSV file. Be sure to use ‘WIN1252’ encoding.
- VACUUM the database
- Backup the database to a .BACKUP file
- Zip the resulting .BACKUP file using 7-Zip
Like this:
Like Loading...
Fracking data, chemicals, toxicities, source code
Fracking Data 
Do you have any plans to generate a visual index with KML or GeoJSON. Thanks for putting this information together!