HOW TO USE MAP-O-MATIC (#9 in a Series)
Locations of Fans with Inquiring Minds (Dallas Cowboys, Eat Your Heart Out)
In this week's Map-O-Matic tutorial, I am going to insert something a little different. I will probably revert to the original plan and show a map of the worst railroad disasters in the world next week, but for this week I want to show how you can use Map-O-Matic to create a map of your customers, clients, or any other group of nouns (persons, places, or things) located in particular areas (specifically, at different coordinates on the earth’s surface).
In this case, the addresses come from those who wrote in today (Thursday, June 3rd, 2021) to the Green Bay Packers website's Inbox, which you can see here.
NOTE: If any are unaware, the Green Bay Packers are an American Football team from Green Bay, Wisconsin.
There were 22 questions posited and posted (answered); here is a rundown of them:
Total: 22 (19 from the USA, 1 each from Canada, Brazil, and England)
From the US: 19 (9 from Wisconsin, 2 from California, and one each from Colorado, Kansas, Indiana, Louisiana, Michigan, Ohio, Pennsylvania, and Texas)
From Wisconsin: 9 (2 from Green Bay, 2 from Verona, and 1 each from Appleton, Chippewa Falls, Hartford, Mequon, and Portage)
So: As the Green Bay Packers are from Wisconsin in the USA, you would expect most of the questions to be from the US, and they were -- 19 out of 22, or 86% of them, in fact.
You would also expect most of the questions from the USA to be from Wisconsin. However, although there were more from Wisconsin than any other State (by far), actually less than half (9 of the 19 from the USA) of the questions came from Wisconsin (41% of the total of 22 and 47% of the 19 from the USA).
Here is the SCSV (Semi-Colon Separated Values) text file I created to generate the map of all 22 locations:
Chocolate~Montreal, Canada;45.484485;-73.667290
Teal~Appleton, Wisconsin;44.254621;-88.398541
Purple~Verona, Wisconsin;42.986523;-89.540320
Red~El Centro, California;32.786687;-115.558245
Green~Green Bay, Wisconsin;44.508638;-87.999527
Blue~Arvada, Colorado;39.823612;-105.117399
Orange~Novato, California;38.101072;-122.570647
Indigo~Portage, Wisconsin;43.548029;-89.459973
Violet~Verona, Wisconsin;42.986523;-89.540320
Blue~Norton, Kansas;39.835712;-99.894053
Gray~Hartford, Wisconsin;43.320203;-88.383010
Black~Chippewa Falls, Wisconsin;44.935193;-91.395716
Chocolate~Erie, Pennsylvania;42.111620;-80.066954
Teal~Trinidad, Brazil;-19.732684;-47.915464
Purple~Mequon, Wisconsin;43.235802;-87.997376
Red~Ishpeming, Michigan;46.484765;-87.663833
Green~Rowlett, Texas;32.917842;-96.564483
Blue~Tunbridge Wells, England;51.138354;0.268469
Orange~Indianapolis, Indiana;39.791712;-86.159573
Indigo~New Orleans, Louisiana;29.995181;-90.027928
Violet~Green Bay, Wisconsin;44.508638;-87.999527
Blue~Cincinnati, Ohio;39.127407;-84.535583
I will show three maps: the first showing the locations of all the questioners from around the world, the second showing just those from the US, and the third showing just those from the State of Wisconsin.
Note that there are only 7 visible pushpins for Wisconsin, as there were two questions from Green Bay and two from Verona, so the second pushpin is covered by the first one in those cases, making the second questions from a town or city "invisible."
Here is the “All 22” Map:
And here is the USA Map; this second map was created by removing the three locations from foreign (to the US) countries from the text file:
Last but not least, here is the Wisconsin-only Map:
Remember that there were two questions from Green Bay itself, as well as two from Verona.
So what does this data tell us? The Dallas Cowboys claim to be “America’s Team.” That may or not be true; but the Green Bay Packers are the World’s Team.
Previous Map-O-Matic Tutorials can be accessed via the links below.
Map-O-Matic Tutorial #1: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-1-in-a-series
Map-O-Matic Tutorial #2: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-2-in-a-series
Map-O-Matic Tutorial #3: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-3-in-a-series
Map-O-Matic Tutorial #4: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-4-in-a-series
Map-O-Matic Tutorial #5: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-5-in-a-series
Map-O-Matic Tutorial #6: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-6-in-a-series
Map-O-Matic Tutorial #7: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-7-in-a-series
Map-O-Matic Tutorial #8: https://ramblingnotesofageezer.substack.com/p/how-to-use-map-o-matic-8-in-a-series