--SQL code to add style_code field as a Whole number (integer) (size 4) to table topographicarea using Open field calculator
CASE
	WHEN "descriptiveTerm" = 'Multi Surface' THEN 1
	WHEN "descriptiveTerm" = 'Archway'THEN 2
	WHEN "descriptiveTerm" ~ 'Bridge' AND ("descriptiveGroup" ~ 'Road Or Track' OR "descriptiveGroup" ~ 'Roadside') THEN 3 --NEW
	WHEN "descriptiveTerm" ~ 'Bridge' AND "descriptiveGroup" ~ 'Rail' THEN 4 --NEW
	WHEN "descriptiveTerm" ~ 'Bridge' THEN 5 --NEW
	WHEN "descriptiveTerm" ~ 'Level Crossing' THEN 6 --NEW
	WHEN "descriptiveTerm" = 'Traffic Calming' THEN 7
	WHEN "descriptiveTerm" = 'Pylon' THEN 8
	WHEN "descriptiveTerm" = 'Track' THEN 9
	WHEN "descriptiveTerm" = 'Step' THEN 10
	WHEN "descriptiveTerm" ~ 'Canal' THEN 11 --NEW
	WHEN "descriptiveTerm" ~ 'Footbridge' THEN 12 --NEW
	--Natural Environment Descriptive Term Rules
	WHEN ( array_contains(descriptiveTerm, 'Nonconiferous Trees') OR array_contains(descriptiveTerm, 'Nonconiferous Trees (Scattered)') )
		AND ( array_contains(descriptiveTerm, 'Coniferous Trees') OR array_contains(descriptiveTerm, 'Coniferous Trees (Scattered)') )
	THEN 13
	WHEN array_contains(descriptiveTerm, 'Nonconiferous Trees') OR array_contains(descriptiveTerm, 'Nonconiferous Trees (Scattered)') THEN 14
	WHEN array_contains(descriptiveTerm, 'Coniferous Trees') OR array_contains(descriptiveTerm, 'Coniferous Trees (Scattered)') THEN 15
	WHEN array_contains(descriptiveTerm, 'Agricultural Land') THEN 16 --NEW
	WHEN array_contains(descriptiveTerm, 'Orchard') THEN 17
	WHEN array_contains(descriptiveTerm, 'Coppice Or Osiers') THEN 18
	WHEN array_contains(descriptiveTerm, 'Scrub') THEN 19
	WHEN array_contains(descriptiveTerm, 'Boulders') OR array_contains(descriptiveTerm, 'Boulders (Scattered)') THEN 20
	WHEN array_contains(descriptiveTerm, 'Rock') OR array_contains(descriptiveTerm, 'Rock (Scattered)') THEN 21
	WHEN array_contains(descriptiveTerm, 'Scree') THEN 22
	WHEN array_contains(descriptiveTerm, 'Rough Grassland') THEN 23
	WHEN array_contains(descriptiveTerm, 'Heath') THEN 24
	WHEN array_contains(descriptiveTerm, 'Marsh Reeds Or Saltmarsh') OR array_contains(descriptiveTerm, 'Saltmarsh') THEN 25
	WHEN array_contains(descriptiveTerm, 'Sand') THEN 26 --NEW
	WHEN array_contains(descriptiveTerm, 'Mud') THEN 27 --NEW
	WHEN array_contains(descriptiveTerm, 'Shingle') THEN 28 --NEW
	WHEN array_contains(descriptiveTerm, 'Marsh') THEN 29 --NEW
	WHEN array_contains(descriptiveTerm, 'Reeds') THEN 30 --NEW
	WHEN array_contains(descriptiveTerm, 'Foreshore') THEN 31
	WHEN "descriptiveTerm" = 'Slope' THEN 32
	WHEN "descriptiveTerm" = 'Cliff' THEN 33
	--Descriptive Group Rules
	WHEN array_contains(descriptiveGroup, 'Building') THEN 34
	WHEN array_contains(descriptiveGroup, 'General Surface') AND "make" = 'Natural' THEN 35
	WHEN array_contains(descriptiveGroup, 'General Surface') AND ("make" = 'Manmade' OR "make" = 'Unknown') THEN 36
	WHEN array_contains(descriptiveGroup, 'Road Or Track') AND "make" = 'Manmade' THEN 37
	WHEN array_contains(descriptiveGroup, 'Roadside') AND "make" = 'Natural' THEN 38
	WHEN array_contains(descriptiveGroup, 'Roadside') AND ("make" = 'Manmade' OR "make" = 'Unknown') THEN 39
	WHEN array_contains(descriptiveGroup, 'Inland Water') THEN 40
	WHEN array_contains(descriptiveGroup, 'Path') THEN 41
	WHEN array_contains(descriptiveGroup, 'Rail') AND ("make" = 'Manmade' OR "make" = 'Unknown') THEN 42
	WHEN array_contains(descriptiveGroup, 'Rail') AND "make" = 'Natural' THEN 43
	WHEN array_contains(descriptiveGroup, 'Structure') THEN 44
	WHEN "descriptiveGroup" = 'Glasshouse' THEN 45
	WHEN array_contains(descriptiveGroup, 'Landform') AND "make" = 'Natural' THEN 46
	WHEN array_contains(descriptiveGroup, 'Tidal Water') THEN 47
	WHEN array_contains(descriptiveGroup, 'Landform') AND "make" = 'Manmade' THEN 48
	ELSE 99
	END