GEMINI Tools
KGS ORACLE PL/SQL Stored Procedures
Description | PL/SQL Stored Procedures Source Download | Copyright & Disclaimer |
The GEMINI Tools Web Applications were developed with the capability of accessing the Kansas Geological Survey (KGS) ORACLE Database and Server for well oil & gas data as well as brine sample data and outcrop & stream cut measured sections. The Kansas Geological Survey has over 450,000 wells listed in their ORACLE Database with more than 18,000 Log ASCII Standard (LAS) version 2.0 files in the Kansas Geological Survey Collection and there are 162,712 wells with top picks.

The web applications were developed for user's to import Log ASCII Standard (LAS) version 2.0 & 3.0 files as well as Comma Separated Values (CSV) files for Core data, Tops data, Brine data, and ASCII delimited geologist core & cuttings reports. These web applications also had links to the Kansas Geological Survey well database tables and file server. This link took on the form of ORACLE PL/SQL stored procedures that generated Extensible Markup Language (XML) data streams for the data.

This web site will provide download process for downloading the ORALCE PL/SQL stored procedures to the developers PC for purpose of maintenance.

Select a button from the following list to view the KGS ORACLE Database tables and the ORACLE PLSQL Stored Procedures.

Well Data
Well Data - Database Tables & ORACLE PL/SQL Stored Procedures
    o LAS File & Curves Database Tables & ORACLE PL/SQL Stored Procedures
    o Perforations Database Tables & ORACLE PL/SQL Stored Procedures
    o Well Tops Database Tables & ORACLE PL/SQL Stored Procedures
    o Measured Core Data Database Tables & ORACLE PL/SQL Stored Procedures
    o Core Image File Database Tables & ORACLE PL/SQL Stored Procedures
KGS Web Site - LAS Viewer
KGS Web Site - LAS Viewer - Database Tables & ORACLE PL/SQL Stored Procedures
Kansas Measured Sections
Kansas Measured Sections - Database Tables & ORACLE PL/SQL Stored Procedures
Brine Sample Data
Brine Sample Data - Database Tables & ORACLE PL/SQL Stored Procedures
Drill Stem Test (DST) Data
Trilobite Drill Stem Test - Database Tables & ORACLE PL/SQL Stored Procedures
Production Data
  Lease Production Database Tables & ORACLE PL/SQL Stored Procedures
  Field Production Database Tables & ORACLE PL/SQL Stored Procedures
  Operator Production Database Tables & ORACLE PL/SQL Stored Procedures
  County Production Database Tables & ORACLE PL/SQL Stored Procedures

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

The URL for this page is http://www.kgs.ku.edu/stratigraphic/JAVA_SRC/ORACLE-PLSQL/index.html