In Chicago, there was a system being developed in partnership with University of Chicago to make city-owned database schemas open to the public through a PHP web app.
The system cost 300k to develop, was never finished, and was quietly put into forever-maintenance mode after a few years of use.
As a general rule, Government is pretty bad with tech projects and their associated costs.
But now take a step back and think about it: the actual problem is probably pretty simple. If the databases are well made, it would just take a few requests for this operation to be done. Even with the tests, that's one or two programmers' job for two weeks, and maybe one week of a partial review of results by a legal specialist to validate the quality.
Imagine if the state had two in-house programmers up to this task available. $195,000 would cover their salary for a year.
> and the consequences when there's a system failure, e.g. lawsuits
Another saving grace for doing things in house: you take actions internally. You can correct very quickly, shuffle incompetent people, save all the litigation costs and the bad faiths over misinterpretation of a SoW.
(from experience in the private sector)
That's what a well-funded public task force looks like.
In such a case, a manager would look at the schedule, reserve the time necessary for this dev, take into account the other missions of the devs and get it done.
Is a 100k salary the norm for people writing DB queries in the US? That sounds a lot.
Yeah but writing the code is not what's expensive on this project.
A few years ago the Supreme Court of the State of Ohio undertook a multi-year data warehouse project to build a centralized reference database for all state courts. I assisted the vendor in our County and easily had a significant fraction of that $50K in my labor over a period of a couple of years.
[0] http://www.pacourts.us/ [1] https://ujsportal.pacourts.us/
Government IT is good at building things like this. They suck at large projects and ops.
> The state police used a vendor to build their program, at an estimated cost of $195,000, and the courts used in-house tech experts at an estimated cost of $50,000.
I don't have any experience in government IT, but even in corporate terms, this seems relatively cheap given the scope and lifetime of the system (though I'm assuming these stated costs don't include maintenance and ongoing operation) and the consequences when there's a system failure, e.g. lawsuits.