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:

CartoDB users training

First session: Introduction to CartoDB

Thi session is oriented for unexperienced users on CartoDB. It will also present a short introduction to the platform as well as their main components and principal use cases.

Overview:

Upload and data management
Editing and querying data on the platform

Get ready for elections workshop

With Jorge Sanz (@xurxosanz - [email protected]), materials from Mamata Akella (@mamataakella) and Andy Eschbacher (@MrEPhysics)

Slides here

Part 1: Importing our Datasets

We are going to be using a dataset of 2012 Presidential Election Results from Data.gov. To make it easier tonight, we made a simplified version.

Taller mapas electorales con CartoDB

En este taller se describe el proceso de creación de diversos mapas electorales con CartoDB, enfocado sobre todo al tratamient o de los datos y las reglas de simbolización cartográfica.

http://bit.ly/cdb-elecciones-151203

Contacto:

Default CartoDB infowindows are rendered using moustache.js templates. The variables you can pass are normally used to render data on the infowindow but you can also use them on other parts of the markup, like using them as CSS property styles to apply to element sizes or colours.

On this map, the infowindow show the percentage of votes of the three most voted parties by municipality. Apart from showing the result as a number, and thanks to some SQL juggling (check the complete query on this cdb-fiddle) you can also have a bar with the representative color of the party and a proper width.

See below the details of the infowindow templat

Small utility to geocode using the nice Mapzen Search geocoder.

This tool simply encodes the first argument and passes it to curl. The result is passed to jq to extract the first result and then using json2csv converts the array result into a couple of coordinates.

So using it is as easy as:

% geocode.sh "valencia"
"Valencia, Municipio Valencia, Venezuela",-68.00765,10.16202,0.947
% geocode.sh "valencia,spain"

On this style example we load a Torque layer that uses a SVG marker. This option is at this moment not available at the CartoDB editor so you need to edit the layer CartoCSS after selecting your options.

	<!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>
	<title>Named Maps Tutorial \| CartoDB</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 {

	<!DOCTYPE html>
	<html>
	<head>
	<title>Named Maps Tutorial \| CartoDB</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 {