3 ms·

Fun fact: in some municipalities you can FOIA for the GPS records of police vehicles. Here's Chicago Police's. They removed 0-15mph for, erm, privacy reasons...

• arm32 2mo ago
  That's indeed a very fun fact!
• deleted 2mo ago
  [deleted]
• judge2020 2mo ago
  The speed limit in neighborhoods is usually 25, so... 0-15mph limiting seems useless? I imagine some level of police <-> home address / general home area is in that data.
  • darksim905 2mo ago
    What? Removing 0-15 mph is to remove places where they camp or loiter with the engine on either for tickets, naps, or other purposes.
    • chaps 2mo ago
      Right there's another gotcha with the data. They gave 15-60mph data in :30 minute increments. "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; -- 15mph
    • protocolture 2mo ago
      >other purposes. Just say "Stalking their ex partners" its fine we all know about it in 2026.
• deleted 2mo ago
  [deleted]