Show HN: Palo Alto Police Arrest Reports
9 brianhama 8 3/27/2025, 11:10:26 AM paloaltopolice.org ↗
Extracts case reports from Palo Alto Police department's daily pdf files and displays cases on a map and in a table on the web.
Source code and background on GitHub: brianhama/palo-alto-police-case-reports
Screenshots: https://vgy.me/album/v8fzwq7Z
crontab: https://snippet.host/ymeofo
DB schema (which I'm sure could use some refinement, lol): https://snippet.host/fiyxhr
query one-liners: https://snippet.host/vouqax
[0]https://sfpdcalls.com/
I know that USA doesn't have anything as strong as EU has with GDPR (or EU DPR), but damn.. arresting someone doesn't mean that they are guilty, so why out them? Wouldn't it make more sense to have these records public after a conviction?
Indeed, they are not guilty and the problem lies with the assumption that they must be guilty because they were arrested. It being a matter of public record that (and where/when/why) they were arrested means their loved ones can know what happened to them when they don't come home (even if that means they have to find the answer themselves, though ideally they wouldn't).
Just consider someone very close to you is arrested but there is no public record of that arrest for you to follow up on. What do you do?