13 ms·

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

• darksim905 1mo 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 1mo 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 1mo ago
    >other purposes. Just say "Stalking their ex partners" its fine we all know about it in 2026.