ArcMap Oil & Gas Help

I. Installation

Follow through the ArcGIS guide to install the necessary components. You will need access to the License File and the License Manager depending upon the type of license you will be using. The installation will primarily be from the ArcGIS desktop DVD.
I recommend that you decide where you want to keep your project files and setup subdirectories, such as the license file, from there. For my use the main files are on the server and the backups are on my c:\ drive.
II. Creating Projects & Feature Classes

Create a GeoDataBase in ArcCatalog

To create a new layer you must first create a Personal or File geodatabase. Note that Personal GeoDataBase is an Access databases. For the databases that will hold Well Header data I use a Personal GeoDataBase and for just layers I use a File GeoDataBase.
Create a folder under the desired Project called MyData. Open ArcCatalog, right click on MyData then NEW, FILE GEODATABASE. In the pane to the far right rename the database as desired keeping the .mdb or .gdb extension.
Ex: MyProject.mdb or MyProject.gdb
Next you must Import the polygon feature class to give the new database a spatial relationship (see also Setting a Projection below). Rick Click on the new database.mdb or gdb file then click: IMPORT, FEATURE CLASS (single). Under INPUT FEATURES click the folder button to the right and navigate to the TRS.shp file, select it and click on ADD. Under OUTPUT FEATURE CLASS type in one of the new Layer names. In the FIELD MAP(optional) text box remove all of the fields. Click OK. For TR and TRS data see To Set a Projection in ArcCatalog before Adding the data to a Project.
Note: For Well Header data imported from Oil Law Records as an Access Database you may need to first convert the Well Header table to a Shape file. Then create a Personal (Access) Database in ArcCatalog and then create the new feature class as described below as Point Features. In Arc Catalog right click on the new Feature Class and select LOAD, LOAD DATA. Clivk NEXT then under Input Data Browse and find the shape file that has the new well header data in it, clock OPEN, then ADD. Click NEXT until you get to the windw that has the radio button LOAD ALL OF THE SOURCE DATA and click NEXT. Hopefully the data will load. There should be a progress bar in the lower center if the data is loading.
To APPEND data in one Access database table to another Access database table, first the two database tables must have exactly the same Schema. Fields need to be in the same order and have the same data type and size. Second, in ArcCatalog in the ArcToolbox pain use DATA MANAGEMENT TOOLS, GENERAL, APPEND. Browse for the INPUT DATASET which is a table in the source database and browse for the TARGET DATASET which is a table in the target database. Select OK. If any errors are reported the Append did not work.
Create a New Layer Using a Feature Class

In the Arc Catalog left hand pane right click on the database.mdb or gdb file and select: NEW, FEATURE CLASS. Under NAME enter additional layer names. There may be as many as you like. Under TYPE pick the desired type such as Point, Polygon, etc.
Click on NEXT and click on IMPORT. Select TRS.shp, ADD, NEXT, NEXT. Under FIELD NAME you may add a new field by typing.
Note: For layers to which lines will de Digitized, there must be Fields for X & Y. I set their data types as Long Integers
ex: Date_Entered
Then under DATA TYPE click in the box and a dropdown list appears and select DATE.
Click on FINISH. Once the Geodatabase has been created you may add fields. Expand the database.mdb or gdb folder and right click on Leasehold_Text, PROPERTIES, on the FIELDS tab under FIELD NAME type in a new field name such as ‘Leasehold” and under DATA TYPE select TEXT. APPLY, OK.
For Polygon layers I add a Field called ‘Switch’. Then under SYMBOLOGY, CAREGORIES, UNIQUE VALUES, set the VALUE FIELD to ‘Switch’, create a Value for ‘On’ and set the Properties as desired. When you create a polygon on a map set the ‘Switch’ field to ‘On’ if you want the symbol to display or ‘Off’ to not. Also add a Field called 'Label' to set the display name of the Polygon (See SYMBOLOGY below).
Note: If you control the Label by using an Expression, the Label may also be controlled by the value of the 'Label' field (see LABELS & ANNOTATION).
III. To Set a Projection in ArcCatalog

In ArcCatalog from the left hand Tree View select a layer. Click on the FAVORITES tab in the middle panel. The ArcToolbox items should be displayed. If not click on the RED TOOLBOX icon.
In the ArcToolbox panel expand DATA MANAGEMENT TOOLS, expand PROJECTIONS AND TRANSFORMATIONS, double click on DEFINE PROJECTION
In the DEFINE PROJECTION window under INPUT DATASET or FEATURE CLASS select the shape file under the layer folder, ADD.
Under COORDINATE SYSTEM click on the button to the right which will open the SPATIAL REFERENCE PROPERTIES window.
* For the first shape file, click on the SELECT button, then double click on PROJECTED COORDINATE SYSTEMS, STATE PLANE, NAD 1983 (FEET), then select
“NAD 1983 STATEPLANE OKLAHOMA NORTH FIPS 3501 (FEET).prj”
ADD, OK
(* For the first shape file, click on the SELECT button, then double click on GEOGRAPHIC COORDINATE SYSTEM, NORTH AMERICA, then select either
“North American Datum 1927.prj” or
“North American Datum 1983.prj” if recent data from Oil law Records
ADD, OK)
Repeat for the remaining shape files:
When you get to the SPATIAL REFERENCE PROPERTIES window for each remaining file, click on the IMPORT button and select the first shape file, ADD, OK
Adding Feature Class Layers to ArcMap

Make sure ArcCatalog is closed and open ArcMap. Select the desired Project and click on the yellow backed + icon to add data. Under the MyData folder select the new database.mdb or gdb file and click ADD. In the next window select the desired item for example LEASEHOLD_TEXT, ADD. This will add the new layer Leasehold_Text to the Project.
Version 10 – Adding a layer to a v10 Project does not add it to the CREATE FEATURES window. In ArcMap, Right Click on the layer to Edit, select EDIT FEATURES, START EDITING. This opens the CREATE FEATURES window. Click on the second icon from left at the top ORGANIZING TEMPLATES. A new window will open, select the new layer under LAYERS, click on NEW TEMPLATE from the menu at the top and then click FINISH. The new layer should now be present in the CREATE FEATURES window.
For a Text Layer:
Right Click on the new Layer name and select PROPERTIES, LABELS. Place a check next to LABEL FEATURES IN THIS LAYER and in the TEXT STRING set the LABEL FIELD to LEASEHOLD. Set the Font, point size, etc.
Under SCALE RANGE set it to the same setting as the section numbers for example
“Don’t Show Labels when zoomed out beyond - 1:?”, when using feet.
OK
For the TR layers I used 1:380,000, Font 48
For the TRS layers 1:400,000, Font 18
For the TR_Reg layer, Font 10, on the PROPERTIES, DISPLAY tab make sure that “Scale Symbols when reference scale is set” is UNCHECKED
Double click on the symbol just below the layer name to open the Symbol Selector. Set FILL COLOR to NO FILL, OUTLINE WIDTH to 0, OK
For a Polygon Layer
Double click on the symbol just below the layer name to open the Symbol Selector. Set FILL COLOR, OUTLINE WIDTH, and OUTLINE COLOR, OK for Polygon layers I add a Field called ‘Switch’. Then under SYMBOLOGY, CAREGORIES, UNIQUE VALUES, set the VALUE FIELD to ‘Switch’, create a Value for ‘On’ and set the Properties as desired. When you create a polygon on a map set the ‘Switch’ field to ‘On’ if you want the symbol to display or ‘Off’ to not.
All (Optional)
For all types of Layers, Right Click on the layer and SAVE AS LAYER FILE.
To EDIT ArcMap Feature Class Layer Data
Make sure Arc Catalog is closed and open ArcMap. Select the desired Project.
Version 10 - In ArcMap, Right Click on the layer to Edit, select EDIT FEATURES, START EDITING. In the CREATE FEATURES window select the item to be edited and then click on the EDIT TOOL from the EDITPR tool bar.
Click on EDITOR, START EDITING, and select the desired folder and OK.
The TASK is CREATE NEW FEATURE or MODIFY FEATURE, the TARGET is the desired layer. In the Tree View to the left, right click on the desired layer and select SELECTION, MAKE THIS THE ONLY SELECTABLE LAYER.
Text layer
Since the layer is referenced to a Section you must draw a polygon using the SKETCH tool which looks like a pencil that will be large enough to encompass the text. Draw the polygon by creating four corner vertices and double clicking on the fourth one to finish. Select the EDIT tool, which looks like an arrow pointing to the NNW, click on the polygon to select it, it will have a light blue border around it, then right click and select ATTRIBUTES. Under VALUE enter text for LEASEHOLD and DATE_ENTERED and then CLOSE the window. The text should appear on the layer. A selected polygon can be dragged around on the map as desired.
Polygon Layer
Select the EDIT tool, which looks like an arrow pointing to the NNW, double click on the polygon to activate the nodes. Move the nodes as desired.
All
When finished click EDITOR, SAVE EDITS, STOP EDITING, save your project.
IV. In ArcMap to Set the Data Frame Properties

Right Click on a map and select at the bottom DATA FRAME PROPERTIES. On the GENERAL tab set DISPLAY = FEET.
After the project is set up set the REFERENCE SCALE so that the object sizes change as the map scale changes. I used 1: 36,000 as an example.
V. Well Header Feature Class

Editing Well (Header)

In ArcMap, change editor to STARTING EDITTING and use the IDENTIFY tool click on the preferred well, which should in turn pull up the Well_Header information. Then right-click on the well name on the tree below and click SELECT (now the preferred well should automatically highlight). Click the ATTRIBUTES tool and another window will pop up allowing you to edit the Well_Header information. Now after you are through editing you can edit Well_Formation with out closing any windows. In order to edit the Well_Formation change the IDENTIFY tool to Well_Formation instead and of Well_Header and click on the formation in which you wish to edit. Right-click on that formation and click SELECT (you should see the formation pop up in the same window you were able to edit the Well_Header and now you should be able to edit the formations information).
For bulk updates to Well Header Layers see (Using DataSheets & ArcMap for Bulk (SQL) Updating) below.
Adding / Moving a Well (Header)
Version 10 - In ArcMap, Right Click on the layer to Edit, select EDIT FEATURES, START EDITING. Click on EDITOR, SNAPPING, SNAPPING WINDOW, for the layer containing the Township, Range and Section data, place a check next to VERTEX, close the Snapping window. In the CREATE FEATURES window select the new type of point to be used, place the new point by left clicking at a corner of the desired section. From the EDITOR Dropdown list select MOVE, enter the x and y values for the new well from the corner and click on ENTER. This should put the well at the desired spot. Save the Edits.
Version 9.3 - In ArcMap, Click on EDITOR, START EDITING, make sure the TARGET: layer is correct the one where the well p oints. Click on EDITOR, SNAPPING, for the layer containing the Township, Range and Section data, place a check next to VERTEX, close the Snapping window. Using the CREATE NEW FEATURE, SKETCH TOOL place a new point by left clicking at a corner of the desired section in most cases this will be the SW corner. A light blue circle will appear, this is the new point. From the EDITOR Dropdown list select MOVE, enter the x and y values for the new well from the corner and click on ENTER. This should put the well at the desired spot. Save the Edits.
Searching for a Well

To search a well base table, Right Click on the desired layer and select OPEN ATTRIBUTE TABLE. Choose the desired Field that you want to look in and Right Click on the Field Header and select SORT ASCENDING. Scroll down to the desired well and click on the left hand table border to select the well. Right Click on the left hand border and select ZOOM TO. This will zoom the map in to the desired well and show it selected.
If you have not already done so, you can start an editing session for this layer and when you click on the ATTRIBUTES icon the selected well’s data will be chosen. Each time you select a well in the Attributes of Layer table and then ZOOM TO it the Attributes table will change for editing.
Setting Well Symbols

In ArcMap, right click on the layer containing the well symbols, select PROPERTIES. Click on the SYMBOLOGY tab, CATAGORIES and select UNIQUE VALUES. Change the VALUE FIELD to Status or WellStatus and then click on ADD ALL VALUES just below. (Note 1)
All of the well categories should appear in the list box. Double Click on the first well symbol. Under MORE SYMBOLS select PETROLEUM and de-select ESRI. Click on the desired symbol, OK. Repeat for each symbol, OK. Note; Font Size used for basic symbols is 12, for the DEV symbol is 6.
When finished, right click on the Layer and select SAVE AS LAYER FILE. Place it under the correct Project main folder and call it:
WellSymbols.lyr
Note 1 - At this point the above described WellSymbols.lyr file is already available. Find it and copy it to the current project. Now on the SYMBOLOGY tab click on IMPORT.., browse for the WELLSYMBOLS.lyr, ARCGIS/Projects/WellsSymbols.lyr, then OK. Set the VALUE FIELD to Status, OK. If you are asked to add to the layer to the project says YES. If needed reset the DEFAULT(OTHER) to the normal oil & gas Location symbol.
Note 2 – For Deviated Wells, in the Area_WB feature class under SYMBOLOGY, add “DEV” as a symbol, use the petroleum “Location” symbol and set the size to 12 which will give you a smaller than normal symbol. This will be the Surface Location symbol.. To do this make the “Status” field = “DEV”.
Well Formation Labels, Symbols & Deviated Wells

For those formations that will be mapped, a copy of the Wellbase Feature Class will be made so that any changes made to the data in the Wellbase Feature Class will be reflected in the copies. There will need to be two copies of the Wellbase FC per formation, one for the Labels and one for the Symbology. The reason for this is that you will want to be able to move the label while not moving the well spot.
Create Copies of the Wellbase Feature Class

In the ArcMap Display Window on the left, right click on the Feature Class to be copied (Tinker_WB) select COPY. At the top of the Display Window right click on the LAYERS menu item and select PASTE LAYRES(s). On the new layer right click and select PROPERTIES, on the GENERAL tab change the LAYER NAME
Ex:
Tinker_Misener_L for labels
Tinker_Misener_S for symbols.
I set the four layers for the Misener in the following order from top to bottom.
Tinker_Wb
Tinker_Dev_Wells
Tinker_Misener_L
Tinker_Misener_S
VI. Setting Labels & Symbols on Feature Class Formation Layers

Labels & Annotation

Right click on the desired layer and select PROPERTIES, Symbology tab. Click on REMOVE ALL. Double click on ALL OTHER VALUES and set no color fill and size = 0.1., OK, APPLY.
On the LABELS tab. Place a check next to “Label features in this layer”, for METHOD use “Label all the features the same way”. Click on EXPRESSION and place a check next to ADVANCED. Click on LOAD and select Misener_L.lxp (see below) . You can modify the Fields at this time if needed and test the code by clicking on VERIFY. If good click OK, APPLY, OK. Set the Font to Arial and size to 5. Set SCALE RANGE to OUT BEYOND = 1:400,000. Set PLACEMENT PROPERTIES as desired. Note: For Subsea and Isopach datums make sure there is a check next to PLACE OVERLAPPING LABELS so that these items will post when close to other labels such as those for the T&R.
Note: Due to the formulas involved, Labels for wells that do not have an Elevation value will often not post to the map, even the Remarks.
Once everything has been set and you are happy, right click on the layer and select CONVERT LABELS TO ANNOTATION, select IN A DATABASE, CONVERT.
To edit annotation stored in a geodatabase you must first start an edit session. On the Editor toolbar, click EDITOR then STAT EDITING. Select the layer or layers you would like to edit from the Start Editing window. After starting the edit session, use the editing tools in ArcMap, including tools on the Editor toolbar, Advanced Editing toolbar, and Draw toolbar (to create new annotation). Once editing is complete, click EDITOR then STOP EDITING. Click YES when asked if you want to save your edits.
For bulk updates to WellHeader or Annotation Layers see (Using DataSheets & ArcMap for Bulk (SQL) Updating) below.
Symbology

On the SYMBOLOGY tab, expand CATEGORIES and select MATCH TO SYMBOLS IN A STYLE, set the VALUE FIELD to “formation_Status”. In the “Match to symbols in Style” dropdown list, click on ADD VALUES, under NEW Value enter N then ADD TO LIST and repeat for P & S.
Back in the Dropdown List double click on the N and set the COLOR to No Color and the SIZE to 0.1, OK.
Double Click on the P and click on PROPERTIES. Set the TYPE to “Simple Marker Symbol”, the Color to a light blue, check USE OUTLINE and set Outline Color to dark blue, set SIZE to 16. Click on the MASK tab and select HALO.
Double Click on the S and click on PROPERTIES. Set the TYPE to “Character Marker Symbol”, there will be two Layers. For FONT use “ESRI Default Marker” and for SUBSET use “Basic Latin”. The top layer is the triangle on the top row to the far right. Set the Color to a dark blue and the set SIZE to 28. The bottom layer is the triangle on the top row fourth from the left. Set the Color to a light blue and the set SIZE to 28.
To make a symbol that will represent production from two different zones, set the TYPE to “Character Marker Symbol”, there will be two Layers. The top layer is a color filled circle with one Color and the bottom layer is a color filled circle of a different Color. The Top layer’s circle size is 16 and the bottom layer is 26.
Deviated Wells

(See Setting Well Symbols – Note 2 above)
As discussed above, Deviated Wells are placed in a separate Line Feature class. Create the feature class in ArcCatalog and add it to the project in ArcMap.
To draw the well path click on EDITOR and go through the process to edit the File Geodatabase and set the TARGET to “Area_Dev_Wells”. Make it the only selectable layer and set the SNAPPING such that “Area_WB” is set for VERTEX and “Area_Dev_Wells” is set for END. Set TASK to “Create New Feature” and hover the cursor over the surface location of the desired well. Right click and then select SNAP TO FEATURE and select VERTEX. Right click again and select MOVE. Enter the x and y values and click ENTER. A red square will appear at the new point, put the cursor back over the surface location and right click, select SNAP TO FEATURE, VERTEX, click F2 on the keyboard to finish the edit. You will now have a new segment in blue. Click EDITOR, SAVE EDITS.
To add another segment, go to the end point of the current (last) segment and right click and then select SNAP TO FEATURE and select END POINT. Right click again and select “MOVE”, enter the x and y values and click ENTER (see Note 3 below). A red square will appear at the new point, put the cursor back over the segment end point, right click, select SNAP TO FEATURE, END POINT and then F2. If you switch the TASK to “Modify Feature”, select the line segments and click on the ATTRIBUTES icon, in the ATTRIBUTES window you will see a listing of the line segments for that well.
To place a well symbol at the Bottom Hole Location, go to the Area_WB layer and add a new point at the end of the well path line. The only Attributes I plan on setting are for Well_Id, Status and whichever “Formation_Status” fields desired. Remember that for Deviated Wells on the “Area_Wb” layer the “Formation_Status” Fields should be empty or Null and the “Status” field should be “DEV”.
Note 3 - If you have a Drilling or Directional Survey, the x and y values to be used will come from that survey. Remember that for x values, positive are to the East and negative values are to the West. For y values, positive are to the North and negative are to the South. The First line segment from the surface location will use the x/y values directly from the report. Subsequent line segments will use incremental values from the last point used to the end point of the new segment. It seems to me that vertex should be at least 150-300’ apart. It may also be worthwhile to have a vertex at measured depth value of a Formation Top that is going to be mapped. This would allow you an easy method to place a well symbol at this point by Snapping to that vertex.
Optional Method for BH Location & Symbol

On the SYMBOLOGY tab, expand CATEGORIES and select MATCH TO SYMBOLS IN A STYLE, set the VALUE FIELD to “Symbol”. In the “Match to symbols in Style” dropdown list, click on IMPORT, browse to the file “Dev_Well_Symbols.lyr” and click on ADD (see below on how to build this layer). For the last segment which will be the one for the Bottom Hole location, set the SYMBOL field to one of the options listed below the layer name in the display window. Then Save and end the Editing session. You will see the symbol near the end of the segment path. At this point I cannot get the symbol at the very end of the segment as I would like.
Creating the “Dev_Well_Symbols.lyr” Layer

On the SYMBOLOGY tab, expand CATEGORIES and select MATCH TO SYMBOLS IN A STYLE, set the VALUE FIELD to “Symbol”. In the “Match to symbols in Style” dropdown list, click on ADD VALUES, under NEW Value enter the desired text then ADD TO LIST and repeat for as many as desired.
Back in the Dropdown List double click on a value. Under CATEGORY select ARROWEND and select the ARROW at START (in my mind this is actually the end of the line segment but as you might already know the segments are actually drawn from the end back to the start). Click on PROPERTIES. On the CARTOGRAPHIC LINE tab set COLOR and SIZE to 1.0. Click on the LINE PROPERTIES tab click on PROPERTIES, SYMBOL to select a symbol and click on the radio button for KEEP SYMBOL AT FIXED ANGLE TO PAGE. OK your way back out until you see APPLY and click on it. Then work on the next value. When completely finished, in the display window right click on the layer and select SAVE AS LAYER FILE, browse to or enter “Dev_Well_Symbols.lyr” and SAVE.

Misener_S.lxp
Function FindLabel ( [Misener_Status])
if [Misener_Status] = "P" then
findlabel = " "
else
if [Misener_Status] ="S" then
findlabel = ""
end if
end if
end function
Misener.lxp
Function FindLabel ( [Misener_Status], [Base_Wdfd_MD] , [Base_Wdfd_TVD] , [Ground_Elev] , [Misener_Remarks] )
if [Base_Wdfd_TVD] =0 then
[Base_Wdfd_TVD] = [Base_Wdfd_MD]
end if
dim xsubsea if [Ground_Elev] =0 then
if [Misener_Status] = "P" then
findlabel = "" & [Misener_Remarks] &""
else
if [Misener_Status] ="S" then
findlabel = "" & [Misener_Remarks] &""
end if
end if
else
if [Misener_Status] = "P" then
findlabel = "" & xsubsea & vbnewline & [Misener_Remarks] &""
else
if [Misener_Status] ="S" then
findlabel = "" & xsubsea & vbnewline & [Misener_Remarks] &""
end if
end if
end if
end function

VII. Shape Files

To Edit Labels on a Shape File Layer

In ArcMap from the Tree View of Layers, right click on the desired layer and select PROPERTIES. The Layer Property Window will open. Select the LABEL tab.
Make sure there is a check next to “Label Features in this Layer”
If the items on the map are polygons and not text set the
TEXT STRING LABEL FIELD = TEXT, OK
Set the TEXT SYMBOL properties as desired.
If there are polygons on the map where they are not wanted, in the tree view double click on the symbol below the desired layer name. The SYMBOLE SELECTOR window will open. Set FILL COLOR = NO COLOR, set OUTLINE WIDTH = 0. Set OUTLINE COLOR if desired.
LABEL FIELD – Set as desired. If the label needs to be of more than one field at a time such as for Township & Range see Expression.
EXPRESSION – To create an expression of what is to be labeled click on the EXPRESSION button. Place a check next to ADVANCED. Create a Function such as:
Function FindLabel ( [TOWNSHIP_N] , [TOWNSHIP_D] , [RANGE_NUM] , [RANGE_DIR] )
FindLabel =[TOWNSHIP_N] & [TOWNSHIP_D] &"/"& [RANGE_NUM] & [RANGE_DIR]
End Function
Note: Fields used within the Function must also be listed as an attribute. Copy and Paste this text into the expression window for labeling T&R.
SAVE the Expression if desired and the OK. Set the PLACEMENT PROPERTIES by clicking on the button and setting LABEL WEIGHT. I set the Township & Range to Medium and the Sections to High.
SCALE RANGE should be set at this time> I have found it best to use the settings on the GENERAL tab.
For basic T&R work I used:
TRS – Don’t Show Labels when zoomed out beyond - 1:250,000
TR – Don’t Show Labels when zoomed out beyond - 1:750,000
ANNOTATIONS:

By making the Labels Annotations, they become fixed and will not move around the map. RIGHT CLICK on the desired layer and select, CONVER LABELS TO ANNOTATIONS. Under STORE ANNOTATOON I have been using IN THE MAP Create New Classes
Set METHOD = “Define Classes of Features & Labels each class differently”
To Add a Class click on ADD, enter a name and OK
Select a Class and set its Properties
Click on SQL QUERY
Double Click on FONTSTYLE from the uppermost list and then single click on the = button and then in the lower textbox type 0 or any desired number.
Ex: "FontStyle" =0
Click OK
Repeat for each desired class
The values used such as 0, 1 etc will relate to the FONTSTYLE attribute on the items on the layer. To EDIT these items select a layer in the tree view, click on the EDIT TOOLBAR, it is the icon that has a pencil with four nodes connected by lines. From the EDITOR drop down list select START EDITING, set the SOURCE to the desired file, OK. Using the new cursor right click on an item on the map and select ATTRIBUTES. In the ATTRIBUTE window set FONTSTYLE to the desired number for the classes added above. Repeat for each map item that needs to be set. Then from the EDITOR drop down list select SAVE EDITS, STOP EDITING.
VIII. ArcMap – Contour Lines & Digitizing Contours

Create a New Line Feature Class Layer for Contours

In ArcCatalog in the left hand column find the Project. Right click on MyData, NEW, Personal GeoDataBase. In the Name column to the right rename the DB. Ex: Tinker_Prue.mdb
Back in the left hand column, right click on the new DB, NEW, FEATURTE CLASS. Name it and select LINE FEATURE, NEXT, IMPORT the Coordinate System, NEXT, NEXT, NEXT, add a Field called DATUM as a TEXT field, FINISH. Close ArcCatalog and in ArcMap add the Layer to the Project. For proper Halo usage, the layers should be ordered from top to bottom as: Wellbase_Formation_Label, Wellbase_Deviated_Wells, Formation_Symbols, Formation_ContourAnno and Formation_Contour.
A. Registering - Open ArcMap, select the layer where the data is to be placed (see CONTOUR SMOOTHING LAYER below). Start an EDITING session and pick the desired layer. Click on EDITOR again and then SNAPPING and turn off the snapping on all layers except for the appropriate TRS layer. V 9.3 - Set TASK to “Create New Feature” and TARGET to the desired layer. You will need to pick five points for reference. I suggest the four corners and one in the middle. I zoom in to view only the townships in which contours will be placed. V 10.0 – In the CREATE FEATURES window click on the line feature to be added then click on the TRACE tool from the EDITOR menu. V 9.3 - Click on the SKETCH TOOL which looks like a pencil and is the second icon to the right of the word EDITOR. This will give a blue circle with cross hairs. Place the cross hairs at a section or township corner, right click and select ABSOLUTE X,Y. Record these numbers for each of the five points. Right click on the desired layer and select SELECTION, MAKE THIS THE ONLY SELECTABLE LAYER. Click EDITOR, OPTIONS which opens the Editing Options window and click on the DIGITIZER tab. Using the puck on the digitizing table, click on the same five points on the paper map as you did on the screen, enter the x,y coordinates for each point. Click on APPLY and make sure that there is a CHECK next to ENABLED to start digitizing. You may SAVE these if desired. They will only be good if the map is in the exact same place, otherwise you will need to register the map again.
B. Digitizing – V 10.0 – In the CREATE FEATURES window click on the line feature to be added. V9.3 - In the EDITOR toolbar select the SKETCH TOOL. With the puck, trace along the desired contour clicking the 1 button to create vertices. At the end of the contour line press F2 to finish that line. Repeat the tracing process for each line. Click EDITOR, SAVE EDITS, EDITOE STOP EDITING and SAVE the project.
If the DIGITIZER tab does not appear use the following. Close any ArcGIS application. Go to a command prompt; START, PROGRAMS, ACCESSORIES. In the Command Prompt window:
Type: cd C:\Program Files\Common Files\ArcGIS\bin enter
Type: ESRIRegAsm.exe “C:\Program Files\ArcGIS\Desktop10.0\bin\digitzer.dll” enter
You should get a window telling you that the registration was successful. Restart ArcMap.
C. Projecting - After the contour lines have been digitized to the ArcMap layer, it is best to PROJECT the layer so that the Editing functions listed below will yield the best results. Open the Arc Toolbox and select DATA MANAGEMENT TOOLS, PROJECTION & TRANSFORMATIONS, FEATURE and double click on PROJECT. Select the Input Feature Class such as “Tinker_Hunton_Isopach”. The Output Feature Class will be named “Tinker_Hunton_Isopach_Projec”. Select the Output Coordinate System by clicking on the button at the end of the line and selecting; Projected Coordinate Systems, State Plane, NAD 1983 (Feet), NAD 1983 State Plane OK North FIPS 3501 (Feet).prj, ADD, APPLY, OK, OK. The routine will run and add the new layer to the LAYERS list. Use this layer for editing. To tell if a layer is projected or not, in the Layers List, right click on the layer and select Properties, Source. Under EXTENT, Layers that are not Projected will show extents with two digits in front of the decimal and be similar to Lat/Longs. Layers that are Projected their Extent numbers will usually have six digits in front of the decimal.
D. Editing Contours- Click on EDITOR, START EDITING and pick the desired layer. Set TASK to “Modify Feature” and TARGET to the desired layer. Click on the EDIT TOOL which looks like an arrow and is the first icon to the right of the word EDITOR. Double Click on a line, the line will turn blue and the vertex will be highlighted. To DELETE a vertex right click on the vertex and select DELETE VERTEX. To INSERT a vertex right click on the line at the desired point and select INSERT VERTEX , see Smoothing.
1) Extending/Merging Two Line Segments – While in Edit mode set to MODIFY FEATURE, click the first line segment (the portion to be extended) to select it. In the ADVANCED EDITING toolbar, click the EXTEND TOOL and then click on the end of the second line segment, they should connect. Select the combined line segments and click EDITOR, MERGE. As an alternative, you can draw a new line segment from the end point pf one line segment to the next. Then MERGE all three segments together.
2) Splitting a Line – In Edit mode select the line then click on the SPLIT tool on the ADVANCED EDITING tool bar and then click on the vertex where you want the Split.
3) Smoothing Contours - To smooth out a selected line, click on EDITOR, MORE EDITING TOOLS, ADVANCED EDITING, I docked this toolbar on the second row of tools at the top right. Click on the SMOOTH icon, third from the right, set the MAXIMUM ALLOWABLE OFFSET = (x when in FEET) or (.0002 when in Degrees) and click ENTER. X will be a value from 1-100 depending on the degree of smoothing. The smaller the number the more vertex are added. To smooth the entire map at one time, right click on the desired layer and select SELECTION, SELECT ALL. Use the SMMOTH icon as above. One trick is to smooth with a large number say 100-200, move the vertex to adjust the line segment then smooth again with a small number to give the line a better look.
4) Contour-Line Width – To set the line width make sure that each line has a DATUM value. Start editing, select a line, open the Attributes table and place a value in the DATUM field. In the LAYERS panel to the left, right click on the Line Layer and select SYMBOLOGY. Expand CATEGORIES and using UNIQUE VALUES set the VALUE FIELD to DATUM. For the symbol ALL OTHER VALUES set the line width to 1. Click on ADD VALUES and add 0 (zero) or any desired value and close that window. Double click on the desired value and set the line color and width. I set 0 to 2.
5) Contour labeling – Right Click on the layer, PROPERTIES, LABELS Tab, check LABEL FEATURES IN THIS LAYER, METHOD is LABEL ALL THE FEATURES THE SAME WAY, LABEL FIELD is DATUM, set the Font, size (10), etc as desired. Click on SYMBOL, PROPERTIES, on the MASK tab select HALO. Under PLACEMENT PROPERTIES, on the CONFLICT DETECTION tab check PLACE OVERLAPPING LABELS, on the PLACEMENT tab set ORIENTATION to PARALLEL, Position to ON THE LINE, LOCATION to AT BEST, select PLACE ONE LABEL PER FEATURE PART. Set SCALE RANGE if desired. When ready, right click on the contour layer and select CONVERT LABELS TO ANNOTATION. Place the new layer above the contour layer. Right click on the Anno layer, PROPERTIES, on the FIELDS tab under NAME deselect ELEMENT, OK. You will now be able to edit just that label’s ATTRIBUTES. Under ANNOTATION you can edit the symbol properties including the angle. Note that after changing an angle and clicking on APPLY you may have to refresh the screen view to see the changes. Addition al labe
ls may be placed by using COPY and PASTE.
E. Optional - Contour Smoothing Layer – In “ArcToolbox, Data Management Tools, Generalization” double click on SMOOTH LINE to open the SMOOTH LINE window. Select the feature to be smoothed. Under SMOOTHING ALGORITHM select BEZIER_INTERPOLATION, OK. This will create a new layer to replace the Line layer previously created.
F. Tracing a Contour for Color Fill
Version 10 - Create a Polygon layer and add a text Field called LABEL and set the fill color for the layer. Set the source layer upon which the object will be traced by RIGHT CLICKING on the layer and choosing SELECTION, MAKE THIS THE ONLY SELECTABLE LAYER. Snapping does not seem to affect Tracing in v10 but I would turn all snapping off just in case. On the source layer SELECT the line to be traced. In the CREATE FEATURES window, click on the Target layer/template where the new object will be located. Click on the TRACE TOOL from the SKETCH tool drop down list, position the cursor at the point to start tracing and hold down the Ctrl key. Move the cursor along the desired path, note that the trace line does not always appear right away even though you are actually tracing. When finished, Double Click at the end point and the shading should appear. Save the edits.
Version 9 - Create a Polygon layer and add a text Field called LABEL and set the fill color for the layer. Set the source layer upon which the object will be traced by RIGHT CLICKING on the layer and choosing SELECTION, MAKE THIS THE ONLY SELECTABLE LAYER. Start Editing for the Source layer and set the Snapping under EDITOR, SNAPPING to EDGE for only the source layer. Turn all other snapping off. On the source layer SELECT the line to be traced. In the TARGET dropdown list change to the Target layer (where the new object will be) and set for CREATE NEW FEATURE. Use the TRACE TOOL from the SKETCH tool drop down list and trace the desired contour. When finished, Double Click on the new line and the shading should appear. Save the edits
IX. Annotation Layers - DataSheets

If you have an ArcEditor or ArcInfo license, you can create and edit geodatabase annotation that is linked directly to the features being annotated. If you have an ArcView license, you can view feature-linked annotation but not create or edit it. Annotation Layers allow you to move your Labels to any spot on the map to avoid overlapping labels.
Converting labels to Annotation
1. In the table of contents, right-click the layer that you labeled and CLICK CONVERT LABELS TO ANNOTATION.
2. Storing annotation in a database is appropriate if you intend to use the annotation in future map documents. To store annotation in a geodatabase, or a feature dataset within a geodatabase, check the radial button next to In a database, then browse to the personal geodatabase where the annotation will be stored. If you do not have an existing personal geodatabase in which to store annotation, one must be created.
3. Once the annotation feature class has been set up, use the storage options on the left of the window to decide which labels will be used for annotation (all features in the layer, features displayed in the current extent only, or only the features that are currently selected).
4. To generate overlapping labels for all of your label classes, check the Generate overlapping labels for all layers check box.
5. To treat overlapping labels as unplaced labels, and have these labels added to the overflow labels window; also check the Display overlapping labels in the overflow window check box. Unplaced labels will be added to the overflow window only if you check both boxes mentioned in steps 10 and 11. Additionally, the Overflow window will only appear if there are unplaced labels after the conversion.
6. Click OK to perform the conversion.
Editing annotation stored in a geodatabase
1. To edit annotation stored in a geodatabase you must first start an edit session. On the Editor toolbar, click Editor then Start editing. Select the layer or layers you would like to edit from the Start Editing window. (Note: if there is only one layer in the map document, there is no need to select it. The edit session for that layer will start automatically once Start Editing is selected).
2. After starting the edit session, use the editing tools in ArcMap, including tools on the Editor toolbar, Advanced Editing toolbar, and Draw toolbar (to create new annotation).
3. Once editing is complete, click Editor then Stop editing. Click Yes when asked if you want to save your edits.
Using DataSheets & ArcMap for Bulk (SQL) Updating
DataSheets is a windows application designed primarily for Petroleum Geologists. It provides for a summary listing of all wells in a desired area, usually by Township & Range or Survey Area. Each file is an Access Database providing excellent search, grouping and sorting capabilities plus being easily portable. Data entry for each well provides for twenty-two geologic formation fields. Each formation field may be marked as a Producing,
Show or blank and there are six data fields for; measured depth, TVD and subsea datum plus three use customizable fields. One of the custom fields maybe used as a preset formula field. The usual Well Header type fields are also present
Filtering is available by any or all of the following: Operator, Lease, Formation and Production type. The Report is designed to print on Legal size paper, in Landscape and in color.
Datasheets now provides for the bulk Exporting and Importing of data from ArcMap Personal Databases using the SQL language. Datasheets will also update ArcMap Annotation Layers for those users having an ArcEditor license or above.
Datasheets is offered as Freeware.
From the main DataSheets window under TOOLS use:
IMPORT

This tool will allow you to add Well Records from an existing ArcMap Personal Database to a Datasheets database. The Target DB will be the current Datasheet that you have open. The Source DB will be the ArcMap Personal Database which is an Access database and will have an .mdb extension. BROWSE and select the Source DB from your ArcMap project. The Source Table will be the table in the Source DB that holds the Well Record data. For most ArcMap Personal Databases this will be the ‘WELL_HEADER’ table.
Click on RUN IMPORT and select the import type to run the process. For most ArcMap files this will be ARCMAP TO DS. A list of the ArcMap records that did not import will be shown. These are from the ‘Well_Id’ field. If you data will not import properly, contact PE Inc. It may be necessary to write a routine that fits your ArcMap Personal Database. A copy of one of your databases will need to be provided to PE Inc.
EXPORT

This tool will allow you to export data from the Formation Fields and some additional fields from an existing Datasheet database to an ArcMap Personal Database. The Source DB will be the current Datasheet that you have open. The Target DB will be the ArcMap Personal Database which is an Access database and will have an .mdb extension. BROWSE and select the Source DB from your ArcMap project. The Target Table will be the table in the Target DB that holds the Well Record data. For most ArcMap Personal Databases this will be the ‘WELL_HEADER’ table.
For this export to run, for each Datasheet Formation Field to be exported there must be four fields in the ArcMap Personal Database as follows:
DataSheet Formation Field: Formation_One

ArcMap Field Name: Formation_One_MD

Formation_One_TVD

Formation_One_Remarks

Formation_One_Status

Click on RUN EXPORT and select the export type to run the process. For most ArcMap files this will be DS TO ARCMAP. A list of the Datasheet records that did not export will be shown. These are from the ‘API’ field. If you data will not export properly, contact PE Inc. It may be necessary to write a routine that fits your ArcMap Personal Database. A copy of one of your databases will need to be provided to PE Inc.
Note: For each Datasheet Formation, text from the lines ‘Net’Gross’, ‘Envirn.’ and ‘Comts.’ are concatenated and copied to ‘Formation_One_Remarks’.
Refreshing an ArcMap Annotation Layer
From the EXPORT window select REFRESH ANNO. The Target DB and the Source Table fields should already be set. Click on the BROWSE button to select an ArcMap Project such as Oklahoma.mxd. The list box will then display all of the Anno layers available to that Project. If you do not see all of the available Anno Layers, you will need to Close and Open the ArcMap Project and then select that project again in DataSheets.
Select from the list the desired layer and the Target MXD and Target Anno Table fields will be displayed. From the dropdown menu select RUN REFRESH and choose the desired menu item. Only those Anno Layers pertaining to Well Header – Formation data and only the Well Header – Formation layers that are compatible with the Target Anno Table may be refreshed.
X. Printing in ArcMap

Paper Size

If necessary use START, SETTINGS, PRINTERS & FAXES to create a paper size for your printer (plotter). Select the desired printer ( HP-T1100ps PS# on AVALONSBS) and create a Custom paper size. We are currently using 42X60.
In ArcMap select FILE, PAGE and PRINT SETUP, set the Paper to 42X60 and set Portrait or Landscape as needed. Under MAP PAGE SIZE set Standard Sizes to Custom, then set Width, Height and Orientation as desired.
Make sure that there is no check next to Scale Map Elements proportionally to changes in Page Size. This will help in setting up the first print job. You may want this latter.
You may click on PROPERTIES in the upper right to create or select a paper size.
Selecting Area to Print

In DATA VIEW I like to select the area I want to print using the ZOOM IN tool. Then click on the LAYOUT VIEW button near the bottom left. Verify that the scale you want is set in the tool bar area at the top of the window. To resize the map click on the map and light blue borders should appear around the map. You can click and drag borders or right click on the map and select Properties, and the SIZE and POSITION tab. Under SIZE set Width and Height until you get what you want. I keep both AS PERCENTAGE and PRESERVE ASPECT RATIO unchecked. On the GENERAL tab make sure DISPLY is in FEET.
Adding Legends or Images

To add objects such as the Avalon Title block from the drop down menu at the very top of the window use INSEERT, PICTURE and select as desired. Once an image has been placed you may double click on it to access its Properties.
XI. Contacting PE Inc.

E-Mail: staff@peincvb.com
You can describe the problem you are having or leave a number and time where I can contact you. I will reply as soon as I can. A preview of this program is available at www.peincvb.com
PE Inc.
2955 S. Boston Place
Tulsa, OK 74114-5218
DISCLOSURE AGREEMENT
PE Inc. grants you a non-exclusive right to use the object version of the Program solely for your own use subject to this Agreement. You agree not to modify, reverse engineer, reverse assemble, decompile, or disassemble the Program in whole or part. Furthermore you agree to comply with all U.S. laws and regulations relating to export of the Program. The Program is proprietary and confidential to PE Inc. and shall not be used by any third party (with or without compensation) without the prior written consent of PE Inc. You agree not to remarket the program or divulge its contents to any third party, other than your subsidiaries or affiliates. This program is based upon PE Inc.’s industry knowledge; however, the accuracy or correctness of information within cannot and will not be guaranteed. The user agrees that he shall rely upon the information provided herein at his own risk. Further, that neither PE Inc. nor its employees shall be liable or responsible for any loss, cost, damages or expenses whatsoever incurred or sustained by the user resulting from any interpretations made herein.

DataSheet Formation Field:				Formation_One

ArcMap Field Name:				Formation_One_MD
				Formation_One_TVD
				Formation_One_Remarks
				Formation_One_Status