Skip to content

Instantly share code, notes, and snippets.

View ebrelsford's full-sized avatar

Eric Brelsford ebrelsford

121 followers · 74 following
View GitHub Profile
@ebrelsford
ebrelsford / index.html
Created April 6, 2015 16:45
JS Bin // source http://jsbin.com/nefaga
<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
<meta charset="utf-8">
<title>JS Bin</title>
<style id="jsbin-css">
html, body {
@ebrelsford
ebrelsford / index.html
Created April 6, 2015 16:53
JS Bin // source http://jsbin.com/sucefe
<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
<!--
Load the MapPaint plugin.
@ebrelsford
ebrelsford / index.html
Created April 15, 2015 20:09
// source http://jsbin.com/roniho
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script src="http://code.jquery.com/jquery-2.1.0.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
@ebrelsford
ebrelsford / index.html
Created April 20, 2015 01:04
// source http://jsbin.com/tiquyu
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script src="http://code.jquery.com/jquery-2.1.0.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
@ebrelsford
ebrelsford / index.html
Created April 23, 2015 23:00
JS Bin // source http://jsbin.com/macoru
<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-2.1.1.min.js"></script>
<meta charset="utf-8">
<title>JS Bin</title>
<script src='https://api.tiles.mapbox.com/mapbox.js/v2.1.8/mapbox.js'></script>
<link href='https://api.tiles.mapbox.com/mapbox.js/v2.1.8/mapbox.css' rel='stylesheet' />
<style id="jsbin-css">
html, body {
@ebrelsford
ebrelsford / index.html
Created June 5, 2015 00:06
// source http://jsbin.com/garesu/2
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<!-- Load jQuery -->
<script src="http://code.jquery.com/jquery-2.1.0.min.js"></script>
<!-- Load Leaflet -->
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
@ebrelsford
ebrelsford / index.html
Created June 5, 2015 15:03
Bike routing with Valhalla // source http://jsbin.com/qepurisibe
<!DOCTYPE html>
<html>
<head>
<script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
<script src="https://rawgit.com/jieter/Leaflet.encoded/master/Polyline.encoded.js"></script>
<meta charset="utf-8">
<title>Bike routing with Valhalla</title>
@ebrelsford
ebrelsford / index.html
Created April 27, 2016 14:55
Blur a Leaflet map with html2canvas and StackBlur
<html>
<head>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet/v1.0.0-rc.1/leaflet.css" />
<script src="http://cdn.leafletjs.com/leaflet/v1.0.0-rc.1/leaflet.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/0.5.0-alpha2/html2canvas.min.js"></script>
<script src="https://cdn.rawgit.com/flozz/StackBlur/master/dist/stackblur.min.js"></script>
<script src="https://code.jquery.com/jquery-2.2.3.min.js"></script>
<style>
html, body {
margin:0;
@ebrelsford
ebrelsford / index.md
Last active April 30, 2016 19:21
Points in polygon spatial joins with PostGIS

PostGIS is capable of just about any GIS operation you're used to doing in a desktop GIS. Here we cover typical points-in-polygon queries in PostGIS.

If you're new to joins in SQL, you'll notice a few things about the queries here. First, we select from multiple tables and give each a unique name (so instead of FROM nycc you'll tend to use FROM nycc cc, listings l if your query is over nycc and listings. Second, you'll be grouping the polygons by a unique id. As I'm using CartoDB here, I will group by cartodb_id.

Average

If we have a table called nycc of City Council districts and a table called listings of Airbnb listings, we can find the average price by city council district like so:

SELECT cc.*, AVG(l.price) AS avg_price
@ebrelsford
ebrelsford / keybase.md
Created November 29, 2016 20:48

Keybase proof

I hereby claim:

  • I am ebrelsford on github.
  • I am ebrelsford (https://keybase.io/ebrelsford) on keybase.
  • I have a public key ASC3gabi902GYAL8aiKmFotr-Kf19RrW4E6NvckfCpehlAo

To claim this, I am signing this object: