Slashdot Mirror


Serious Design Failure At USAspending.gov?

theodp writes "Over at Intelligent Enterprise, Seth Grimes declares the Federal Government's USAspending.gov website a travesty, calling it 'almost a parody of a government-transparency site.' Among the faults cited by Grimes is a botched 'Federal Spending FY 2009 YTD' pie chart that graced USAspending.gov's home page. Not only were the sizes of pie segments not in proportion to the percentage labels (due to a Google Chart API error), the colors in the pie chart didn't even match the colors and values in the table immediately below the chart. Lucky for the Feds, Grimes didn't get a chance to look behind the curtain at the Federal IT Dashboard, where they forgot to remove a (commented) reference to a Google spreadsheet that states 'These totals are pretty poor numbers' (Google workbook). Oops!"

38 of 207 comments (clear)

  1. Criticize the Numbers Not the Presentation by eldavojohn · · Score: 5, Insightful

    Having never done this before, the government is bound to have problems. All of them do when they try new things. I can bear with them for some incorrectly rendered pie charts or -- gasp! -- an informative comment about the numbers being pretty poor. Sorry to sound so apologetic but I'll give the idea of transparency and A and the implementation a C-. So what? The numbers are there.

    Because what did we have before? Data via third parties that had to use a FOIA and sit and wait for it? Numbers that were years old? Or we had to visit 50 state sites that were all laid out differently and aggregate the data? And we're ripping on usaspending.gov for design flaws? Okay, from a web developer's standpoint these are pretty egregious errors but so what?

    At least it reads "These totals are pretty poor numbers." and not "We really had to cook the books to get this to look right." Hell, now you know where to start looking if you want to do what you should be doing: criticizing the government based on their spending and IT (mis)management!

    How would you react if the next president did away with usaspending.gov? Happy that the travesty of a parody site is gone?

    --
    My work here is dung.
    1. Re:Criticize the Numbers Not the Presentation by synthparadox · · Score: 3, Informative

      I agree. When I first read the title, "Serious" jumped out at me (possibly with the assistance of being the first word), and luckily for me I actually RTFA'd. Speaking for myself and more than likely any one who's done any web programming, a minor mistake of data passing being in the incorrect format for the Google APIs to digest is much much less than a "serious" design failure. In fact, its not a design failure at all. Its a code error, and luckily (or possibly unluckily) for the guys at USAspending.gov, Google's APIs don't just segfault out and crash the page, instead they try to parse it in a "is this what you wanted?" sort of way.

      TL:DR - its not serious, its not a design failure, its a coding bug, and as TFA says its a 2-3 line fix. Not newsworthy if you ask me.

    2. Re:Criticize the Numbers Not the Presentation by garcia · · Score: 4, Insightful

      In the end, the graphical representation of data is nearly always skewed, whether intentionally or not and in the end, as long as the underlying data is available (and many time, especially in government it is not) you can do you own charts to determine what is correct.

      While the layperson (or CEO) likes pretty pictures and big flashy dashboards that have little green and red and black arrows to show what's going on, it's not transparent until you can get your hands on the data itself. Being that I have fought with local governments and state/federally funded groups for years to give me the underlying data (and not some self-created aggregation), I applaud any effort to give us what we need.

      Yay.

    3. Re:Criticize the Numbers Not the Presentation by Gazzonyx · · Score: 4, Interesting
      Seriously.

      We should be happy that they even were aware that their numbers were poor. That means that someone is, at the least, paying attention if not objectively analyzing the data. The fact that it is a government agency makes it that much more astounding (IE. it's not going to make a difference in their paycheck or pension most likely).

      --

      If I mod you up, it doesn't necessarily mean I agree with what you've said, sorry.

    4. Re:Criticize the Numbers Not the Presentation by Runaway1956 · · Score: 3, Interesting

      Heh. I read the bit about incorrect colors and sizes of pie slices, and laughed. I can't read a color coded chart anyway. GIVE ME A BAR GRAPH DAMMIT! Better yet, just post the numbers. ;^)

      --
      "Windows is like the faint smell of piss in a subway: it's there, and there's nothing you can do about it." - Charlie Br
    5. Re:Criticize the Numbers Not the Presentation by noidentity · · Score: 2, Informative

      It[']s a code error, and luckily (or possibly unluckily) for the guys at USAspending.gov, Google's APIs don't just segfault out and crash the page, instead they try to parse it in a "is this what you wanted?" sort of way

      It should at least flag these errors (see Postel's Law). Maybe it does; just wanted to note that there is something between "reject" and "accept without even a warning".

    6. Re:Criticize the Numbers Not the Presentation by ljaszcza · · Score: 5, Insightful

      I agree that the title is inflammatory. But. I'll take issue with the statement "The numbers are there". Well, the numbers are wrong. So, they are not useful unless you do a lot of work to figure out the errors. Then there is the issue of the govt. releasing the contract to revamp the recovery.gov website. Almost entirely redacted and given to someone (Smartronix), a company that specializes in security, does not even mention web design on it's page... (http://www.nextgov.com/nextgov/ng_20090803_2176.php). A $18m contract. All this does not bode well for transparency and accountability. I suppose what really bites is that if I were to produce incorrect data for a IRS inspector, my life would probably be destroyed by fines and reprisals. I can just imagine giving the IRS redacted copies of my business contracts. The fun would be short lived. Why do we, the citizens and taxpayers, accept this crap from people that want to run more and more of our lives? /rant

    7. Re:Criticize the Numbers Not the Presentation by LKM · · Score: 2, Insightful

      And that is different from private company exactly not at all. There's a reason why both CEOs and politicians often tend to be sociopaths whose main goal seems to be to fill their own coffers. It's not unique to the government at all.

      The government screws up. So do private companies. The government does great things. So do private companies. I've yet to see objective data telling me that private companies are inherently better at something compared to "the government". Both are run by humans.

      In fact, where comparisons can be made because something is done by both the government and by private companies (train systems, health service, road service), the government typically tends to kick private companies' asses. That's not to say that I want to live in communist russia, quite the opposite. Private companies offer the advantage of competition; no government can tolerate a competing government. My point is merely that governments aren't inherently worse than private companies. Both have their place; private companies make sense where competition is possible and useful, governments make sense where competition is impossible or hurtful.

    8. Re:Criticize the Numbers Not the Presentation by LKM · · Score: 2, Informative

      What healthcare lies are you referring to? Perhaps the lies spread by the Republicans? You can hardly blame the administration for those.

    9. Re:Criticize the Numbers Not the Presentation by Daniel+Dvorkin · · Score: 4, Insightful

      Government managers don't routinely get hundred-million-dollar golden parachutes for losing billions of dollars and costing tens of thousands of people their jobs, either. If you really think industry is any better at rewarding good performance and punishing bad performance, you're delusional.

      --
      The correlation between ignorance of statistics and using "correlation is not causation" as an argument is close to 1.
    10. Re:Criticize the Numbers Not the Presentation by Bigby · · Score: 2, Informative

      When it is a problem in the private industry, people stop investing and/or the company goes bankrupt. It took government to bail them out and basically support the rewarding of bad performance. Meanwhile, government can print money and increase taxes without any kind of "check" in the marketplace.

    11. Re:Criticize the Numbers Not the Presentation by Daniel+Dvorkin · · Score: 3, Insightful

      Private companies pay executives for the associated risks for being executives.

      Risk? What risk, exactly? Company does well: executives get fat bonuses and their stock options increase in value. Company does badly: executives get giant golden parachutes. There is no penalty for failure at the boardroom level.

      --
      The correlation between ignorance of statistics and using "correlation is not causation" as an argument is close to 1.
  2. oookay by nomadic · · Score: 4, Informative

    Read the blog article, and I think that a better title for this slashdot article would be "minor design failure."

  3. Whatever. by Anonymous Coward · · Score: 4, Funny

    It's good enough for Government work.

  4. The Important Thing is Existence by steve_thatguy · · Score: 4, Interesting

    In terms of government it is considerably harder to make bring these things into existence and to remove them once they're already there. Changing it after it already exists is trivial. And that's what's important and significant about this: it exists. The general population has facilitated access to something that was obscure and hidden behind a wall of government before. This may not seem like much but I think the successful creation of this type of transparency throughout the government, and if possible embedding it systemically into government processes, that we will see a great improvement in terms of freedom, success, and efficiency of our government.

    It's similar to the way open source applications always get bugs patched faster than commercial implementations--crowdsourcing is a good way to catch errors. That will undoubtedly apply to government as well, especially when many politicians make their living relying on their practices being obscured from the public.

  5. A step in the right direction by proslack · · Score: 4, Interesting

    One of the first items on USAspending's page states "A journey towards greater Transparency and Accountability...". Seems to me like the site is a work in progress and will improve with time.

    --


    Floating in the black seas of infinity without a paddle.
    1. Re:A step in the right direction by sakdoctor · · Score: 3, Funny

      Seems to me like the site is a work in progress and will improve with time

      Then where is the digging_man.gif? Where is are the road cones with flashing beacons, or the web 2.0 equivalent, the beta status?
      No. This must be assumed to be a finished website and judged "as is"

  6. Re:Design Failure? by insertwackynamehere · · Score: 2, Funny

    Light you say? Folks I think we have an Illuminatus in our midst.

  7. They are merely tallying points by Shivetya · · Score: 3, Insightful

    its not like they are out to be serious. If they were the same government promising more openness would not be ramming near trillion dollar bills through Congress without a chance for public discussion, let alone reading of by the voting parties.

    then again, change might mean soliciting bids for a system to systematically scrape all non-hidden data on popular sites like facebook and myspace https://www.fbo.gov/index?s=opportunity&mode=form&id=eec856940efb75b2b1c11e2b1d5660a4&tab=core&_cview=0&cck=1&au=&ck=

    Change we can believe in, with all these CZARs the only thing apparent is that the public isn't paying attention to the other hand

    --
    * Winners compare their achievements to their goals, losers compare theirs to that of others.
    1. Re:They are merely tallying points by M.+Baranczak · · Score: 3, Informative

      a system to systematically scrape all non-hidden data on popular sites like facebook and myspace

      Did you even read that link? The job it describes consists of archiving all the web content produced by the EOP (Executive Office of the President). Where does it say anything about facebook or myspace? Is it after the secret paragraphs that talk about the death panels and hiding the President's birth certificate?

  8. Looks like a typical IT contractor job.. by ErichTheRed · · Score: 2, Insightful

    If you're in IT long enough, you've probably seen a million sites and software packages like this in use at large companies. In my experience, this is usually the result of a low-bid IT contractor getting a last-minute request to slap something together. Of course, in-house resources can screw things up badly too, but high-dollar consulting/contracting deals seem to have a special knack for it. Some places have great results with outsourcing/contracting, but others make it impossible to get high-quality work done in a reasonable time.

    It sucks that something as public as the federal spending-accountability website has obvious problems, but how much time do you think whoever won that contract got to get the site live?

    I'd be interested in hearing from an MBA-type about what the actual rationale for hiring third party IT help is. I know it's usually driven by raw costs and the fact that "IT's not strategic." But what is it that's actually taught in business school that has every executive that drives the whole outsourcing push? Or is it really just "my golf buddy is doing it at his company."?

    Disclaimer: In the government case, I can definitely see the need for contract help. Projects would probably have a really hard time surviving administration changes, internal squabbles, etc.

  9. Can't write HTML.... by aitala · · Score: 5, Informative

    The site's pages don't even have a proper BODY or HTML close tags..

    Jeez.

    Eric

    --
    Eric Aitala
    www.f1m.com
    1. Re:Can't write HTML.... by themacks · · Score: 4, Informative

      Not to mention the 253 errors from the W3C Validation site.

      --
      i read about it in a blog once
    2. Re:Can't write HTML.... by themacks · · Score: 2, Informative

      and this makes it ok to write sloppy code? amazon's site doesn't even declare a doctype.


      in case you were wondering its my second time on the internet

      --
      i read about it in a blog once
  10. Bugzilla? by should_be_linear · · Score: 2, Interesting

    How about adding Bugzilla to that site? Here is one feature request: I would like to see contract sums by company (yes, I am interested in overall amount going to Microsoft).

    --
    839*929
    1. Re:Bugzilla? by kevinNCSU · · Score: 4, Informative

      You mean something like this?

      Microsoft Contracts

      I mean come on, the search by contractors was only one click from the main page ;)

    2. Re:Bugzilla? by should_be_linear · · Score: 2, Interesting

      +1, thanks. Interesting fact: They are eating $2.5B/year, and 90% of that money is "Not competed for an allowable reason".

      --
      839*929
    3. Re:Bugzilla? by kevinNCSU · · Score: 2, Informative

      Actually, my mistake, this is the correct link:

      Microsoft Corporation Contracts

      The initial search (linked in parent) for some reason included the "United States Government" in the search results for Microsoft as a parent company.

  11. Pie Charts by chrb · · Score: 4, Interesting

    I'm surprised the guy rips into the bug calling the Google API and even says "Here's the government's chart done right" without mentioning that piecharts are a bad way to represent comparative data like this in the first place 3D pie charts may look fancy, but they make it more difficult to compare the actual data (which is supposed to be the whole point of plotting it). They are even worse than 2D barcharts, at least with 2D you are only looking at data being relative to slice area, and not being rendered at an angle - look at the edge in the plot he uses, there's as much if not more purple on display as the supposedly larger green slice. What's wrong with a bar chart for visualising comparative data like this? Surely it would give the reader a much more informed quick overview of spending?

    1. Re:Pie Charts by DrVomact · · Score: 2, Insightful

      piecharts are a bad way to represent comparative data like this in the first place...3D pie charts may look fancy, but they make it more difficult to compare the actual data (which is supposed to be the whole point of plotting it)

      Give that man a cigar. This is exactly what I thought when I looked at the .gov page: this is no worse than any other Power Point presentation I've sat through. The real problem isn't some error in the algorithm that draws the pie, but in the notion that tarting up a graph by making it 3-D somehow makes it better. Of course, the opposite is true—in art, perspective is used to create an illusion of depth in a 2-D medium. But illusion is precisely what we don't want in the visual representation of data! Because artistic perspective distorts the presented object (in this case, our pie), it's much harder to judge the relative size of the pieces. In fact, how do we even know that this is a circular pie? Most pies I've eaten were circular, but maybe this one is elliptical, perhaps with the major axis perpendicular to the plane surface it's been projected on.

      It's not just pie charts that are misused in this way; the same thing can be said about just any type of 3D chart that's commonly used in presentations and reports for business or government organizations—the effects of perspective make it difficult or impossible to tell what is really going on. Consequently, these "visual aids" do not clarify data, but obfuscate it.

      Some critics blame this on PowerPoint and similar tools (like this one provided by Google), and it's true that these tools make it easy to produce bad visual representations of data. The most vociferous and articulate of these critics is Edward Tufte, who goes so far as to blame the Challenger shuttle disaster on PowerPoint (take a look at Tufte's web page about PowerPoint, or better yet, buy his books!). I wouldn't go quite as far as Tufte; these tools are just like any tools; they can be used ineptly or deceptively, just as they can be used to clarify and enlighten. The real problem lies in the managerial culture that dominates both American business and government. This culture pretends to be rational and "scientific", as defined by whatever management fads are current, but it's not really interested in serious thought or analysis, just in keeping up appearances. So I don't think 3D charts are going away any time soon.

      --
      Great men are almost always bad men--Lord Acton's Corollary
  12. Re:I'm a conservative by JSBiff · · Score: 2, Insightful

    Certainly any real problem, no matter how minor, is more important than a non-existant problem you just made up, right?

  13. Re:I'm a conservative by JSBiff · · Score: 2, Informative

    How's that *any* different than now? See, what I see is people crying and whining that we shouldn't have any form of government/universal health coverage (even a 'basic' health plan, which could then be supplemented by private insurance, or if you prefer, completely opt out of the public program and buy fully private healthcare), because you make the claim that resources are finite, so therefor, someone's gonna die because the government decides it's 'not worth paying for'.

    How exactly, do private health insurance companies get around the lack of infinite resources? Your statement can easily be turned around and directed at the private insurance companies: "There are not infinite resources. Some people will have their health care yanked so others will live. Surely you don't think that resources are infinite?"

    It appears that, in your world, the lack of infinite resources is an insurmountable problem for a public healthcare plan, but magically, private insurance companies have infinite resources? What about all the people who are getting sick and/or dieing simply because they have no healthcare, so the only option for them is to go to the emergency room when it's already too late, and too expensive? What about the people who get screwed by the penny-pinchers at the health insurance companies who deny their legitimate claims?

    Surely, a problem which universally affects both private and public healthcare plans, cannot be used as an argument against *either* of them?

  14. Serious Troll Failure at that article by spectro · · Score: 2, Insightful

    That guys trolls about "major design flaws" on a website that was slapped together within a month of President Obama taking office... gimme a break.

    The fact that a government operation was able to put that information out that quickly is just impressive and unprecedented.

    I wonder if TFA author would be able to put together a website of such scope and functionality in such short amount of time... and without any bugs when he claims to have "spent way too much time" troubleshooting just the pie chart.

    Maybe he works for the shop that came second on the bid?

    --
    HTML is obsolete. It's time for a new, simpler and richer markup language.
  15. With a grain of salt by Twillerror · · Score: 3, Interesting

    The govt. always gets highly critizied. Or even when someone is just making a simple obersvation it all of the sudden becomes a "slam".

    Can you imagine if companies had to bear this sort of total public critisim. How many companies have stupid errors on there website, menus, marketing, or anything else and we don't get upset.

    I just take it with a grain of salt and hope things get better. The govt. isn't going to be perfect becuase it's ran by human beings...just like everything else.

  16. newness is not an excuse in this case by sbma44 · · Score: 5, Informative

    I work at the Sunlight Foundation, where we're pretty familiar with the people and data systems powering USASpending.gov. I've seen a lot of comments here saying that the important thing is that the government is publishing something, and that it's understandable that their first pass might not be perfect.

    But this isn't their first pass. The underlying data systems -- FAADS and FPDS -- have existed since the 90s, and have been riddled with errors throughout their existence. Instead of fixing the problems, OMB continues to slap new coats of paint on the same lousy data.

    It's nice that we've got a new USASpending.gov, and I agree that it would be a mistake to put too much emphasis on a buggy visualization. But the underlying data is terrible, and so far no one is showing the will to fix it. Just look at USASpending's "data quality" tab -- it talks about the completeness of each row. Well, that's great, but it tells you nothing about the thousands upon thousands of missing rows, nor about the rows that massively under- or over-report their dollar amounts.

    At Subsidyscope, the project on which I work, we've delved into these problems in more depth. Those who'd like to learn more about the shortcomings of the data systems powering USASpending can find a discussion of the relevant issues here.

  17. Re:Pie Chart = Transparency? by iivel · · Score: 2, Informative

    Like this? http://www.usaspending.gov/fpds/tables.php?tabtype=t2&subtype=t&year=2009 Or any of the other easily available charts on the site...

  18. Missing the biggest outflows by JDS13 · · Score: 2, Insightful

    The whole exercise is a political manipulation anyway. The largest government outlays - the so-called entitlements - are omitted from the chart. Medicare, Social Security, and reimbursements to states for social services are not shown on these charts. Those items constitute more than half of Federal spending - that's where your tax dollars go - but they're completely omitted in this analysis.

  19. Re:Pay Attention Here... by Daniel+Dvorkin · · Score: 2, Funny

    So tell me, how much transparency do you get from your insurance company?

    --
    The correlation between ignorance of statistics and using "correlation is not causation" as an argument is close to 1.