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":"SF Muni explorer","view":{"label":"","lat":37.756536571255594,"lng":-122.44246582735484,"zoom":12.1087},"date":"2018-02-23T23:43:59.482Z","versions":{"tangram":"v0.14.2","leaflet":"1.0.3"},"user":null} |
{"name":"SF Muni via Transitland","view":{"label":"","lat":37.75841097986255,"lng":-122.44580840660919,"zoom":12.212833333333336},"date":"2018-02-20T17:36:06.059Z","versions":{"tangram":"v0.14.2","leaflet":"1.0.3"},"user":null} |
{"name":"old sf street names","view":{"label":"","lat":37.75543221712659,"lng":-122.41236969912961,"zoom":14.25},"date":"2018-01-25T23:23:31.239Z","versions":{"tangram":"v0.14.2","leaflet":"1.0.3"},"user":null} |
license: mit |
license: mit |
{"name":"tanzania","view":{"label":"","lat":-8.352541909510766,"lng":35.24999582629394,"zoom":6.861856965753216},"date":"2016-09-20T18:10:45.181Z","versions":{"tangram":"v0.10.2","leaflet":"1.0.0-rc.3"}} |
{"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"}} |
{"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":"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"}} |