Jorge Sanz jsanz

Introduction to the CartoDB interface

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

gdal (and python bindings)
cartodb up and running
- it would be nice to use ghost tables branch (CDB-2572) so it can get tables into the dashboard. requires resque to be running also.

# Download shaded relief from natural earth (http://www.naturalearthdata.com/downloads/10m-raster-data/10m-shaded-relief/)
make prepare

This simple script will take a picture of a whiteboard and use parts of the ImageMagick library with sane defaults to clean it up tremendously.

The script is here:

#!/bin/bash
convert "$1" -morphology Convolve DoG:15,100,0 -negate -normalize -blur 0x1 -channel RBG -level 60%,91%,0.1 "$2"

	//Logs current map center and zoom level for use in map init options
	//Use it to find that perfect intial view without having to use trial and error
	map.on('dragend',getInit).on('zoomend',getInit);

	function getInit() {
	var c = map.getCenter();
	console.log('center: [' + c.lat + ',' + c.lng + '],\nzoom: ' + map.getZoom());
	}

	-- Function: makegrid_epsg3857(text, text, text, numeric)

	-- DROP FUNCTION makegrid_epsg3857(text, text, text, numeric);

	CREATE OR REPLACE FUNCTION makegrid_epsg3857(schemaname text, boundingbox text, gridtable text, halfwidth numeric)
	RETURNS text AS
	$BODY$
	DECLARE
	tbl_cnt int;
	XMIN numeric;

	<!DOCTYPE html>
	<html>
	<head>
	<title>
	customhoverwindows \| CartoDB
	</title>

	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8" />

	Water Management Projects with FOSS4G:

	International Water Management Institute, University of Moratuwa, Sri Lanka
	Research & Monitoring
	Evapotranspiration model
	Road condition monitoring
	PyWPS y Grass
	http://www.slideshare.net/HirofumiHayashi/combining-foss4g-open-hardware-for-research-monitoring-in-southern-asia

	San Jose Water Company, USA

	# Change YOUR_TOKEN to your prerender token
	# Change http://example.com (at the end of the last RewriteRule) to your website url

	<IfModule mod_headers.c>
	RequestHeader set X-Prerender-Token "YOUR_TOKEN"
	</IfModule>

	<IfModule mod_rewrite.c>
	RewriteEngine On

	The moon is a harsh mistress - Robert A. Heinlein - 5*
	A canticle for Leibowitz - Walter M. Miller 4*
	Flowers for Algernon - Daniel Keyes 5*
	The Forever War - Joe Haldeman - 4*
	The Stars my destination (also known as Tiger! Tiger!) - Alfred Bester - 5*
	The Road - Cormac Mc Carthy - 4*
	God is Dead - Ron Currie Jr. - 4*
	The world without us - Alan Weisman (not really sci fi, but interesting, anyways) - 4*
	Animal Farm - George Orwell - 5*
	1984 - George Orwell - 5*