WHEN descriptivegroup = '{"General Surface"}' AND make = 'Natural' THEN 'General Surface Natural Text' WHEN descriptivegroup = '{"General Surface"}' AND make ...
WHEN descriptivegroup @> '{"General Feature"}' AND descriptiveterm IS NULL AND physicalpresence = 'Obstructing' THEN 'Default Line' WHEN descriptivegroup ...