I know of several programs that can query a database in real time (eg, Tableau), but am not aware of any free versions. Given a database of US zipcodes and their coordinates and a database of LW poll responses, I’m sure it would be trivial for me to write a program that makes a list of occupied zipcodes, their locations, and how many people are at each one. Presumably then it would be possible to draw a map or feed the data to Google Maps...I’m not much of a hand at web stuff so I’m not sure about that.
You can make feed Google Maps a set of latitude/longitude points trivially using KML. Just type the URL of your KML file into the search field on google maps, and it’ll show up.
I know of several programs that can query a database in real time (eg, Tableau), but am not aware of any free versions. Given a database of US zipcodes and their coordinates and a database of LW poll responses, I’m sure it would be trivial for me to write a program that makes a list of occupied zipcodes, their locations, and how many people are at each one. Presumably then it would be possible to draw a map or feed the data to Google Maps...I’m not much of a hand at web stuff so I’m not sure about that.
You can make feed Google Maps a set of latitude/longitude points trivially using KML. Just type the URL of your KML file into the search field on google maps, and it’ll show up.
To geocode zip codes (convert them to lat/lon pairs), you can hit http://geocoder.us/service/csv/geocode?zip=95472