Business Intelligence Tools / Geology & Geoscience

Let’s QC 1000 well logs in Spotfire

Got a question today about the Well Log visualization that I thought I would work through here. We haven’t done much write up on the tool so I thought I would take a moment and sketch out this use case.

Let’s say that you have a repository of LAS files that you need to look through.

Now to get these into Spotfire, we’re not going to add these one by one as data tables. That would be a huge mess and problematic to load so much data. What we will do instead is load them on-demand. To do this, we need to create a specific architecture. Here are the steps outlined:

  1. Create list of LAS files
  2. Import LAS path list into Spotfire
  3. Setup LAS OnDemand
  4. Highlight rows in the original list table.
  5. Ensure the well logs came in.
  6. Setup a Well Log visualization that is trellised on Well Name.

Alright here we go!

Create the list of LAS Files

The LAS Loader needs two columns:  a Filename (really the whole Filepath) and an Identifier.  We will show you how to build a table of LAS files with those columns in the next sections.

Filepath (with Filename)

Alright, first we need a list of the Filepaths in a data table. I’ll show you folks a quick shortcut.

Open PowerShell from the Start Menu (or search bar) and navigate to the directory which contains your using the following:

  • cd C:\Users\lucaswood1\lasfiles\
    • Make sure to replace the directory with yours.  You can copy and paste the directory from the file window into the line above.
    • Make sure the file location does not have blanks or odd symbols like dashes
  • (Get-ChildItem * -Recurse).fullname
    • Don’t replace anything in the above line–exact copy and paste

You should get something like this:

Click and drag the highlight over the entire list, copy it, and paste that into Excel.

Identifier

The LAS Loader can use any identifier.  You could simply use a row ID or attach an API to each well.  But, we’ll show you how to access the Well Name used within the name of the LAS file.

Still in the Powershell, you can use the command, ls, to isolate the Names from the path.  Other columns like Mode, LastWriteTime, and Length will be next to the Names.  Don’t worry, copy and paste all of it into a different area in Excel than you did before.

Go to Data > Text to Columns > choose Delimited > Next > choose Space as a delimiter > Next.

Now, your Name should be its own column.  Let’s go one step further and remove the .las extension.

In the column next to your Names, you can use the Excel Formula =SUBSTITUTE(B2,”.las”,””) to lop off the .las.  Just make sure the B2 corresponds to the right column/cell.  Now, you have a unique identifier Well Name.

Cut and paste the Well Names next to your Filepath.  Your LAS table with the two columns should look something like this:

Select the columns and Ctrl-c to copy them to your clipboard.

Import LAS path list into Spotfire

Alright, now that we have our table, let’s begin with the end in mind (courtesy Stephen Covey) by reviewing what we’re going to make.

Normally, in Spotfire we’d go to Insert > Rows but that will be quite a bit of button work for our 400 wells.  We will use the list of LAS files that we just made in Excel to choose which wells we will include as we build the above table in Spotfire.  The Well Log extension uses an R Script Transform behind the scenes:  you don’t have to worry about that part.

So, now that we know where we’re going, let’s get there.

  1. First, you need to add the LAS list data table you just created to dxp by going to File > Add Data Tables > Add > Clipboard.  Remember, we copied the two columns we need to our clipboard.
  2. You now have the list ready to select.  You can choose all of the wells or any subset to load on demand.  To do so, open a table or another visualization and mark the wells to import.

Now, you’re ready to use the LAS tool!  We’ll show you how in the next section.

Setup LAS OnDemand

Access the LAS OnDemand dialog box by going to Tools > LAS > Load dynamic LAS files:

Let’s step through our choices.

  • Data table – this is the LAS file list data table we just imported.
  • Filename – this will be the full path of the file.  In our Excel sheet, we called it Filepath.
  • Identifier – this can be any unique ID.  We used Well Name.
  • Marking – this is the marking layer that you used to mark the files.
  • Result table – the LAS OnDemand loader will build your table with this name.
  • Automatic update – use this to toggle automatic updates when the marking changes.

That’s it! Spotfire will create a table for you ready to use in the Well Log extension. Just remember to Trellis by the Well Name. Let me know if you have any questions in the comments below.

1 thought on “Let’s QC 1000 well logs in Spotfire

  1. David Reply

    New to spotfire, have tinkered with R and would love to explore this approach to viewing LAS.. There isn’t a company I have ever worked for that doesn’t have a huge collection of LAS files they paid big $ for and then squirrled away in some absurd folder structure rendering them mostly useless.
    But I digress…
    You lose me on the R transform you reference above….?
    It’s early… am I missing something obvious? what is this doing?
    Regards

Leave a Reply

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