I have a dataset of land values which, for the full range, is say 125 to 250,000,000, i.e for a whole state. For the user, they will only be seeing on the map canvas, a small subset of this at any one time, i.e for a suburb. But they will want to get a full spectrum on the colour ramp in their area of interest, to tease out the slightest variation in the suburb.
The approach I have taken is to divide the full range into 10 and have pseudo range of 1 - 100% within that sym_rnge
. The psuedo range therefore repeats (code below). This is OK, until you get to the edges, when the values shown go from 99% to the next upper set and revert to 1% 2% etc.
I am using the VIRIDIS in-built ramp which looks nice, but doesn't repeat back to the starting colour (below). Instead the user seems brownish, purple, dark purple, yellow! I can't find an in-built ramp which repeats back to the starting colour. Just using that would solve my problem.
I looked at editing the code for the ramp, it is way too detailed I think to edit.
Is there a way to;
- have a colour ramp which repeats
- approach the problem from another angle?
set sym_rnge =
case
when dlrs_ha1 between 0 and 12500 then dlrs_ha1 / 125
when dlrs_ha1 between 12500 and 62500 then dlrs_ha1 / 625
when dlrs_ha1 between 62500 and 312500 then dlrs_ha1 / 3125
when dlrs_ha1 between 312500 and 1562500 then dlrs_ha1 / 15625
when dlrs_ha1 between 1562500 and 7812500 then dlrs_ha1 / 78125
when dlrs_ha1 between 7812500 and 39062500 then dlrs_ha1 / 390625
when dlrs_ha1 between 39062500 and 195312500 then dlrs_ha1 / 1953125
when dlrs_ha1 between 195312500 and 976562500 then dlrs_ha1 / 9765625
when dlrs_ha1 between 976562500 and 4882812500 then dlrs_ha1 / 48828125
when dlrs_ha1 between 4882812500 and 24414062500 then dlrs_ha1 / 244140625
else dlrs_ha1