discussion / Software and Mobile Apps  / 14 June 2021

Looking for - Intelligence Database Software

I work for an anti-poaching organization (https://rhino-force.org/) with a reasonably successful intelligence arm that makes around ~70 wildlife-related arrests each year. We are looking to ramp up this side of our work and part of that is an easy-to-use, affordable database to store profiles of suspects, linking them to incidents, firearms, and more suspects. 

The functions I foresee would not be complex, things like:

- Flexible categories for data input

- Export/import to excel

- Entity and relationship visualisation

- Allows for temporal and spatial data e.g. views over certain time periods, maps with markers.

SMART Profiles would fulfill 90% of our desired functions but we find SMART profiles to be unfortunately quite slow even with low data. Does anyone know of a database program they would recommend? 

Thank you very much in advance!

 




Hi Dexter,

In case you have not found your solution yet: I don't know of an off the shelf solution for what you need, but it seems to me that any more or less developed relational database software can do the core of what you are looking for.

You'll need to develop the database application to model (perhaps people from Hemmersbach can help with that) and store what data you want to capture about suspects, incidents, firearms and what have you.

Export to XL should be a no-brainer .

Entity-relationship visualization (I think you mean networks of suspects, firearms, etc.) is not easy for such softwares, but exporting the data and then importing to a network visualizer (GEPHI perhaps) should be possible.

For temporal and spatial data you would do something similar. Don't let the database software do it (unless it has a plugin or extension for it) but export to Geographical Information System software. I can not suggest any, but there must be plenty of that around, probably even open source/freeware.

If you insist on having it all integrated, then that is probably possible, but you'll have to pay a developer for it.

Hopefully this helps

Frank