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

Updated Geomapping Formula for TimeMapper #18

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

My Google Sheet for the Emily Carr TimeMapper: https://docs.google.com/spreadsheets/d/1xF5dejh29Tgw4-vj-U84jV7fKvyoXuCvhNMUELhTC2o/edit?usp=sharing