The task needed to intertwine ABS census data sets & Queensland crime data from the QLD Gov Open Data portal to evaluate trends across districts.
For the data-set “LGA Reported Offences Numbers”, the 89 individual crimes were filtered into 11 main categories:
i. Violent Offences
ii. Sexual Offences
iii. Other Personal Offences
iv. Robbery and Theft
v. Property Offences
vi. Drugs and Alcohol
vii. Prostitution
viii. Weapons Offences
ix. Fraud
x. Driver Offences
xi. Other Minor Offences
The monthly crime data was then surmised by year
Using R and the GGPLOT Library, a map of Queensland was generated and overlayed with the LGA spatial boundaries to form the foundation of a Choropleth Map.
From here an R script was created to fill the map with the appropriate data required by the user:
i. Crime Category (listed above)
ii. Form of Data (per Capita or Total Number)
iii. Year (any selection from 2001 to 2022)
The following census data-sets were acquired:
i. 2021 LGA Populations
ii. 2011 and 2016 WPP (Working Population Profile)
iii. 2011 and 2016 PEP (Place of Enumeration Profile)
This data was used to find unemployment rates for each LGA and to convert the per-capita crime rate to a total number per LGA as needed.
Using R, a ‘Shiny’ App was created to output the data based on customised user inputs in the following two navigation pages:
i. QLD State-wide Overview (to display the previously mentioned Queensland maps)
ii. Local Government Area (to plot the results for an individual LGA along with a trendline which could then be compared to the unemployment data to find any correlations)