Ultramafic primary

Almost entirely one lithology (≥90%)

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

Ultramafic dominant

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

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

Ultramafic subordinate

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

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

Ultramafic minor

Minor component (if present, <10%)

Very low probability of observing ultramafic rocks in these areas

Ultramafic

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

Chromitit

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

Dunit

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

Harzburgit

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

Hornblendit

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

Komatiit

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

Lherzolit

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

Magnetitit

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

Peridotit

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

Pyroxenit

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

Serpentin

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

Tremolit

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

Websterit

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

Wehrlit

LOWER (DESCRIPTN) LIKE LOWER ('%wehrlit%')

Ultramafic igneous intrusive rock

CODE LIKE '%-a%' Or

Ultramafic volcanic rock

CODE LIKE '%-u%' Or

Metamorphosed ultramafic igneous intrusive rock

CODE LIKE '%-ma%' Or

Pyroxenitic hornfels – unknown protolith

CODE LIKE '%-me%' Or

Metamorphosed ultramafic volcanic rock

CODE LIKE '%-mu%' Or

Metamorphosed ultramafic igneous intrusive rock

CODE LIKE '%-xa%' Or

Metamorphosed ultramafic volcanic rock

CODE LIKE '%-xu%' Or

Metamorphosed ultramafic intrusive rock associated with other rock types

CODE LIKE '%-xma%' Or

Metamorphosed ultramafic volcanic rock associated with other rock types

CODE LIKE '%-xmu%'

Operation

Expression

Operation

Expression

Operation

Expression

Operation

Expression

Operation

Select

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

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

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

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

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

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

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

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

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

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

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

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

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

LOWER (DESCRIPTN) LIKE LOWER ('%wehrlit%')

Select1

CODE LIKE '%-a%' Or

CODE LIKE '%-u%' Or

CODE LIKE '%-ma%' Or

CODE LIKE '%-me%' Or

CODE LIKE '%-mu%' Or

CODE LIKE '%-xa%' Or

CODE LIKE '%-xu%' Or

CODE LIKE '%-xma%' Or

CODE LIKE '%-xmu%'

Select2

MIXEDROCK IS NULL OR MIXEDROCK LIKE '%Mixed%'

AND ROCKTYPE1 LIKE '%igneous ultramafic%'

AND ROCKTYPE2 LIKE '%igneous ultramafic%'

Calculate Field1

"Ultramafic primary"

Merge

Select3

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

Calculate Field2

"Ultramafic dominant"

Select4

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

Calculate Field3

"Ultramafic subordinate"

Select5

CODE NOT LIKE '%-a%' AND CODE NOT LIKE '%-u%' AND CODE NOT LIKE '%-ma%' AND CODE NOT LIKE '%-me%' AND CODE NOT LIKE '%-mu%' AND CODE NOT LIKE '%-xa%' AND CODE NOT LIKE '%-xu%' AND CODE NOT LIKE '%-xma%' AND CODE NOT LIKE '%-xmu%'

Calculate Field4

"Ultramafic minor”