Skip to content

Instantly share code, notes, and snippets.

@aborruso

aborruso/geocode_nominatim_gdrive

Created August 1, 2014 08:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aborruso/2350e828caa16ae196e2 to your computer and use it in GitHub Desktop.
Save aborruso/2350e828caa16ae196e2 to your computer and use it in GitHub Desktop.
Download ZIP
Geocoding con le API di MapQuest Nominatim a partire da GDrive
Raw
geocode_nominatim_gdrive
#Geocoding con le API di MapQuest Nominatim a partire da GDrive
Per fare il Geocoding con le **API** di **[MapQuest Nominatim](http://developer.mapquest.com/web/products/open/nominatim)** a partire da un foglio elettronico GDrive, basta applicare la funzione [ImportXML](https://support.google.com/docs/answer/3093342?hl=it) di GDrive alle celle che contengono i toponimi che vogliamo trasformare in una coppia di coordinate.
Se ad esempio ho il mio toponimo nella cella A2, la formula da applicare sarà:
=JOIN(",", ImportXML(CONCATENATE("http://open.mapquestapi.com/nominatim/v1/search?format=xml&q=",A2), "//searchresults/place[1]/@lat | //searchresults/place[1]/@lon"))
Il tutto in azione [qui](https://docs.google.com/spreadsheets/d/1s8dTaPSUCORUsXsylcu4PsesTJ9ddG-_fXlNHkEPEGs/edit?usp=sharing).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment