Department of Environmental Conservation

D E C banner

Documentation on Data Files

Division of Mineral Resources, New York State Department of Environmental Conservation

The file,, consists of data from the Division of Mineral Resources' oil and gas database. The 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:

  1. 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

Items (or Fields) in the Point Attribute Table
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
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_PLUGGED Date of plugging
DATE_WELL_CONFIDENTIAL Date confidential status applied
CONFID Confidential well status Confidential Information Codes
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)
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 Names and Codes
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

Back to Attribute Tables

Confidential Information Codes
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.

Back to Attribute Tables

Well Status Codes
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

Back to Attribute Tables

Well Type Codes
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

Back to Attribute Tables

Well Type Codes for Mapping (Map_Symbol Field in Attribute Table)
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

State Lease Codes
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

Back to Attribute Tables

Integration Codes
Code Definition
NO No integration order required
OI Integration order issued
OP Integration order pending
RE Referred to Office of Hearings and Mediation Services

Back to Attribute Tables

  • PDF Help
  • For help with PDFs on this page, please call 518-402-8072.
  • Contact for this Page
    Division of Mineral Resources
    625 Broadway
    3rd Floor
    Albany NY 12233-6500
    Send us an email
  • This Page Covers
  • Page applies to all NYS regions