Third Landing

Using MySQL to calculate baseball statistics by year of career

By admin Posted on November 20, 2017 Posted in Baseball

Notice: Undefined index: replace_iframe_tags in /home/trhdatac/public_html/wp/wp-content/plugins/advanced-iframe/advanced-iframe.php on line 1107

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 …

Using MySQL to calculate baseball statistics by year of career Read more »

Eat Globally, Locally in Chicago – Revisited

By admin Posted on November 17, 2017 Posted in Chicago, GIS

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 …

Eat Globally, Locally in Chicago – Revisited Read more »

Using a Space Filling Curve to Visit Every County in a State

By admin Posted on September 13, 2017 Posted in Bicycles, GIS, TSP

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 …

Using a Space Filling Curve to Visit Every County in a State Read more »

Determining the closest city that you’ve never heard of

By admin Posted on September 6, 2017 Posted in Chicago, GIS, Open Data

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 …

Determining the closest city that you’ve never heard of Read more »

A TSP Variant – An efficient route for visiting all counties in a state ?

By admin Posted on September 4, 2017 Posted in Bicycles, GIS, TSP

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 …

A TSP Variant – An efficient route for visiting all counties in a state ? Read more »

Mapping the Mathematical Streets of Paris

By admin Posted on August 14, 2017 Posted in GIS, Open Data

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 …

Mapping the Mathematical Streets of Paris Read more »

Extract Chicago Crime Data from the Open Data Portal Using Python

By admin Posted on August 13, 2017 Posted in Chicago, Open Data, 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 …

Extract Chicago Crime Data from the Open Data Portal Using Python Read more »

See the projects and the lessons learned

By admin Posted on July 10, 2017 Posted in Miscellany

I’ve decided to try and catalog some of the side projects I’ve done that I feel can discuss publicly. Some of these were borne from professional projects, while others were just things that struck my curiosity. (Disclaimer: Unless explicitly granted …

See the projects and the lessons learned Read more »

A GIS Buffer for the 606 Trail

By admin Posted on May 11, 2017 Posted in Chicago, GIS

In a previous post, I examined creating a bounding box for the 606 trail to enable analysis of surrounding crime. While this is straight forward and a convenient heuristic to explain what we were doing, notice that it’s not fully …

A GIS Buffer for the 606 Trail Read more »

Naturally occurring GIS – An Oil Stain of Michigan in Algoma, WI

By admin Posted on April 6, 2017 Posted in GIS, Miscellany

Inspired by this New Jersey shaped sidewalk crack, I found the following oil stain on a street in Algoma, WI. Its not a perfect match (the ”thumb” portion is a bit off) , but awfully close to the shape of …

Naturally occurring GIS – An Oil Stain of Michigan in Algoma, WI Read more »