select * from JOINED_MAPPABLE where PARAMETER = "Cracking Whole Carriageway" into CraUD
Update CraUD Set LOWER_THRESH = 0.15
Update CraUD Set UPPER_THRESH = 2
Update CraUD Set FACTOR = 0.6

select * from JOINED_MAPPABLE where PARAMETER = "Ride Quality (LV3)" into LV3UD
Update LV3UD Set LOWER_THRESH = 4
Update LV3UD Set UPPER_THRESH = 10
Update LV3UD Set FACTOR = 0.8

select * from JOINED_MAPPABLE where PARAMETER = "Rutting" into RutUD
Update RutUD Set LOWER_THRESH = 10
Update RutUD Set UPPER_THRESH = 20
Update RutUD Set FACTOR = 1

select * from JOINED_MAPPABLE where PARAMETER = "Texture_R" into TexRUD
Update TexRUD Set LOWER_THRESH = 0.7
Update TexRUD Set UPPER_THRESH = 0.4
Update TexRUD Set FACTOR = 0.75

select * from JOINED_MAPPABLE where PARAMETER = "Ride Quality (LV10)" into LV10UD
Update LV10UD Set LOWER_THRESH = 21
Update LV10UD Set UPPER_THRESH = 56
Update LV10UD Set FACTOR = 0.6

select * from JOINED_MAPPABLE where PARAMETER = "Texture_U" into TexUUD
Update TexUUD Set LOWER_THRESH = 0.6
Update TexUUD Set UPPER_THRESH = 0.3
Update TexUUD Set FACTOR = 0.5