>> Table of Contents
- 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.
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.
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.
To delete a criterion from the criteria list, click the "X" preceding the 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
The default columns returned by a search are as follows:
- Company Name
- Producing Formation
- Total Drill Depth
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.
When you add criteria to a search, the fields of those criteria are added to the columns displayed.
ESOGIS allows you to export any search result to a number of formats and detailed below.
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 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 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 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.
You can export the production data from a search result to CSV.
You can regroup the data by changing the Group By drop down.