WHEN descriptiveterm = 'Polygon Closing Link' THEN 'Polygon Closing Line' WHEN descriptiveterm = 'Inferred Property Closing Link' THEN 'Property Closing Line' WHEN descriptiveterm = 'Bottom Of Slope' ...
WHEN descriptivegroup = '{"General Surface"}' AND make = 'Natural' THEN 'General Surface Natural Text' WHEN descriptivegroup = '{"General Surface"}' AND make ...