chriswhong’s gists

chriswhong / index.html

Last active April 18, 2016 14:51

A simple bootstrap form

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<!-- The above 3 meta tags must come first in the head; any other head content must come after these tags -->
	<title>Bootstrap 101 Template</title>

	<!-- Bootstrap -->

chriswhong / boro.sql

Created January 29, 2016 20:05

SQL to convert geo_id2 field from Census ACS data to boroct201 from NYCDCP's bytes of the big apple--

	--Replace county FIPS code with NYC boro code, concatenate with 6-digit tract ID

	SELECT
	*,
	(
	(
	CASE WHEN (substring(geo_id2,4,2) = '61')
	THEN '1'
	WHEN (substring(geo_id2,4,2) = '05')
	THEN '2'

chriswhong / index.html

Last active August 28, 2019 18:55

Time block charts wth D3

	<!DOCTYPE html>
	<html class="html">
	<head>
	<meta charset="UTF-8">
	<title>Document</title>
	<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
	<style>

	.axis text {
	font: 10px sans-serif;

chriswhong / 311_scratch.json

Last active January 8, 2016 21:05

	{
	"version": "2",
	"header": {
	"title": "NYC 311 Data",
	"description": "The last 3 million NYC 311 complaints",
	"navigation": [
	{
	"label": "Download",
	"url": ""
	}

chriswhong / 311_test.json

Last active January 15, 2016 22:02

	{
	"version": "2",
	"header": {
	"title": "NYC 311 Data",
	"description": "The last 3 million NYC 311 complaints",
	"navigation": [
	{
	"label": "Download",
	"url": ""
	}

chriswhong / speedsensors.txt

Created January 4, 2016 21:19

	NYC DOT Live Speed Sensors data:

	http://207.251.86.229/nyc-links-cams/LinkSpeedQuery.txt

	h/t https://twitter.com/5h15h/status/684116277586100224

chriswhong / sql.txt

Created December 29, 2015 20:27

SQL to Liberate Point Location Data from Proprietary Socrata "Location" Column (PostGIS)

	Socrata datasets often include a column of type 'Location', which may include a WGS84 latitude and longitude in parenthesis, separated by a comma. `(latitude,longitude)` This format does not lend itself well to mapping the point data, as most mapping software is expecting separate attribute columns for latitude and longitude. The SQL below is meant for use in a PostGIS database such as CartoDB. It parses the latitude and longitude from the a Socrata location column, and creates a point geometry in `the_geom` using PostGIS' `ST_geomfromtext()` function.

	With this function you can liberate point location data from Socrata's unconventional format, and put it to use in maps!

	UPDATE tablename
	SET the_geom =
	ST_setsrid(
	ST_geomfromtext(
	concat(
	'POINT(',

chriswhong / gist:a4d1e6305ecaf2ad507a

Created November 20, 2015 21:55

Use cartodb.js to add a torque layer from a named map with auth_tokens enabled

	var layerSource = {
	type: "torque",
	options: {
	auth_token: '{yourAuthToken}',
	user_name: "{yourCartoDBUsername}",
	tile_style:"{torqueCartoCSS}",
	named_map: {
	name: "{namedmap}"
	}
	}

chriswhong / alias.txt

Created November 19, 2015 21:59

Create an alias in the terminal to open the current directory in chrome via the local webserver

alias chrome='/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome --url "http://localhost/~chriswhong/$(basename $PWD)"'

chriswhong / index.html

Created November 13, 2015 05:18

Multiple CartoDB Named Maps on One Leaflet Map

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>Document</title>
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.15/themes/css/cartodb.css" />
	<style>
	#map, html, body {
	height:100%;
	width:100%;

Chris Whong chriswhong