Upgrade to Pro — share decks privately, control downloads, hide ads and more …

CartoDB application building tutorial

CartoDB application building tutorial

Here we build a basic application that shows a lot of the different APIs and methods for CartoDB. While the final application isn't exactly how we would do it for production, it is a good learning tool.

Andrew W Hill

August 29, 2012
Tweet

More Decks by Andrew W Hill

Other Decks in Education

Transcript

  1. All the information contained in this tutorial is available in

    a GitHub repo: https://github.com/ Vizzuality/CartoDB-Tutorials/ tree/master/nyc-rising-seas Contents
  2. SELECT nycb2000.cartodb_id, min(elevation) FROM nycb2000,elevation WHERE st_intersects( nycb2000.the_geom, elevation.the_geom )

    GROUP BY nycb2000.cartodb_id Find the MINIMUM (in case there are multiple) elevation reading for every census block in NYC