[databeers] 06/05/2014 - javier de la torre: “everything happens somewhere.”
TRANSCRIPT
![Page 1: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/1.jpg)
Everything happens somewhere
@jatorreCartoDB
![Page 2: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/2.jpg)
![Page 3: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/3.jpg)
An Eastern in Leon
![Page 4: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/4.jpg)
http://jatorre-cloud.cartodb.com/api/v2/sql?q=!select sum(ST_Length(the_geom::geography))!
!from procesiones_leon
![Page 5: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/5.jpg)
http://jatorre-cloud.cartodb.com/api/v2/sql?q=!select max(ST_Length(the_geom::geography))!
!from procesiones_leon
![Page 6: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/6.jpg)
![Page 7: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/7.jpg)
![Page 8: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/8.jpg)
![Page 9: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/9.jpg)
1 hour ago
![Page 10: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/10.jpg)
![Page 11: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/11.jpg)
SELECT *,!'http://maps.googleapis.com/maps/api/streetview?size=300x190&location='||!
ST_Y((the_geom))||','||ST_X((the_geom))!||'&sensor=false&fov=110' as image !
FROM table_2012_entire_tree_down_complaints_sandy
![Page 12: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/12.jpg)
![Page 13: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/13.jpg)
![Page 14: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/14.jpg)
![Page 15: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/15.jpg)
![Page 16: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/16.jpg)
![Page 17: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/17.jpg)
![Page 18: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/18.jpg)
![Page 19: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/19.jpg)
![Page 20: [Databeers] 06/05/2014 - Javier de la Torre: “Everything happens somewhere.”](https://reader034.vdocuments.us/reader034/viewer/2022052621/558aa11dd8b42a7d6a8b458e/html5/thumbnails/20.jpg)