Search this Site
Index of Posts
37 Signals Accenture Acer ACS Adobe Advertising Airbus Al Gore Alaska Airlines All Things Digital Amazon Americas Cup Amway Andrew Mason AOL Apple Asus Audio Books Australia Autodesk Avatar AWS Bank of America Baptie Barack Obama Ben Horowitz BestBuy Bill Gates Blackwater Blog Brad Feld Bradley Manning Broadband Business Insider Businessweek Buzz Caste System CEO Channel Insider Channel Marketing Charlie Rose Chase China Chris Anderson Chris Jordan Chris Paine Cisco Citi Group ClaimID Clay Shirky Clive Thompson Cloud Computing Cnet Comcast Comdex Compaq CompTIA Computer Operator Consumer Electronics Context Convergence Copernic Cost CraigsList Cranky Geeks Creative Destruction CSG CyberCrime Daniel Ellsberg Danny Sullivan Darren Huston Data Portability Dave Winer David Brooks David Letterman Deflation Dell Deloitte Delta Airlines DemandProgress.org Diaspora Digg Direct TV Disney Droid X Dropbox EarthPoint Ebay Economic Development Economies of Scale Economist EDS Edwin Land email Emerald City Rotary Enterprise Eric Schmidt Ericsson Escape from Las Vegas Euro RSCG Events Evernote Everything Channel Expedia FAA Facebook Fall of Giants Fax Machine FCC FFacebook Ford Foreign Affairs Fortune Fox News Fred Wilson Free Future in Review Game Change Gartner Gas Prices Gatekeeper Gates GBill Gates GDP GE General Electric George Lucas Gnip GoDaddy Goldman Sachs Google Google App Engine Google Maps Google+ Government Groupon Halperin Happiness Harvey Mackay Healthcare Heilemann Hemingway Hollywood Horsemen Hotels.com Hotmail HP HTC IBM Immigration India inflation Ingram Micro Instagram Intel Internet Week Intuit IOR iPad iPhone iPod Touch IQPC Ira Glass Iraq iTunes Jajah James Balog Jaron Lanier Jason Fried Jay C Leon Jay Rosen JC Penney Jeep Jeff Jarvis Jimmy Wales John Dvorak John Edwards John Mayer Johnny Depp Julian Assange Kayak.com Keith Richards Ken Follett Kevin Turner Kinect KIPP KPI Labor Unions Larry McMurtry Leadership League of Education Voters Lehman Brothers Lenovo Leo Laporte LeWeb LG Lists Liu Xaiobo Live Lloyd Blankfein Louie Psihoyos Loyalty Programs LTE Malcolm Gladwell Malcom McLean Marc Levinson March Madness Maris Pearl Mark Hurd Mark Zuckerberg MarketWatch Matt Cutts McAfee McDonalds Measurements Michael Lewis Michael Mandelbaum Michael Moore Microsoft MMicrosoft Monaco Media Forum Moneyball Mortgage Motorola Movember MS Azure Natural Monopoly NCAA Tournament Neal Stephenson Net Neutrality Netflix Network Effect New Trade Routes New York City New York Times Nobel Prize North Korea Novell NY Review of Books NY Times NYSE Office 365 Om Malik On The Media One Question Open Book OpenStack Oracle Osama bin Laden Outcome Outlook 2010 Panasonic Pareto Paul Krugman PBS PC Magazine Perot Systems Peter Byck Pew Pharmaceutical; Military; Wall Street Philippines Phone.com Photo Sharing Picasa Piracy Podcasts Polaroid Predictions Priceline Privacy ProPublica Public Speaking Quality Quants Race to the Top Rahm Emanuel Ray Ozzie Rebooting the News RetroDex Ric Merrifield RingRevenue Robert Rubin Robert Scoble Sailing Sales Process Engineering Salesforce.com Sam Palmisano SAP Sarah Palin Savings Rate Schumpeter Scientific Method Scott Patterson Search Sears Sebastian Rupley SEC Security Sharepoint ShowNotes Shutterfly Signage Simon Sinek Siri Skype Small Business Server SMB SMB Nation Smothers Brothers Soccer Social Media Socialtext South Korea Spray and Pray Squarespace Stand for Children Starbucks Steve Ballmer Steve Jobs Superbowl SWOT SXSW Synnex Tech Data TechCrunch techflash TED Telephone Tesla The Advertising Show The Big Short The Box This American Life Thomas Friedman Time Tina Fey Toshiba Trade Deficit Transparency Trends Trust TSA Tungle.me Twilio Twin Towers TWIT Twitter U of W Umair Hague Uncanny Valley Unemployment UPCon2010 US Bank Vacation Value Vic Maui Video Conference Virtualization VMware Vodburner voicemail Waiting for Superman Wall Street Wall Street Journal Walmart Walter Isaacson Warren Buffet Washington State Waste Wave Systems WIFI WikiLeaks Wikipedia Wildfire Wimbledon Wired World Cup WPC10 Writing wwpc2010 X1 Xbox 360 Xerox Zappos.com Zillow Zynga
Search This Site

My Other Links
Sites I Like
Index of Posts

Entries in Vic Maui (1)

Thursday
Jul082010

Vic Maui on Google Maps (How to put Lat Lon data onto Maps)

This year I have some friends racing their sailboat to Hawaii.  The nine boat fleet left Victoria over the weekend and they should be there within two weeks.  This kind of thing is more fun than ever to track with the new web enabled tools available.  The race committee is posting the lat and lon and standings each day on the official web site.  The numbers are fun to look at, but not as revealing as a map.  

I thought it would be an interesting exercise to figure out how to put this information onto a map.  It took me an hour or so to figure out, and I think I can update it daily in about 10 minutes.  Here are the steps:

  1. Use the web import tool in Excel to scrape the data off of the web site.   (Exel 2010, Data Tab, From Web...follow instructions -- very easy)
  2. Build some formulas in Excel to format the data to be read by EarthPoint.  (combine the data imported, label columns -- also very easy)
  3. Use EarthPoint to import the spreadsheet and create a KML file that can be read by Maps or Earth.  (just follow the instructions -- also very easy.  Hardest part is deciding on the types of Icons.)
  4. Create a MyMap in Google Maps.  (Go to maps.google.com, My Maps, Create New Map, Edit, Import, follow instructions).  I did this step a few times until I got the thing to look like I wanted.  
  5. Get Link to embed or email around.  (just click on the Link button on the top right corner).

Here are the results embedded: 


View 2010 Vic Maui in a larger map