examples/leaflet_vector.html

<!DOCTYPE html>
<html>
  <head>
    <title>Leaflet vector example | CartoDB.js</title>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
    <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
    <link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />
    <style>
      html, body, #map {
        height: 100%;
        padding: 0;
        margin: 0;
      }
    </style>

    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.2/leaflet.css" />
<!--[if lte IE 8]>
    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.2/leaflet.ie.css" />
<![endif]-->

  </head>
  <body>
    <div id="map"></div>

    <!-- include cartodb.js library -->
    <script src="http://cdn.leafletjs.com/leaflet-0.6.2/leaflet.js"></script>
    <script src="http://libs.cartocdn.com/cartodb.js/v3/cartodb.core.js"></script>
    <script>

      function main() {

        var map = L.map('map', { 
          zoomControl: false,
          center: [43, 0],
          zoom: 3
        })

        var sql = new cartodb.SQL({ user: 'examples', format: 'geojson' });

        L.tileLayer('http://tile.stamen.com/toner/{z}/{x}/{y}.png', {
          attribution: 'Stamen'
        }).addTo(map);

        // create the layer and add to the map, then will be filled with data
        var countriesLayer = L.geoJson().addTo(map);
        //sql.execute("select * from european_countries_e").done(function(geojson) {
          //sql.execute("select * from european_countries_e where area::float > {{area}}", { area: 10000 }).done(function(geojson) {
        sql.execute("select ST_Simplify(the_geom, 2) as the_geom from european_countries_e").done(function(geojson) {


          countriesLayer.addData(geojson);
        });

      }

      window.onload = main;

    </script>
  </body>
</html>