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)
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <title>Title</title> | |
| <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.49.0/mapbox-gl.js'></script> | |
| <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.49.0/mapbox-gl.css' rel='stylesheet' /> | |
| </head> | |
| <body> |
Quattroshapes to WhosOnFirst as the canonical source for administrative hierarchies and corresponding geometries.Quattroshapes data since WhosOnFirst contains all those records and more. Going forward, any use of quattroshapes or qs in queries will resolve to whosonfirst or wof automatically.bbox property has been added to individual results, for which geometry was available in the original source. This does not affect POI and address data.id and gid format has changed to make the ids more unique.geonames ids being invalid for lookup via the /place endpoint.macroregion, macrocounty, and burough.| var fs = require('fs'); | |
| var _ = require('lodash'); | |
| var data = JSON.parse(fs.readFileSync(process.argv[2])); | |
| var results = []; | |
| Object.keys(data).forEach(function (key) { | |
| var item = data[key]; |
| /** | |
| * To run do as follows: | |
| * | |
| * $ npm install request | |
| * $ node locmux.js 'text i want to search for' | |
| * | |
| * If you'd like more locations to be searched just add them to the list below. | |
| * | |
| */ |
| var fs = require('fs-extra'); | |
| var fileName = process.argv[2]; | |
| var extend = require('extend'); | |
| var path = require('path'); | |
| // config mapping of old names to new ones | |
| var NAME_MAP = { | |
| 'layer': 'type', | |
| 'number': 'housenumber', | |
| 'zip': 'postalcode', |
| var apiBenchmark = require('api-benchmark'); | |
| var services = { | |
| server1: "http://localhost:3100/" | |
| }; | |
| var routes = { | |
| route1: { | |
| method: 'get', | |
| route: 'reverse?lat=40.744243&lon=-73.990342&size=40&categories=food,education,entertainment' |
Table of contents:
pelias-openaddresses
pelias-addresses
quattroshapes
pelias-geonames