Documentation on Data Files
Division of Mineral Resources, New York State Department of Environmental Conservation
The file, wellDOS.zip, consists of data from the Division of Mineral Resources' oil and gas database. The wellDOS.zip file contains two separate files: wellspublic.csv and OilandGasMetadata.html. The wellspublic.csv file contains records from the oil and gas database of wells that have been permitted, drilled, or plugged in New York State. The file type of the 'wellspublic' file is comma-separated values (.csv) to simplify importing into spreadsheet programs (Microsoft Excel- and ESRI ArcGIS-compatible). The associated metadata file, OilandGasMetadata.html, contains information about the dataset, which is also detailed in the tables below. Some well records contain confidential information which has been replaced by the word "CONFIDENTIAL".
Field names are listed on the first row of the .csv file.
Latitude and longitude are in the NAD83 datum. Coordinates are in decimal degrees. [e.g. -73.23541] Longitudinal values are negative (-) to reflect the correct geographical coordinate quadrant.
Geographic Data Set: Oil and Gas Wells
Description: This coverage contains data from the Division of Mineral Resources' Oil and Gas Wells permit files
Available: Statewide
Completion or Most Recent Revision Date: Dataset updated nightly (Monday - Friday).
Attribute Tables: Items (or Fields) in the Point Attribute Table
Contact: Division of Mineral Resources
625 Broadway, 3rd Floor
Albany, NY 12233-6500
email us
Documentation Date: 06 June 2019
Usage Notes:
- This data has not been field verified but is expected to be within approximately 300 feet of the actual well location. The data should not be used for precise determination of distances to buildings, property boundaries or other features. It is most useful for determining general locations of wells.
Attribute Tables
| Field Name | Explanation |
|---|---|
| API_WELLNO | 14-Digit API number |
| CNTY | 3-Digit county code County Codes |
| HOLE | 5-Digit hole code |
| SIDETRCK | 2-Digit sidetrack code |
| COMPLETION | 2-Digit completion code |
| WELL_NAME | Well name |
| COMPANY_NAME | Well owner |
| OPERATOR_NUMBER | Well owner code |
| WELL_TYPE | Well Type Codes |
| MAP_SYMBOL | Well Type Codes for Mapping |
| WELL_STATUS | Well Status Codes |
| DT_STATUS | Date of assigned well status code |
| DT_PERMIT_APPLICATION | Date permit application received |
| PERMIT_ISSUED | Date permit issued/approved |
| DATE_SPUDDED | Date drilling began |
| DATE_TOTAL_DEPTH | Date wellbore drilled to total depth |
| DATE_WELL_COMPLETED | Completion date |
| DATE_WELL_PLUGGED | Date of plugging |
| DATE_WELL_CONFIDENTIAL | Date confidential status applied |
| CONFID | Confidential well status Confidential Information Codes |
| TOWN | Town |
| QUAD | USGS Quadrangle |
| QUADSEC | Letter designation of USGS quadrangle section |
| PRODUCING_NAME | Name of producing field |
| PRODUCING_FORMATION | Name of producing formation |
| FINANCIAL_SECURITY | Does operator have financial security? |
| SLANT | Orientation of borehole (Vertical/Horizontal/Directional) |
| COUNTY | County |
| REGION | NYSDEC Administrative Region |
| STATE_LEASE | Lease owned by the state State Lease Codes |
| PROPOSED_DEPTH | Depth (ft.) specified on permit application |
| SURFACE_HOLE_LOCATION | Specifies type of location point |
| SURFACE_HOLE_LONGITUDE | Longitude of surface hole point (decimal degrees) |
| SURFACE_HOLE_LATITUDE | Latitude of surface hole point (decimal degrees) |
| BOTTOM_HOLE_LOCATION | Specifies type of location point |
| BOTTOM_HOLE_LONGITUDE | Longitude of bottom hole point (decimal degrees) |
| BOTTOM_HOLE_LATITUDE | Latitude of bottom hole point (decimal degrees) |
| TRUE_VERTICAL_DEPTH | True vertical depth (ft.) to bottom of wellbore (TVD) |
| MEASURED_DEPTH | Total measured length (ft.) of borehole (TMD) |
| KICKOFF | Depth (ft.) of kickoff point |
| DRILLED_DEPTH | Length (ft) of borehole drilled past Kickoff Point |
| ELEVATION | Elevation (ft.) above sea level at the wellhead. |
| ORIGINAL_WELL_TYPE | Well type specified on permit application |
| PERMIT_FEE | Amount paid for fee |
| OBJECTIVE_FORMATION | Formation targeted for production |
| DEPTH_FEE | Fee paid based on final depth of wellbore |
| SPACING | Spacing required or exempt |
| SPACING_ACRES | Acres specified in the spacing order |
| INTEGRATION | Integration code Integration Codes |
| DT_HEARING | Date of Integration Hearing |
| DT_MOD | Last date record was modified |
| LINK | Link to DEC Searchable online database record for individual well |
| LOCATION_VERIFIED | A Global Positioning System receiver was used in the field to verify existing, or revise less accurate, surface location coordinates. Verified locations can be expected to be within 50 feet of the actual well surface location. |
| GENERALWELLTYPE | Indicates the general well type |
| GENERALWELLSTATUS | Indicates whether the well is plugged or unplugged |
| County Code | County Name | County Code | County Name |
|---|---|---|---|
| 001 | Albany | 063 | Niagara |
| 003 | Allegany | 065 | Oneida |
| 005 | Bronx | 067 | Onondaga |
| 007 | Broome | 069 | Ontario |
| 009 | Cattaraugus | 071 | Orange |
| 011 | Cayuga | 073 | Orleans |
| 013 | Chautauqua | 075 | Oswego |
| 015 | Chemung | 077 | Otsego |
| 017 | Chenango | 079 | Putnam |
| 019 | Clinton | 081 | Queens |
| 021 | Columbia | 083 | Rensselaer |
| 023 | Cortland | 085 | Richmond |
| 025 | Delaware | 087 | Rockland |
| 027 | Dutchess | 089 | St. Lawrence |
| 029 | Erie | 091 | Saratoga |
| 031 | Essex | 093 | Schenectady |
| 033 | Franklin | 095 | Schoharie |
| 035 | Fulton | 097 | Schuyler |
| 037 | Genesee | 099 | Seneca |
| 039 | Greene | 101 | Steuben |
| 041 | Hamilton | 103 | Suffolk |
| 043 | Herkimer | 105 | Sullivan |
| 045 | Jefferson | 107 | Tioga |
| 047 | Kings | 109 | Tompkins |
| 049 | Lewis | 111 | Ulster |
| 051 | Livingston | 113 | Warren |
| 053 | Madison | 115 | Washington |
| 055 | Monroe | 117 | Wayne |
| 057 | Montgomery | 119 | Westchester |
| 059 | Nassau | 121 | Wyoming |
| 061 | New York | 123 | Yates |
| Code | Description |
|---|---|
| R | Confidential information has been Released |
| Y | Well information is held confidential for 6 months after spud date |
| E | Confidential status has been extended for an additional 18 months |
| N | Well does not have confidential information. |
| Code | Description |
|---|---|
| AC | Active |
| AR | Application Received to Drill/Plug/Convert |
| CA | Cancelled |
| CO | Converted to other well type |
| DC | Drilling Completed |
| DD | Drilled Deeper |
| DG | Drilling in Progress |
| EX | Expired Permit |
| IN | Inactive |
| NR | Not Reported on AWR |
| PA | Plugged and Abandoned |
| PB | Plugged Back |
| PI | Permit Issued |
| PM | Plugged Back Multilateral |
| RE | Refunded Fee |
| RW | Released - Water Well |
| SI | Shut-In |
| TA | Temporarily Abandoned |
| TR | Transferred Permit |
| UN | Unknown |
| UM | Unknown Not Found |
| UL | Unknown Located |
| VP | Voided Permit |
| Code | Description |
|---|---|
| BR | Brine |
| DH | Dry Hole |
| DS | Disposal |
| DW | Dry Wildcat |
| GD | Gas Development |
| GE | Gas Extension |
| GW | Gas Wildcat |
| IG | Gas Injection Well |
| IW | Enhanced Oil Recovery - Injection |
| LP | Liquefied Petroleum Gas Storage |
| MB | Monitoring Brine |
| MM | Monitoring Miscellaneous |
| MS | Monitoring Storage |
| NL | Not Listed |
| OD | Oil Development |
| OE | Oil Extension |
| OW | Oil Wildcat |
| SG | Stratigraphic |
| ST | Storage |
| TH | Geothermal |
| UN | Unknown |
| Code | Description |
|---|---|
| CON | Confidential |
| GW | Gas Well |
| GWP | Gas Well Plugged |
| OW | Oil Well |
| OWP | Oil Well Plugged |
| S | Storage Well |
| SP | Storage Well Plugged |
| SM | Solution Brine Well |
| SMP | Solution Brine Well Plugged |
| DH | Dry Hole |
| DHP | Dry Hole Plugged |
| O | Other Well* |
| OP | Other Well Plugged* |
*Other includes: Injection, Stratigraphic, Geothermal, Disposal, Monitoring Miscellaneous, and Not Listed well types.
Back to Attribute Tables
| Code | Definition |
|---|---|
| NA | Not Applicable - Well Not on State Land |
| SD | Well on State DOT Land |
| SO | Well on Other State Land |
| SP | Well on State Park Land |
| ST | Well on State DEC Land |
| UD | Well Unitized with State DOT Land |
| UO | Well Unitized with Other State Land |
| UP | Well Unitized with State Park Land |
| UT | Well Unitized with State DEC Land |
| Code | Definition |
|---|---|
| NO | No integration order required |
| OI | Integration order issued |
| OP | Integration order pending |
| RE | Referred to Office of Hearings and Mediation Services |
