CartoDB + Marker File + Bootstrap SQL Selector by wboykinm

index.html

<!DOCTYPE html>
<html>
  <head>
    <style>
      html, body, #map {
        height: 100%;
        padding: 0;
        margin: 0;
      }

    #layer_selector {
        position: absolute;
        top: 20px;
        right: 20px;
        padding: 0;
      }
     
    </style>

    <link rel="stylesheet" href="//libs.cartocdn.com/cartodb.js/v2/themes/css/cartodb.css" />
    <link rel="stylesheet" href="//geosprocket.com/assets/bootstrap/css/bootstrap.css" />
    <!--[if lte IE 8]>
        <link rel="stylesheet" href="//libs.cartocdn.com/cartodb.js/v2/themes/css/cartodb.ie.css" />
    <![endif]-->

  </head>
    
  <body>
    <div id="map"></div>
    <div id="layer_selector" class="cartodb_infobox btn-group">
         <a class="btn dropdown-toggle" data-toggle="dropdown" href="#">Type de Culture
             <span class="caret"></span>
         </a>
         <ul class="dropdown-menu">
             <li><a href="#" data="tout" class="selected">Tout</a></li>
             <li><a href="#" data="ble">Ble</a></li>
             <li><a href="#" data="fourr">Fourrage</a></li>
             <li><a href="#" data="jache">Jacherre</a></li>
             <li><a href="#" data="mais">Mais</a></li>
         </ul>
    </div>
  </body>

  <!-- include cartodb.js library -->
  <script src="//libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script>
  <script src="//geosprocket.com/assets/bootstrap/js/bootstrap.min.js"></script>
  <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>

  <script>

    // create layer selector
    function createSelector(layer) {
      var sql = new cartodb.SQL({ user: 'dai' });

      var $options = $('#layer_selector li');
      $options.click(function(e) {

        // get the area of the selected layer
        var $li = $(e.target);
        var crop = $li.attr('data');

        // deselect all and select the clicked one
        $options.removeClass('selected');
        $li.addClass('selected');

        // create query based on data from the layer
        var query = "select * from ag_survey_2011";
        if(crop !== 'tout') {
          query = "select * from ag_survey_2011 where " + crop + " > 0 ";
        }

        // change the query in the layer to update the map
        layer.setQuery(query);
      });
    }

    function main() {
      cartodb.createVis('map', '//dai.cartodb.com/api/v1/viz/11330/viz.json', {
          tiles_loader: true,
          center_lat: 34.88593094075317,
          center_lon: -3.0322265625,
          zoom: 10
      })
      .done(function(vis, layers) {
        // layer 0 is the base layer, layer 1 is cartodb layer
        createSelector(layers[1])
      })
      .error(function(err) {
        console.log(err);
      });


    }

    window.onload = main;

  </script>


</html>