3 ms·
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
by mingos_ 1y ago
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?
- notjoemartinez 1y agoIncident 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.
- mingos_ 1y agothank 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/ https://www.opportunityatlas.org/) or the roadway report (https://roadway.report/beta https://roadway.report/beta). you could also add colored markers to filter by incident type, frequency, etc.