Matt Gardner allthesignals

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

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)

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

	<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>

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

	<!--
	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" />

	#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`

	function getType (value) {
	let type = typeof value;
	if (type === 'object') {
	return value ? Object.prototype.toString.call(value).slice(8, -1) : 'null';
	}
	return type;
	}

	[NaN, 0, 1, Infinity, // numbers
	null, undefined, false, 'str', // other primitives

	import Ember from 'ember';

	export default Ember.Object.extend({
	model: null,
	subpath: null,

	dynamicModelProperty: Ember.computed('model', 'subpath', function() {
	let subpath = this.get('subpath');

	if ( subpath ) {

	s3cmd setacl s3://bucket/path/to/file --acl-public
	s3cmd info s3://bucket/path/to/file
	s3cmd setacl s3://bucket/path/to/file --acl-private

Matt Gardner allthesignals

Project Title

Getting Started

Prerequisites