Skip to content

Instantly share code, notes, and snippets.

@ebrelsford
Last active March 28, 2017 14:32
Show Gist options
  • Save ebrelsford/020e7b50b5e017ffb61b66b8135ce5a4 to your computer and use it in GitHub Desktop.
Save ebrelsford/020e7b50b5e017ffb61b66b8135ce5a4 to your computer and use it in GitHub Desktop.
Start map with custom SQL with Carto.js v3
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8' />
<script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
<!--
Load Carto's code so we can pull in our Carto maps.
-->
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<style>
html, body {
height: 100%;
margin: 0;
padding: 0;
width: 100%;
}
#map {
height: 100%;
width: 100%;
}
</style>
</head>
<body>
<div id="map"></div>
<script>
var dataLayer;
$(document).ready(function () {
cartodb.createVis('map', 'https://thenewschool.carto.com/u/brelsfoeagain/api/v2/viz/b1dd3eb7-dc48-4dff-8d31-948b2f451cf6/viz.json')
.done(function (vis, layers) {
dataLayer = layers[1].getSubLayer(0);
// Immediately set the SQL on the layer. We do this here because setting the SQL
// in Builder is an Analysis so doesn't work with Carto.js v3.
dataLayer.setSQL("SELECT * FROM watsan WHERE watsan = 'urban_agriculture'");
});
});
</script>
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment