5,340 karma · joined November 14, 2019
You'll do great.
Also, show proof.
Like I would love to go to law school but I can't afford it. So many possible but inherently unattainable futures. We'll get there.
Should private prisons be FOIA'able just like public prisons?
heh as a foia nerd, heh.
"This would still identify officers blocks or get within a couple blocks of their home for those with take home cars. Would speeds of 15 miles per hour or more but only pings on the :30 minute mark, so one ping per hour from 2019 until the end of April work for you?"
Even gave them this SQL to run to get around that problem but they never got back to me, heh:
WITH immobile_pings as (
select count(*), vehicleid, round(xcoord::numeric, 3) as xcoord_rounded,
round(ycoord::numeric,3) as ycoord_rounded,date_trunc('day', datetime) as day
FROM gps_table
WHERE speed = 0
GROUP BY
vehicleid,
xcoord_rounded,
ycoord_rounded,
day
having count(*) > 1440), --4 hours
day_counts as (
select count(*), vehicleid, xcoord_rounded, ycoord_rounded
from immobile_pings
group by vehicleid, xcoord_rounded, ycoord_rounded having count(*) > 15 -- 15 days
)
select gps_table.* from gps_table s inner join day_counts i
ON i.vehicleid = s.vehicleid
AND array[round(s.xcoord::numeric, 3), round(s.ycoord::numeric, 3)] != array[i.xcoord_rounded,i.ycoord_rounded]
AND speed > 15; -- 15mphHave a glance:
https://www.dropbox.com/scl/fo/hj4jtcag2i9qvl4sj6mg2/AF6c9r7...
It took 8mo for Chicago Police to review and redact bodycamera footage from a protest in Chicago. It was 95% blurred. Almost hilariously, one of the only parts that wasn't blurred was a moment where one cop commented on another cop's mustache.
So from the FOIA perspective, the public isn't able to get gobs and gobs of footage just because it's public.
The front fell off because the base was never built to support a shakeup of the industry. There's so little support, now and for as long as I can remember, for people to fail gracefully in the field. It's just up up up. And now that programmers are finding their jobs to be a little more precarious, maybe folk will start supporting mentorship as a practice.
This isn't just a "market" problem. It's a problem of people not teaching others skills that help them thrive inside AND outside of work.
I'm talking about the random schmos out there who don't know what "ALPR" even is. These folk are more and more learning about what these things are and pushing back on them.
There's no malintent with it, it just means that the public conversation hasn't gotten to a point where these distinctions can easily be made to a wider audience. We'll get there.
I was very fortunate to get a job in a NOC a little bit after high school where I learned things one'd expect to learn in an entry level job. The team I worked on was all about mentorship, learning, and building people to the next level.
Haven't seen that attitude elsewhere in my entire career except in the non-profit world where I reside these days. It blows me away that people are surprised that these industries have failed to build entry level positions.
This, "just run these three commands" attitude is exactly the reason why these curl|sh "installers" have become popular.
(Actually yeah. Chicago Police uses an on-prem 3rd party blackbox fax service to avoid those records being FOIA'able. But that's beside the point.)