News for hackers. Stuff that matters.
Re:Show HN: Real-time emergency incident maps from police/fi... by mingos_ on Sunday April 13, 2025 @01:03PM (#43674194)
This is so cool - it reminds me of the police scanner apps but with a visual and searchable. Can't wait to see more departments added.

How are you storing the transcripts for each report and how long would you store the reports?

Re:Show HN: Real-time emergency incident maps from police/fi... by notjoemartinez on Sunday April 13, 2025 @01:16PM (#43674290)
Incident metadata and transcripts are stored in a PostgreSQL db indefinitely. We've logged over 250k incidents since January. Planning on combining the incident data with other sources for historical analysis, search and such.
Re:Show HN: Real-time emergency incident maps from police/fi... by mingos_ on Sunday April 13, 2025 @03:06PM (#43675081)
thank you

I like that you're adding historical analysis - it reminds me of some similar ideas I've seen in the past, like the opportunity atlas (https://www.opportunityatlas.org/) or the roadway report (https://roadway.report/beta).

you could also add colored markers to filter by incident type, frequency, etc.