Skip to content

Instantly share code, notes, and snippets.

@ramiroaznar

ramiroaznar/index.html

Last active July 28, 2017 13:17
Show Gist options
  • Save ramiroaznar/d2ec0405fd979962655a54799e7765c4 to your computer and use it in GitHub Desktop.
Save ramiroaznar/d2ec0405fd979962655a54799e7765c4 to your computer and use it in GitHub Desktop.
Download ZIP
featureClick + closest points + CARTO.js
Raw
index.html
<!DOCTYPE html>
<html>
<head>
<title>featureClick + closest points + CARTO.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="https://cartodb.com/assets/favicon.ico" />
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
<style>
html, body, #map {
height: 100%;
padding: 0;
margin: 0;
}
</style>
</head>
<body>
<!-- map div -->
<div id="map"></div>
<!-- legend div -->
<div class='cartodb-legend category'>
<div class="legend-title" style="color:#284a59">Cities</div>
<ul>
<li><div class="bullet" style="background-color:#5F4690"></div>Populated Place</li>
<li><div class="bullet" style="background-color:#1D6996"></div>Admin. 1 Capital</li>
<li><div class="bullet" style="background-color:#38A6A5"></div>Admin. 0 Capital</li>
<li><div class="bullet" style="background-color:#0F8554"></div>Admin. 1 region Capital</li>
<li><div class="bullet" style="background-color:#73AF48"></div>Scientific Station</li>
<li><div class="bullet" style="background-color:#EDAD08"></div>Admin. O region Capital </li>
<li><div class="bullet" style="background-color:#E17C05"></div>Admin. 0 Capital Alt.</li>
<li><div class="bullet" style="background-color:#CC503E"></div>Historic Place</li>
<li><div class="bullet" style="background-color:#94346E"></div>Meteorological Station</li>
</ul>
</div>
<script type="text/cartocss" id="style">
#layer {
marker-width: 5;
marker-fill: ramp([featurecla], (#5F4690, #1D6996, #38A6A5, #0F8554, #73AF48, #EDAD08, #E17C05, #CC503E, #94346E), ("Populated place", "Admin-1 capital", "Admin-0 capital", "Admin-1 region capital", "Scientific station", "Admin-0 region capital", "Admin-0 capital alt", "Historic place", "Meteorological Station"), "=");
marker-fill-opacity: 0.7;
marker-allow-overlap: true;
marker-line-width: 0;
}
</script>
<script type="text/sql" id="query">
SELECT * FROM populated_places WHERE pop_max > 250000
</script>
<script>
function main() {
// get styles & query
style = $("#style").text(),
query = $("#query").text(),
// declare map variable
map = L.map('map', {
zoomControl: false,
center: [41, -3],
zoom: 3
});
// add basemap
L.tileLayer('http://{s}.basemaps.cartocdn.com/light_nolabels/{z}/{x}/{y}.png', {attribution: '&copy; <a href="http://www.openstreetmap.org/copyright">OpenStreetMap</a> contributors, &copy; <a href="http://cartodb.com/attributions">CARTO</a>'}).addTo(map);
// add cartodb layer
cartodb.createLayer(map, {
user_name: 'ramirocartodb',
type: 'cartodb',
sublayers: [{
sql: query,
cartocss: style,
}]
}).addTo(map)
.done(function(layer){
// declare sublayer variable
var cityLayer = layer.getSubLayer(0);
// get coordinates
map.on('click',
function(e){
var latitude = e.latlng.lat;
var longitude = e.latlng.lng;
console.log("You clicked the map at latitude " + latitude + ", and longitude " + longitude + ".");
// set new query
var new_query = query + " ORDER BY the_geom <-> ST_SetSRID(ST_MakePoint(" + longitude + ", " + latitude + "), 4326) LIMIT 10";
// get 10 closest cities
cityLayer.setSQL(new_query);
console.log("The 10 closest cities to your selected location are:")
var sql = cartodb.SQL({ user: 'ramirocartodb' });
sql.execute(new_query)
.done(function(data) {
var cities = data.rows;
_.each(cities, function(city, index, cities) {
console.log(city['name']);
});
})
.error(function(errors) {
console.log("Something went wrong!")
})
});
});
}
window.onload = main;
</script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment