Kyros Koh kyroskoh

Installing CartoDB on Ubuntu Server 12.04

Get CartoDB Rails application source

sudo apt-get update

sudo apt-get install git

cd ~

git clone --recursive https://github.com/CartoDB/cartodb20.git

Sublime Text 2 – Useful Shortcuts (PC)

Loosely ordered with the commands I use most towards the top. Sublime also offer full documentation.

Editing

Ctrl+C	copy current line (if no selection)
Ctrl+X	cut current line (if no selection)
Ctrl+⇧+K	delete line
Ctrl+↩	insert line after

Remove old PostGIS Installation

The first step is to remove older version of PostGIS if any.

sudo apt-get purge postgis

Setup repository

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" >> /etc/apt/sources.list.d/postgresql.list'

##Two Maps

Experiment in synching two maps together.

Contributors

	###################################
	## CartoDB 2.0 Install [Working] ##
	## Tested on Ubuntu 12.04 ##
	###################################

	sudo apt-get update
	sudo apt-get safe-upgrade -y

	# Install miscellaneous dependencies packages
	sudo apt-get install -y git-core python-software-properties openmpi-bin libopenmpi-dev build-essential libxslt-dev zlib1g-dev ruby gems unzip

	#!/bin/bash
	#
	# Install Postgres 9.1, PostGIS 2.0 and pgRouting on a clean Ubuntu 12.04 install (64 bit)
	# updated to PostGIS 2.0.1

	# basics
	sudo apt-get install python-software-properties
	sudo apt-add-repository ppa:sharpie/for-science # To get GEOS 3.3.3

	# install the following pacakages

	$(function () {
	// Future-proofing...
	var context;
	if (typeof AudioContext !== "undefined") {
	context = new AudioContext();
	} else if (typeof webkitAudioContext !== "undefined") {
	context = new webkitAudioContext();
	} else {
	$(".hideIfNoApi").hide();
	$(".showIfNoApi").show();

	<!DOCTYPE html>
	<html>
	<head>
	<title>2 Maps: Create Viz</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" />
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css" />

	<style>

	// Tile server using the node web framework Express (http://expressjs.com).
	var app = require('express').createServer();
	var tilelive = require('tilelive');
	require('tilelive-mapnik').registerProtocols(tilelive);
	var filename = __dirname + '/' + 'stylesheet.xml';
	tilelive.load('mapnik://' + filename, function(err, source) {
	if (err) throw err;
	app.get('/:z/:x/:y.*', function(req, res) {
	source.getTile(req.param('z'), req.param('x'), req.param('y'), function(err, tile, headers) {
	// `err` is an error object when generation failed, otherwise null.