Drunk driving map with all-Ontario coverage and video
|TORONTO STAR STAFF|
As I said in an earlier post, our tools for producing online maps have become much more sophisticated over the last year and a half, and it’s tempting to go back to some of our earlier data and give it the presentation it deserves.
This week, we’re taking another look at our drunk driving maps, which have been consistently popular since they first appeared. They were based on license suspension records from the Ministry of Transportation for the whole of 2007, which showed the age, sex and postal area of accused drunk drivers. (The age graphs of male and female drunk drivers are worth a look.)
The do-over has two main improvements:
- For the first time, we have a map video, produced with the movie feature of Google Maps 5. I had some trouble getting the audio tracks to appear on the movie file; thanks to multimedia editor Scott Simmie for attaching them.
- The map displays 513 Ontario postal codes, showing patterns across the whole province. It uses boundaries I bought from Statistics Canada, very helpfully converted to .kml by Sanjay Singh at Pitney Bowes. I simplified some of the polygon shapes to speed loading, in the Lake of the Woods area, Manitoulin Island and Long Point. This whittled the zipped .kmz file down to about 800K, which is still much larger than anything we’ve tried to display before. It loads acceptably fast in IE and Firefox, but let me know in the comments if it seems slow. Unusually, it actually seems to load faster in IE.
Here is the video:
So, on to the data. The map shows a strong pattern of higher drunk driving rates in rural and northern areas, especially around Georgian Bay (on all sides – Bruce and Grey Counties, Manitoulin, Parry Sound-Muskoka) and lower rates in rural and suburban areas in the GTA, London and Ottawa.
Here is a top 20 list. It differs (though not enormously) from the previous one because it uses FSA population estimates from the 2006 census, which weren’t available at the time.
Here is a top 10 list:
|P0C||Georgian Bay shore south of Parry Sound||0.40%|
|K6K||Rural area north of Cornwall||0.35%|
|P0G||Georgian Bay shore north of Parry Sound||0.33%|
|K0E||Rural areas east and west of Brockville||0.28%|
|N7T||Rural area south of Sarnia||0.26%|
… and a bottom 10 list:
|M6B||Toronto: Glencairn/the Allen||0.06%|
|N9B||Windsor: university area||0.06%|
|M4X||Toronto: St. Jamestown||0.05%|
|K1J||Ottawa: Beacon Hill||0.05%|
|M4V||Toronto: Casa Loma/southern Forest Hill||0.04%|
|M3C||Toronto: Flemingdon Park||0.04%|
|M4P||Toronto: North Toronto (N of Eglinton/Mount Pleasant)||0.04%|
|M6A||Toronto: Lawrence Manor/Lawrence Heights||0.04%|
|M5A||Toronto: Regent Park/St Lawrence/Corktown||0.04%|
|M6G||Toronto: Little Italy: Seaton Village||0.04%|
|M4S||Toronto: Mt. Pleasant/Davisville||0.04%|
|N9G||Windsor: Dougall Ave/Howard Ave area||0.04%|
|M2K||Toronto: York Mills||0.04%|
|M4H||Toronto: Thorncliffe Park||0.03%|
|M2H||Toronto: Hillcrest Village||0.02%|