kathypennacchio

```
-title: "A visualization of 10 Robin Williams filming locations as a tribute to his life "
-author: "CartoDB team"
```

#A visualization of 10 Robin Williams filming locations as a tribute to his life
```
- center: [34.5970, 10.7227]
- zoom: 2
```

kathypennacchio

```
-baseurl: "https://cartocdn_a.global.ssl.fastly.net/base-light/{z}/{x}/{y}.png"
-title: "Ebola virus disease in West Africa
-author: "Katherine Pennacchio"
-vizjson: "http://team.cartodb.com/api/v2/viz/fef19ffe-1d7c-11e4-97f4-0e230854a1cb/viz.json"
```
 
#Ebola virus disease in West Africa
```

kathypennacchio

clubs['gcz'].css = '#fussballfans_merge { polygon-opacity: 0; line-color: #FFFFFF; line-width:
0.5; line-opacity: 1; polygon-fill: #f7941d; } #fussballfans_merge [ dom2_gcz <= 
32.3844125609574] { polygon-opacity: 0.9;} #fussballfans_merge [ dom2_gcz <= 
0.789733464955576] { polygon-opacity: 0.8;} #fussballfans_merge [ dom2_gcz <= 
0.368822227686255] { polygon-opacity: 0.6;} #fussballfans_merge [ dom2_gcz <= 
0.123331597563727] { polygon-opacity: 0.4;} #fussballfans_merge [ dom2_gcz <= 
0.0289901288611228] { polygon-opacity: 0.2;} #fussballfans_merge [ dom2_gcz = 0] { 
polygon-opacity: 0;} #fussballfans_merge[best="keine"] { polygon-opacity: 0; }'

kathypennacchio

SELECT * FROM sg_2014_07_fussballfans_merge 
WHERE canton IN ('BE','VD','AG','ZH','GR','SO','LU','BL','SG','TG','JU','GE','NE','SZ','SH','AR','UR','ZG','NW','AI','OW','BS','GL') 
AND kt IS NOT NULL

kathypennacchio

cmd
python cartodb-utils.py import -f {{Local File Name}} -   
k {{Your CartoDB API Key}} -u {{your CartoDB Username}}

kathypennacchio

SELECT ST_MakeLine(the_geom_webmercator) 
  AS the_geom_webmercator 
  FROM loomstateviz

kathypennacchio

SELECT ST_MakeLine(the_geom_webmercator) AS the_geom_webmercator FROM loomstateviz

kathypennacchio

-vizjson: 
“http://{your username}.cartodb.com/api/v2/viz/{unique viz ID}/viz.json”

kathypennacchio

SELECT ST_MakeLine(the_geom_webmercator) 
  AS the_geom_webmercator 
  FROM loomstateviz

kathypennacchio

SELECT ST_Buffer(ST_ConvexHull(ST_Union(l.the_geom)), 0.0001) AS the_geom     FROM lots l LEFT JOIN plans p ON p.cartodb_id = l.plan_id
    WHERE p.name = 'PLAN_NAME'