Jorge Sanz jsanz

## index.html
<!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" />


## getCurrentView.js
//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());
}

## cartocssmaker.js
//node script for generating complex cartoCSS for torque
//as value increases, duration of marker gets longer,
//radius gets larger, and color moves up the ramp.

var breaks = [0,10,50,100]
var colors = ['#eff3ff','#bdd7e7','#6baed6','#2171b5'];

var data = {
  "tableName":"#nepaltrends",
  "valueCondition":0,

## change_log.sql
--
-- Create a table in your CartoDB editor called 'version_control'
-- Run the following SQL in your editor to create the needed columns
--

ALTER TABLE version_control ADD COLUMN data json;
ALTER TABLE version_control ADD COLUMN source_id integer;
ALTER TABLE version_control ADD COLUMN table_name text;
ALTER TABLE version_control ADD COLUMN tg_op text;

## hasadna.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              2 stars
            
          
                auremoser
                / hasadna.md
            
            
              Last active
              August 29, 2015 14:24
            
              
                Hasadna Workshop
              
          
    Hasadna: Pollution Mapping + CartoDB

Aurelia Moser, CartoDB
Workshop - Hasadna, IL
July 6, 2015
Find this document here:

Stackedit:


## speed.sql
WITH deltas as (
   SELECT
  	st_distance(the_geom::geography, lag(the_geom::geography, 1) over(order by timestamp)) as ddist,
    timestamp - lag(timestamp, 1) over(order by timestamp) as dt
   from out_2 offset 1000
)

select avg(ddist/dt) as speed from deltas

## harvest_a_game.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                andrewxhill
                / harvest_a_game.ipynb
            
            
              Last active
              September 1, 2015 12:38
            
              
                Use Goldberry to harvest a single basketball game and push it to CartoDB. WARNING This will pull ~2-3,000,000 points, so probably not for your typical free CartoDB account :)
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## harvard_workshop.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              5 stars
            
          
                andrewxhill
                / harvard_workshop.md
            
            
              Last active
              September 30, 2015 17:26
            
          
    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


## review.sh
###########################################################################
# Script per automatitzar la revisió de traduccions d'OSGeo-Live
###########################################################################
#
# Converteix a UTF8, treu el BOM, converteix CRLF a UNIX, copia els nous
# continguts al checkout local del repo, compila els html i els obre en FF.
#
# Llavors cal: revisar l'aspecte visual de cada document, corregir-lo si
# convé, i fer 'svn commit'.
#

## gist:4183609
{
	"color_scheme": "Packages/Color Scheme - Default/Monokai.tmTheme",
	"font_size": 10,
	"highlight_line": true,
	"rulers": [80,120],
	"draw_minimap_border": true
}
	<!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" />
	//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());
	}
	//node script for generating complex cartoCSS for torque
	//as value increases, duration of marker gets longer,
	//radius gets larger, and color moves up the ramp.

	var breaks = [0,10,50,100]
	var colors = ['#eff3ff','#bdd7e7','#6baed6','#2171b5'];

	var data = {
	"tableName":"#nepaltrends",
	"valueCondition":0,
	--
	-- Create a table in your CartoDB editor called 'version_control'
	-- Run the following SQL in your editor to create the needed columns
	--

	ALTER TABLE version_control ADD COLUMN data json;
	ALTER TABLE version_control ADD COLUMN source_id integer;
	ALTER TABLE version_control ADD COLUMN table_name text;
	ALTER TABLE version_control ADD COLUMN tg_op text;
	WITH deltas as (
	SELECT
	st_distance(the_geom::geography, lag(the_geom::geography, 1) over(order by timestamp)) as ddist,
	timestamp - lag(timestamp, 1) over(order by timestamp) as dt
	from out_2 offset 1000
	)

	select avg(ddist/dt) as speed from deltas
	###########################################################################
	# Script per automatitzar la revisió de traduccions d'OSGeo-Live
	###########################################################################
	#
	# Converteix a UTF8, treu el BOM, converteix CRLF a UNIX, copia els nous
	# continguts al checkout local del repo, compila els html i els obre en FF.
	#
	# Llavors cal: revisar l'aspecte visual de cada document, corregir-lo si
	# convé, i fer 'svn commit'.
	#
	{
	"color_scheme": "Packages/Color Scheme - Default/Monokai.tmTheme",
	"font_size": 10,
	"highlight_line": true,
	"rulers": [80,120],
	"draw_minimap_border": true
	}