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)
const File = require('vinyl'); | |
const gulp = require("gulp"); | |
const Handlebars = require('handlebars'); | |
const streamArray = require('stream-array'); | |
const ghostContentAPI = require("@tryghost/content-api"); | |
const api = new ghostContentAPI({ | |
url: 'https://demo.ghost.io', | |
key: '22444f78447824223cefc48062', | |
version: "v4" |
const fs = require('fs'); | |
const d3 = require('d3-dsv'); | |
const path = require('path'); | |
const yaml = require('js-yaml'); | |
const toMarkdown = require('to-markdown'); | |
d3.csvParse( | |
fs.readFileSync('./goodreads_library_export.csv', 'utf8') | |
).filter(row => { | |
return row['Exclusive Shelf'] !== 'to-read'; |
Wiring up a Google Form to GitHub is not that difficult with a little bit of Apps Script automation. All you need is a Google account, a GitHub account, and a web browser...
Personal access tokens provide an easy way to interact with the GitHub API without having to mess with OAuth. If you don't already have a personal access token with repo or public_repo access, visit your GitHub settings page and generate a new token.
Be sure to copy your token some place safe and keep it secure. Once generated, you will not be able to view or copy the token again.
First, check your current config (example output in homebrew.mxcl.postgresql.plist.xml
lower down in this gist):
cat ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Most importantly, note the -D /usr/local/var/postgres
argument.
Second, shut down your current PostgreSQL.
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Data exported out of the Fulcrum OpenTrails Trailhead App requires some post processing in order to generate the proper files, per the OpenTrails trailheads.geojson specification. Simply export as Shapefile and execute the following GDAL/OGR commands:
ogr2ogr -f "SQLite" opentrails-trailheads.sqlite -nln "trailheads" -a_srs "EPSG:4326" opentrails_trailheads.shp
ogr2ogr -update -f "SQLite" opentrails-trailheads.sqlite -nln "osm_tags" opentrails_trailheads_osm_tags.dbf
<?php | |
$fulcrum_api_key = 'your-fulcrum-api-key-goes-here'; | |
if (!isset($_GET['photos']) && !isset($_GET['photo'])){ | |
print 'photo or photos parameter required!'; | |
} | |
if (isset($_GET['photos'])) { | |
$photos = explode(',', $_GET['photos']); |
from osgeo import ogr | |
from osgeo import osr | |
source = osr.SpatialReference() | |
source.ImportFromEPSG(4326) | |
target = osr.SpatialReference() | |
target.ImportFromEPSG(3857) | |
transform = osr.CoordinateTransformation(source, target) |