Wednesday, June 30, 2021

Lego World Map-Spreadsheet Version

The Lego World Map contains 11,695 Lego pieces. The land areas are meant to be colored in white,

but for the oceans they encourage creativity.  

The map is a grid and therefore lends itself to being replicated in Excel as Jon Schwabish of PolicyViz has done. He assigned a color for each grid cell based on the LEGO palette. In this article he describes the process and lets makes his Excel file available for download. Here is a close up.


So you can take this color by numbers approach to make your own creative spin on the world. My artistic skills are limited but here was a quick pass at it.

You can download your own spreadsheet here.


Wednesday, June 23, 2021

The Southern Underground Railroad

Mexico outlawed slavery in 1829. Texas fought for independence from Mexico in part to be able to reestablish slavery there. For those seeking freedom from Texas and other nearby states Mexico was a much closer destination than Canada. It was a much tougher trip than for those who went north without the support and protection available in free states. Most who tried to escape to Mexico likely never made it. Still Stephen F. Austin State University's Texas Runaway Slave Project has documented over 2,500 escapees.

Illustration by Erwin Sherman via Texas Highways 

Runaways may have been helped by Mexican immigrants, German settlers who were opposed to slavery and by their own skills at horseback riding. Crossing the Nueces Strip, the hot, arid land between the Nueces River and Rio Grande was particularly difficult but with a horse and a gun, it was possible. 

Once in Mexico there was still much adversity with few job opportunities, a language barrier and little local support. Still it was better than being enslaved. 

Without a major support network there are not established routes to map, just general flow patterns as seen on the map above. This map that commonly appears on the web shows a general flow southward through Texas in addition to the more commonly known routes.

via Pinterest

 More info at Texas Highways

Thursday, June 17, 2021

Vaccine Deserts

 A new vaccine equity planning tool has been launched by Ariadne Labs. It shows vaccine deserts, defined as areas with limited access to vaccinations. You can pick a state or zip code and see where these are. Here is Ohio.

There is a pretty clear pattern of rural areas having the least access. In contrast, earlier in 2021, there were rural and urban deserts as detailed by a Deloitte study quoted in the Missouri Independent. Here is a map showing (in blue) the deserts of Missouri,

Images via the Kansas City Star

and a close up of Kansas City.

The Ariadne tool is designed so that planners can advance their outreach to the areas most in need. From their web page.

“Vaccines are now increasingly available across the U.S., yet there is still a population struggling with access. Not everyone has the ability or time to spend an hour out of their workday or more to get their vaccine. By accounting for different modes of transportation — including public transit and walking — we hope public health officials and providers will gain a deeper understanding of how to reach all communities,” said Katherine Chou, Director, Product Management, Google Health.

Some of these deserts are in empty, disconnected, or wet areas such as this spot on the coast of Maryland so the tool is imperfect, like everything in mapping.



Wednesday, June 9, 2021

The Cold War in the Heartland

Cold War in the Heartland is a project of the University of Kansas Center for Russian, East European, and Eurasian Studies.

Durng the Cold War Intercontinental Ballistic Missile (ICBM) silos were placed throughout the United States, particularly in the upper Midwest. This map shows missile fields that are still active in red and ones that have been deactivated in black.

Here is a diagram of a typical missile site.

Topeka Regional Airport, formerly Forbes Air Force Base, became the home for an Air Force unit that conducted nighttime photography and mapping expeditions over Russia and other communist nations. In 1959 the Strategic Air Command ordered nine ICBM sites built surrounding the base. These were decommissioned in 1965 after the costs to maintain them became too high.

A description of the site at Worden Kansas (548-2 Lawrence) on the map above.            

"Today, weeds, bushes, and trees cover nearly the entire site and frogs cheerfully leap into the pond that has formed in front of the entry door to the old missile bay. At first glance, it appears that the site, once at the forefront of the nation’s nuclear arsenal, has been reclaimed by nature. Yet is still possible to recognize a few of the launch facility’s features, such as the different buildings and the doors that allowed the missile to be launched. These remnants speak to the profound environmental impact of the nuclear arms race, one that can still be felt today."