>> Table of Contents

  1. Search Wells
    1. Criteria
      1. Adding Criteria
      2. Removing Criteria
      3. Combining Criteria
    2. Columns
      1. Sorting
      2. Criteria Fields
    3. Exporting Search Results
      1. Comma Separated Values
      2. Petra® Project
      3. Keyhole Mark-up Language (KML)
    4. Production Data
      1. Save as Comma Separated Values
      2. View Graphs

Search Wells

One of the strong points of ESOGIS is the variety of search criteria. You can also combine search terms using AND or OR to further filter the results.

Search Wells is found in the left menu under Queries.

Criteria

When performing a search, you must choose a field, an operator, and a value. Some fields have special operators and values such as API, with which you can only use the "equal" operator. For Example:

County begins with All
This query will display all of the wells in Allegany county.
County begins with Al

In the above example, The field is "County", the operator is "begins with" and the value is "All" or "Al". This will search for all ways that have a county name that starts with "All" or "Al", respectively.

Adding Criteria

To add criteria, choose a field, an operator, then a value, and then click the "Submit" button to add the criterion to the list criteria list.

Removing Criteria

To delete a criterion from the criteria list, click the "X" preceding the criteria.

Combining Criteria

We you add criteria to a search, you can choose whether the criteria is combined using an "and" or an "or. Naturally, this only affects search with more than one criterion. The default combiner is "and". To change it to "or", use the drop down box by the label "Criteria Combiner" and select "or", then click the "Submit" button. "And" combiners generally restrict results; whereas, "or" combiners generally expands results.

For Example:
County begins with All or County begins with Cat
This query will display all of the wells in Allegany or Cattaraugus counties which results in more than 21000 wells.
County begins with All and County begins with Cat

Columns

The default columns returned by a search are as follows:

  1. API
  2. Name
  3. Company Name
  4. County
  5. Town
  6. Quad
  7. Field
  8. Producing Formation
  9. Total Drill Depth

Sorting

If you click the heading of a column, the search results will be sorted by that column in a descending fashion. If you click it again, the order of the sort will be reversed.

Criteria Fields

When you add criteria to a search, the fields of those criteria are added to the columns displayed.

Exporting Search Results

ESOGIS allows you to export any search result to a number of formats and detailed below.

Comma Separated Values

Comma separated values (CSV) is a text file where the first row is the column names separated by columns. Each row thereafter corresponds to row from the search results. CSV can be imported in to a number of programs such as Excel, Petra, ArcGIS, MySQL, and many more.

Petra® Project

Petra project format allows you to import well data in to an existing Petra project. It is a text file with the extension .asc which stands for ASCII.

Keyhole Mark-up Language (KML)

Keyhole Mark-up Language or KML is an XML based language used by Google Earth, formally Keyhole. Google submitted KML to the Open Geospatial Consortium to be maintained as a standard. More information can be found at the OGC site under standards, KML.

KML files are compressed and are presented with the extension .kmz.

Production Data

Production data for wells in NY State are obtained from the DEC - Division of Mineral Resources, Oil and Gas. The data units for the data are MCF (thousand cubic feet) for gas, BBL (barrels) for oil and water.

Save as Comma Separated Values

You can export the production data from a search result to CSV.

View Graphs

In order to view the graphs for production data, you must use a modern browser with JavaScript enabled.

You can regroup the data by changing the Group By drop down.