[ddj] Open data murder tracker in Trinidad and Tobago

[Gerard Best]

Thanks Rosie, For some reason I hadn't though about it!


On Mon, Feb 3, 2014 at 6:58 PM, Rosie Williams <budgetaus at hotmail.com>wrote:

> Have you thought about using Ushahidi?
> http://www.ushahidi.com/
>
> Rosie Williams BA (Sociology)
> Founder & Developer InfoAus.net
>    ABN 90 345 143 783
>                        Home <http://infoaus.net> | Blog<http://infoaus.net/wp>
>   | Twitter <https://twitter.com/Info_Aus> | BudgetAus FB<https://www.facebook.com/pages/Expenseaus/244247399060027?ref=hl>
>   <http://www.facebook.com/budgetaus>| eXpenseAusFB<https://www.facebook.com/pages/Expenseaus/244247399060027?ref=hl>
>  | BudgetAus <http://infoaus.net/budget/budget_home.php> | eXpenseAus<http://infoaus.net/budget/expenses/expenses_home.php>|
> KnowYourPlace <http://infoaus.net/seifa/seifa_home.php> | InfoAus Shop<http://www.cafepress.com/infoaus>
>
>
>
> ------------------------------
> Date: Fri, 31 Jan 2014 14:09:39 -0400
> From: gerardbest at gmail.com
> To: data-driven-journalism at lists.okfn.org
> Subject: [ddj] Open data murder tracker in Trinidad and Tobago
>
>
> Hello all,
>
> INTRO
> I'm on a team working on a open data journalism project called Bullet
> Points and I'm hoping you can lend your collective experience/expertise to
> the project.
>
> Bullet Points tracks murders in Trinidad and Tobago. The murders are
> tracked on a Google doc here: http://tinyurl.com/bulletpoints2014
>
> The fatal incidents are listed chronologically and are numbered by victim
> (murder toll). The victims are announced on Twitter (
> twitter.com/bulletpoints_) by their toll number. This system has some
> serious limitations.
>
> PROBLEM
> Firstly, it is geared toward tracking the murder victims but is an
> inadequate way of tracking the actual killings themselves. For example,
> when there is a double murder, the toll goes up by two but the number of
> incidents goes up by only one.
>
> Secondly, killings do not always occur in the same chronological order
> that the victims' bodies are discovered. Sometimes bodies of murder victims
> are discovered after several days. When this happens, the relevant killing
> must be inserted somewhere in the middle of the existing chronological
> list, which obviously changes the toll count of all subsequent victims.
> Unfortunately, because our current system relies on the toll count to
> identify the victim, it has now run into this serious limitation.
>
> PROPOSED SOLUTION
> I think that what I need to do is add another column that contains a
> unique reference number for each incident. The unique reference number can
> follow a standard protocol such as [DATE][INTEGER]. For example, the most
> recent murder, which was discovered today, would have a reference number
> 2014013001. I think this will deal with the problem but I am not sure it
> is the best solution.
>
> Thanks for taking the time to read this. If you think you can help, I
> would be grateful for your perspective on this problem and proposed
> solution.
>
> --
> ---
> Gerard Best
>
> _______________________________________________ data-driven-journalism
> mailing list data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalismUnsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
>
>


-- 
---
Gerard Best
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20140408/d193eb4a/attachment-0002.html>