Hi Emily (and others if this is useful),
As Alex has said, that's one option for you to use. Alternatively you could use a google fusion table which can automatically geocode placenames from the columns in your file - see https://support.google.com/fusiontables/answer/2527132?hl=en . Or with a little bit of cut and paste, you could use this script from Mapbox: https://www.mapbox.com/geo-for-google-docs/ with a google document and then export the data to Tilemill for instance. There's various ways to do this and it might depend on how you want to display the data.
If you need more help, email me directly at the BM.
Dan
-----Original Message-----
From: Museums Computer Group [mailto:[log in to unmask]] On Behalf Of Alexander von Lünen
Sent: 20 November 2013 15:30
To: [log in to unmask]
Subject: Re: [MCG] Mapping visitors
Hi,
you could use the Google Geocoding API:
https://developers.google.com/maps/documentation/geocoding/
This is a Web Service, which returns the coordinates for a place name as JSON or XML. I've seen people using the Google Maps Interface directly from Google Docs as well, i.e. you could list the place names your visitors come from in a spreadsheet and have these place names geocoded from Google Docs and mapped onto Google Maps. I am not a great fan of Google (don't like their terms and conditions) and I use more sophisticated GIS. If you don't like to use Google and are able (or have someone around you being able) to do some basic programming in Perl or Python etc, you could use the GeoNames service (www.geonames.org) to geocode the place names and then map it onto OpenStreetMap (www.openstreetmap.org).
Hope this helps,
Alex
On 20/11/2013 14:47, Emily Hicks wrote:
> Hi All,
>
> Does anyone know of a good website or method online for mapping visitors- e.g. I have lots of data from our visitors book about where people come from, and would like to be able to input it somehow to create me some useful statistics rather than working out something on a spreadsheet.
>
> Many thanks
> Emily
>
> ****************************************************************
> website: http://museumscomputergroup.org.uk/
> Twitter: http://www.twitter.com/ukmcg
> Facebook: http://www.facebook.com/museumscomputergroup
> [un]subscribe: http://museumscomputergroup.org.uk/email-list/
> ****************************************************************
>
--
Dr Alexander von Lünen
Independent Scholar, Leicester, UK
Academia.edu profile <http://independent.academia.edu/AlexandervonLunen>
LinkedIn profile <http://uk.linkedin.com/in/avonlunen>
****************************************************************
website: http://museumscomputergroup.org.uk/
Twitter: http://www.twitter.com/ukmcg
Facebook: http://www.facebook.com/museumscomputergroup
[un]subscribe: http://museumscomputergroup.org.uk/email-list/
****************************************************************
****************************************************************
website: http://museumscomputergroup.org.uk/
Twitter: http://www.twitter.com/ukmcg
Facebook: http://www.facebook.com/museumscomputergroup
[un]subscribe: http://museumscomputergroup.org.uk/email-list/
****************************************************************
|