Constructing the model variables

A location, (P) can be described as a bivariate coordinate expression (x,y), but for this purpose, P is operationalised as the approximate city address. The  number of  SJPD visits to the location P is the dependent variable (Sp) is operationalised as a non-negative integer variable. 
Each police call record in meant to contain an address field.  I record each unique address as a unit P variable, which is  sorted by Sp . Th highest ordinal number is Max (Sp) within the time window being analysed. 
To generate Sp, I use the OFFENSE_DATE to determine the date at which the visit to the site occured.

Exploratory data analysis

Exploratory data analysis involved (a) Time series visualisation of total amount of services delivered per day (Sd) across the full time range. (b) For each annual period, a simple X-Y plot of locations of P against Sp .  (c)  Generating descriptive statistics of the variables P and Sp.

Model discovery and fitting

I attempted to find the appropriate stochastic model iteratively fitting the service volume data to the distribution and observing result of the ChiSquare test.

Longitudinal analysis

I performed longitudinal data analysis, yearwise, with a focus on locations. I selected the top “high needs” locations that were common in each of the ten years. 

Visualisation

I geocoded the locations, by (unique) street addresses and plotted the result geospatially. 

Privacy and Ethics

Address locations are sensitive, personal identifiable information, especially in context to adverse family related events. I assessed the data set and research plan for privacy risks. The source system has reasonable privacy protections because the address locations are expressed in ranges spanning a city block. In processing the data, I do not present or report any specific location at any stage as I have assessed that the actual location is not important to the study objectives.  Geospatial plots produced in this paper does not present the basemaps which therefore cannot link the locations to street geometry.

Results

Exploratory Analysis: