How to set up a quick geocoding system on google spreadsheets.
- Create a new spreadsheet
- Open the Scripts editor and paste the script attached
- Use on your spreadsheet this new formula
=searchMapzen(place_cell,mapzen_api_key)
| import QtQuick 2.0 | |
| /** | |
| * adapted from StackOverflow: | |
| * http://stackoverflow.com/questions/26879266/make-toast-in-android-by-qml | |
| */ | |
| /** | |
| * @brief An Android-like timed message text in a box that self-destroys when finished if desired | |
| */ |
| """ | |
| Name: replace_vector_tile_layer.py | |
| Description: Replace a hosted vector tile layer with an updated version | |
| from a map in a project while retaining the item name, id, and url. | |
| """ | |
| import os | |
| import datetime | |
| import arcpy | |
| from arcgis.gis import GIS |