As a crime statistician, I want to retrieve only those crime records that could be required by the Clery Act, so that my research time is reduced.

[paulhennings]

Clery Act lists the following crimes:
(I) murder;
(II) sex offenses, forcible or nonforcible;
(III) robbery;
(IV) aggravated assault;
(V) burglary;
(VI) motor vehicle theft;
(VII) manslaughter;
(VIII) arson;
(IX) arrests or persons referred for campus disciplinary action for...
liquor law violations,
drug-related violations, and
weapons possession
(ii) hate crimes
(iii) of domestic violence,
dating violence, and
stalking
Need to select distinct Category, Description and map to the above categories.
Also, need to evaluate Resolution contains "ARREST" for IX.

[paulhennings]

Cross-reference to Issue #3

[paulhennings]

Next Steps

1. Review/Revise/Approve "Proposed_Category_Description_Resolution_Mapping_to_PossibleCleryCategory" GSheet posted to Slack.
2. Determine best coding method to add the new mapped column "PossibleCleryCategory" to the result set.
3. Add new column "PossibleCleryCategory" to queried results set. Make the new column available to the map, so the icons can vary by PossibleCleryCategory (see Develop icons for different crime incident categories #11 ), so the user can filter by PossibleCleryCategory, etc. (see Allow filtering by category type #3).

[joeysk2012]

Julia and I are working on this at Open data day please assign to us.