newtfire / introDH-Hub

shared repo for DIGIT 100: Introduction to Digital Humanities class at Penn State Erie, The Behrend College
https://newtfire.github.io/introDH-Hub/
Creative Commons Zero v1.0 Universal
8 stars 4 forks source link

TimeMapper Location Formula Update #17

Closed ebeshero closed 3 years ago

ebeshero commented 3 years ago

I think I found a more stable formula for pulling in map geo-coordinate data for location names for TimeMapper's Column J. Try replacing my original formula by copying and pasting this one into your cell K2 (Location column):

=JOIN(",", ImportXML(CONCATENATE("https://nominatim.openstreetmap.org/?format=xml&q=",J2), "//place[1]/@lat | //place[1]/@lon"))

The website address in my formula is just slightly different than what I'd shared originally. Give this a try, and then copy and paste from K2 into your other cells in your Location column.

My Emily Carr TimeMapper: http://timemapper.okfnlabs.org/anon/gq9o2g-emilycarr_timemap#12