An Alternative Alteration Plot

Sometimes geologists cross paths with databases.  And you never know what you’re going to get when this happens – fireworks, explosions!?

As a geologist, my world includes plotting data in Target. For example, I may want to plot a strip log or section with some key alteration types – a plot for CPY, for PY and for SER.  But what if the data was logged in fields called Alt1, Alt2, Alt3, containing alteration codes like CPY, PY, and SER….? 

 

Likewise, Alt_Int needs to be CPY_Intensity when Alt1, Alt2 or Alt3 could be CPY.

It doesn’t take a database guru to convert results this way.  I can use the Math Expression tool to create these new fields, essentially ‘pivoting’ the data from Alt1 into fields for each type of alteration.

I can fill in the SER field with the alteration intensity using a simple expression: C0 = C1=="SER"?C2:""

 

Expand this to combine sericite alteration from all Alteration fields:
SER = Alt1=="SER"?Alt1_Int:(Alt2=="SER"?Alt2_Int:"") And voila!

 

Then, combining plotting options with Alteration Intensity or Percentage can make for some useful data visualization techniques – Go from a plot of Alt1 to a plot of alteration by intensity.

Sometimes geologists cross paths with databases.  And you never know what you’re going to get when this happens – fireworks, explosions!?

As a geologist, my world includes plotting data in Target. For example, I may want to plot a strip log or section with some key alteration types – a plot for CPY, for PY and for SER.  But what if the data was logged in fields called Alt1, Alt2, Alt3, containing alteration codes like CPY, PY, and SER….? 

 

Likewise, Alt_Int needs to be CPY_Intensity when Alt1, Alt2 or Alt3 could be CPY.

It doesn’t take a database guru to convert results this way.  I can use the Math Expression tool to create these new fields, essentially ‘pivoting’ the data from Alt1 into fields for each type of alteration.

I can fill in the SER field with the alteration intensity using a simple expression: C0 = C1=="SER"?C2:""

 

Expand this to combine sericite alteration from all Alteration fields:
SER = Alt1=="SER"?Alt1_Int:(Alt2=="SER"?Alt2_Int:"") And voila!

 

Then, combining plotting options with Alteration Intensity or Percentage can make for some useful data visualization techniques – Go from a plot of Alt1 to a plot of alteration by intensity.