Skip to content

Instantly share code, notes, and snippets.

View cblanc's full-sized avatar
🐇
♞

Christopher Blanchard cblanc

🐇
♞
44 followers · 13 following
View GitHub Profile
@cblanc
cblanc / gist:8488177
Last active January 3, 2016 16:19
$ curl https://api.ideal-postcodes.co.uk/v1/postcodes/ID11QD?api_key=ak_iddqdidkfaidchoppers&callback=foo
# result =>
foo && foo({"result":[
{
"postcode":"ID1 1QD",
"post_town":"LONDON",
"line_1":"Kingsley Hall",
"line_2":"Powis Road",
"line_3":""
@cblanc
cblanc / postalCounties.json
Created May 24, 2017 13:15
List of Postal Counties
[
"Aberdeenshire",
"Kincardineshire",
"Banffshire",
"Hertfordshire",
"West Midlands",
"Warwickshire",
"Worcestershire",
"Staffordshire",
"Somerset",
@cblanc
cblanc / keybase.md
Created July 23, 2017 17:07

Keybase proof

I hereby claim:

  • I am cblanc on github.
  • I am cablanchard (https://keybase.io/cablanchard) on keybase.
  • I have a public key ASBldidyjn7X2MmOTNq50qQs-Hb-uYObpbBBZ-PuCyMlbAo

To claim this, I am signing this object:

@cblanc
cblanc / hulls.sql
Created August 4, 2017 13:55
Computing Hulls from a List of Geometries
-- Compute Convex Hull for a list of geolocations matching the outcode 'SW1A'
SELECT
ST_AsText(ST_ConvexHull(ST_Collect(location::geometry))) AS hull
FROM
postcodes
WHERE
outcode = 'SW1A';
-- Compute Concave Hull for a list of geolocations matching the outcode 'SW1A'
-- Little bit more expensive but the polygons are a "tighter fit", the more you increase the second parameter the "tightness" increases but so does computational work required
@cblanc
cblanc / outcodes.csv
Created March 28, 2018 16:02
UK Outcodes - Feb 2018
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
AB10
AB11
AB12
AB13
AB14
AB15
AB16
AB21
AB22
AB23
@cblanc
cblanc / callbackify.js
Last active November 29, 2018 15:22
https://github.com/stripe/stripe-node/blob/master/lib/utils.js#L232
const callbackifyPromiseWithTimeout = function(promise, callback) {
if (callback) {
// Ensure callback is called outside of promise stack.
return promise.then(function(res) {
setTimeout(function() { callback(null, res) }, 0);
}, function(err) {
setTimeout(function() { callback(err, null); }, 0);
});
}
@cblanc
cblanc / extraction.sh
Created January 7, 2019 08:39
Extract NL streetnames / postcodes
# Get raw dataset
wget https://s3.amazonaws.com/data.openaddresses.io/runs/554587/no/countrywide.zip
unzip countrywide.zip
# Extract street and postcode from CSV, get unique elements and stream to file
awk -F "\"*,\"*" '{print $4,$9}' countrywide/nl/countrywide.csv | uniq > nl-postcodes.txt
@cblanc
cblanc / postcodesio.pl
Last active February 9, 2019 22:09
Postcodes.io - Perl Example Postcode Lookup
#!/usr/bin/perl
# Kindly provided by github/@digdilem
my $pc = "TQ13 9XT"; # Example postcode (Dartmoor National Park Visitor's Centre, Haytor)
use LWP;
use JSON qw( decode_json );
my $ll_url = "https://api.postcodes.io/postcodes/$pc";
@cblanc
cblanc / outcodes.bash
Last active February 11, 2019 10:55
UK Outcodes generated from postcodes.io
docker pull idealpostcodes/postcodes.io.db
docker run -p 5432:5432 idealpostcodes/postcodes.io.db
psql -h 0.0.0.0 --username=postgres postgres -c "COPY (SELECT outcode FROM outcodes ORDER BY outcode) TO STDOUT WITH CSV DELIMITER ','" | pbcopy
@cblanc
cblanc / postcodesio.sh
Created October 22, 2019 10:47
Various commands to run on postcodes.io.db docker container
# Start docker container
docker run -p 5432:5432 -e POSTGRES_USER=postcodesio -e POSTGRES_DB=postcodesiodb -e POSTGRES_PASSWORD=password idealpostcodes/postcodes.io.db
# Generate postcode list
psql -h 0.0.0.0 -p 5432 --username postcodesio postcodesiodb -t -A -F"," -c "SELECT postcode FROM postcodes ORDER BY postcode" > postcodes.csv