{"id":2086,"date":"2014-12-09T09:22:45","date_gmt":"2014-12-09T17:22:45","guid":{"rendered":"http:\/\/dougmccune.com\/blog\/?p=2086"},"modified":"2024-06-20T20:54:11","modified_gmt":"2024-06-21T04:54:11","slug":"bay-area-homicide-constellation-map","status":"publish","type":"post","link":"https:\/\/dougmccune.com\/blog\/2014\/12\/09\/bay-area-homicide-constellation-map\/","title":{"rendered":"Bay Area Homicide Constellation Map"},"content":{"rendered":"

This is a map of murders throughout the Bay Area. Constellations are formed by connecting homicides from 2013 that are in close geographic proximity to each other. Homicides from 2014 are also layered on to provide a bit more context, although not used to form the constellations. <\/p>\n

\"sf_bay_area_homicide_constellations_696\"<\/a><\/p>\n

<\/p>\n

“Perhaps they are not stars, but rather openings in heaven where the love of our lost ones pours through and shines down upon us to let us know they are happy.”
Eskimo Proverb<\/small><\/span><\/p><\/blockquote>\n

Detailed Views<\/h1>\n

Here’s a detailed view of San Francisco and Oakland, which have some of the most interesting constellations. As with clouds in the sky, different people will see different things. San Francisco jumps out as a dog to me. In Oakland I can see a whale or shark (facing south toward Hayward) or a caterpillar (facing north toward Berkeley).<\/p>\n

\"sf_closeup\"<\/p>\n

Just north of Berkeley we have a cluster in Richmond, forming what to me resembles a child swinging in a hammock. <\/p>\n

\"richmond_closeup\"<\/p>\n

A bit to the east is Antioch and Pleasanton. Antioch is the main cluster in the middle and Pleasanton is the smaller cluster to the west.<\/p>\n

\"antioch_closeup\"<\/p>\n

East Palo Alto is a notable cluster that stands out due to its concentration and isolation. The data has eight 2013 murders in East Palo Alto, contrasted with almost nothing in the richer surrounding cities of Palo Alto, Atherton, and Menlo Park.<\/p>\n

\"east_palo_alot_closeup\"<\/p>\n

The sprawling city of San Jose also produces a sprawling map — connecting the dots of the 2013 killings produces a disarming image that looks an awful lot like a human face.<\/p>\n

\"san_jose_closeup\"<\/p>\n

The Data<\/h1>\n

San Francisco publishes a decent amount of crime data on its data portal, DataSF<\/a>, however homicide data is not included. The data used in these maps was collected and published by the San Jose Mercury News.<\/p>\n

2013 map<\/a> and kml file<\/a>.<\/p>\n

2014 map<\/a> and kml file<\/a>.<\/p>\n

Method<\/h1>\n

Both the 2013 points and the 2014 points were used in the map. To form the constellations, however, only the full set of 2013 data was used. Constellations were formed by connecting the 2013 points using Delaunay triangulation<\/a> and then filtering down the resulting lines to only include lines shorter than a certain distance. That left clusters of points that are all close together.<\/p>\n

Here’s the map of only 2013 points connected using Delaunay triangulation.
\n\"2013_delaunay\"<\/p>\n

There is no connection between any of these locations besides their proximity to each other. A line connecting two points is not meant to signify any relationship (again, other than their geographic proximity).<\/p>\n

Tools<\/h2>\n

The data was processed using QGIS<\/a> for the initial exploration work and to create the Delaunay triangulation lines. I then brought the data into MapBox Studio<\/a>, which was used to style the points and lines and to export a high resolution image. The rest of the processing was done in Photoshop.<\/p>\n

High Resolution Files<\/h1>\n

All images are licensed under the CC BY-NC 2.0<\/a> license. If you’d like to print your own copy the dimensions should work with an 18×12 print.<\/p>\n

High-res version with the “old paper” background<\/a> (32 MB)
\nHigh-res version with a white background<\/a> (12 MB)<\/p>\n","protected":false},"excerpt":{"rendered":"

This is a map of murders throughout the Bay Area. Constellations are formed by connecting homicides from 2013 that are in close geographic proximity to each other. Homicides from 2014 are also layered on to provide a bit more context, although not used to form the constellations.<\/p>\n","protected":false},"author":1,"featured_media":2257,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[78,98,34,119,97],"tags":[106],"class_list":["post-2086","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-art","category-deviantcartography","category-maps","category-maps-and-data","category-portfolio","tag-sf"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t