The Well Header Data Search application allows the
user to query oil & gas header records in our system through the given fields
on the form. Once the user enters their selection criteria and hits
the search button, the matching header records are then returned. When performing a query on multiple fields, it is treated with an "and" operator
in the search. This means that criteria entered in all fields must be met.
The default value for each search field is set to null which will return all records.
However, you must enter/select at least one condition for the application
to run, but not any one field condition is required. The form is made up of 4 types of searches: numeric searches(Num), character searches(Char), pull-downs and checkboxes.
Below is an illustration of the oil & gas header data
search form with type of searches and requirements to perform searches on each field.
API #: |
10 Digit Num between 4700100001 and 4710999999, looks for
an exact match
|
Well Type: |
Pull Down - select one if
desired |
County: |
Pull Down - select one if
desired |
Total Vertical Depth TVD(ft) >=
|
4 or 5 digit Num between 1000 and 15000 |
7.5 Minute Quad: |
Pull Down - select one if desired |
Completion Year = |
4 digit Num between 1850 and 2010, looks for an exact match |
Type of Log: |
Pull Down - select one if desired |
Operator (contains): |
contains character search, minimum 3 characters
if searching |
Log Bottom (ft) >= |
4 or 5 digit Num between 1000 and 15000 |
Surface Owner (contains): |
contains character search, minimum 3 characters
if searching |
has Scanned Log(s): |
Checkbox
- checked (Yes), unchecked(No/Null) |
Field Name (contains): |
contains character search, minimum 3 characters
if searching |
has Digitized Log(s): |
Checkbox - checked (Yes), unchecked(No/Null) |
Company Number (contains): |
contains character search, minimum 3 characters
if searching |
has Sample Desc Scan: |
Checkbox
- checked (Yes), unchecked(No/Null) |
Mineral Owner (contains): |
contains character search, minimum 3 characters if searching |
has Slabbed Core Photo(s): |
Checkbox - checked (Yes), unchecked(No/Null) |
Horizontal/Deviated Well: |
Checkbox
- checked (Yes), unchecked(No/Null) |
An example of a search would be if you wanted to see all wells in Barbour county,
with a total depth greater than or equal to 5000 feet and with a surface owner name of Smith.
You would enter the search criteria and the form should look similar to the following
display. Please note you have the option to change the number of records
returned per page within the form by changing the selection in the "Results/Page"
pull-down. You also have several sorting options available in the "Order By"
pull-down.
You would then hit the search button and the application would return the resulting
records similar to below.
The resulting data is our header records for each well that met your search criteria.
Latitude and longitude coordinates for wells are provided in NAD83 datum.
The system
will also provide a link to "pipeline" and other system applications to provide
more complete well info if the data are available. To use the link
to "pipeline" just hit the "All Data" link for that record. Sometimes you
may see more than one record for one particular well. This is due to multiple
episodes of the well, for instance it the well is worked over or deepened.