Hopefully, 2021 brings us a return to live baseball and the ability to road trip once again ! The Bases Roaded website to plan your baseball road trip has been updated to reflect the 2021 schedule and is now available.…
Third Landing
Investigations in Data
Author: admin
All the golf courses within a given drive time
I have done a fair amount of road trip related projects, including routing baseball trips as well as golf trips . The golf trip tool linked here is a sort of ambitious traveling tool, picking top golf courses and building an…
Scattered Thoughts on the TSP for a baseball road trip
I have done a number of applications that have a flavor of the Traveling Salesman Problem (TSP). That is, they concern themselves with visiting a number of locations in an efficient manner. None of these applications have ever concerned themselves…
Using pgRouting to produce a tour of all MLB stadiums
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…
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…
Top