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

The distribution of mafic and related rocks in Western Australia, coloured by the likelihood of their presence in these areas

Legend

Description

Mafic primary

Almost entirely one lithology (≥90%).

Mafic rocks are considered to be the predominant lithology. There is a high probability of observing mafic rocks in these areas. Any other lithology must be minor only.

Mafic dominant

Main, but not the only lithology (≥50%, but <90%).

Mafic rocks are considered to be the dominant lithology. There is a medium-high probability of observing mafic rocks in these areas.

Mafic subordinate

Significant (≥10%), but not the main lithology (<50%).

Mafic rocks are considered to be a subordinate lithology. There is a lower probability of observing mafic rocks in these areas.

Mafic minor

Minor component (if present, <10%).

Very low probability of observing mafic rocks in these areas.

Geology MERGED

Terms

SQL query

Mafic

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

?Mafic

LOWER (DESCRIPTN) LIKE LOWER ('%?mafic%') OR

Mafic

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

Metamafic

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

Amphibolit

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

Basalt

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

Boninite

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

Anorthosite

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

Dolerite

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

Gabbro

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

Norite

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

Troctolite

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

 

Terms

SQL query

Igneous mafic volcanic

CODE LIKE '%-b%' OR

Igneous mafic intrusive

CODE LIKE '%-o%' OR

Dolerite

CODE = 'od' OR

Metamafic volcanic rock

CODE LIKE '%-mb%' OR

Amphibolitic gneiss

CODE LIKE '%-mna%' OR

Metamafic intrusive rock

CODE LIKE '%-mo%' OR

Metamafic rock

CODE LIKE '%-mw%' OR

Mixed igneous mafic volcanic

CODE LIKE '%-xb%' OR

Mixed metamorphic igneous mafic volcanic

CODE LIKE '%-xmb%' OR

Mixed metamorphic protolith unknown: Gneiss and meta-igneous felsic intrusive

CODE LIKE '%-xmna%' OR

Mixed meta-igneous mafic intrusive

CODE LIKE '%-xmo%' OR

Mixed meta-igneous mafic

CODE LIKE '%-xmw%' OR

Mixed mafic igneous intrusive rock

CODE LIKE '%-xo%' OR

Mafic volcanic rock; undivided

CODE LIKE '%-bn%' OR

Mafic intrusive rock; undivided

CODE LIKE '%-on%'

Operation

Expression

Operation

Expression

Operation

Expression

Operation

Expression

Operation

Select

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

LOWER (DESCRIPTN) LIKE LOWER ('%?mafic%') OR

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

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

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

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

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

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

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

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

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

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

Select1

CODE LIKE '%-b%' OR

CODE LIKE '%-o%' OR

CODE = 'od' OR

CODE LIKE '%-mb%' OR

CODE LIKE '%-mna%' OR

CODE LIKE '%-mo%' OR

CODE LIKE '%-mw%' OR

CODE LIKE '%-xb%' OR

CODE LIKE '%-xmb%' OR

CODE LIKE '%-xmna%' OR

CODE LIKE '%-xmo%' OR

CODE LIKE '%-xmw%' OR

CODE LIKE '%-xo%' OR

CODE LIKE '%-bn%' OR

CODE LIKE '%-on%'

Select2

MIXEDROCK IS NULL OR MIXEDROCK LIKE '%Mixed%' AND ROCKTYPE1 LIKE '%igneous mafic%' AND ROCKTYPE2 LIKE '%igneous mafic%'

Calculate Field1

"Mafic primary"

Merge

Select3

MIXEDROCK IS NOT NULL AND ROCKTYPE1 LIKE '%igneous mafic%' AND ROCKTYPE2 NOT LIKE '%igneous mafic%'

Calculate Field2

"Mafic dominant"

 

Select4

MIXEDROCK IS NOT NULL AND ROCKTYPE1 NOT LIKE '%igneous mafic%' AND ROCKTYPE2 LIKE '%igneous mafic%'

Calculate Field3

"Mafic subordinate"

 
       

Select5

CODE NOT LIKE '%-b%' AND CODE NOT LIKE '%-o%' AND CODE <> 'od' AND CODE NOT LIKE '%-mb%' AND CODE NOT LIKE '%-mna%' AND CODE NOT LIKE '%-mo%' AND CODE NOT LIKE '%-mw%' AND CODE NOT LIKE '%-xb%' AND CODE NOT LIKE '%-xo%' AND CODE NOT LIKE '%-xmb%' AND CODE NOT LIKE '%-xmna%' AND CODE NOT LIKE '%-xmo%' AND CODE NOT LIKE '%-xmw%' AND CODE NOT LIKE '%-bn%' AND CODE NOT LIKE '%-on%'

Calculate Field4

"Mafic minor”

 
       

Select6

ROCKTYPE1 NOT LIKE '%igneous mafic%' AND ROCKTYPE2 NOT LIKE '%igneous mafic%'

 

Back to Top