Skip to main content
Department of Mines, Industry Regulation and Safety

The distribution of mafic intrusions, gabbro, norite and anorthosite in Western Australia, coloured by the likelihood of their presence in these areas.

Legend

Description

Mafic intrusion dominant

There is a high probability of observing mafic intrusions, gabbro, norite or anorthosite in these areas

Mafic intrusion minor

There is a lower probability of observing mafic intrusions, gabbro, norite or anorthosite in these areas

Terms

SQL query

Gabbro

LOWER (DESCRIPTN) LIKE LOWER ('%gabbro%') OR

Norite

LOWER (DESCRIPTN) LIKE LOWER ('%norite%') OR

Anorthosite

LOWER (DESCRIPTN) LIKE LOWER ('%anorthosite%') OR

Layered intrusion

LOWER (DESCRIPTN) LIKE LOWER ('%layered mafic–ultramafic%') OR

LOWER (DESCRIPTN) LIKE LOWER ('%layered mafic and ultramafic%') OR

LOWER (DESCRIPTN) LIKE LOWER ('%layered mafic--ultramafic%') OR

Mafic intrusion

LOWER (DESCRIPTN) LIKE LOWER ('% mafic intrusive rock%') OR

LOWER (DESCRIPTN) LIKE LOWER ('%mafic and ultramafic intrusive%') OR

LOWER (DESCRIPTN) LIKE LOWER ('%mafic and ultramafic intrusion%') OR

LOWER (DESCRIPTN) LIKE LOWER ('%mafic--ultramafic igneous%')

Operation

Expression

Operation

Operation

Expression

Operation

Select

 (LOWER (DESCRIPTN) LIKE LOWER ('%gabbro%') OR LOWER (DESCRIPTN) LIKE LOWER ('%anorthosite%') OR LOWER (DESCRIPTN) LIKE LOWER ('%norite%')) AND (CODE LIKE '%o%' OR CODE LIKE '%mo%')

Calculate Field

 

CLASS= "Mafic intrusion dominant"

Merge

Select2

LOWER (DESCRIPTN) LIKE LOWER ('% mafic intrusive rock%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%mafic and ultramafic intrusive%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%mafic and ultramafic intrusion%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%mafic--ultramafic igneous%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%layered mafic–ultramafic%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%layered mafic and ultramafic%') OR\nLOWER (DESCRIPTN) LIKE LOWER ('%layered mafic--ultramafic%')

Merge

Calculate Field

CLASS= "Mafic intrusion minor"

Select3

(LOWER (DESCRIPTN) LIKE LOWER ('%gabbro%') OR LOWER (DESCRIPTN) LIKE LOWER ('%anorthosite%') OR LOWER (DESCRIPTN) LIKE LOWER ('%norite%')) AND NOT (CODE LIKE '%o%' OR CODE LIKE '%mo%')

Back to Top