<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection">
<div dir="auto">I don’t think there are perfect solutions to this problem, just less bad ones. The reality is if you’re looking at an exponential growth situation, this is bound to happen. This was exactly the problem that led to the argument a few weeks back about Georgia and its COVID case maps changing the scale — people thought they were being misled.<br />
<br />
<span style="color:var(--textColor);background-color:var(--backgroundColor)">With the surge in COVID cases, the NYT recently had to change the scale on its maps, and they had a big caveat to that effect when they did.</span><br />
<br />
I think that’s probably the least bad solution: update it the scale, but only occasionally. Make sure there’s a note <em>right next to the legend </em>that explains when and why the scale has changed. You could do it on an as-needed basis (but build yourself some headroom so it’s not happening weekly), or on a schedule, like quarterly or annually.<br />
<br />
It’s probably also helpful to use a system where the bins are consistent, like a linear scale, and you’re just changing the top end of the scale. In other words avoid Jenks, which could just compound the confusion if someone is looking back at past maps, IMO.<br />
<br />
Darrell<br /></div>
</div>
<div name="messageReplySection">On Dec 3, 2020, 09:29 -0800, SMITH Cy * DAS via gis_info <gis_info@omls.oregon.gov>, wrote:<br />
<blockquote type="cite" style="border-left-color: grey; border-left-width: thin; border-left-style: solid; margin: 5px 5px;padding-left: 10px;">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Hi folks, we have a question about making good choropleth maps. See below.</span></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D">cy</span></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:526.5pt;margin-left:5.4pt;border-collapse:collapse">
<tbody>
<tr style="height:72.45pt">
<td width="135" valign="top" style="width:101.6pt;padding:0in 5.4pt 0in 5.4pt;height:72.45pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-family:"Calibri",sans-serif;color:#1F497D"><image001.png></span></p>
</td>
<td width="567" valign="top" style="width:424.9pt;padding:0in 5.4pt 0in 5.4pt;height:72.45pt">
<p class="MsoNormal" style="line-height:105%"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D">Cy Smith, GISP</span></b></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Enterprise Information Services</span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Data Governance and Transparency|Geospatial Enterprise Office</span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-family:"Calibri",sans-serif;color:#1F497D">(503)378-6066, <a href="http://gis.oregon.gov"><span style="color:#0563C1">http://gis.oregon.gov</span></a></span></p>
</td>
</tr>
<tr>
<td width="702" colspan="2" valign="top" style="width:526.5pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><i><span style="font-family:"Calibri",sans-serif;color:#2E74B5">“Ensuring user-friendly, reliable and secure state technology systems that serve Oregonians.”</span></i></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif">From:</span></b> <span style="font-family:"Calibri",sans-serif">VARGAS Antonio R * DCBS <Antonio.R.Vargas@oregon.gov><br />
<b>Sent:</b> Thursday, December 3, 2020 9:19 AM<br />
<b>To:</b> SMITH Cy * DAS <Cy.SMITH@oregon.gov>; TANNER Joshua * DAS <Joshua.TANNER@oregon.gov><br />
<b>Cc:</b> JOHNSON Nathan * DCBS <Nathan.Johnson@oregon.gov><br />
<b>Subject:</b> Looking for advice on making an updating choropleth</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hello,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I was wondering if you or someone on your team could provide some advice or a reference to best practices that might help with a project.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I’ve been asked to make a choropleth to illustrate dollar amounts going to each Oregon county to illustrate the progress of a program. The issue I’m having is that leadership would like to update the choropleth with new data each week, and I’m not sure how to choose the color scale to accommodate that.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">By the end of its lifespan, the dollar amounts will be roughly an order of magnitude higher than at the start. So, when I choose a color scale with enough room at the high end to account for this in the future, basically every county in today’s map is assigned the lowest colors on the scale. One idea we had was to use a continuous color scale, though the colors still end up very similar.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">On the other hand, if I were to update the color scale each time the data is updated, so that the data fills the whole color range each time, I expect that the colors assigned to each county wouldn’t change much over time. I guess the map would look wholly the same each data update, just with the legend assigning different dollar amounts to each color.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Any advice would be much appreciated.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Kind regards,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Antonio</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-----</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Antonio R. Vargas</p>
<p class="MsoNormal">Research Analyst</p>
<p class="MsoNormal">Division of Financial Regulation</p>
<p class="MsoNormal">Oregon Dept. of Consumer and Business Services</p>
<p class="MsoNormal">Office: 971.345.1106</p>
<p class="MsoNormal"> </p>
</div>
</blockquote>
</div>
</body>
</html>