Business Intelligence Tools / Reservoir Engineering

Creating Well Sticks using the Spotfire Map Visualization

In this blog, I’m going to show you how to create well sticks as a layer in your map chart visualization. The only table that you will need are your well headers that has both surface and bottom hole locations.

First, import your well header table into Spotfire:

  1. Create a location table by cloning your original table.
  2. Create a transformation where I exclude unnecessary columns from the well sticks table.
  3. Now we need to duplicate this table so that we can establish the connections between surface and bottom hole coordinates. First Insert > Rows, then reselect the Well Header again with columns excluded.
  4. Match all possible columns.
  5. Then this is the most important step, we need to differentiate between the surface data and the bottom hole data.
  6. Now I’ve got a column that shows surface and bottom holes as different rows.
  7. Create a new Map visualization and add the new Well Sticks table as a marker layer.
  8. Almost there! Now you need to set up your calculated expression in the positioning tab of the layer.
    EDIT: 5/7/2019

  9. Remove the Size column and set marker size to 0.
  10. Open the Line Connection Tab and connect the markers using UWI/API.

All done! You can add another layer on top of this that just has well headers for you to select. These can be pie charts, markers, or features; configure any way you like.

5 thoughts on “Creating Well Sticks using the Spotfire Map Visualization

  1. Pingback: How to Draw Wellbore Laterals in Spotfire

  2. Kirsten Smith Reply

    This is great, and will be helpful for a lot of customers. I was working with one of our users, and he was getting stuck on Step 8, can I suggest some clarifications?

    First, it might be helpful to specify that the custom expressions need to be created under ‘Coordinate columns’ in the Positioning tab. Since the ‘Geocoding’ section is at the top, most people don’t think to scroll down.

    Second, I think there’s an issue with the expression you have listed. Pretty sure it should be:

    If([CoordinateGroup]=”Surface”, [Surface_Longitude], [Bottom_Longitude]) for X-column
    If([CoordinateGroup]=”Surface”, [Surface_Latitude], [Bottom_Latitude]) for Y-column

  3. Mauro Lo Cascio Reply

    Hi this seems like a nice tool but I am having issues when having both vertical and horizontal wells. Most of my data only has surface hole locations (old data that assumes vertical wellbores) and the visualization does not seem to work with a parse table. Any suggestions? I tried the following which didn’t give me any errors but the map didn’t work:

    If([CoordinateGroup]=”Bottom” and [BH Latitude] Is Not Null,[Surface Latitude],[BH Latitude])
    If(([CoordinateGroup]=”Bottom”) and ([BH Longitude] Is Not Null),[Surface Longitude],[BH Longitude])

    Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *