Live data from Hacker News

Philadelphia budget data visualization

budget.brettmandel.com

51–60 of 63 posts

Re: Philadelphia budget data visualization

#51
post #37

Nice visualization but HOLY CRAP is that normal for the police department suck up so much of a city's budget?

Try running for office in a city with a platform of "cutting the police budget" and see how far you get...

You could end up with the police union buying the house next door to you, staging protests there and posting signs about how dangerous your making the city. You could even end up finding yourself or relatives followed for their protection as well.

It is not the public someone who wants to run on that platform has to fear

Re: Philadelphia budget data visualization

#52
post #45
post #22

This is a nice visualisation but it's not clear to me what the purpose of it is - other than the immediate "WOW look how much is spent on Police + Prisons!" that struck me. Or is it simply a "check it out, I know what comprises Philadelphia's budget...". I'm a total outsider so I admit it's entirely likely that this means something to folks living there. But either way it would be nice if there was a little blurb on…

If you had been to Philly recently it would make total sense how much money is spent on police and prisons. They're doing yeoman's work making the city habitable again. EDIT: No offense to Philly, but it's by a large margin the most dangerous city with more than 1 million people in the U.S. And that danger isn't as segregated as it is in say Chicago or New York, making policing harder.

Just stay out of North, South, West, and East (Camden) Philly.

Re: Philadelphia budget data visualization

#53

> $1,062,921.12 PANASONIC TB19/2GB/TOUGHB The prisons department needs a lot of toughbooks. How many toughbooks do you get for a million dollars?

265 @$4000. Base price is ~3400, but figure it comes with warranty and service addons and whatnot.

Re: Philadelphia budget data visualization

#54
post #34

Earlier quoted context omitted.

In most cities this also covers revenues, aka tax collection. It would be nice to see the breakdown on how much of the budget is dedicated to collecting taxes to fund the budget.

When you drill down you get to the actual entries in the budget that correspond to the particular thing you are looking at. It was interesting all the Director of Finance salaries of 900K - 1.4M. Seems like a lot of money to pay a civil servant but I may have been misreading the budget item. I was looking at things like this: 192 FICA TAXES 0192 DIRECTOR OF FINANCE - - - 2012 - $1,369,489.56 PPE 07/10/2011 FICA MATCH…

Nothing compared to the $15 million it shows as total compensation for the sheriff. (Don't know how to link it; just go to the farthest-right gray square that touches the bottom of the overall rectangle.)

Re: Philadelphia budget data visualization

#55
post #45

Earlier quoted context omitted.

If you had been to Philly recently it would make total sense how much money is spent on police and prisons. They're doing yeoman's work making the city habitable again. EDIT: No offense to Philly, but it's by a large margin the most dangerous city with more than 1 million people in the U.S. And that danger isn't as segregated as it is in say Chicago or New York, making policing harder.

Just stay out of North, South, West, and East (Camden) Philly.

Due-south/south-east are fine, southwest is awful (~15th and west). West is okay provided you don't go further than, say, 40th. North is a warzone aside from the narrow strip following the Schuylkill river. Fishtown is okay.

Thankfully the Delaware river provides an adequate barrier between east Philly and Baghdad... err, I mean Camden. You can go as far east in Pennsylvania as you like and be fine.

Philadelphia is sort of an inversion of the stereotypical "ghetto in the middle, suburb surrounding" model, the main line being an exception to this.

Re: Philadelphia budget data visualization

#56
post #54

Earlier quoted context omitted.

When you drill down you get to the actual entries in the budget that correspond to the particular thing you are looking at. It was interesting all the Director of Finance salaries of 900K - 1.4M. Seems like a lot of money to pay a civil servant but I may have been misreading the budget item. I was looking at things like this: 192 FICA TAXES 0192 DIRECTOR OF FINANCE - - - 2012 - $1,369,489.56 PPE 07/10/2011 FICA MATCH…

Nothing compared to the $15 million it shows as total compensation for the sheriff. (Don't know how to link it; just go to the farthest-right gray square that touches the bottom of the overall rectangle.)

That's to the Sherriff's department. It's all the salaries of deputies and whatnot. If you click on a box after zoomed in it gives an itemization.

Looks like the Sherriff (Barbara Deeley) had two line items for salary and made about 130k or so.

Re: Philadelphia budget data visualization

#57
post #55

Earlier quoted context omitted.

Just stay out of North, South, West, and East (Camden) Philly.

Due-south/south-east are fine, southwest is awful (~15th and west). West is okay provided you don't go further than, say, 40th. North is a warzone aside from the narrow strip following the Schuylkill river. Fishtown is okay. Thankfully the Delaware river provides an adequate barrier between east Philly and Baghdad... err, I mean Camden. You can go as far east in Pennsylvania as you like and be fine. Philadelphia is s…

I'm moving there next year, so this is quite useful information. Thanks.

Re: Philadelphia budget data visualization

#58
post #37

Earlier quoted context omitted.

Try running for office in a city with a platform of "cutting the police budget" and see how far you get...

You could end up with the police union buying the house next door to you, staging protests there and posting signs about how dangerous your making the city. You could even end up finding yourself or relatives followed for their protection as well. It is not the public someone who wants to run on that platform has to fear

In a city with "1 murder, 2 rapes, 25 robberies, 25 assaults, 35 burglaries, 110 thefts, and 20 stolen cars" PER DAY -- the public is exactly who you'd better be afraid of.

Re: Philadelphia budget data visualization

#59
post #57
post #55

Earlier quoted context omitted.

Due-south/south-east are fine, southwest is awful (~15th and west). West is okay provided you don't go further than, say, 40th. North is a warzone aside from the narrow strip following the Schuylkill river. Fishtown is okay. Thankfully the Delaware river provides an adequate barrier between east Philly and Baghdad... err, I mean Camden. You can go as far east in Pennsylvania as you like and be fine. Philadelphia is s…

I'm moving there next year, so this is quite useful information. Thanks.

No problem! I lived in Philly off and on (mostly on) for 5 or 6 years up until about a year ago. The 'grunge'/grime is probably a bit of a culture shock at first (depending on what you are used to) but it's a pretty nice city once you get over that.

If I were to move back, I would probably outside of the 'city' Philly along the main line. Lowest grime-factor there is, as far as I know.

Re: Philadelphia budget data visualization

#60
post #57
post #55

Earlier quoted context omitted.

Due-south/south-east are fine, southwest is awful (~15th and west). West is okay provided you don't go further than, say, 40th. North is a warzone aside from the narrow strip following the Schuylkill river. Fishtown is okay. Thankfully the Delaware river provides an adequate barrier between east Philly and Baghdad... err, I mean Camden. You can go as far east in Pennsylvania as you like and be fine. Philadelphia is s…

I'm moving there next year, so this is quite useful information. Thanks.

Unless you've got kids or are going to school, I'd live in center city. For a fairly small and completely walkable area, it's got variety, from high rise apartments to "George Washington slept here" houses two blocks south. Best overall option in the city. Or live outside the city, but that's not living in a city.
Post reply on HN