I want to take Frank's Live Archive and create a GIS (Geographical Information System (pronounced "jizz" (not really))). My plan is to use something like Leaflet to create a web-enabled GIS that everyone can see. http://leafletjs.com/

I have the list of shows with dates and the venues in a spreadsheet but to add the shows to a map I need the latitude and longitude of each venue. Given that there are (to date!) 2016 of them, it's not practical for me to do them all myself so I'm asking for help.

This is what I would like people to do:
1) find a show with no link shown in Column D.
2) copy and paste the venue into Google Maps; check that it's the right location.
3) THIS IS IMPORTANT: zoom in on the venue as close as you can get and center the marker on your screen. The lat and long coded in the URL is the center of your window, not the venue itself.
3) copy and paste the Google Maps link in the address bar on your browser back to the spreadsheet. Don't worry about formatting. The spreadsheet with automatically extract the latitude and longitude of the venue from the URL.

What fun. I have stuck in a few venues that no longer exist in London, along with my old flat from The Road video and some others. I love a bit of Google maps so have bookmarked and will come back to it.

I am planning to mess around with some more sophisticated software once there is more data but I have created a *.kmz with the first 258 shows that have coordinates. You will need to download and install Google Earth to view this but it's currently the easiest way to view the data. https://www.google.com/earth/download/gep/agree.html

Filling this out is actually kind of fun. For the nerd that I am Quick tip for everyone else: if you've found the coordinates for a venue, check list (or Frank's archive in a second tab) to see if he has played there multiple times and fill the data in for each of those gigs.

Ok, maybe you all already did that this way and I'm the only one who didn't think of that and had to look up venue coordinates twice

"And the only things that holds me back are the things I hold inside..."
34 gigs. 15 cities. 6 countries.
Twitter/Instagram: @dennasus

OMG Zoe, the "frank Stats" spreadsheet. I'm dying at the category descriptions for the songs: "I hate you all, especially you, Amy" I'm a little cranky right now and feel sorry for myself" "Life is great, let's play some songs! I might even have a girlfriend right now."

reitzel6570 wrote:OMG Zoe, the "frank Stats" spreadsheet. I'm dying at the category descriptions for the songs: "I hate you all, especially you, Amy" I'm a little cranky right now and feel sorry for myself" "Life is great, let's play some songs! I might even have a girlfriend right now."

Ha Ha. I made that one last year. I was organizing the other day and put it in the same folder not realizing everyone would see it too. Frank tweeted a link to that spreadsheet and I was sick with anguish. I could never handle fame.