Jorge Sanz jsanz

This CSV serves as a look up table to relate GRIDCODE field with the corresponding Köppen-Geiger classification and the color used on the paper.

I used this table to create this map

More info:

14.0000km to Dubai

This SQL is an experiment to play with Postgis ST_LineInterpolatePoint function and other SQL tricks to generate a points dataset that travels from a starting point in Dubai to several cities all over the world and under a distance similar the coverage of a long distance flight (between 14 an 15 thousand kilometres).

This SQL is the main part of this CartoDB Visualization.

The SQL is separated in several dataset constructions using the WITHclause so the approach is:

Example derived from the official demo but disabling the sanitization of the infowindow to allow custom uris to the Spotify app.

If you visit the original visualization the infowindow header is orange and the uri is sanitized and it doesn't work, but if you visit this page the infowindow is replaced by a new one with an orange header and the uris are not sanitized and work.

	<!doctype html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
	<title>Geolocation example</title>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<style>
	html, body, #map {

	<!doctype html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
	<title></title>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.14/themes/css/cartodb.css" />
	<style>

	<!DOCTYPE html>
	<html>
	<head>
	<title>Named Map with Interactivity \| CartoDB.js</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" />
	<style>
	html, body, #map {
	height: 100%;


	<!doctype><html><head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title>Odyssey.js Slides</title>
	<meta name="description" content="">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">

	<link rel="icon" type="image/x-icon" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
	<link rel="icon" type="image/png" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">

	<html>
	<head>
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.15/themes/css/cartodb.css" />
	<style>
	html, body {width:100%; height:100%; padding: 0; margin: 0;}
	#map { width: 100%; height:100%; background: black;}
	#menu { position: absolute; top: 5px; right: 10px; width: 115px; height:60px; background: transparent; z-index:10;}
	#menu a {
	margin: 10px 5px 0 0;
	float: right;