CO2 I Tools
Database Scripts
Download to your PC

This web page are instructions to download the ORACLE-I-Files Directory that contains the ORACLE PL/SQL stored procedure packages needed for the CO2 Tools web apps to access and download Kansas Geological Survey well data.

You will need ORACLE sqlplus installed on your PC to compile the ORACLE PL/SQL stored procedures on your pc. You will need to contace KGS Computer Services for help.

The ORACLE-I-Files ORACLE Files software is bundled by 2 methods as a ZIP file and as a JAR File. Both will create the ORACLE-I-Files directory with all the ORACLE PL/SQL stored procedures source files.


Directory Structure of ORACLE-I-Files

Insert Data This directory contains all the scripts that loads the CO2 I Data
 
o insert_doe_co2_las3_files.sql Insert DOE CO2 Log ASCII Standard (LAS) version 3.0 Files into the DOE CO2 LAS 3.0 File Information & Profile Plot Image Database Table
o insert_doe_co2_LAS3_files_final.sql Insert DOE CO2 Log ASCII Standard (LAS) version 3.0 Files into the DOE CO2 LAS 3.0 File Information & Profile Plot Image Database Table
o insert_doe_co2_tops.sql Insert DOE CO2 Well Tops into the DOE CO2 Well Tops Database Table
o insert_doe_co2_tops_T31S-R1W-Sec_28.sql Insert DOE CO2 Well Tops for Township 31S - Range 1W - Section 28 into the DOE CO2 Well Tops Database Table
o insert_doe_co2_tops-Wellington_KGS_2-32.sql Insert DOE CO2 Well Tops for Wellington KGS 2-32 Well into the DOE CO2 Well Tops Database Table
o insert_geo_report_georeport.sql Insert DOE CO2 Geologist Cuttings & Core Description File Informaiton into the DOE CO2 Geologist Cutting & Core Description File Information Database Table
 
PL/SQL This directory contains all the stored procedures that will retrieve the data as XML (Extensible Markup Language) or Summary Web Pages for the CO2 project
o doe_co2_summary_pkg.sql Generate the DOE CO2 Summary Web Page PL/SQL Stored Procedure Package
o doe_co2_summary_ascii_pkg.sql Generate the DOE CO2 Summary Comma Separated Values (CSV) Web Page PL/SQL Stored Procedure Package
o iqstrat_doe_co2_wells_pkg.sql Generate the DOE CO2 Wells Extensible Markup Language (XML) PL/SQL Stored Procedure Package
o iqstrat_doe_co2_tops_pkg.sql Generate the DOE CO2 Tops Extensible Markup Language (XML) PL/SQL Stored Procedure Package
o kgs_summary_pkg.sql Generate the KGS Summary List of Geologist Cuttings Reports Web Page PL/SQL Stored Procedure Package
o production_doe_co2_wells_pkg.sql Generate the Production DOE CO2 Wells Extensible Markup Language (XML) PL/SQL Stored Procedure Package
 
SQL This directory contains all the SQL Scripts that will build the database tables for the CO2 I Tables
o db_create_doe_co2_files_table.sql Create the DOE CO2 Log ASCII Standard (LAS) version 3.0 File Information,
Profile Plot - Portable Network Graphics (PNG) Image File Information &
Profile Plot - Portable Document File (PDF) File Information Database Tables
o db_create_doe_co2_tops_table.sql Create the DOE CO2 Well Tops Database Table
o db_create_doe_co2_georeport_table.sql Create the DOE CO2 Geologist Cutting & Core Description File Information Database Table
o db_create_doe_co2_core_csv_table.sql Create the DOE CO2 Core CSV File Information Database Table

Compile the ORACLE PLSQL Stored Procedure

To compile the stored procedure you must start a sqlplus session. You will need to log into the session as IQSTRAT/{password}@KGSPRD, you will need to retrieve the password from computer services. You then can compile the PL/SQL Stored Procedure Package, e.g. @C:\ORACLE-I-Files\co2_pressure_catalog_pkg, which will compile the Pressure Catalog Summary Web Page stored procedure package. This will load & compile the stored procedure package into KGS Oracle Database.

This download process is provided only for maintenance, if by chance the database tables are changed or columns within a database is changed, that would cause the stored procedure to fail.


Author: John R. Victorine jvictor@kgs.ku.edu

The URL for this page is http://www.kgs.ku.edu/PRS/Ozark/JAVA_SRC/ORACLE-I-Files/download.html