{"id":2890,"date":"2015-04-16T14:30:29","date_gmt":"2015-04-16T18:30:29","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=2890"},"modified":"2015-04-16T14:30:29","modified_gmt":"2015-04-16T18:30:29","slug":"crime-in-the-square-mile-the-city-of-london","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/crime-in-the-square-mile-the-city-of-london\/","title":{"rendered":"Crime in the Square Mile (The City of London)"},"content":{"rendered":"

I used data from data.police.uk<\/a>, a site that provides open data about crime in England, Wales, and Northern Ireland. I had initially wanted to use data from the Metropolitan Police, Greater London\u2019s police force, but the amount of data was immense and CartoDB was unable to connect to a dataset of such multitude. In lieu of the Met\u2019s data, I used data from the City of London police. The City of London,\u00a0also known as the “Square Mile” because it is 1.12 sq miles\/2.90 km, is a a hub of financial institutions and home to a relatively modest population of ~520,462 people. I downloaded a bundle of Excel spreadsheets, which contained crime data from December 2010 to February 2015. Since each month had its own Excel sheet, I aggregated all the data into one sheet, then connected the dataset\u00a0to CartoDB.<\/p>\n

The first viz I created in CartoDB is\u00a0“Crime in the City of London (December 2010-February 2015).”<\/p>\n

\"\"<\/a>

Where have certain crimes occurred?<\/p><\/div>\n

\n

[Click image\u00a0to access interactive version].<\/p>\n

This category map visualizes\u00a0drugs, shoplifting, burglary, other theft, vehicle crime, anti-social behavior, violent crime, violence and sexual offenses, criminal damage and arson, and miscellaneous crimes (“other crime”)\u00a0 as documented by the City of London police from December 2010 to February 2015 (which is the most current data available). There is a key on the bottom right-hand\u00a0corner\u00a0which a user can use to differentiate types of crime (by color). If the types of crimes are not closely related I tried to make sure the colors were distinct enough in order to more clearly distinguish them from each other. If they are related (like shoplifting, burglary, other theft and violent crimes and violence and sexual offenses) I placed them\u00a0in the\u00a0same color family. I also included a hover feature for convenience, so a user can immediately know where a crime was committed instead of zooming in to find out–a user can hover over a point and be shown where a crime was committed “on or near” a particular street, landmark, or highway.<\/p>\n

This viz could be improved if I were able to create a more suitable UI–a\u00a0filter could be included in order for a user to view crime in a particular month\/year (though, \u00a0I created an animated heat map [see viz 2] for this purpose). I also think displaying the numerical amount of crimes for each point could enhance the visualization.<\/p>\n

Lastly, overall, one can immediately glean from this viz that there have mostly been “other” thefts, anti-social behavior, and “other” crimes (I’ve provided a list of what types of crimes are\u00a0included in “other” at the end of this post).<\/p>\n

The second viz, entitled Crime in the City of London Over Time, is\u00a0an animated heatmap version of viz 1.<\/p>\n

\"\"<\/a>

Where and to what extent has crime occurred over the years?<\/p><\/div>\n

\n

This viz shows the amount of crimes over time (December 2010 to February 2015). While it may look like an amorphous blob at\u00a0first glance, there is a method to the madness! Red indicates a greater intensity \u00a0i.e., a greater amount of crimes. Zooming in allows a user to better track the amount of crime over time for a specified\u00a0location. The time slider, automatic on page load, allows a user to pause the map on a particular month\/year in order to better view\u00a0the amount of crime for that month\/year or to manually slide across the months\/years. Since the time slider plays automatically, I have slowed\u00a0down the animation (I’ve set the\u00a0duration [secs] at 40) just enough so that a user is able to compare the increase\/decrease of crime between consecutive months.<\/p>\n

Again, this viz could be improved for better analysis purposes with a filter\u00a0by types of crime. But, mostly, this map shows there has been some consistency of\u00a0crime in relation to particular locations. It also provides some other insights such as, for example, 2011’s progression–October 2011 is suddenly\u00a0far more intensely red\u00a0than previous months, indicating an increase in crime.<\/p>\n

The last visualization concerns violent crime.<\/p>\n

\"\"<\/a>

What is the amount of violent crime that has occurred and which location(s) has the most instances of violent crime?<\/p><\/div>\n

 <\/p>\n

I thought it would be interesting to isolate one crime type, so I’ve filtered type of crime by violent crime and violence and sexual offenses and created the above viz. With cluster visualizations, is it possible to see exactly how many crimes were committed in a specific location. While it is not obvious at first glance which location corresponds to which circle, a user can zoom in and read the street names. As a user zooms in, some\u00a0circles break and become\u00a0more granular so a user can pinpoint a more exact amount at a more exact location. I do think this viz could be improved if there were\u00a0a time slider to track the growth of violent crime\u00a0in particular areas.<\/p>\n

As a final note, I think CartoDB’s search feature (in the upper right-hand corner of each viz) is quite useful; if a user wants to check crime that has occurred near his\/her residence, he\/she can type in the street they live on and magnify it.<\/p>\n

\n

Police.uk’s FAQ\u00a0provides a list of definitions for each type of crime in the\u00a0visualizations above, which clarifies some\u00a0of the more vague labels for the types of crime:<\/p>\n

    \n
  • Anti-social behavior:\u00a0<\/b>Includes personal, environmental and nuisance anti-social behavior.<\/li>\n
  • Burglary:\u00a0<\/b>Includes offences where a person enters a house or other building with the intention of stealing.<\/li>\n
  • Criminal damage and arson:\u00a0<\/b>Includes damage to buildings and vehicles and deliberate damage by fire.<\/li>\n
  • Drugs:\u00a0<\/b>Includes offences related to possession, supply and production.<\/li>\n
  • Other theft:\u00a0<\/b>Includes theft by an employee, blackmail and making off without payment.<\/li>\n
  • Robbery:\u00a0<\/b>Includes offences where a person uses force or threat of force to steal.<\/li>\n
  • Shoplifting:\u00a0<\/b>Includes theft from shops or stalls.<\/li>\n
  • Vehicle crime:\u00a0<\/b>Includes theft from or of a vehicle or interference with a vehicle.<\/li>\n
  • Violence and sexual offences:\u00a0<\/b>Includes offences against the person such as common assaults, Grievous Bodily Harm and sexual offences<\/li>\n
  • Other crime:\u00a0<\/b>Includes forgery, perjury and other miscellaneous crime.<\/li>\n<\/ul>\n
    \n

    Sources:<\/strong><\/p>\n

    1. http:\/\/www.data.police.uk<\/p>\n

    2. http:\/\/www.ukcrimestats.com\/Police_Force\/City_of_London_Police<\/p>\n

    3.\u00a0https:\/\/www.police.uk\/about-this-site\/faqs\/#what-do-the-crime-categories-mean<\/p>\n

     <\/p>\n

    Sarah Hatoum<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    I used data from data.police.uk, a site that provides open data about crime in England, Wales, and Northern Ireland. I had initially wanted to use data from the Metropolitan Police, Greater London\u2019s police force, but the amount of data was immense and CartoDB was unable to connect to a dataset of such multitude. In lieu…<\/p>\n","protected":false},"author":359,"featured_media":2985,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[],"class_list":["post-2890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-KC","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/2890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/359"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=2890"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/2890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=2890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=2890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=2890"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=2890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}