from Hacker News

Show HN: Palo Alto Police Arrest Reports

by brianhama on 3/27/25, 11:10 AM with 8 comments

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

by vonunov on 3/30/25, 10:05 AM
For Dallas PD active calls:
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
by yodon on 3/27/25, 3:11 PM
Also of interest, a similar site for SF.[0]
[0]https://sfpdcalls.com/
by HenryBemis on 3/27/25, 7:29 PM
Whoah.. name, surname, date of birth.
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?