Skip to content

Instantly share code, notes, and snippets.

@acouch
Last active August 29, 2015 14:21
Show Gist options
  • Save acouch/d7db3441937aded63b12 to your computer and use it in GitHub Desktop.
Save acouch/d7db3441937aded63b12 to your computer and use it in GitHub Desktop.
Madison Tree Data and Map
<!doctype html>
<meta charset="UTF8">
<html>
<head>
<title>Madison Tree Types</title>
<link rel="stylesheet" href="http://cdnjs.cloudflare.com/ajax/libs/nvd3/1.1.15-beta/nv.d3.min.css">
<script src="http://cdnjs.cloudflare.com/ajax/libs/d3/3.5.2/d3.js" charset="utf-8"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/nvd3/1.1.15-beta/nv.d3.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.4/jquery.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
<!-- CSS -->
<link rel="stylesheet" type="text/css" href="//cdnjs.cloudflare.com/ajax/libs/chosen/1.1.0/chosen.min.css">
<!-- JS -->
<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/chosen/1.1.0/chosen.jquery.min.js"></script>
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.11/themes/css/cartodb.css" />
<script src="http://libs.cartocdn.com/cartodb.js/v3/3.11/cartodb.js"></script>
<style>
#chart {
height: 200px;
width: 100%;
}
body {
padding: 0 10px;
}
.tab-content {
width: 100%;
}
.pagination {
margin: 5px 0 0 0;
}
.pagination>li>a, .pagination>li>span {
position: relative;
float: left;
padding: 4px 9px;
margin-left: -1px;
line-height: 1.42857143;
color: #337ab7;
text-decoration: none;
background-color: #fff;
border: 1px solid #ddd;
}
.pagination {
margin: 5px 0 0 0;
font-size: 12px;
padding: 0;
float: left;
}
#map { width: 100%; height:500px;}
</style>
<script>
var map;
function init() {
// initiate leaflet map
map = new L.Map('map', {
center: [43.0667,-89.4000],
zoom: 12
});
L.tileLayer('http://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}.png', {
attribution: 'MapBox'
}).addTo(map);
var layerUrl = 'https://dkan.cartodb.com/api/v2/viz/6f588616-d19d-11e4-a931-7054d21a95e5/viz.json';
var sublayers = [];
cartodb.createLayer(map, layerUrl)
.addTo(map)
.on('done', function(layer) {
// change the query for the first layer
var subLayerOptions = {
sql: "SELECT * FROM madison_trees ",
//cartocss: "#ne_10m_populated_p_2{marker-fill: #F84F40; marker-width: 8; marker-line-color: white; marker-line-width: 2; marker-clip: false; marker-allow-overlap: true;}"
}
var sublayer = layer.getSubLayer(0);
sublayer.set(subLayerOptions);
sublayers.push(sublayer);
}).on('error', function() {
//log the error
});
function updateQuery(tree) {
sublayers[0].set({
sql: "SELECT * FROM madison_trees WHERE species = '" + tree + "'",
});
$("h2.tree-type").text(tree);
}
var page = 0;
function search() {
var sql = cartodb.SQL({ user: 'dkan-admin' });
sql.execute("SELECT DISTINCT species FROM madison_trees ORDER BY species ASC").done(function(data) {
items = [];
$.each(data.rows, function(key, value) {
items.push(value.species);
$('#search-select')
.append($("<option></option>")
.attr("value",key)
.text(value.species));
});
$("#search-select").trigger("chosen:updated");
});
}
function graph(page) {
var sql = cartodb.SQL({ user: 'dkan-admin' });
sql.execute("SELECT species, count(species) as count FROM madison_trees group by (species) order by count desc LIMIT 10 OFFSET " + page + "").done(function(data) {
var count = [];
var species = [];
var treeData = [{
key: "Number of Trees",
values: []
}];
var values = []
for (i in data.rows) {
values.push({label: data.rows[i].species, value: data.rows[i].count})
}
var treeData = [{
key: "Number of Trees",
values: values
}];
nv.addGraph(function() {
var chart = nv.models.discreteBarChart()
.x(function(d) { return d.label }) //Specify the data accessors.
.y(function(d) { return d.value })
.staggerLabels(true)
.tooltips(false)
.showValues(true)
.transitionDuration(350)
;
if (page > 1) {
chart.color(['#8ca38b'])
}
chart.yAxis
.tickFormat(d3.format(',.0f'));
chart
.valueFormat(d3.format(',.0f'));
d3.select('#chart svg')
.datum(treeData)
.call(chart);
nv.utils.windowResize(chart.update);
d3.selectAll("g rect")
.on("mouseover", function(d){
updateQuery(d.label)
})
.on("click", function(d){
alert(d.label);
});
return chart;
});
})
}
graph(page);
search();
$('#tabs').on('shown.bs.tab', function () {
$(".chosen-select").chosen();
$(".chosen-select").chosen().change(function() {
var num = +$(this).val()
updateQuery(items[num]);
});
});
$("a.next").click(function() {
page = page + 10;
graph(page);
});
$("a.prev").click(function() {
page = page - 10;
graph(page);
});
}
$('#tabs2').tab();
</script>
</head>
<body onload="init()">
<div class="container"><div class="row">
<h1>Trees of Madison</h1>
<div class="well well-sm">
Scroll over a tree species to see those trees on the map below. Click on a tree for more info about the tree.
</div>
<ul id="tabs" class="nav nav-tabs" data-tabs="tabs">
<li class="active"><a href="#population" data-toggle="tab">Population</a></li>
<li><a href="#search" data-toggle="tab">Search</a></li>
</ul>
<div id="my-tab-content" class="tab-content">
<div class="tab-pane" id="search">
<select class="chosen-select" id="search-select">
<option value=""></option>
<option value="United States">United States</option>
</select>
</div>
<div class="tab-pane active" id="population">
<div id="chart-container">
<nav>
<ul class="pagination">
<li>
<a class="prev" href="#" aria-label="Previous">
<span aria-hidden="true">&laquo;</span>
</a>
</li>
<li>
<a class="next" href="#" aria-label="Next">
<span aria-hidden="true">&raquo;</span>
</a>
</li>
</ul>
</nav>
<div id="chart"><svg></svg></div>
</div>
</div>
<h2 class="tree-type">All Trees</h2>
<ul id="tabs" class="nav nav-tabs" data-tabs="tabs">
<li class="active"><a href="#map-tab" data-toggle="tab">Map</a></li>
<li><a href="#stats" data-toggle="tab">Stats</a></li>
</ul>
<div class="tab-content">
<div class="tab-pane active" id="map-tab">
<div id="map"></div>
</div>
<div class="tab-pane" id="stats">
stats
</div>
</div>
<h2>About</h2>
<div class="well well-sm">
The following visualization is built with data from: <a href="https://dkan.cartodb.com/u/dkan-admin/viz/6f588616-d19d-11e4-a931-7054d21a95e5/map">https://dkan.cartodb.com/u/dkan-admin/viz/6f588616-d19d-11e4-a931-7054d21a95e5/map</a>.
</div>
</div></div>
<script>
</script>
</body>
</html>
<html>
<head>
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.11/themes/css/cartodb.css" />
<script src="http://libs.cartocdn.com/cartodb.js/v3/3.11/cartodb.js"></script>
<style>
html, body {width:100%; height:100%; padding: 0; margin: 0;}
#map { width: 100%; height:100%; background: black;}
#menu { position: absolute; top: 5px; right: 10px; width: 400px; height:60px; background: transparent; z-index:10;}
#menu a {
margin: 15px 10px 0 0;
float: right;
vertical-align: baseline;
width: 30px;
padding: 10px;
text-align: center;
font: bold 15px "Helvetica",Arial;
line-height: normal;
color: #555;
border-radius: 4px;
border: 1px solid #777777;
background: #ffffff;
text-decoration: none;
cursor: pointer;
}
#menu a.selected,
#menu a:hover {
color: #000;
}
</style>
<script>
var map;
function init() {
// initiate leaflet map
map = new L.Map('map', {
center: [43.0820197,-89.35851819999999],
zoom: 8
});
L.tileLayer('https://dnv9my2eseobd.cloudfront.net/v3/cartodb.map-4xtxp73f/{z}/{x}/{y}.png', {
attribution: 'MapBox'
}).addTo(map);
var layerUrl = 'http://documentation.cartodb.com/api/v2/viz/9af23dd8-ea10-11e2-b5ac-5404a6a683d5/viz.json';
var sublayers = [];
cartodb.createLayer(map, layerUrl)
.addTo(map)
.on('done', function(layer) {
// change the query for the first layer
var subLayerOptions = {
sql: "SELECT * FROM ne_10m_populated_p_2 LIMIT 2000",
cartocss: "#ne_10m_populated_p_2{marker-fill: #F84F40; marker-width: 8; marker-line-color: white; marker-line-width: 2; marker-clip: false; marker-allow-overlap: true;}"
}
var sublayer = layer.getSubLayer(0);
sublayer.set(subLayerOptions);
sublayers.push(sublayer);
}).on('error', function() {
//log the error
});
var = 10;
function updateQuery() {
sublayers[0].set({
sql: "WITH cities AS (SELECT cartodb_id, the_geom, the_geom_webmercator, name FROM ne_10m_populated_p_2 ORDER BY the_geom <-> ST_SetSRID(ST_MakePoint("+lon+","+lat+"),4326) ASC LIMIT "+total+") SELECT null as cartodb_id, ST_MakeLine(ST_Transform(ST_SetSRID(ST_MakePoint("+lon+","+lat+"),4326),3857),the_geom_webmercator) as the_geom_webmercator, null as name FROM cities UNION ALL SELECT cartodb_id, the_geom_webmercator, name FROM cities",
cartocss: "#ne_10m_populated_p_2{[mapnik-geometry-type = 1]{text-name: [name]; text-face-name: 'DejaVu Sans Book'; text-size: 12; text-fill: #000; text-allow-overlap: false; text-halo-fill: #FFF; text-halo-radius: 2;} [mapnik-geometry-type = 2]{line-color: white; line-opacity: 0.5;} } "
});
console.log(total);
console.log(sublayers);
}
$('.button').click(function() {
$('.button').removeClass('selected'); $(this).addClass('selected');
total = $(this).attr('id');
updateQuery();
});
}
</script>
</head>
<body onload="init()">
<div id='map'></div>
<div id='menu'>
<a href="#500" id="500" value=500 class="button 500">500</a>
<a href="#100" id="100" value=100 class="button 100">100</a>
<a href="#50" id="50" value=50 class="button 50">50</a>
<a href="#10" id="10" value=10 class="button 10 selected">10</a>
</div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment