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