chaps

26 ms·

451.
by chaps 2y ago
What a weird take. Arresting someone for reporting a major security vulnerability is pretty shitty thing for a state to do. What you're suggesting is that that's not actually that bad. Same sort of logic that leads to people getti
452.
by chaps 2y ago
Not a constructive comment, but I'm gonna say it anyway: this conversation is perfectly frustrating to watch. Thank you both.
453.
by chaps 2y ago
Going to litigation made sense here because, tbh, I didn't want to deal with the PAC's office taking three years to complete the RFR while never actually understanding the underlying issue. They really stink at interpreting anythi
454.
Losing a 5-year-long Illinois FOIA lawsuit for database schemas(mchap.io)
138 points by chaps 2y ago|37 comments
455.
by chaps 2y ago
The Department of Justice disagrees and voluntarily releases column and table names: https://www.justice.gov/afp/media/1186431/dl?inline=
456.
by chaps 2y ago
I wish it were that easy easy. I'll go more into this specific question in my post, but the short answer is that FOIA does not statutorily require the creation of new records in response to a request. The gov agency creating a descript
457.
by chaps 2y ago
The short answer is yes, you can do this. I've seen this work for emails, where the request is basically, "Give me the most recent email of blah@gov.com". And yeah, the plan was to eventually submit a batch of requests using
458.
by chaps 2y ago
Is your argument that government agencies should also withhold the names of filing cabinet manufacturers? :)
459.
by chaps 2y ago
My first step is to actually finish my post :) But after that, getting a reasonable law passed to fix this now-broken nonsense.
460.
by chaps 2y ago
The DBMS is almost definitely going to be mentioned in RFP or specification documentation. As it was in this lawsuit.
461.
by chaps 2y ago
Hard to say. One of my personal drivers for this lawsuit is a tip I received that said that Chicago has a list of vendors whose tickets are dropped in the back-end. When I requested that info, the city said they had no such list. I trust my
462.
by chaps 2y ago
Not quite, and the details get hairier the closer you look. The database in-question here is an IBM system. The database itself is used for government functions, making it FOIA'able, despite it being managed by a third party company. I
463.
by chaps 2y ago
Yep, that was done in the FOIA request related to this lawsuit: select utc.column_name as colname, uo.object_name as tablename, utc.data_type as type from user_objects uo join user_tab_columns utc on uo.object_name = utc.table_name
464.
by chaps 2y ago
Short answer -- already been done. This (spoiler) visualization's going into my eventual post about the lawsuit: https://observablehq.com/d/026992341cc47ff0
465.
by chaps 2y ago
Hi everyone, I'm the plaintiff in this lawsuit. I'm still working on my companion post for tptacek's post! I'll have it ready Soon TM, but feel free to me any questions in the meantime here. While you're waiting, ch
466.
by chaps 2y ago
Aaaaaaa! I need to finish my post! :(
467.
by chaps 2y ago
I really appreciate this response, thank you. I still think you're making some assumptions about quite a lot of people, eg, a friend of an asylum seekers might join an app together where both friends have vastly different legal situati
468.
by chaps 2y ago
I'm not sure if they are "officially" illegal, but they are most likely waiting on an Asylum or Immigration hearing. Seems like you've jumped from "they only speak spanish" to, "there's a ve
469.
by chaps 2y ago
Do you have any source that would agree with your 30-40%?
470.
by chaps 2y ago
Yes, but you have to submit a request to every single one of those places. And then they have to review and redact them. I've had these policies denied in public records requests because the 800 page document would take many hours of r
471.
by chaps 2y ago
Actually, I will add something to that. In Chicago there are two means of holding individuals accountable to this sort of thing. The first is the local records act, which carries a misdemeanor for intentionally violating the act (ie, destro
472.
by chaps 2y ago
I think you're failing to realize just how few complaints and misconduct are actually looked into in any sort of depth. It's not that "when they look they see things". It's that misconduct happens so frequently that
473.
by chaps 2y ago
You're not talking about officers being fired because it doesn't happen very often :). Your lens is from the now-world where, in any other job, you would be fired 100 times over for actions done by police on a routine basis. It&#x
474.
by chaps 2y ago
Transparency is indeed a large focus of mine, but it's mostly focused on local transparency and not federal.
475.
by chaps 2y ago
"the department is happy to be both rid of a problem officer and not have to put it in the public record just how bad the problem officer was." ...have you not seen the extents that LE agencies and the FOP will go to make sure the
476.
by chaps 2y ago
This is exactly what Oracle does.
477.
by chaps 2y ago
Do you believe that Native Americans should continue receiving the benefits provided by the federal government? Considering that their land was taken and millions of their people were killed during the era of Manifest Destiny, it seems like
478.
by chaps 2y ago
Wasn't meant as an insult, but I'll admit it wasn't kind. It came from a genuine interest in seeing you grow as a person, despite what you might think. To say I've been down on my dumps a few times in the past is an unde
479.
by chaps 2y ago
I hope you never experience homelessness or addiction, but if you do, I hope it humbles you.
480.
by chaps 2y ago
Of course that shit happens on a constant basis and it's silly of you to think that my position isn't that shit happens. Think about it like this: if you had no food, were starving, and the only way to eat for the night is to stea

More ›