Skip to content

Instantly share code, notes, and snippets.

@springmeyer
springmeyer / ideas.md
Created July 19, 2013 03:59
Ideas for speeding up remote Postgres/PostGIS data access in TileMill

Pulling data from remote Postgresql can be really slow. Many people try this, once.

That said, here is a mini guide of things to think about if you are pulling remote data.

Big ideas

  • If network between you and the remote data is slow, try running TileMill on a remote machine. For example, if your data is on Amazon's network, short of running TileMill on the same machine, at least running TileMill on another AWS machine would be faster. This is because network access within Amazon's cloud is going to be reliably faster than between AWS and the outside. Here is a guide for how to run TileMill from the command line on an Ubuntu Server (with no desktop) that works with AWS: http://www.mapbox.com/tilemill/docs/guides/ubuntu-service/. For details on setting up an AWS instance see https://gist.github.com/springmeyer/b0bbcd976378cf3e4e44 and for details for how to automate this see https://github.com/miccolis/aws-tilemill.

  • Debug locally to make sure you know how fast data should show up in a normal situa

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@springmeyer
springmeyer / world-merc-z1-wgs84.geojson
Last active August 1, 2019 23:05
World Mercator tiling scheme @ z1
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
codecov:
token: uuid # Your private repository token
url: "http" # for Codecov Enterprise customers
slug: "owner/repo" # for Codecov Enterprise customers
branch: master # override the default branch
bot: username # set user whom will be the consumer of oauth requests
ci: # Custom CI domains if Codecov does not identify them automatically
- ci.domain.com
- !provider # ignore these providers when checking if CI passed
# ex. You may test on Travis, Circle, and AppVeyor, but only need
@springmeyer
springmeyer / z0.geojson
Last active May 21, 2019 21:07
WGS84 tiling scheme
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@springmeyer
springmeyer / z0.geojson
Last active May 6, 2019 21:23
GoogleCRS84Quad
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@springmeyer
springmeyer / bbox2csv.py
Created December 14, 2012 21:20
Convert bbox to polygon and encode as geo csv for TileMill
#!/usr/bin/env python
'''
Usage:
# edit the script below "main" then:
python bbox2csv.py > bounds.csv
'''
def bbox2wkt(minx, miny, maxx, maxy):
@springmeyer
springmeyer / campus-maps.md
Last active November 6, 2018 03:29
Campus Map Technology
@springmeyer
springmeyer / install-pcp.sh
Last active August 22, 2018 15:09 — forked from johanstenberg92/install-pcp.sh
Install Performance Co-Pilot on Amazon Linux AMI
#!/bin/sh
set -eu
if [ "$(id -u)" != "0" ]; then
echo "Sorry, you are not root."
exit 1
fi
if !(type pcp 2>/dev/null;) then