[ Launch: Honolulu Budget Regular Pay ] 53906af9ab2a885f13bb by axelson
[ Launch: Honolulu Budget 3 ] 4a653132d765d7d20f44 by axelson
[ Launch: Honolulu Budget 3 ] 207521894ec530e805eb by axelson
[ Launch: Honolulu Budget 2 ] 393c6689f7606a0c99f0 by bentut
[ Launch: D3 Basics ] 8e0e8350a766a79d97fa by axelson
[ Launch: Jason Test ] 8da7744ab1eb9456929f by axelson
[ Launch: test ] 4653053 by enjalot
[ Launch: test ] 4652017 by enjalot
[ Launch: test ] 4582399 by enjalot
-
-
Save axelson/53906af9ab2a885f13bb to your computer and use it in GitHub Desktop.
Honolulu Budget Regular Pay (no scales)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"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} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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']); | |
}) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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