ESRI UC 2017

Python scripts discussed at the ESRI user conference during the summer of 2017. The presentation can be found here.

Usage

These python scripts show how to:

Create 3D feature class laterals in geodatabase from directional surveys
Create point along lateral based on measure (m) value
Create area of interest tool (AOI) in ArcGIS Pro

Files

Details for each script and file

directional_survey_to_lateral.py

Python 2.x

This script uses arcpy to loop through a folder of directional surveys. These directional surveys are in text format of m, z, NS, EW with the start location being 0, 0, 0, 0. The start location for each lateral comes from a well point feature class. The resulting lateral is then added to a x, y, z, and m enabled line feature class in a geodatabase. An example text file has been uploaded here. The name of the text file is a unique identifier for the well (in this case an API) and used to find the well starting location. Features should be projected in a coordinate system matching the directional survey units.

create_perfs.py

Python 2.x

This script adds a point along an m and z enabled line feature class. This point is based on the measure value stored in the m variable. The two points surrounding the measure value are extracted from the line feature class and used to calculate the resulting point. This script assumes that the start of the line is the surface hole location. Each feature class should be projected and have the same unit of measurement.

create_AOI.py and reset_AOI.py

Python 3.x

These scripts are used in ArcGIS Pro to create an area of interest tool (AOI). They should be used as guidelines and are not written for easy implementation. They are extremely dependent on the structure of your map and data. This is built around an ArcGIS Pro map with oil & gas data in a 2D map and local 3D Scene.

The create_AOI python script is built to run in the ArcGIS Pro as a tool. After the user selects one or more laterals, the script can be run. It then goes and grabs the unique ID's(in this case BHLID) for each lateral.

These BHLID's are passed into a definition query to layers like wells and laterals where the data is stored in the attribute tables. Leases are selected by running an intersect between the selected laterals and the multipatch leases. Multipatch leases must be used because 3D intersect does not work on extruded features. All 3D leases shown in pictures are extruded.

After running this tool, you end up with the screen shot below. Just the wells, laterls, leases, perfs etc. are shown.

In order to reset the map, reset_AOI.py is used. This goes to every layer and resets the definition query to its preset in order to return the map to its original state.