Programming without Code

A talk by Pat Palmer for PMUG on Oct. 9, 2012

Powerpoint slides (.zip) from "Programming without Code" talk

Palmer, P.G.; , "Programming without code," Integrated STEM Education Conference (ISEC), 2012 IEEE 2nd , vol., no., pp.1-4, 9-9 March 2012, DOI 10.1109/ISECon.2012.6204177
 


Google Map with push pins

I was able to generate a mash-up, an interactive map showing occurrences of an algae species at 317 sites, in ~20 minutes including learning curve.  I used the Google Maps service indirectly by way of two other websites which offer utilities to facilitate creation of map mash-ups. Along the way, I created and used these files. Here is the procedure to use if you want to do a mashup of your own using the same steps:

  1. Decide what website you'll install your map on
  2. Get a "Google Maps API key" for that website from http://code.google.com/apis/maps/signup.html
  3. Wrangle the data into a text (.csv) or Excel file with these columns (only Latitude and Longitude are required):
  4. Use the converter at http://www.earthpoint.us/ExcelToKml.aspx to convert the Excel (or .csv) file to .kml
  5. Optionally, select a number for an icon from the above site's tables and paste it into the Icon column of the spreadsheet
  6. Feed the .kml file to the map generator at http://www.gpsvisualizer.com/
  7. Follow directions on the GPS Visualizer site above to save the HTML file for the map, and then use a text editor to replace the Google Maps API key in the saved file with your own key
  8. Upload the HTML file to your own website.  Style and label it as you please.

Geocoder

Google (restricted, doesn't work):
 
http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Pennsylvania+Avenue,+Washington,+DC
 
Yahoo placefinder:
 
XML:
http://where.yahooapis.com/geocode?q=1600+Pennsylvania+Avenue,+Washington,+DC&appid=[yourappidhere]
 
JSON:
http://where.yahooapis.com/geocode?q=1600+Pennsylvania+Avenue,+Washington,+DC&appid=[yourappidhere]&flags=J