USGS Home Contact USGS Search USGS

Open-File Series 03-037: Data Files Readme and Examples

THE NEW ALBANY SHALE PETROLEUM SYSTEM, ILLINOIS BASIN – DATA AND MAP IMAGE ARCHIVE FROM THE MATERIAL-BALANCE ASSESSMENT

Homepage | Readme | Table of Contents | Data Files Readme | Glossary |

The two sets of data that are located in the appendices are porperm.xls and HI_TOC.xls. All data files are saved in Microsoft EXCEL version 5.0 as v97 and 5.0/95 Workbooks, as space-delimited files (*.prn), and comma-delimited data (*.csv). File contents and examples are shown and explained below.

Table 1. Below is a sample from the porperm.xls file that is located in appendix 1. The data are also saved as comma-delimited ( porperm.csv ) and space-delimited ( porperm.prn ) formats. Files are located in the "data" sub-directory. Three-hundred and seventy-seven core reports were used to determine median values of porosity, permeability, and the percent oil and water saturation for cored intervals of the following Mississippian-age formations: the McCloskey unit of the Ste. Genevieve, Aux Vases, Bethel, and Cypress. Figure 7 is a stratigraphic column that shows these formations. Percents of oil and water saturation are generally inaccurate due to water washing and/or contamination of the core during drilling and recovery.

VARIABLES FOR PORPERM FILES ARE:

• ID = Identification code for that cored interval
• Longitude = Geographic reference point, values are degrees of arc.  Data are derived primarily from State sources.  
• Latitude = Geographic reference point, values are degrees of arc. Data are derived primarily from State sources.  
• Form = Cored stratigraphic interval. AXVS = Aux Vases, BTHL = Bethel, CPRS = Cypress, MCLK = McCloskey
• Depthft = Median depth in feet of the core
• Hperm = Median horizontal permeability, in millidarcies
• Porosity = Median porosity of the cored interval, in percent
• %Oil = Median percent of oil saturation in the cored formation
• %Water = Median percent of water saturation in the core.
• Well Name = Name of the well on the core report
• Field Name = Name of the oil field, or "wildcat" is entered if there is no field
• TRS = Township, range, and section location of the well from the core report. This is written in several formats and can include quarter sections.

Table 2. The below sample from the HI_TOC files, located in appendix 2, shows geochemical statistics for samples from the New Albany Shale. HI_TOC.xls file is saved in Microsoft EXCEL version 5.0 as v97 and 5.0/95 Workbook. The file is also saved in space-delimited (HI_TOC.prn) and comma-delimited formats (HI_TOC.cvs). Analytical methods are detailed and assessed in Lewan et al. (1995, 2002), and very briefly summarized here. Total organic carbon content (TOC) of hydrocarbon source rocks is primarily determined using Rock-Eval pyrolysis. This technique involves heating about 50 to 150 mg of powdered rock in a crucible under anhydrous conditions. The oven is continuously swept by flowing helium at low pressures, and the sample is heated isothermally, followed by a programmed rate of heating. Pyrolysis of the sample at a constant temperature of about 250 degrees C for 3 to 5 minutes distills organic compounds from C1 (one carbon atom and attached hydrogen atoms) to about C32. Volatilized products are swept with helium into a flame ionization detector (FID) for quantification of contained hydrocarbons. These pyrolyzed hydrocarbons are considered to be bound to the organic matter in the sample and are designated as "S₁" (S subscript 1) hydrocarbons. Programmed heating from 250 to 600 degrees C at a rate of 25 degrees C/minute cracks the kerogen and heavy bitumen. This yields organic compounds, water, carbon dioxide, and other gases. Half of the flow of produced molecules is sent to the FID to measure hydrocarbon compounds; these are designated "S₂" (S subscript 2), generated hydrocarbons. The other half of the flow is sent to a carbon dioxide trap that is heated at 250 to 390 degrees C. Compounds in the carbon dioxide trap are heated and resulting gas is measured by a thermal conductivity detector (TCD); these hydrocarbons are designated as "S₃" (S subscript 3). Evolved carbon monoxide (CO) is not measured. The crucible is then moved to another furnace where it is heated to about 590 degrees C in air (oxidizing atmosphere). The evolved carbon dioxide is measured by the TCD.

VARIABLES FOR HI_TOC FILES OF THE NEW ALBANY SHALE ARE:

• State = The State in the United States from which the sample originated (IL=Illinois, IN=Indiana, KY=Kentucky)
• Latitude = Geographic reference point, values are degrees of arc.  Data are primarily from State records.
• Longitude = Geographic reference point, values are degrees of arc.  Data are primarily from State records.
• Tmax = Tmax results (degrees C) from Rock Eval or hydrous pyrolysis
• PI = Production index (Lewan et al., 2002)
• TOC = Total organic carbon content (weight percent) of the New Albany Shale source rocks
• HI = Hydrogen index values determined from Rock Eval or hydrous pyrolysis ((mg S2 hydrocarbons)/TOC).
• Sample_Number = Sequential numbers assigned to each sample. Numbers for the 262 samples in the file range up to 318. Not all results are included, some were for different formations or were outside the study area.
• Sample_ID = Identification code for that sample location. Some Kentucky wells instead have the well name.

Homepage | Readme | Table of Contents | Data Files Readme | Glossary |

AccessibilityFOIAPrivacyPolicies and Notices
U.S. Department of the Interior | U.S. Geological Survey URL: <http://pubsdata.usgs.gov/pubs/of/2003/ofr-03-037/htmltext/fileform.htm> Contact: Energy Program Inquiries Questions or Assistance: GS Pubs Web Contact Page Last Modified: Sat Jan 12 23:01 EDT 2013