Drilling Permits (W-1)
Drilling Permits (W-1)Drilling Permits Pending ApprovalPlus Latitudes and LongitudesRailroad Commission of TexasInformation Technology Services DivisionMay 2020
Table of Contents1.0 Purpose . 12.0 Data Export Information . 13.0 File Descriptions . 24.0 File Definitions . 61. dp drilling permit pending yyyymmddhhmmss.txt . 62. dp wellbore pending yyyymmddhhmmss.txt . 73. dp permit restriction pending yyymmddhhmmss.txt . 84. dp swr resolution pending yyyymmddhhmmss.txt . 95. dp permitted field pending yyyymmddhhmmss.txt . 96. dp mailing address pending yyyymmddhhmmss.txt . 107. dp perp pending yyyymmddhhmmss.txt . 118. dp wellbore profile pending yyyymmddhhmmss.txt . 129. dp perp field pending yyyymmddhhmmss.txt . 1210. dp latlongs pending yyyymmddhhmmss.txt. 1311. dp perp wellbore pending yyyymmddhhmmss.txt . 145.0 Data Dictionary . 156.0 Data Relationships . 477.0 Revisions . 49
1.0 PurposeThis document provides the file formats and data dictionary for submitted drillingpermit applications (Form W-1 Application for Permit to Drill, Recomplete or Reenter). The files only contain applications that are in a pending approval status.The file creation process parses the data for a drilling permit application intomultiple text files. The date and time at the end of the file indicate when the filewas generated. The file creation process generates two sets of files daily. One fileset is generated at approximately 11:00 a.m., which captures W-1s submitted after5:00 p.m. of the previous day and before 11:00 a.m. of the current day. Thesecond file set captures W-1s submitted between 11:00 a.m. and 5:00 p.m. of thecurrent day.The text files for an application are associated with each other through commondata fields identified in Section 3.0 File Descriptions. Data field definitions areprovided in Section 5.0 Data Dictionary. A graphical view of how the data is parsedis provided in Section 6.0 Data Relationships.Since the applications are in a pending approval status, the data in the record maycontains errors that will be corrected prior to application approval. There may beblank data fields where the data will be added later, during the application reviewprocess. Other data fields such as completion code will remain blank until after thewell is drilled, and the permit is closed.To view current data for a specific application or permit, you can access the DrillingPermits Query screen on the RRC public ngPermitsQueryAction.do.2.0 Data Export InformationFile NamesExport FormatFile DelimiterDelivery Format1. dp drilling permit pending yyyymmddhhmmss.txt2. dp wellbore pending yyyymmddhhmmss.txt3. dp permit restriction pending yyyymmddhhmmss.txt4. dp swr resolution pending yyyymmddhhmmss.txt5. dp permitted field pending yyyymmddhhmmss.txt6. dp mailing address pending yyyymmddhhmmss.txt7. dp perp pending yyyymmddhhmmss.txt8. dp wellbore profile pending yyyymmddhhmmss.txt9. dp perp field pending yyyymmddhhmmss.txt10. dp latlongs pending yyyymmddhhmmss.txt11. dp perp wellbore pending yyyymmddhhmmss.txtASCII delimited file}CD or FTPDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 1Version 2.2 May 2020
3.0 File DescriptionsFile Name1. dp drilling permit pendingyyyymmddhhmmss.txtFile DescriptionDrilling Permit level information. There is onerecord for each drilling permit application enteredin the online Drilling Permits system. This recordcontains information for the application and thedrilling permit issued.UNIVERSAL DOC NO is the system-assignedunique identifier for this file.Data in this text file is associated with other filesvia the UNIVERSAL DOC NO column:dp wellbore pending (File 2)dp permit restriction pending (File 3)dp swr resolution pending (File 4)dp permitted field pending (File 5).2. dp wellbore pendingyyyymmddhhmmss.txtWellbore information for the drilling permit. Thereis one record for each drilling permit applicationentered in the online Drilling Permits system. Thisrecord contains wellbore surface hole location datasuch as distance and direction from nearest town,county code, GPS coordinates, and API number.Data in this text file is associated with the“dp drilling permit pending” file via theUNIVERSAL DOC NO column.3. dp permit restriction pendingyyymmddhhmmss.txtRestriction(s) applied to a drilling permit. Therecan be multiple records for each drilling permitapplication entered in the online Drilling Permitssystem. Restriction codes are as follows:09 - Corrected permit to show correct survey.12 - No authority to downhole commingle untilexception to Rule 10 is granted.15 - This permit is generated for administrativepurposes only.17 - Approved under entity for density pursuant toDocket #18 - Administrative SWR 39 Exception.21 - This is not a directional well. Unintentionallydeviated. As drilled BHL22 - Permit to drill granted pending approval.23 - Exception to SWR 86 granted per Docket #Drilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 2Version 2.2 May 2020
File NameFile Description24 - This is not a permit to drill. This permit isissued to re-plug well only.25 - This well cannot be produced concurrentlyfrom the same reservoir.28 - No perforations or take points may be placedin the wellbore where a "NO PERF ZONE" wasdesignated on the plat that was approved for thispermit. If at such time the NPZ's are no longerapplicable, then an amended permit will berequired to remove the NPZ restriction beforecompleting the well.29 - This well must comply to the new SWR 3.13requirements concerning the isolation of anypotential flow zones and zones with corrosiveformation fluids. See approved permit for thoseformations that have been identified for the countyin which you are drilling the well in.30 – Text is entered by Drilling Permits reviewer.Data in this text file is associated with the“dp drilling permit pending” file via theUNIVERSAL DOC NO column.4. dp swr resolution pendingyyyymmddhhmmss.txtInformation on the resolution of a Statewide Ruleexception for the drilling permit. There can bemultiple records for each drilling permit applicationentered in the online Drilling Permits system.Data in this text file is associated with the“dp drilling permit pending” file via theUNIVERSAL DOC NO column.5. dp permitted field pendingyyyymmddhhmmss.txtInformation on a field of anticipated completion(also referred to as “permitted field”) associatedwith the drilling permit. For each drilling permitapplication entered in the online Drilling Permitssystem, there can be multiple permitted fields,with one record for each permitted field.Data in this text file is associated with the“dp drilling permit pending” file via theUNIVERSAL DOC NO column.Data in this text file is associated with other filesvia the PERMITTED FIELD ID column:dp wellbore profile pending (File 8)Drilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 3Version 2.2 May 2020
File NameFile Descriptiondp perp field pending (File 9)dp perp wellbore pending (File 11)6. dp mailing address pendingyyyymmddhhmmss.txtMailing address for the operator. There is onerecord for each drilling permit application enteredin the online Drilling Permits system.Data in this file is associated with the“dp drilling permit pending” file via theOPERATOR NUMBER column.7. dp perp pendingyyyymmddhhmmss.txtWellbore surface hole location measured from thenearest perpendicular survey lines. There is onerecord for each drilling permit application enteredin the online Drilling Permits system. File alsoincludes abstract, section and survey informationrelated to the wellbore surface hole location.Data in this file is associated with the“dp wellbore pending” file via the WELLBORE IDcolumn.8. dp wellbore profile pendingyyyymmddhhmmss.txtFor a permitted field, the type of wellbore profileassociated with it. For each drilling permitapplication entered in the online Drilling Permitssystem, there can be multiple permitted fieldrecords, and multiple wellbore profile records foreach permitted field record.Data in this file is associated with the“dp permitted field pending” file via thePERMITTED FIELD ID column.9. dp perp field pendingyyyymmddhhmmss.txtFor a permitted field, the surface hole locationmeasured from the nearest perpendicular leaselines. If the surface hole location is off-lease,measurements are from the nearest perpendicularsurvey lines. For each drilling permit applicationentered in the online Drilling Permits system, thereis one record for each permitted field. File alsoincludes abstract, section and survey informationrelated to the permitted field.Data in this file is associated with the“dp permitted field pending” file via thePERMITTED FIELD ID column.Drilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 4Version 2.2 May 2020
File NameFile Description10. dp latlongs pendingyyyymmddhhmmss.txtGlobal Positioning System (GPS) coordinates asstored on the RRC GIS System. They are stored inNAD27 decimal degrees format. For each drillingpermit application entered in the online DrillingPermits system, there are two records, one forsurface hole location, and one for bottom holelocation.Data in this file is associated with the“dp wellbore pending” file via theAPI SEQUENCE NUMBER column.11. dp perp wellbore pendingyyyymmddhhmmss.txtFor a horizontal or directional wellbore profilewithin a permitted field, the location of points onthe wellbore (such as penetration point, terminuspoint, take points, or bottom hole location) asmeasured from perpendicular reference lines (i.e.survey or lease lines). For each drilling permitapplication entered in the online Drilling Permitssystem, there can be multiple permitted fieldrecords, multiple wellbore profile records for eachpermitted field record, and multiple wellboreperpendicular records for each wellbore profilerecord. File also includes abstract, section andsurvey information related to the bottom holelocation.Data in this file is associated with the“dp wellbore profile pending” file via theWELLBORE PROFILE ID column.Drilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 5Version 2.2 May 2020
4.0 File DefinitionsFile NameDataFieldNo.Data Field Name1. dp drilling permit pending yyyymmddhhmmss.txt1234SWR38 ABBR NOTICEIS REAPPLIEDUNIVERSAL DOC NOSTATUS NUMBER5EFFECTIVE DT6RETURN DT7TOTAL DEPTH8IS AMENDMENT9SWR 36 FLAG10DEVELOP MINERALS FLAG11CASE DOCKET NO12FINAL PROTEST DT13STATUS SEQ NO14SPUD DT15EXPEDITE FLAG16EXPEDITE DATE TIME17FILING PURPOSE CODE18SURFACE CASING DT19DEFAULT LEASE NAME20DEFAULT WELL NUMBER21DEFAULT VERTICAL22DEFAULT HORIZONTAL23DEFAULT SIDETRACK24LOCKED BY25DEFAULT DIRECTIONAL26STATUS CODE27EXPIRATION DATE28WALKIN CONTACT NAME29WALKIN CONTACT PHONE30COMPLETION CODE31SWR SUBSECT CODEDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 6Version 2.2 May 2020
File NameDataFieldNo.Data Field Name32STAT DT33CURRENT STATE CODE34BRIDGE FLAG35SWR LIST36BRIDGE PRINT FLAG37HAS DISCREPANCY38SUBMIT DATE39CREATE DATE40UNIQUE ADDRESS NUMBER41DKT SUFFIX CODE42DKT EXAMINER CODE43REAPPLIED STATUS NO44OPERATOR NAME45OPERATOR NUMBER46OPERATOR PHONE47DISTRICT2. dp wellbore pending yyyymmddhhmmss.txt1LATLONG TYPE CODE2LAT DEGREES3LAT MINUTES4LAT SECONDS5LONG DEGREES6LONG MINUTES7LONG SECONDS8STATE PLANE ZONE CODE9STATE PLANE X10GW1 FLAG11LAT DEGREES S12LAT MINUTES S13LAT SECONDS S14LONG DEGREES S15LONG MINUTES S16LONG SECONDS SDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 7Version 2.2 May 2020
File NameDataFieldNo.Data Field Name17API SEQUENCE NUMBER18DIRECTIONS19MODIFIED BY20NEAREST TOWN DISTANCE21NEAREST TOWN22MODIFIED DT23API LINKED FLAG24LOCATION DESCRIPTION25COUNTY CODE26SURFACE LOCATION CODE27WELLBORE ID28OFFSHORE COUNTY CODE29UNIVERSAL DOC NO30HORIZ WELLBORE TYPE CODE31STACKED LAT STATUS NO32PSA FLAG33ALLOCATION FLAG34STACKED LATERAL FLAG35STATE PLANE Y36OPERATOR NAME37OPERATOR NUMBER38OPERATOR PHONE39DISTRICT3. dp permit restriction pending yyymmddhhmmss.txt1PERMIT RESTRICTION ID2RESTRICTION CODE3UNIVERSAL DOC NO4RESTRICTION TEXT5MODIFIED BY6MODIFIED DT7OPERATOR NAME8OPERATOR NUMBER9OPERATOR PHONEDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 8Version 2.2 May 2020
File NameDataFieldNo.10Data Field NameDISTRICT4. dp swr resolution pending yyyymmddhhmmss.txt1UNIVERSAL DOC NO2SWR RESLTN CODE3MODIFIED BY4MODIFIED DT5SWR RESOLUTION ID6OPERATOR NAME7OPERATOR NUMBER8OPERATOR PHONE9DISTRICT5. dp permitted field pending yyyymmddhhmmss.txt1OFF LEASE PNTRN PT FLAG2OFF LEASE SURF LOC FLAG3REX OLPP OWN OFFSET YN4REX OLPP WAVIER YN5REX OLPP NOTICE YN6REX OLPP PUBLICATION YN78REX OLPP HEARING REQUESTYNREX OLPP LAST NOTICE DT9REX OLPP DOCKET NO10WELL NUMBER11UNIVERSAL DOC NO12FIELD ID13WELL TYPE CODE14MODIFIED BY15COMPLETION DEPTHDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 9Version 2.2 May 2020
File NameDataFieldNo.Data Field Name16MODIFIED DT17PRIMARY FIELD FLAG18NEAREST WELL DISTANCE19NEAREST LEASE DISTANCE20TOTAL ACRES21NON CONCURRENT 37WELLS22NON CONCURRENT 38WELLS23POOLED UNIT FLAG24UNITIZED DOCKET NO25SWR39 RESOLUTION26REPORTED LEASE NAME27WELL COUNT28ENTITY DENSITY DOCKET NO29FIELD VALIDATED DT30W1A TRACT DT31COMPLETION DT32COMPLETION WELL CODE33PERMITTED FIELD ID34TEXT FOR 852792013537REX OLPP HEARING OUTCOMECODEHORIZ DEPTH SEVERANCELOWERNRST LEASE DIST SURF LOC38OPERATOR NAME39OPERATOR NUMBER40OPERATOR PHONE41DISTRICT366. dp mailing address pending yyyymmddhhmmss.txt1MAILING ADDRESS ID2ADDRESS LINE13ADDRESS LINE24CITYDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 10Version 2.2 May 2020
File NameDataFieldNo.Data Field Name5COUNTRY CODE6STATE CODE7FOREIGN DELIVERY AREA8UNIVERSAL DOC NO9POSTAL CODE10POSTAL EXTENSION CODE11MODIFIED BY12MODIFIED DT13OPERATOR NAME14OPERATOR NUMBER15OPERATOR PHONE16DISTRICT7. dp perp pending yyyymmddhhmmss.txt1LOCATION TOWNSHIP2LOCATION LOT3LOCATION PORCION4LOCATION SHARE5LOCATION LEAGUE6LOCATION LABOR7LOCATION TRACT8PERP ID9MODIFIED BY10SECTION LINE1 DISTANCE11SECTION LINE1 DIRECTION12MODIFIED DT13SECTION14SECTION LINE2 DISTANCE15ABSTRACT NUMBER16SECTION LINE2 DIRECTION17SURVEY NAME18LOCATION COMMENTS19BLOCK NUMBER20PERP TYPE CODEDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 11Version 2.2 May 2020
File NameDataFieldNo.Data Field Name21WELLBORE PROFILE ID22PERMITTED FIELD ID23COUNTY CODE24PERP LOC CODE25WELLBORE ID26MEASURE LINE TYPE CODE27OPERATOR NAME28OPERATOR NUMBER29OPERATOR PHONE30DISTRICT8. dp wellbore profile pending yyyymmddhhmmss.txt1PROFILE NAME2WELLBORE PROFILE ID3PROFILE CODE4MODIFIED BY5PERMITTED FIELD ID6MODIFIED DT7NRST LEASE DIST BOTM LOC810NRST LEASE DIST FST LST TKPTNRST LEASE DIST PRP ANYTK PTOPERATOR NAME11OPERATOR NUMBER12OPERATOR PHONE13DISTRICT99. dp perp field pending yyyymmddhhmmss.txt12LOCATION TOWNSHIPLOCATION LOT3LOCATION PORCION4LOCATION SHARE5LOCATION LEAGUEDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 12Version 2.2 May 2020
File NameDataFieldNo.Data Field Name6LOCATION LABOR7LOCATION TRACT8PERP ID9MODIFIED BY10SECTION LINE1 DISTANCE11SECTION LINE1 DIRECTION12MODIFIED DT13SECTION14SECTION LINE2 DISTANCE15ABSTRACT NUMBER16SECTION LINE2 DIRECTION17SURVEY NAME18LOCATION COMMENTS19BLOCK NUMBER20PERP TYPE CODE21WELLBORE PROFILE ID22PERMITTED FIELD ID23COUNTY CODE24PERP LOC CODE25WELLBORE ID26MEASURE LINE TYPE CODE27OPERATOR NAME28OPERATOR NUMBER29OPERATOR PHONE30DISTRICT10. dp latlongs pending yyyymmddhhmmss.txt1API SEQUENCE NUMBER2LATITUDE3LONGITUDE4LOCATION TYPEDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 13Version 2.2 May 2020
File NameDataFieldNo.Data Field Name11. dp perp wellbore pending yyyymmddhhmmss.txt1LOCATION TOWNSHIP2LOCATION LOT3LOCATION PORCION4LOCATION SHARE5LOCATION LEAGUE6LOCATION LABOR7LOCATION TRACT8PERP ID9MODIFIED BY10SECTION LINE1 DISTANCE11SECTION LINE1 DIRECTION12MODIFIED DT13SECTION14SECTION LINE2 DISTANCE15ABSTRACT NUMBER16SECTION LINE2 DIRECTION17SURVEY NAME18LOCATION COMMENTS19BLOCK NUMBER20PERP TYPE CODE21WELLBORE PROFILE ID22PERMITTED FIELD ID23COUNTY CODE24PERP LOC CODE25WELLBORE ID26MEASURE LINE TYPE CODE27OPERATOR NAME28OPERATOR NUMBER29OPERATOR PHONE30DISTRICTDrilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 14Version 2.2 May 2020
5.0 Data DictionaryThis data dictionary provides a description of all the data fields relevant to a drillingpermit application record. The Submitted Drilling Permits Pending Approval filecontains a “snapshot” of the data for records that were in a pending approval statusat the time the file was created.The specific data fields that are populated, and the values in those data fields, aredependent on factors such as the purpose of filing, the type of wellbore profile, orwhether the filer has requested one or more statewide rule exceptions. Also, datafield values may be populated or modified as the application moves fromsubmission through the review process, and on to final approval. Several data fieldswill not contain a value until after the well is drilled, and the drilling permit isclosed.Data fields in this section are listed in alphabetical order.Data Field NameABSTRACT NUMBERData Field DescriptionAssigned number as it is recorded with theTexas General Land Office for the surveyedproperty in which the well is located.The term ‘abstract’ refers to an original landsurvey describing an area transferred from thepublic domain by either the Republic of Texas orthe State of Texas. Each survey so recorded isassigned an abstract number, which is uniquewithin the county in which the survey falls.Because Texas has never performed a uniformstatewide land survey, these original surveyscalled “Patent Surveys” constitute the State’sOfficial Land Survey System.Not every drilling permit application record willcontain an abstract number.In the ‘dp perp pending’ files, abstract numberdenotes the abstract associated with thewellbore surface hole location.In the ‘dp perp field pending’ file, abstractnumber denotes the abstract associated withthe bottom hole location for a directionalwellbore profile, or the terminus location for ahorizontal wellbore profile.ADDRESS LINE1Operator mailing address line one.Drilling Permits (W-1)Drilling Permits Pending Approval Plus Latitudes and LongitudesPage 15Version 2.2 May 2020
Data Field NameData Field DescriptionADDRESS LINE2Operator mailing address line two.ALLOCATION FLAGFor a horizontal wellbore profile, a value of ‘Y’indicates that the well will be completed as anallocation well. The default value is blank.This data field was added to the file in April2013.API LINKED FLAGThis indicator is used by RRC internal systems.API SEQUENCE NUMBERA permanent unique identifier assigned to awellbore. It consists of 10 digits; the first twoare the state code, the next 3 digits are thecounty code, and the last 5 digits are assignedby the RRC, and are unique with
Drilling Permits (W-1) Page 1 Drilling Permits Pending Approval Plus Latitudes and Longitudes Version 2.2 May 2020 1.0 Purpose This document provides the file formats and data dictionary for submitted drilling permit applications (Form W-1 Application for Permit to Drill, Recomplete or Re-enter). The files only contain applications that are .
Fundamentals of drilling operations; the drilling rig equipment and their functions; drilling terminologies; drilling processes; planning of drilling operations; logistics, role and responsibilities of service companies including drilling contractor; the functions of drilling fluid, casing, cementing and components of a drill string; the different
iv LIST OF TABLES Page Table 1 - State multi-trip permits 9 Table 2 - Connecticut permits issued 10 Table 3 - Delaware permits issused 12 Table 4 - New York permits issued 14 Table 5 - Pennsylvania permits issued 18 Table 6 - Maryland permits issued 20 Table 7 - New Jersey permits issued 21 Table 8 - Virginia permits issued 23 Table 9 - State routing requirements 25
Casing drilling, otherwise known as drilling with casing (DwC) or casing while drilling (CwD) is an alternative drilling technique to the conventional drilling method. Casing drilling involves the simultaneous drilling and casing of well with a (active-standard) casing string. It is mandatory to note that casing is the same grade and weight as in
Drilling Permits (W-1) Page 1 Drilling Permits Pending Approval Plus Latitudes and Longitudes Version 2.2 May 2020 1.0 Purpose This document provides the file formats and data dictionary for submitted drilling permit applications (Form W-1 Application for Permit to Drill, Recomplete or Re-enter). The files only contain applications that are .
Drilling Productivity Report (DPR), September 2020. The drilling process is increasingly managed usingmass production operations , such as pad drilling, cube drilling, and multilateral drilling, to achieve higher cost efficiency in both the physical and contractual management of heavy-duty and fully automated drilling rigs.
Lifting Capacity of Drilling Fluids, Pressure losses in the Circulating System and ECD Functions of the Drilling Fluids, Impact of Hydraulic on the Drilling Optimization Parameters affecting on the Drilling Penetrations Drilling Fluid Properties, Functions of Drilling Fluid Mud Properties and Problems related to Mud Properties
Geothermal Well Drilling, the differences between Geothermal Drilling and Oil and Gas Drilling. The challenges of drilling and producing hot, volcanic resources from fractured formations. By Louis E. Capuano, Jr. November 21, 2014
development teams. In Agile Product Management with Scrum, you’ll see how a product owner differs from a traditional product manager having a greater level of responsibility for the success of the product. The book clearly outlines and contrasts the different behav-iors between the traditional and the agile role.
