brad507 / frac_focus_pdfs

Frac focus pdfs


A difficult parsing of the two tables from the PDFs for each well

Forked from ScraperWiki

Contributors brad507

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Traceback (most recent call last): File "scraper.py", line 198, in <module> Main() File "scraper.py", line 17, in Main scraperwiki.sqlite.attach("frac_focus_wells") AttributeError: 'module' object has no attribute 'attach'

Data

Downloaded 0 times

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (505 KB) Use the API

rows 10 / 112

Latitud Well Type Datum depth Longitude County State API Operator water_gal Fracture Date Well Name and Number
41.763361
Gas
NAD83
7000
-76.534025
Bradford
PA
37-015-20610
Chief Oil & Gas
5112072
2011-07-10
Clear Spring Dairy 2H
41.763525
Gas
NAD83
7000
-76.534008
Bradford
PA
37-015-21440
Chief Oil & Gas
4787790
2011-07-01
Clear Spring Dairy 4H
41.714325
Gas
NAD83
7500
-76.422633
Bradford
PA
37-015-21434
Chief Oil & Gas
3995544
2011-06-07
Elliott Unit 1H
41.714661
Gas
NAD83
7293
-75.8847
Susquehanna
PA
37-115-20228
Chief Oil & Gas
4873932
2011-01-04
Tell Unit 2H
41.714717
Gas
NAD83
7180
-75.884697
Susquehanna
PA
37-115-20342
Chief Oil & Gas
667716
2011-01-02
Tell Unit 4
41.559425
Gas
NAD83
7678
-76.639944
Sullivan
PA
37-113-20053
Chief Oil & Gas
430584
2011-02-05
Hemlock Hunting Club Unit 1H
41.625047
Gas
NAD83
7858
-75.937856
Wyoming
PA
37-131-20147
Chief Oil & Gas
1020138
2011-08-07
Garrison Unit 1H
41.556636
Gas
NAD83
8306
-76.403167
Bradford
PA
37-015-21426
Chief Oil & Gas
5293176
2011-07-28
Curtin Unit 1H
41.730208
Gas
NAD83
6224
-76.330506
Bradford
PA
37-015-21343
Chief Oil & Gas
1997688
2011-07-25
Allen Unit 3H
41.715303
Gas
NAD83
6447
-76.341069
Bradford
PA
37-015-21344
Chief Oil & Gas
90846
2011-03-04
PMG God Unit 1H

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (505 KB) Use the API

rows 10 / 2161

Trade Name Ingredients CAS API MaxConc_in_fluid Purpose Supplier MaxConc_in_additive MinConc_in_additive Comments
(FRW-18)
Hydrotreated Light Distillate
64742-47-8
37-015-20610
0.0951
Friction Reducer
BJ Services
30.0
10.0
(ALPHA 1427)
Glutaraldehyde
000111-30-8
37-015-20610
0.024
Biocide
BJ Services
30.0
10.0
(ALPHA 1427)
Quaternary Ammonium Chloride
007173-51-5
37-015-20610
Biocide
BJ Services
10.0
5.0
(ALPHA 1427)
Alkyl Dimethyl Benzyl Ammonium Chloride (C12-16)
068424-85-1
37-015-20610
Biocide
BJ Services
7.0
3.0
(ALPHA 1427)
Ethanol
000064-17-5
37-015-20610
Biocide
BJ Services
5.0
1.0
(ALPHA 1427)
Water
007732-18-5
37-015-20610
Biocide
BJ Services
60.0
30.0
(Scaletrol 720)
Ethylene Glycol
000107-21-1
37-015-20610
0.0474
Scale Inhibitor
BJ Services
45.0
0.0
(Scaletrol 720)
Diethylene Glycol
000111-46-6
37-015-20610
Scale Inhibitor
BJ Services
5.0
0.0
(Techni-Hib 604)
Ammonium Bisulfite
10192-30-0
37-015-20610
0.0113
Oxygen Scavengar
BJ Services
75.0
0.0
(Techni-Hib 604)
Nickel Chelate Catalyst
007732-18-5
37-015-20610
Oxygen Scavengar
BJ Services
5.0
0.0

Statistics

Total run time: half a minute

Total cpu time used: less than 5 seconds

Total disk space used: 532 KB

History

  • Manually ran revision 534f130d and failed .
    nothing changed in the database
  • Forked from ScraperWiki

Scraper code

Python

frac_focus_pdfs / scraper.py