blocks by jczaplew

2c7f54fa623192c1e484

0c8f6aaba3e912e71f7d

tqdm with multithreading

Cancelable async

PostGIS Multipolygon Join

Supercluser + tilestrata + Mapbox GL JS

Install mapnik 3.+ on Ubuntu 14.04 Trusty

keybase.md

b573f7a9217cecdf5a70

Auto import csv to Postgres

d990ee34e809633be169

PostGIS vs shapely union

Redis cheatsheet

Heading to direction

319856742c75acb257ce

b96b6057a4021ab3a19c

5fe137627013b9b3df32

Best color for text on a background of a given hex color

Brute Force

Problematic polygon

pg_dump raster error

nlp2json.py

US Census incorporated places in PostGIS

Javascript Date to Postgres-acceptable format

Rolling tiles with mapnik + tilestache instead of Tilemill

Postgres array union of result set

Packt Response

Postgres management tools

Get Macrostrat columns + GMUS geometry for Michigan Basin

Postgres string matching in WHERE between two fields

Pagespeed Insights test

PBDB Annual Federal Burden

Process mammals with Postgres+PostGIS

PostGIS doesn't add extra decimal places

Aggregate

Postgres query to CSV with headers

Node + Apache

Install psycopg2 via Macports

Difference in area between projections

Add/update git submodule

Kentucky Senate Districts

Sampling Problem

(Climbing) Suicide Counter

Fix Bash OS X

Sample Along Line with PostGIS

Add 11 hours to a directory of JPGs

Macports Postgres + PL/R

Set up Postgresql93 with Macports

Array.map confusion

Install QGIS OS X

Terms of Use

Point on line

JS Scopes

Setting up a LaunchDaemon with pm2

Install MySQLdb on Mavericks

GNU Screen Cheatsheet

Vanilla Responsive SVG

Fun with PostGIS

8978255

8963069

PostGIS to MySQL

8641098

Vertical d3.fisheye

If/else

Heroku + Github + Sensitive Data

A tool for extracting data from PostGIS into GeoJSON and TopoJSON. UPDATE: Added a dedicated repo for contributions - https://github.com/jczaplew/postgis2geojson

Bulk import SHP into PostGIS

Pole-wrapping geometry issue

Geologic Time Scale

Topojson Paleogeography (reversed latitudes)

Topojson Paleogeography (normal order)

Detecting double taps with d3.js

Lazy composite

Adaptive Composite Map Projection (Canvas)

Adaptive Composite Map Projection example

Using d3.behavior.drag() with a map (updated)

Using d3.behavior.drag with a map

Alternate of http://bl.ocks.org/svmatthews/6123346

Gremlins

A very simple example showing how to force the Bootstrap typeahead (http://twitter.github.io/bootstrap/javascript.html#typeahead) to match only the start of words. The default matcher function matches the user query to any part of the possible results, which is often times undesirable - for example, in the standard typeahead in the example below, typing "Uni" gives four results that begin with "Uni", but also "RĂ©union" and "Tunisia".

502 Proxy Error with Apache, Node, and MySQL

EIA Nuclear Powerplant data scraper

FOSS4GNA Presentation Links

Responsive TopoJSON Sizing with d3.js