Mapping T206 Cards

[theshowandme]

Hey folks,

I got bored and decided to go down a rabbit hole and try to map different parts of the T206 set.

Using a number of sources and a lot of Python and SQL, I’ve been able to do a number of things so far.

This will be a work in progress and I welcome all ideas and feedback.

I am giving credit to Baseball Reference, t206resource, SABR, and the Sean Lahman database as data sources for this. I will update this post as data sources and contributions change.

I will have a longer write up at some point on the “how” for those interested in this type of data analysis.

First up is a map of all the cities of teams represented on T206 cards. I have distinguished where HOFers are and by their league.

Since this is mostly a national map, you can see clustering in major cities. It is nice to see the distribution of minor and southern leagues as well.


Next up I decided to zoom into St. Louis since they had both leagues present in the set. One challenge I had is that when geolocating these cities, all points for a city will just stack on top of one another. Thats no good. I wrote a point explosion function that dispersed similar points in a 360 degree radius between 1000 and 5000 feet from one another. You can see this in action below. One thing to note, every CARD has a point in this dataset. Therefor you can see duplicate points for Rube Waddell and Roger Bresnahan towards the north end of the city. Vic Willis also has two points.



Next up I wanted to show how the database I have built is combining a variety of information sources. When I click on a point, I am presented information about the player to include the baseball reference link and the t206resource link which has a high resolution scan of the image

I did this with Walter Johnson’s portrait of course


My next goals will be birthplaces and resting places. Those will be a bit tricky but I have the things I need. It will involve more data clean up and standardization but it will be fun.

I also want to map individual players journeys who may have had cups of coffees in the big leagues but played long careers in the minors across any number of cities. I will take suggestions on players who may be interesting case studies!

It was already suggested to me by a friend that it would be interesting to find data for the railroad network and major train stations of the time showing the travel networks between cities. I do not know how tough this will be, but I think that could be fun.

Outside the map side of this, now that I have tables of t206 players, I can also query historical batting, fielding, and pitching tables to answer more questions about the careers of players. I will try to show some things off with this stuff as well.

Anyways, if you have made it this far, I appreciate you taking the time to read this.

-Don

[ValKehl]

Don, I applaud you for undertaking this very interesting, but mammoth project.

Being a native, life-long Virginian and a collector of the T206 cards of the players on VA teams, I see that you have omitted at least one of the VA cities represented by southern leaguers. Assuming that the green triangle you placed on the VA-NC border represents Danville, VA, then you are missing one of the two cities - Norfolk and Portsmouth - located in the southeastern area of VA.

[theshowandme]

Originally Posted by ValKehl

Don, I applaud you for undertaking this very interesting, but mammoth project.

Being a native, life-long Virginian and a collector of the T206 cards of the players on VA teams, I see that you have omitted at least one of the VA cities represented by southern leaguers. Assuming that the green triangle you placed on the VA-NC border represents Danville, VA, then you are missing one of the two cities - Norfolk and Portsmouth - located in the southeastern area of VA.

No omission

We are viewing a small-scale national map, the points just conflict and do not render at this scale

zooming in a bit they are there

[B O'Brien]

That looks like some interesting stuff Don! The scale and scope of information might just turn that into a lifelong project!

Very cool and look forward to seeing more of it,
Bob

[CRT Sportscards]

From reading what you have written up, this seems really cool!

[Kevin]

Wow, Don, at first glance, I thought you had there street addresses on the map for when they played in the city. Nevertheless, brilliant work!

[theshowandme]

Originally Posted by Kevin

Wow, Don, at first glance, I thought you had there street addresses on the map for when they played in the city. Nevertheless, brilliant work!

Possible if we dug into the 1900 and 1910 US Census records, although depending on when that city was surveyed, it might have been the offseason and they could have been at a hometown address. Nonetheless, would be cool

[ValKehl]

Don, thanks for showing me the zoomed-in map that shows both Norfolk and Portsmouth.

[horzverti]

Don, looking forward to following your progress. Great to see passionate people doing cool things.