Matt Gardner allthesignals

The gist: by having a Promise adopt the state of a forever pending one, you can suspend its then handlers chain.

Promise.pending = Promise.race.bind(Promise, [])

let cancel

new Promise(function(fulfill, reject) {
  cancel = function() {fulfill(Promise.pending())}
  setTimeout(fulfill, 1000, 5)

To load MapPLUTO into carto, the best approach is to upload the five borough shapefiles together, then UNION ALL them together.

Upload all five zipped borough shapefiles from Bytes of the Big Apple. Be sure to uncheck 'Allow Carto to guess column types" when uploading, or you'll get column type mismatches
UNION ALL the tables together with the following query. We can't just SELECT * because we'd have duplicate cartodb_ids in the result set, and saving as a new table would fail.

SELECT the_geom,the_geom_webmercator,borough,block,lot,cd,ct2010,cb2010,schooldist,council,zipcode,firecomp,policeprct,healthcent,healtharea,sanitboro,sanitdistr,sanitsub,address,zonedist1,zonedist2,zonedist3,zonedist4,overlay1,overlay2,spdist1,spdist2,spdist3,ltdheight,splitzone,bldgclass,landuse,easements,ownertype,ownername,lotarea,bldgarea,comarea,resarea,officearea,retailarea,garagearea,strgearea,factryarea,otherarea,areasource,numbldgs,numfloors,unitsres,unitstotal,lotfront,lotdepth,bldgfront,bldgdepth,ext,pro

	#Notes for getting docker-cartodb to run on a digitalocean droplet

	As of 21 June 2016, the Dockerfile at sverhoeven/docker-cartodb is not up to date, and the build will fail. It seems to fail at step 39, when it goes to create a user, but was not able to update it to get it working. Hopefully someone else can get it going with the latest cartodb code.
	`https://hub.docker.com/r/sverhoeven/cartodb/`

	However, running `docker run -d -p 3000:3000 -p 8080:8080 -p 8181:8181 sverhoeven/cartodb` will pull a complete docker image that is a few months old.
	Running this image will get you a container that expects to run at the domain `cartodb.localhost`, and per the installation instructions you are told to update your hosts file to point cartodb.localhost to the IP of your docker host.

	I wanted to run this with a real domain, so here are some notes on the steps involved.
	- run the image using `docker run -d -p 3000:3000 -p 8080:8080 -p 8181:8181 sverhoeven/cartodb`

	<!--
	based on @iriberri's http://bl.ocks.org/iriberri/7d84ed35ef0b5e80555d
	-->
	<!DOCTYPE html>
	<html>
	<head>
	<title>Point Collector \| CARTO</title>
	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />

	---
	---
	[
	{% for post in site.posts limit:10 %}
	{
	"title": {{ post.title \| jsonify }},
	"url": {{ post.url \| jsonify }}
	}
	{% unless forloop.last %},{% endunless %}
	{% endfor %}

	<li>{{ include.item.title }}
	{% if include.item.items.size > 0 %}
	<ul>
	{% for item in include.item.items %}
	{% include item.html item=item %}
	{% endfor %}
	</ul>
	{% endif %}
	</li>