Posts

Do Council Estates Lead to an Increase in Crime? - Part 3

Image
Part 3 - The Ratios We saw in part 2 that there is a relationship between the number of postcodes (which is a proxy for the number of buildings/people) and the number of crimes as well as the number of local authority properties is a given square of the grid. What I want to do in this part is to remove the effect of the number of postcodes and isolate that of the number of council owned properties. To do this I'll use the ratio of both the number of crimes and number of local authority owned properties to the number of postcodes in each square. This gives us a crime ratio and a local authority ratio, which expresses the density of each compared to the general population desity.   By this measure, the most criminal place in the UK by this standard is Lindholme near Doncaster, with 16 postcodes but 494 violence and sexual offences, 45 cases of criminal damage and arson and 182 'other' crimes. This happens to be a prison so while accurate, subjectively its not very usefu

Do Council Estates Lead to an Increase in Crime? - Part 2

Image
Part 2 - The Correlations So to recap part 1 - we've created a grid of .5x.5 miles over England and Wales, and for each square got the number of postcodes (which is a proxy for building/population density), local authority owned properties and crimes from January to July 2018. I assumed that the greater the number of people/buildings in the area, the greater number of crimes, which is something I want to test in this part.  In fact, there are three relationships to uncover - the one between the number of postcodes and crime, the one between the number of postcodes and local authority owned properties and lastly, the number of local authority owned properties to crime. I'll be going through these relationships one by one and providing some more information on the outliers to relate these numbers to the real world. Keep in mind that because LA owned properties might share a postcode (e.g. in the case of flats in a building), there may be more LA properties than postcodes in

Do Council Estates Lead to an Increase in Crime? - Part 1

Image
Part 1 - Gathering Data Whenever I look for property, I'll have a walk around the area to see what kind of tenants I'm likely to get. I'll walk down the street and sometimes see an ominous looking tower block that was somebody's idea of a social experiment forty years ago that may or may not have gone horribly wrong. I don't know what the locals think of it, whether it impacts their life in any way or whether it might put off employed professional tenants. I live in London and am usually buying far from home, so other than data, my own impressions and the information I can gather online, I have no way of knowing anything about the area I'm buying into. I know not all council estates are not all bad (have a look  here ), that places like Park Hill in Sheffield that were once a byword for crime have  had makeovers   and that crime rates overall in the UK are dropping long term . If in fact people are put off buying near council estates but there is no discernib