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

The distribution of mafic and related intrusive rocks (gabbro, norite, gabbronorite, troctolite, dolerite 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 gabbro, norite, gabbronorite, troctolite, dolerite or anorthosite in these areas.

Mafic intrusion minor

There is a lower probability of observing gabbro, norite, gabbronorite, troctolite, dolerite or anorthosite in these areas.

Geology MERGED

Terms

SQL query

Gabbro

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

 

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

 

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

Norite

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

Gabbronorite

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

Troctolite

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

 

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

Dolerite

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

 

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

Anorthosite

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

-o%

(CODE LIKE '%-o%' OR

-mo%

CODE LIKE '%-mo%' OR

od

CODE = 'od' OR

-xmo%

CODE LIKE '%-xmo%' OR

-xo%

CODE LIKE '%-xo%')

 

Terms

SQL query

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%') OR

 

LOWER (DESCRIPTN) LIKE LOWER ('% metamafic intrusive rock%')

Operation

Expression

Operation

Expression

Operation

Expression

Operation

Select

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

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

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

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

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

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

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

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

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

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

(CODE LIKE '%-o%' OR

CODE LIKE '%-mo%' OR

CODE = 'od' OR

CODE LIKE '%-xmo%' OR

CODE LIKE '%-xo%')

Calculate Field

"Mafic intrusion dominant"

   

Merge

Select (2)

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

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%') OR

LOWER (DESCRIPTN) LIKE LOWER ('% metamafic intrusive rock%')

Merge

 

Calculate Field

"Mafic intrusion minor"

Select (3)

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

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

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

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

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

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

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

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

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

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

AND NOT (CODE LIKE '%-o%' OR

CODE LIKE '%-mo%' OR CODE = 'od' OR

CODE LIKE '%-xmo%' OR CODE LIKE '%-xo%')

Back to Top