Show HN: Palo Alto Police Arrest Reports

[brianhama]

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

[vonunov]

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

[yodon]

Also of interest, a similar site for SF.[0]

[0]https://sfpdcalls.com/

[brianhama]

I’d never seen that site before. It’s nice that SF makes that data available in such a friendly format.

[HenryBemis]

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?

[lcnPylGDnU4H9OF]

> arresting someone doesn't mean that they are guilty, so why out them

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?

[brianhama]

I agree. I’ve always found it strange that mug shots and arrest information are public.