Xatpy/index.html

## index.html
<!DOCTYPE html>
<html>
  <head>
    <title>World flags | 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://libs.cartocdn.com/cartodb.js/v3/3.11/themes/css/cartodb.css" />
  </head>
  <body>
    <div id="map"></div>

    <!-- include cartodb.js library -->
    <script src="http://libs.cartocdn.com/cartodb.js/v3/3.11/cartodb.js"></script>

    <script>

      function generateMap(dt) {

        var c_css = "#world_flags{  line-color: #FFF;  line-width: 1;  line-opacity: 1;  polygon-pattern-file: url(https://pbs.twimg.com/profile_images/2020063308/twavatar.png);  polygon-pattern-opacity: 0.7;}";

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

        // add a base layer
        L.tileLayer('https://stamen-tiles-{s}.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.png', {
          attribution: 'Map tiles by <a href="http://stamen.com">Stamen Design</a>, under <a href="http://creativecommons.org/licenses/by/3.0">CC BY 3.0</a>. Data by <a href="http://openstreetmap.org">OpenStreetMap</a>, under <a href="http://creativecommons.org/licenses/by-sa/3.0">CC BY SA</a>.'
        }).addTo(map);

        // add cartodb layer with one sublayer
        cartodb.createLayer(map, {
          user_name: 'xatpy',
          type: 'cartodb',
          sublayers: [{
            sql: "SELECT * FROM world_flags ",
            cartocss: c_css
          }]
        })
        .addTo(map)
        .done(function(layer) {
          console.log('cargado');
          var l = layer.getSubLayer(0);
          l.setSQL("SELECT * FROM world_flags");

          for (var i = 0; i < dt.length; ++i) {
            if ((dt[i].flag != null) && (dt[i].flag != "")){
              console.log(dt[i].name + dt[i].flag);
              c_css += " #world_flags [ name = '" + dt[i].name + "'] {  polygon-pattern-file: url(" + dt[i].flag + ");  polygon-pattern-opacity: 0.8;} ";
            }
          }

          l.setCartoCSS(c_css);
        });
      }

      function main() {

        var dt = [];

        var url = "http://xatpy.cartodb.com/api/v2/sql?q=SELECT name, flag FROM world_flags";

        $.getJSON( url, function (data) {
          for (var i = 0; i < data.rows.length; ++i) {
            dt[i] = data.rows[i];
          }
          generateMap(dt);
        })
      }

      window.onload = main;
    </script>
  </body>
</html>

## thumbnail.png

      
    Raw
  

              thumbnail.png
	<!DOCTYPE html>
	<html>
	<head>
	<title>World flags \| 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://libs.cartocdn.com/cartodb.js/v3/3.11/themes/css/cartodb.css" />
	</head>
	<body>
	<div id="map"></div>

	<!-- include cartodb.js library -->
	<script src="http://libs.cartocdn.com/cartodb.js/v3/3.11/cartodb.js"></script>

	<script>

	function generateMap(dt) {

	var c_css = "#world_flags{ line-color: #FFF; line-width: 1; line-opacity: 1; polygon-pattern-file: url(https://pbs.twimg.com/profile_images/2020063308/twavatar.png); polygon-pattern-opacity: 0.7;}";

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

	// add a base layer
	L.tileLayer('https://stamen-tiles-{s}.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.png', {
	attribution: 'Map tiles by <a href="http://stamen.com">Stamen Design</a>, under <a href="http://creativecommons.org/licenses/by/3.0">CC BY 3.0</a>. Data by <a href="http://openstreetmap.org">OpenStreetMap</a>, under <a href="http://creativecommons.org/licenses/by-sa/3.0">CC BY SA</a>.'
	}).addTo(map);

	// add cartodb layer with one sublayer
	cartodb.createLayer(map, {
	user_name: 'xatpy',
	type: 'cartodb',
	sublayers: [{
	sql: "SELECT * FROM world_flags ",
	cartocss: c_css
	}]
	})
	.addTo(map)
	.done(function(layer) {
	console.log('cargado');
	var l = layer.getSubLayer(0);
	l.setSQL("SELECT * FROM world_flags");

	for (var i = 0; i < dt.length; ++i) {
	if ((dt[i].flag != null) && (dt[i].flag != "")){
	console.log(dt[i].name + dt[i].flag);
	c_css += " #world_flags [ name = '" + dt[i].name + "'] { polygon-pattern-file: url(" + dt[i].flag + "); polygon-pattern-opacity: 0.8;} ";
	}
	}

	l.setCartoCSS(c_css);
	});
	}

	function main() {

	var dt = [];

	var url = "http://xatpy.cartodb.com/api/v2/sql?q=SELECT name, flag FROM world_flags";

	$.getJSON( url, function (data) {
	for (var i = 0; i < data.rows.length; ++i) {
	dt[i] = data.rows[i];
	}
	generateMap(dt);
	})
	}

	window.onload = main;
	</script>
	</body>
	</html>