CO2 II Tools
Database Scripts
Download to your PC
|
|
CO2 II Tools |
|
| Description | DB Scripts Source Download | Copyright & Disclaimer | |
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.
Unzip the file. The program files are located under a directory called 'ORACLE-II-Files' so it is safe to unzip where ever you like.
Extract the JAR file by the following command
C:\jdk1.7.0_25\bin\jar xf ORACLE-II-Files.jar
The program files are located under a directory called 'ORACLE-II-Files' so it is safe to extract the jar where ever you like.
| 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 | ||
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 |
 |
 |