search

SkyTruth / django_tools

1 stars 1 forks source link

FracFocusReportChemical row order for api 35-129-23747 is mangled #5

Open craigwin-ni opened 10 years ago

craigwin-ni commented 10 years ago

The FracFocusReportChemical records for API 35-129-23747 ordered by row do not match the pdf. The pdf parser output matches the pdf so the rows have been reordered in the post-parsing record generation.

craigwin-ni commented 10 years ago

PDF Parser output: api 35-129-23747-00-00 base_nonwater_volume 0 county Roger Mills datum NAD27 end_date 2/17/2013 federal NO fracture_date 2/16/2013 latitude 35.66890000 longitude -99.98080000 operator Laredo Petroleum, Inc. state Oklahoma total_water_volume 2,823,869 well_name Red Falcon trade_name supplier purpose ingredients cas_number additive_concentration hf_fluid_concentration comments Fresh Water Operator Carrier Fluid
Water 77323-18-5 100.00000 93.68511 Density = 8.330 PROP-CARBO HYDROPROP, BULK (101649541) Halliburton Proppant
Mullite 1302-93-8 85.00000 3.50971 Crystalline silica, cristobalite 14464-46-1 30.00000 1.23872 Silicon Dioxide 7631-86-9 10.00000 0.41291 CERAMIC PROP Halliburton Proppant
Mullite 1302-93-8 100.00000 0.66386 Crystalline silica, cristobalite 14464-46-1 30.00000 0.19916 Silica, amorphous - fumed 7631-86-9 30.00000 0.19916 100 mesh Halliburton Proppant
Crystalline silica, quartz 14808-60-7 100.00000 0.44065 FE ACID - >10% HCL Halliburton Acid
Hydrochloric acid 7647-01-0 15.00000 0.22457 FR-66 Halliburton Friction Reducer
Hydrotreated light petroleum distillate 64742-47-8 30.00000 0.05924 CLA-WEB? Halliburton Additive
Ammonium salt Confidential 60.00000 0.02942 BE-7? Halliburton Biocide
Sodium hypochlorite 7681-52-9 30.00000 0.01675 Sodium hydroxide 1310-73-2 2.00000 0.00112 FE-1A ACIDIZING COMPOSITION Halliburton Additive
Acetic anhydride 108-24-7 100.00000 0.00750 Acetic acid 64-19-7 60.00000 0.00450 OptiKleen-WF? Halliburton Concentrate
Sodium perborate tetrahydrate 10486-00-7 100.00000 0.01106 FE-2A Halliburton Additive
Citric acid 77-92-9 60.00000 0.00518 HAI-404 Halliburton Corrosion Inhibitor
Isopropanol 67-63-0 30.00000 0.00061 Methanol 67-56-1 30.00000 0.00061 Aldehyde Confidential 30.00000 0.00061 Chloromethylnaphthalene quinoline quaternary amine 15619-48-4 10.00000 0.00020 RockOn? MX 5-2350 Multi-Chem Surfactant
Methanol 67-56-1 100.00000 0.00117 Ethoxylated Alcohols Proprietary 13.00000 0.00015 Sulfonate Proprietary 10.00000 0.00012 Ingredients shown above are subject to 29 CFR 1910.1200(i) and appear on Material Safety Data Sheets (MSDS). Ingredients shown below are Non-MSDS. Water 7732-18-5 0.95776 Aluminum Silicate 1302-76-7 0.66386 Polyacrylamide Copolymer 62649-23-4 0.05924 Sodium chloride 7647-14-5 0.01232 Alcohols, C12-16, ethoxylated 68551-12-2 0.01008 Tall oil acid diethanolamide 68155-20-4 0.00987 Ammonium chloride 12125-02-9 0.00987 Acetic acid 64-19-7 0.00749 Acetic anhydride 108-24-7 0.00749 Citric acid 77-92-9 0.00749 Quaternary Amine 34004-36-9 0.00245 Sorbitan, mono-9- octadecenoate, (Z) 1338-43-8 0.00197 Sorbitan monooleate polyoxyethylene derivative 9005-65-6 0.00197 Naphthenic acid ethoxylate 68410-62-8 0.00061 Quaternary Amine 3327-22-8 0.00049 Propylene glycol 57-55-6 0.00020 Fatty Acids, Tall Oil 61790-12-3 0.00020 Amine Salts 75-57-0 0.00005 Quaternary Amine
Amine Salts 593-81-7 0.00005 Ammonium phosphite 13446-12-3 0.00002