The Traveling Salesperson Problem (TSP) is a well known problem with many applications. One such application could be visiting all the baseball stadiums in Major League Baseball. These type of trips (or subsets of it) are the passion of many…
Third Landing
Investigations in Data
Year: 2017
Longitude and latitudes of MLB stadiums
In another post, I made reference to producing the latitudes and longitudes of all the stadiums in Major League Baseball. I thought I would share that data here.
Driving distances between all MLB ballparks
In other posts, I had need to determine driving distances between major league baseball ballparks. The link below contains a CSV file containing a distance matrix for such distances. Below is a snippet of the file. There is one line for…
Using MySQL to calculate baseball statistics by year of career
In previous analyses of the concept of the career year in baseball, I had occasion to calculate some statistics by year of a player’s career. That is, I wanted to analyze questions like ‘How did a player do in their 4th professional…
Eat Globally, Locally in Chicago – Revisited
A while back, I had undertaken a little project to determine how many country’s restaurants were represented in the Chicagoland area. This was one of the earliest projects I used that leveraged location and GIS information, and I thought I would revisit it…
Using a Space Filling Curve to Visit Every County in a State
In a previous post, we discussed the problem of determining an efficient route to visit every county. Part of that post explicated the difficulty of even defining the problem. In this post, let’s take a look at using space filling…
Determining the closest city that you’ve never heard of
I’ve spent the majority of my life in the Chicagoland area. So it came as somewhat of a surprise to me when I recently ran across the name of a city that was less than 30 miles away that I had…
A TSP Variant – An efficient route for visiting all counties in a state ?
i was reading a bicycle tourist’s idea of visiting every county in his home state. He had diligently chipped away at the goal for a number of years, visiting a few at a time. The question occurred to me as…
Mapping the Mathematical Streets of Paris
I recently came across a reference that stated over 100 streets in Paris are named after mathematicians. Having never heard that before, I decided to investigate and see what that looked like. The following site had tallied 91 streets that…
Extract Chicago Crime Data from the Open Data Portal Using Python
As part of the investigation in crime around the 606 trail, we pulled the crime data from Chicago’s open data portal. The following is a straight forward sample Python script for pulling a daily extract. Note that the available crime data on…
Top