A map of every distillery in the United States
When I first met with Rob Masters (distiller at Spring44 in Loveland, Colorado & President of the Colorado Distillers Guild) to discuss my #ColoradoDistilleryRoadTrip, he sent me a TTB website link listing all distilleries in the United States that had permits. While the table is very descriptive, I wanted to take that data and make it into something more visual.
So I talked with my special ladyfriend who helped me organize the data some, and then I dove down the rabbit hole of trying to get latitude & longitude coordinates for each distillery location. I also wanted to plot these locations into Google Maps. It all means nothing if you can’t embed them on your website.
On a Friday night.
At least I was drinking a pear gin & tonic using Peach Street Distillers Jackelope and Jenny Pear Gin while I was doing it. Long story short, I was successful.
I was successful, and here’s how I did it. It took me a long time to figure this out, so I thought people searching for “how to get latitude and longitude coordinates for a list of multiple address and how they can get them into a google map” could just use these directions below.
It took me a while to find a free site that would easily give me some lat/lon coordinates from addresses. I added those coordinates to the Excel file I was building. Then I imported this information into a Google Drive spreadsheet and used the experimental Fusion Table app to plot everything. Then I used this iTouchMap.com tool to fix any erroneous latitude/longitude points one address at a time (zip codes starting with a 0 – like Massachusetts - were handled weird and had to be fixed).
So there you go. It’s a map of the 1006 distilled spirits producers and bottlers with permits, current as of June 30, 2013. I’ll have more detailed stats on these distilleries as I better analyze the data over the coming weeks.