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.

3 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

Leave a Reply

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