project at a time. world, one project at a time. From data visualization to citizen science, it is all about stories that matter From data visualization to citizen science, it is all about stories that matter RECENT WORK Evolution Of Web 2.0 Google Endangered Languages Google GFW 2.0 Prototype World Resources Institute Irekia 2.0 Basque Government Carbon Calculator UNEP-WCMC OldWeather Zooniverse Friday, 28 September 12 member of Vizzuality. Small agency. Madrid and NYC. Data visualization. Working on stories that matter. Here to talk about CartoDB and some of the cool things you can do with it.
Import/export Admin UI and conﬁg Tiler + interactivity API Data API Caching Authentication ... Friday, 28 September 12 hosted geospatial database (postgis) + nice gui to take the grunt work out of our geospatial projects
you might not want to take all of it. There's deﬁnitely a case for taking slices of it” http://www.youtube.com/watch? v=zH5bJSG0DZk&feature=youtu.be&t=2h 44m20s Josh Livni & Chris Broadfoot - Google. SXSW 2012. Friday, 28 September 12
12, 5), Cdb_xyz_resolution(5) * 4, Cdb_xyz_resolution(5) * 4) AS cell) SELECT x, y, Array_agg(c) vals, Array_agg(d) dates FROM (SELECT St_xmax(hgrid.cell) x, St_ymax(hgrid.cell) y, Count(i.cartodb_id) c, Floor(( Date_part('epoch', built) -‐ -‐10418716800 ) / 32837875) d FROM hgrid, us_po_offices i WHERE St_intersects(i.the_geom_webmercator, hgrid.cell) GROUP BY hgrid.cell, Floor(( Date_part('epoch', built) -‐ -‐10418716800 ) / 32837875) ) f GROUP BY x, y Friday, 28 September 12