Skip to content

Instantly share code, notes, and snippets.

@axelson
Created June 1, 2014 00:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save axelson/53906af9ab2a885f13bb to your computer and use it in GitHub Desktop.
Save axelson/53906af9ab2a885f13bb to your computer and use it in GitHub Desktop.
Honolulu Budget Regular Pay (no scales)
Department Name FY 2011 Actual Object Code Name
Budget and Fiscal Services 4064 Holiday Overtime Pay
Budget and Fiscal Services 312285 Non-Holiday Overtime Pay
Budget and Fiscal Services 13653147 Regular Pay
Corporation Counsel 250 Non-Holiday Overtime Pay
Corporation Counsel 4931218 Regular Pay
Customer Services 2660 Holiday Overtime Pay
Customer Services 55830 Non-Holiday Overtime Pay
Customer Services 9753807 Regular Pay
Community Services -1 Holiday Overtime Pay
Community Services 59636 Non-Holiday Overtime Pay
Community Services 7090938 Regular Pay
Design and Construction 86768 Non-Holiday Overtime Pay
Design and Construction 4231 Holiday Overtime Pay
Design and Construction 9456549 Regular Pay
Emergency Management 1101 Holiday Overtime Pay
Emergency Management 505282 Regular Pay
Emergency Management 58495 Non-Holiday Overtime Pay
Enterprise Services 245313 Holiday Overtime Pay
Enterprise Services 8655365 Regular Pay
Enterprise Services 400026 Non-Holiday Overtime Pay
Facility Maintenance 19142508 Regular Pay
Facility Maintenance 162292 Holiday Overtime Pay
Facility Maintenance 1423334 Non-Holiday Overtime Pay
Human Resources 0 Holiday Overtime Pay
Human Resources 4211042 Regular Pay
Human Resources 37457 Non-Holiday Overtime Pay
Information Technology 37088 Holiday Overtime Pay
Information Technology 6959343 Regular Pay
Information Technology 163713 Non-Holiday Overtime Pay
Planning and Permitting 12873542 Regular Pay
Planning and Permitting 59777 Non-Holiday Overtime Pay
Parks and Recreation 300606 Holiday Overtime Pay
Parks and Recreation 27100762 Regular Pay
Parks and Recreation 591983 Non-Holiday Overtime Pay
Transportation Services 0 Holiday Overtime Pay
Transportation Services 4628038 Regular Pay
Transportation Services 222738 Non-Holiday Overtime Pay
Environmental Services 9054505 Non-Holiday Overtime Pay
Environmental Services 36882190 Regular Pay
Environmental Services 1341547 Holiday Overtime Pay
Emergency Services 17958290 Regular Pay
Emergency Services 563386 Holiday Overtime Pay
Emergency Services 4897125 Non-Holiday Overtime Pay
Fire 4638020 Holiday Overtime Pay
Fire 67427324 Regular Pay
Fire 6689604 Non-Holiday Overtime Pay
Police 159931266 Regular Pay
Police 15120019 Non-Holiday Overtime Pay
Police 5645372 Holiday Overtime Pay
Mayor 384505 Regular Pay
Mayor 0 Non-Holiday Overtime Pay
Managing Director 2387 Non-Holiday Overtime Pay
Managing Director 1388729 Regular Pay
Medical Examiner 17741 Holiday Overtime Pay
Medical Examiner 734738 Regular Pay
Medical Examiner 31180 Non-Holiday Overtime Pay
Neighborhood Commission 570565 Regular Pay
Neighborhood Commission 152 Non-Holiday Overtime Pay
Prosecuting Attorney 12913827 Regular Pay
Prosecuting Attorney 260 Holiday Overtime Pay
Prosecuting Attorney 10360 Non-Holiday Overtime Pay
Royal Hawaiian Band 44258 Non-Holiday Overtime Pay
Royal Hawaiian Band 1514864 Regular Pay
{"description":"Honolulu Budget Regular Pay (no scales)","endpoint":"","display":"svg","public":true,"require":[{"name":"d3","url":"http://d3js.org/d3.v3.min.js"}],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"_.md":{"default":true,"vim":false,"emacs":false,"fontSize":12},"config.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"budget.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12},"regularpay.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12},"pay.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"period","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"tab":"edit","display_percent":0.7,"thumbnail":"http://i.imgur.com/coKUQxI.png","fullscreen":false,"ajax-caching":true}
var data = tributary.pay;
//d3.csv("pay.csv", function(data) {
//});
data.forEach(function(d) {
d['FY 2011 Actual'] = parseInt(d['FY 2011 Actual'], 10);
d['FY 2012 Budget'] = parseInt(d['FY 2012 Budget'], 10);
});
console.log("start");
tributary.trace = true;
var margin = {top: 23, right: 20, bottom: 123, left: 74},
width = 489 - margin.left - margin.right,
height = 441 - margin.top - margin.bottom;
var x = d3.scale.linear().range([ 0, width])
var y = d3.scale.linear().range([height, 0]);
var xAxis = d3.svg.axis()
.scale(x)
.orient("bottom")
.tickFormat(d3.format("$.2s"));
var yAxis = d3.svg.axis()
.scale(y)
.orient("left")
.tickFormat(d3.format("$.2s"));
var svg = d3.select("svg")
.attr("width", width + margin.left + margin.right)
.attr("height", height + margin.top + margin.bottom)
.append("g")
.attr("transform", "translate(" + margin.left + "," + margin.top + ")");
function get_division(d) { return d['Department Name']; }
var divisions = data;
var max_y_val = d3.max(divisions, function(d) {
return d['FY 2011 Actual'];
});
var max_x_val = d3.max(divisions, function(d) {
return d['FY 2012 Budget'];
});
console.log("max x value is " + max_x_val);
//debugger;
//max_y_val = 10000000
//max_y_val = 71944965401
//max_x_val = 17065861;
y.domain([0, max_y_val]);
x.domain([0, max_x_val]);
x_axis = svg.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + height + ")")
.call(xAxis)
x_axis
.append("text")
.attr("x",height)
.attr("text-anchor","end")
.attr("dy", -10)
.text("Overtime Pay")
x_axis
// Rotate x-axis label
.selectAll("text")
.style("text-anchor", "start")
.attr("dx", ".8em")
.attr("dy", ".15em")
.attr("transform", "rotate(65)");
svg.append("g")
.attr("class", "y axis")
.call(yAxis)
.append("text")
.attr("transform", "rotate(-90)")
.attr("y", 6)
.attr("dy", ".71em")
.style("text-anchor", "end")
.text("Pay");
svg.selectAll("path").attr("fill","none").attr("stroke","#CCC")
svg.selectAll("line").attr("fill","none").attr("stroke","#CCC")
svg.selectAll("text").attr("fill","#828282")
svg.append("text").attr("class", "readout").attr("x", 200).attr("y",50)
var division = svg.selectAll(".division")
.data(divisions)
.enter().append("g")
.attr("class", "g")
division.append("circle")
.attr("r",11.04)
.attr("fill-opacity", 0.3)
.on("mouseover", function(d) {
console.log(d)
d3.select(this).attr("fill","red")
d3.select("text.readout").text(d.key)
})
.on("mouseout", function(d) {
d3.select(this).attr("fill","black")
d3.select("text.readout").text("")
})
.attr("cx", function(d) {
return x(d['FY 2012 Budget']);
})
.attr("cy", function(d) {
return y(d['FY 2011 Actual']);
})
Department Name Object Code Name FY 2011 Actual FY 2012 Budget
Police Regular Pay 159931266 163823022
Fire Regular Pay 67427324 71931144
Environmental Services Regular Pay 36882190 52177404
Parks and Recreation Regular Pay 27100762 36024825
Facility Maintenance Regular Pay 19142508 31926076
Emergency Services Regular Pay 17958290 20471028
Budget and Fiscal Services Regular Pay 13653147 18072844
Design and Construction Regular Pay 9456549 18051876
Planning and Permitting Regular Pay 12873542 16975608
Prosecuting Attorney Regular Pay 12913827 14549388
Customer Services Regular Pay 9753807 12137482
Enterprise Services Regular Pay 8655365 11743332
Community Services Regular Pay 7090938 10039268
Information Technology Regular Pay 6959343 8557560
Transportation Services Regular Pay 4628038 6471752
Corporation Counsel Regular Pay 4931218 5424948
Human Resources Regular Pay 4211042 5180424
Royal Hawaiian Band Regular Pay 1514864 1884048
Managing Director Regular Pay 1388729 1865260
Medical Examiner Regular Pay 734738 1074816
Emergency Management Regular Pay 505282 780264
Neighborhood Commission Regular Pay 570565 662760
Mayor Regular Pay 384505 437940
Department Name Object Code Name FY 2011 Actual FY 2012 Budget
Budget and Fiscal Services Regular Pay 13653147 18072844
Corporation Counsel Regular Pay 4931218 5424948
Customer Services Regular Pay 9753807 12137482
Community Services Regular Pay 7090938 10039268
Design and Construction Regular Pay 9456549 18051876
Emergency Management Regular Pay 505282 780264
Enterprise Services Regular Pay 8655365 11743332
Facility Maintenance Regular Pay 19142508 31926076
Human Resources Regular Pay 4211042 5180424
Information Technology Regular Pay 6959343 8557560
Planning and Permitting Regular Pay 12873542 16975608
Parks and Recreation Regular Pay 27100762 36024825
Transportation Services Regular Pay 4628038 6471752
Environmental Services Regular Pay 36882190 52177404
Emergency Services Regular Pay 17958290 20471028
Fire Regular Pay 67427324 71931144
Police Regular Pay 159931266 163823022
Mayor Regular Pay 384505 437940
Managing Director Regular Pay 1388729 1865260
Medical Examiner Regular Pay 734738 1074816
Neighborhood Commission Regular Pay 570565 662760
Prosecuting Attorney Regular Pay 12913827 14549388
Royal Hawaiian Band Regular Pay 1514864 1884048
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment