tag:blogger.com,1999:blog-3178813192704651028.post6195773633613730177..comments2024-03-28T17:52:37.818-04:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: Demers Cartograms and Other Maps of AfricaKen Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3178813192704651028.post-5704451399638063492017-06-17T10:23:06.347-04:002017-06-17T10:23:06.347-04:00I did some research myself before starting, but li...I did some research myself before starting, but like you, couldn't find anything. A search for "Demers Cartogram Algorithm" came up empty. Sounds like you've come up with a pretty good approach.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-14150974940271802332017-06-16T08:47:17.260-04:002017-06-16T08:47:17.260-04:00Hi Ken,Nice work! Coincidentally I stumbled upon t...Hi Ken,<br><br>Nice work! Coincidentally I stumbled upon this the day I finally got to work doing the same thing for my client's operating areas. There are 250+ so placing by hand would have been very time-consuming. I used Excel to snap the polygon centroids to a 'best-looking compromise' grid (3km squares). That left a few squares with multiple matches, which I corrected by incrementing their grid X/Y values. That still left a fair amount of space around the larger areas, so I finished off by moving the groups manually.<br><br>I feel like somewhere in there is the bones of a less manual approach; say one which resolves duplicates without tweaking. The goal of course is to automate the tightening of the group too, so that blocks/squares aren't disconnected from the group.<br><br>Before starting I asked mathmeticians and cartographers on Quora for their ideas. I didn't get any solutions. One told me it's complex and requires some thought of the compromises you're prepared to accept; as you pointed out.<br><br>Thanks for the article. It's good to know someone else is working on this.Dylan Omrannoreply@blogger.com