Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALots of parsing!
The data prep on this one is a perfect use case for the tile tool (so often overlooked)! Made the data prep on this one a synch!
The Tile_Num is unique to the state, and the Tile_SequenceNum is the row number for that state. Pairs well with crosstabs!
Fun challenge.
Trickiest part for me was remember how North/South/East/West convert to lat/longs.
Good'ol bit of regex and data wrangling.
Here is my solution to Challenge #214. Enjoyed it very much, nice one!