Alluvial/fluvial

Alluvium in channels and floodplains. Includes deltaic deposits.

Colluvial

Proximal mass wasting deposits grading into sheet wash with a significant to perceptible slope

Eolian

Dunes, interdune areas, and sandplain resulting from wind action

Lacustrine

Inland lakes, dunes, playa terrain and some coastal lakes. Includes saline and freshwater playas and claypans, and minor eolian deposits directly associated with the lake system (e.g. fringing gypsiferous dunes).

Sandplain

May be of mixed origin, including residual, sheet wash and eolian sands

Sheetwash

Distal slope deposits (including sheet flood), where the gradient is minimal and drainage is not clearly defined

_C

Coluvial unit

(CODE LIKE '_C%' Or

_W

Sheetwash unit

CODE LIKE '_W%' Or

_A

Alluvial/fluvial unit

CODE LIKE '_A%' Or

_L

Lacustrine unit

CODE LIKE '_L%' Or

_E

Eolian unit

CODE LIKE '_E%' Or

_S

Sandplain unit

CODE LIKE '_S%' Or

_Rt

Residual transported

CODE LIKE '_Rt%') And

Residual or relict

LANDFORM NOT LIKE '%Residual or relict%'

Select

(CODE LIKE '_C%' Or

CODE LIKE '_W%' Or

CODE LIKE '_A%' Or

CODE LIKE '_L%' Or

CODE LIKE '_E%' Or

CODE LIKE '_S%' Or

CODE LIKE '_Rt%') And

LANDFORM NOT LIKE '%Residual or relict%'