Department of Environmental Conservation

D E C banner

Documentation on Data Files

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

The accompanying file,, updated nightly, 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, and plugged in New York State. The file type of the 'wellspublic' file is .csv to simplify importing into spreadsheet programs (MS 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 line of the .csv file.

The latitude and longitude are in the NAD83 datum. Coordinates are in decimal degrees. [e.g. -73.23541 Degrees, decimal minutes] 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: 01 May 2013

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 API number
SIDETRCK 2-Digit sidetrack code
COMPLETION 2-Digit company completion code
WELL_NAME Well name
COMPAY_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 Well completion date
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
STATE_LEASE Lease owned by the state (Y/N)
PROPOSED_DEPTH Depth 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 Total 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 Depth (ft) of bottom of wellbore
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
DT_HEARING Date of Integration Hearing
DT_MOD Last date record was modified
LINK Link to DEC Searchable online database record for individual well

County Names and Codes
County Code County Name County Code County Name
001 Albany 061 New York
003 Allegany 063 Niagara
005 Bronx 065 Oneida
007 Broome 067 Onondaga
009 Cattaraugus 069 Ontario
011 Cayuga 071 Orange
013 Chautauqua 073 Orleans
015 Chemung 075 Oswego
017 Chenango 077 Otsego
019 Clinton 079 Putnam
021 Columbia 081 Queens
023 Cortland 083 Rensselaer
025 Delaware 085 Richmond
027 Dutchess 087 Rockland
029 Erie 089 St. Lawrence
031 Essex 033 Franklin
093 Schenectady 035 Fulton
095 Schoharie 037 Genesee
097 Schuyler 039 Greene
099 Seneca 041 Hamilton
101 Steuben 043 Herkimer
103 Suffolk 045 Jefferson
105 Sullivan 047 Kings
107 Tioga 049 Lewis
109 Tompkins 051 Livingston
111 Ulster 053 Madison
113 Warren 055 Monroe
115 Washington 057 Montgomery
117 Wayne 059 Nassau
119 Westchester 121 Wyoming
123 Yates 091 Saratoga

Back to Attribute Tables

Confidential Information Codes
Code Description
R Released
Y We have confidential information for 6 months.
E Confidential information is 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
DH Dry Hole
EX Expired Permit
IN Inactive
NL Not Listed
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
OB Observation Well
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
O Other Well*
OP Other Well Plugged*

*Other includes: Injection, Stratigraphic, Geothermal, and Not Listed well types.
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