Skip to content

Instantly share code, notes, and snippets.

@ramiroaznar
Last active April 5, 2016 13:39
Show Gist options
  • Save ramiroaznar/8f732220f7626850ca7143917d141728 to your computer and use it in GitHub Desktop.
Save ramiroaznar/8f732220f7626850ca7143917d141728 to your computer and use it in GitHub Desktop.
Points to Line with CartoDB.js
<!DOCTYPE html>
<html>
<head>
<title>Points to Line with CartoDB.js and Leaflet</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" />
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<script src="http://libs.cartocdn.com/cartodb.js/v3/3.15/cartodb.js"></script>
<style>
html, body,#map {
width:100%;
height:100%;
padding: 0;
margin: 0;
}
</style>
</head>
<body>
<div id='map'></div>
<script type="text/javascript">
// declare geom & lines variables
var geom;
var lines;
function main() {
// center and zoom level
var options = {
center: [59.5,-151.5],
zoom: 10,
};
// declare a map object
var map_object = new L.Map('map', options);
// add basemap
L.tileLayer('http://{s}.tile.opentopomap.org/{z}/{x}/{y}.png', {
attribution: 'OpenStreetMaps'
}).addTo(map_object);
cartodb.createLayer(map_object,{
user_name: 'ramirocartodb',
type: 'cartodb',
sublayers: [
{
sql: 'SELECT * FROM kachemakbaysp_track_points',
cartocss: '#kachemakbaysp_track_points{marker-fill: #FF6600;marker-allow-overlap: true;marker-opacity:0.5}'
}
]}).addTo(map_object) // add points layer
.done(function(layer){
// remove points layer
layer.remove();
// cartodb sql api
var sql = new cartodb.SQL({ user: 'ramirocartodb'});
// select the attribute tables to extract from CartoDB table
sql.execute("SELECT ST_asGeoJSON(ST_MakeLine(the_geom ORDER BY track_seg_id ASC)) AS geom, track_fid FROM kachemakbaysp_track_points GROUP BY track_fid")
.done(function(data){
for(i = 0; i < data.total_rows; i++){
geom = data.rows[i].geom; // get geom from row
lines = L.geoJson(JSON.parse(geom),{ // style lines
style:{
color: "red",
weight: 5,
opacity: 0.5
}
});
map_object.addLayer(lines)
}
}); // end sql api call
}); // end createLayer
}
window.onload = main;
</script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment