SF 311 Case Source Distribution

<!DOCTYPE html>
<meta charset="utf-8">
<style>

body {
  font: 10px Arial, Helvetica, sans-serif;
  background-color: #eff2ef;
}

marquee {
  font: 10px Arial, Helvetica, sans-serif;
  background-color: #eff2ef;
}

.axis path,
.axis line {
  fill: none;
  stroke: #000;
  color: black
  shape-rendering: crispEdges;
}

</style>
<body>
<script src="//d3js.org/d3.v3.min.js"></script>
<script>

var margin = {top: 20, right: 20, bottom: 30, left: 90},
width = (990),
height = 500 - margin.top - margin.bottom + 50;

var y = d3.scale.ordinal()
    .rangeRoundBands([height, 0], .1);

var x = d3.scale.linear()
    .rangeRound([0, width * 0.82]);

var color = d3.scale.ordinal()
    .range(["#66c2a5","#fc8d62","#8da0cb","#e78ac3","#a6d854","#ffd92f","#b3b3b3","#e5c494"]);

var parsedate = d3.time.format("%x %X %p").parse;

var yAxis = d3.svg.axis()
    .scale(y)
    .orient("left");

var xAxis = d3.svg.axis()
    .scale(x)
    .orient("bottom")
    .tickFormat(d3.format(".1%"));

var opens = 0;
var closes = 0;

var today = new Date(parsedate("03/23/2016 8:00:00 AM"));

var tooltip = d3.select("body")
  .append("div")
  .style("top", "600px")
  .style("left", "120px")
  .style("position", "absolute")
  .style("z-index", "10")
  .style("font-size", "16px") 
  .style("font-family", "Arial, Helvetica, sans-serif")
  .text("");

var loader = d3.select("body")
  .append("marquee")
  .style("top", "200px")
  .style("font-size", "16px") 
  .style("font-family", "Arial, Helvetica, sans-serif")
  .text("Loading, be paitent...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................");

var svg = d3.select("body").append("svg")
    .attr("width", (width + margin.left + margin.right))
    .attr("height", height + margin.top + margin.bottom + 50)
    .append("g")
    .attr("transform", "translate(" + margin.left + "," + margin.top + ")");
var total;

d3.csv("https://raw.githubusercontent.com/lyndonclarke/311Sources/master/dated_source_data.csv", function(a){
    a.Open = new Date(parsedate(a.Opened));
    if (a.Closed != ""){
      a.Closed = new Date(parsedate(a.Closed));
      if(a.Open.getMonth != a.Closed.getMonth){
        if(a.getYear() == 2016){
          if(a.getMonth() == 2 || a.getMonth() == 3){
              a.Closed = today;
          }
        }
        if(daysBetween(a.Open, a.Closed) > 30){
          a.Status = "Closed";
        }
      }
    } 
    else{
      a.Closed = undefined;
    }
    return a;
    
  }
  , function(error, data) {
  if (error) throw error;

})

years.forEach(function(d) {
    var y0 = 0;
    d.sources = color.domain().map(function(name) {
      var rationame = name + " ratio";
      var ratio = 1;
      if(d[rationame] != undefined){
        ratio = d[rationame];
      }
      var width = +d[name];
      var open = width * ratio;
      var closed = width - open;
      return {name: name, y0: y0, y1: y0+= open, y2: y0 += closed, cases: d.reports, num: Math.floor((+d[name] / d.reports) * 10000) / 100, ratio: 100 - (Math.floor(ratio * 10000) / 100), year: d.key}; 
    });
    d.sources.forEach(function(d){ d.y0 /= y0; d.y1 /= y0; d.y2 /= y0});
    d.total = d.sources[d.sources.length - 1].y2;
  });

years.sort(function(a, b) { return b.key - a.key; });

y.domain(years.map(function(d) { return d.key; }));

svg.append("text")
        .attr("x", (width / 2))             
        .attr("y", 0)
        .attr("text-anchor", "middle")  
        .style("font-size", "16px") 
        .text("Source and Resolution Rate of 311 Cases by Year");

svg.append("g")
      .attr("class", "x axis")
      .attr("transform", "translate(0," + height + ")")
      .call(xAxis)
      .append("text")
      .attr("y", 39)
      .attr("x", width / 2)
      .style("text-anchor", "middle")
      .text("Percentage of Total Cases");

svg.append("g")
      .attr("class", "y axis")
      .call(yAxis)
    .append("text")
      .attr("y", -14)
      .attr("dy", ".71em")
      .style("text-anchor", "end")
      .text("Year");
  
  var year = svg.selectAll(".source")
      .data(years)
    .enter().append("g")
      .attr("class", "g")
      .attr("transform", function(d) {return "translate(0, " + y(d.key) + ")"; });

var yearEnter = year.selectAll("rect")
      .data(function(d){
        total = d.total;
        return d.sources; 
      })
    .enter();

yearEnter.append("rect")
      .attr("width", function(d) {
        
        return x(d.y1) - x(d.y0);
      })
      .attr("x", function(d) { return x(d.y0);})
      .attr("height", function(d){ return y.rangeBand();})
      .style("fill", function(d) { return LightenDarkenColor(color(d.name), 30); })
      .on("mouseover", function(d){
        var me = d3.select(this);
        me.style("fill", LightenDarkenColor(color(d.name), -30));
        tooltip.text(d.name + " reported " + d.num + "% of the " + d.cases +" cases in " + d.year + ", " + d.ratio + "% were closed within 30 days")
      })
      .on("mouseout", function(d){
        var me = d3.select(this);
        me.style("fill", LightenDarkenColor(color(d.name), 30));
      });

yearEnter.append("rect")
      .attr("width", function(d) {
        
        return x(d.y2) - x(d.y1);
      })
      .attr("x", function(d) { return x(d.y1);})
      .attr("height", function(d){ return y.rangeBand();})
      .style("fill", function(d) { return color(d.name); })
      .on("mouseover", function(d){
        var me = d3.select(this);
        me.style("fill", LightenDarkenColor(color(d.name), -30));
        tooltip.text(d.name + " reported " + d.num + "% of the " + d.cases +" cases in " + d.year + ", " + d.ratio + "% were closed within 30 days")
      })
      .on("mouseout", function(d){
        var me = d3.select(this);
        me.style("fill", color(d.name));
      });

var legend = svg.selectAll(".legend")
      .data(color.domain())
    .enter().append("g")
      .attr("class", "legend")
      .attr("transform", function(d, i) {return "translate(0," + i * 20 + ")"; });

legend.append("rect")
      .attr("x", width - 25)
      .attr("width", 18)
      .attr("height", 18)
      .style("fill", function(d){ return LightenDarkenColor(color(d), 30);});

legend.append("rect")
      .attr("x", width - 7)
      .attr("width", 18)
      .attr("height", 18)
      .style("fill", function(d){ return color(d);});

legend.append("text")
      .attr("x", width - 30)
      .attr("y", 9)
      .attr("dy", ".35em")
      .style("font-size", "10x") 
      .style("text-anchor", "end")
      .text(function(d) { return d });

svg.append("text")
    .attr("x", width - 155)
    .attr("y", 180)
    .style("font-size", "11px") 
    .style("text-anchor", "start")
    .text("Lighter: Open After 30 Days");

svg.append("text")
    .attr("x", width - 155)
    .attr("y", 200)
    .style("font-size", "11px") 
    .style("text-anchor", "start")
    .text("Darker: Closed Within 30 Days");

loader.remove();
});
//Taken from https://css-tricks.com/snippets/javascript/lighten-darken-color/
function LightenDarkenColor(col, amt) {
    var usePound = false;
    if (col[0] == "#") {
        col = col.slice(1);
        usePound = true;
    }
    var num = parseInt(col,16);
 
    var r = (num >> 16) + amt;
 
    if (r > 255) r = 255;
    else if  (r < 0) r = 0;
 
    var b = ((num >> 8) & 0x00FF) + amt;
 
    if (b > 255) b = 255;
    else if  (b < 0) b = 0;
 
    var g = (num & 0x0000FF) + amt;
 
    if (g > 255) g = 255;
    else if (g < 0) g = 0;
 
    return (usePound?"#":"") + (g | (b << 8) | (r << 16)).toString(16);
  
}

//Taken from https://stackoverflow.com/questions/1036742/date-difference-in-javascript-ignoring-time-of-day
function daysBetween(first, second) {

// Copy date parts of the timestamps, discarding the time parts.
    var one = new Date(first.getFullYear(), first.getMonth(), first.getDate());
    var two = new Date(second.getFullYear(), second.getMonth(), second.getDate());

// Do the math.
    var millisecondsPerDay = 1000 * 60 * 60 * 24;
    var millisBetween = two.getTime() - one.getTime();
    var days = millisBetween / millisecondsPerDay;

// Round down.
    return Math.floor(days);
}

</script>

https://d3js.org/d3.v3.min.js