Skip to content

Instantly share code, notes, and snippets.

mojodna / 0_register_planet.sql
Last active Apr 2, 2021
Sample OSM Athena queries
View 0_register_planet.sql
-- This will register the "planet" table within your AWS account
type STRING,
lat DECIMAL(9,7),
lon DECIMAL(10,7),
mojodna /
Last active Jan 13, 2021
GDAL 2.0 on Amazon Linux
sudo yum -y update
sudo yum-config-manager --enable epel
sudo yum -y install make automake gcc gcc-c++ libcurl-devel proj-devel geos-devel
cd /tmp
curl -L | tar zxf -
cd gdal-2.0.0/
./configure --prefix=/usr/local --without-python
make -j4
sudo make install
View dynamodb-batch-get.js
"use strict";
var AWS = require("aws-sdk");
region: process.env.AWS_DEFAULT_REGION || AWS.config.region || "us-east-1"
var dynamodb = new AWS.DynamoDB();
mojodna / default.vcl
Created Nov 12, 2013
Resolve ELB IPs and create a dynamic Varnish backend list (intended to run out of cron).
View default.vcl
# ...
include "dynamic_backends.vcl";
# ...
# git-svn-diff originally by (
# modified by
# modified by aconway@[redacted] - handle diffs that introduce new files
# Generate an SVN-compatible diff against the tip of the tracking branch
# Get the tracking branch (if we're on a branch)
TRACKING_BRANCH=`git svn info | grep URL | sed -e 's/.*\/branches\///'`
mojodna / typography.yaml
Created Dec 3, 2018
Tangram style (modified from Refill) pushing the type layout engine
View typography.yaml
# Refill provides a high contrast, black & white basemap useful for data visualization.
# Give OpenStreetMap data a professional basemap skin using the Tangram graphics library
# and Mapzen's versatile Vector Tiles.
# Refill is a modern GL take on Geraldine's work on Toner for Stamen as part of their
# great CityTracking project. Please use and adapt the open source scene file in
# your own projects!
# Authors: Geraldine Sarmiento, Nathaniel V. Kelso
# Read more:
mojodna / Procfile
Created Sep 29, 2011 — forked from RandomEtc/Procfile
Getting Kue working on Heroku
View Procfile
web: node app.js
worker: node consumer.js
mojodna /
Last active May 20, 2019
libvirt LXC container w/ bridged networking (and 2GB RAM)

apt-get install -y libvirt-bin lxc
lxc-create -t ubuntu -n o1
virsh -c lxc:// define o1.xml
virsh -c lxc:// start o1
virsh -c lxc:// console o1
mojodna /
Last active Oct 26, 2018
ESACCI-LC Mid Latitude mask

Mid Latitude masking

First, apply the mid latitude mask as mask.

Next, add envelopes for each of the C-CAP sources as masks (otherwise chunky pixels sneak in, per

update land_cover set mask = ST_Union(mask, (select ST_Union(ST_Envelope(geom)) from land_cover where source='C-CAP')) where source='ESACCI-LC Mid Latitudes';
mojodna /
Created Oct 26, 2018
ESACCI-LC Mid Latitude mask
-- update the footprint to exclude the mask
update land_cover set geom=ST_Multi(ST_Difference(geom, mask)) where source='ESACCI-LC Mid Latitudes';