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)
{"name":"POIkemon.yaml","view":{"label":"","lat":37.793143902544756,"lng":-122.40240468460294,"zoom":18.171666005011364},"date":"2016-07-15T19:47:09.975Z"} |
{"name":"gotham_traffic.yaml","view":{"label":"","lat":37.79263436551425,"lng":-122.39713668823244,"zoom":17},"date":"2016-07-18T21:24:48.169Z"} |
{"name":"isochrone.yaml","view":{"label":"","lat":40.04864272291728,"lng":-76.24511718750001,"zoom":9},"date":"2016-07-29T21:55:37.243Z"} |
{"name":"wvu, prt, ants","view":{"label":"","lat":39.64131071741682,"lng":-79.96322463005573,"zoom":16.0033},"date":"2016-08-19T22:34:55.254Z","versions":{"tangram":"v0.9.1","leaflet":"1.0.0-rc.2"}} |
{"name":"la_hoods","view":{"label":"","lat":34.19788913406563,"lng":-118.26112747192384,"zoom":12},"date":"2016-08-19T22:55:20.185Z","versions":{"tangram":"v0.8.2","leaflet":"1.0.0-rc.2"}} |
{"name":"LA hoods","view":{"label":"","lat":33.99518087394024,"lng":-118.18851470947267,"zoom":11},"date":"2016-08-19T23:13:53.382Z","versions":{"tangram":"v0.9.1","leaflet":"1.0.0-rc.2"}} |
{"name":"wider bike lift","view":{"label":"","lat":37.7490728023292,"lng":-122.41329431533815,"zoom":17},"date":"2016-08-25T21:48:30.265Z","versions":{"tangram":"v0.9.3","leaflet":"1.0.0-rc.2"}} |
{"name":"emoji, transparent shields, ","view":{"label":"","lat":-22.912919022459082,"lng":-43.233288338656294,"zoom":17.625004944007546},"date":"2016-08-25T06:58:10.009Z","versions":{"tangram":"v0.9.3","leaflet":"1.0.0-rc.2"}} |
{"name":"pools in polygons","view":{"label":"","lat":33.93778086371438,"lng":-118.13342375972198,"zoom":10.961876310470121},"date":"2016-09-13T21:13:11.858Z","versions":{"tangram":"v0.9.5","leaflet":"1.0.0-rc.3"}} |