hallahan

Preliminary Packages

Make sure you have done sudo apt-get update and sudo apt-get upgrade on your fresh install. This guide is geared toward Ubuntu 14.04 LTS (Trusty Tahr). Most of the guide will work for earlier versions of Ubuntu with some slight changes, but 14.04 is advised.

Enable the root user

sudo cp /home/ubuntu/.ssh/authorized_keys /root/.ssh/

andrewxhill

CartoDB Build Day

Introduction

Hello!

this document

http://bit.ly/cdb-fiesta

andrewxhill

Link to final map

Also take a look at the directional coloration map

Step 1

andy-esch

CartoDB.js Deep Dive

CartoDB's JavaScript API

Examples:

• Global Forest Watch
• Urban Reviewer

Table names:

• census_neighborhood_demographics_2010

andrewxhill

Introduction to the CartoDB interface

This page can always be found at: http://bit.ly/cdb-harvard

• Tour of dashboard
• Common data
• Uploading data
• Tour of table and map view
• Publishing maps
• Public profile

botris

cordova plugin add https://github.com/brodysoft/Cordova-SQLitePlugin.git

javisantana

import requests
import json
import random
import urllib

class MapInstance(object):

    def __init__(self, definition, url, headers=None):
        self.url = url
        self.definition = definition

javisantana

test_postgis=# select count(*) from sigpac_47_valladolid_parfe;
 count
--------
 342691
 
 test_postgis=#  select sum(st_memsize(the_geom_webmercator)) from sigpac_47_valladolid_parfe;
    sum
-----------
 254827296
(1 row)

sanderpick

CREATE OR REPLACE FUNCTION clearOld()
RETURNS TRIGGER
AS $$
    BEGIN
        DELETE FROM sf_muni_points WHERE created_at < now()-'1 day'::interval;
        RETURN NEW;
    END;
$$ language plpgsql;

CREATE TRIGGER clearOldOnInsert

timgit

angular.module('utilsModule').filter("megaNumber", () => {
    return (number, fractionSize) => {

        if(number === null) return null;
        if(number === 0) return "0";

        if(!fractionSize || fractionSize < 0)
            fractionSize = 1;

        var abs = Math.abs(number);