CO2 II Tools
Database Scripts
Download to your PC

This web page are instructions to download the ORACLE-II-Files Directory that contains the ORACLE PL/SQL stored procedure packages needed for the CO2 II 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-II-Files ORACLE Files software is bundled by 2 methods as a ZIP file and as a JAR File. Both will create the ORACLE-II-Files directory with all the ORACLE Files source files.


Directory Structure of ORACLE-II-Files

Insert Data This directory contains all the scripts that loads the CO2 II - Brine, Fluid, Seismic & Pressure Data
o   Brine This directory contains all the scripts that loads the CO2 II - Brine Data
  - db_insert_co2_brine_laboratory.sql Load Brine Laboratory Information into CO2 Brine Laboratory Database Table
  - db_insert_co2_data_type.sql Load Brine Data Type Data into CO2 Brine Data Type Database Table
  - db_update_co2_build_groups.sql Modify the Group Number & Group ID in the CO2 Brine Sample Database Table. These 2 columns control the data in the animation web apps.
  + Field This directory contains all the scripts that loads the CO2 II - Field Brine Data
  - Wellington_Field_pH_Progression-2016_02_05.sql Load Field - Brine Data into CO2 Brine Database Tables
  + Lab This directory contains all the scripts that loads the CO2 II - Laboratory Brine Data
 
o   Fluid This directory contains all the scripts that loads the CO2 II - Fluid Data
  + insert_co2_and_offset_gas.sql Load Emissions Well Data into CO2 and Offset Gas Database Table
  + insert_fluid_levels.sql Load Production Well Data into CO2 Producer Test Data Database Table
  + insert_injection_data.sql Load Injection Data into CO2 Injection Data Database Table
  + insert_static_data.sql Load Static Well Data into CO2 static by dates Database Table
  + db_update_co2_build_fluid_groups.sql Modify the Group Number & Group ID in the CO2 Producer Test Data Database Table. These 2 columns control the data in the animation web apps.
 
o   Seismic This directory contains all the scripts that loads the Seismic Data from the Wellington Field Seismic Sensors
 
o   Pressure This directory contains all the scripts that loads the CO2 II - Pressure Data
  + insert_pressure_barometric_files.sql Load Barometric File Information into Barometric Files Database Table
  + insert_pressure_plot_data.sql Load Pressure Parameters Data into Pressure Plot Info Database Table
  + insert_pressure_data_files.sql Load Pressure Plot File Information into Pressure Data Files Database Table
  + insert_pressure_test_files.sql Load Pressure Data File Information into Pressure Files 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 II project
  [b] co2_brine_data_type_pkg.sql Generate the Brine Data Types Database Table Contents Web Page
  [b] co2_brine_summary_pkg.sql Generate the Brine Data Summary Page Web Page
  [b] co2_brine_data_summary_pkg.sql Generate the Brine Well Sample Data Summary Page Web Page
  [b] co2_brine_summary_csv_pkg.sql Generate the Brine Data CSV (Comma Separated Values) Web Page
  [b] co2_brine_data_pkg.sql Get Brine Data for brine plots as XML (Extensible Markup Language) from Brine Database Tables
  [b] co2_gridding_pkg.sql Get Brine Data for brine animation plots as XML (Extensible Markup Language) from Brine Database Tables
 
  [b] co2_production_pkg.sql Get Oil Production as XML (Extensible Markup Language) from the CO2 Producer Test Data Database Table &
CO2 Emissions Data as XML (Extensible Markup Language) from CO2 and Offset Gas Database Table
  [b] co2_injection_pkg.sql Get Brine / CO2 Injection Data as XML (Extensible Markup Language) from CO2 Injection Data Database Tables
  [b] co2_gridding_fluid_pkg.sql Get Fluid Level Data for gridding & mapping animation as XML (Extensible Markup Language) from Fluid Level Database Tables
 
  [s] co2_events_summary_pkg.sql Generate the Seismic Array Data Summary Web Page
  [s] ks_earthquakes_pkg.sql Get Kansas Earthquakes (Source USGS) as XML (Extensible Markup Language) from the GIS Webinfo Earthquakes Database Table
  [s] co2_events_pkg.sql Get Seismic Array Events as XML (Extensible Markup Language) from the CO2 Events Database Table
  [s] ks_earthquakes_swd_pkg.sql Get Salt Water Disposal Wells as XML (Extensible Markup Language) from the Qualified Well Headers Database Table
  [s] co2_sensors_pkg.sql Get Seismic Sensors as XML (Extensible Markup Language) from the CO2 Seismic Sensors Database Table
  [s] co2_miniseed_files_pkg.sql Get Seismic Sensors MiniSeed File Location as XML (Extensible Markup Language) from the MiniSeed Files Database Table
  [s] co2_miniseed_pkg.sql Get Seismic Sensor Location as XML (Extensible Markup Language) from the CO2 Seismic Sensors Database Table
 
  [p] co2_pressure_catalog_pkg.sql Generate the Pressure Catalog Summary Web Page
  [p] co2_barometric_files_pkg.sql Get Barometric File Information as XML (Extensible Markup Language) from the Barometric Files Database Table
  [p] co2_pressure_files_pkg.sql Get Pressure/Temperature File Information as XML (Extensible Markup Language) from the Pressure Files Database Table
 
SQL This directory contains all the SQL Scripts that will build the database tables for the CO2 II tables
  [b] db_create_brine_tables.sql Create the Brine Data Database Tables
 
  [f] db_create_fluid_level_tables.sql Create the Fluid Level Data Database Tables
 
  [s] db_create_co2_seismic_tables.sql Create the Seismic Database Table
 
  [p] db_create_co2_barometric_tables.sql Create the Barometric Files Database Table
  [p] db_create_co2_pressure_data_tables.sql Create the Pressure/Temperature Database Tables

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-II-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-II-Files/download.html