Created
September 14, 2012 21:09
-
-
Save tylor/3724845 to your computer and use it in GitHub Desktop.
DriveBC incident data 2006-2011
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Some basic queries of the DriveBC incident data 2006-2011. | |
| Total incidents: 817479 | |
| Number of incidents by region: | |
| Rocky Mountain District 149174 | |
| West Kootenay District 133435 | |
| Thompson Nicola District 101701 | |
| Cariboo District 92216 | |
| Lower Mainland District 77129 | |
| Bulkley Stikine District 69441 | |
| Fort George District 53674 | |
| Okanagan Shuswap District 47549 | |
| Peace District 36408 | |
| Vancouver Island District 34965 | |
| Skeena District 21787 | |
| Number of incidents by cause: | |
| Compact Snow with Slippery Sections 156569 | |
| Slippery Sections 104513 | |
| Falling Rock 72727 | |
| Wildlife Alert in Effect 38657 | |
| Compact Snow 35829 | |
| Compact Snow with Slushy Sections 29871 | |
| Frost Heaves 28955 | |
| Slushy with Slippery Sections 27487 | |
| Compact Snow Sanded 25757 | |
| Slushy Sections 24585 | |
| Compact Snow with Plowing & Sanding 22494 | |
| Limited Visibility with Fog 22353 | |
| Slippery Sections Sanded 21387 | |
| Wildlife on Road 20087 | |
| Maintenance 17517 | |
| Watch for Wildlife 15146 | |
| Limited Visibility with Blowing Snow 12312 | |
| Snowing with Slippery Sections 10339 | |
| Collision 10119 | |
| Construction 9015 | |
| Falling Ice 8836 | |
| Bridge Maintenance 7625 | |
| Fog Patches 6766 | |
| Black Ice 6750 | |
| Wash Out 6439 | |
| Vehicle incident 4235 | |
| Ferry Out of Service 4044 | |
| Water Pooling 3677 | |
| Winter Driving Conditions 3507 | |
| Paving 3220 | |
| Plowing & Sanding and-or Salting in Progress 2822 | |
| Avalanche Control 2570 | |
| Ferry Service Interruption 2381 | |
| Muddy Sections 2358 | |
| Vehicle Recovery 2336 | |
| Special Event 2307 | |
| Limited Visibility with Heavy Snowfall 2298 | |
| Freezing Rain 2059 | |
| Forest Fire 2038 | |
| Rock Slide 1863 | |
| Electrical Maintenance 1844 | |
| Mud Slide 1714 | |
| High Avalanche Hazard 1699 | |
| Heavy Snowfall with Plowing & Sanding 1449 | |
| Debris on Road 1433 | |
| Strong Cross Winds 1418 | |
| Flooding 1376 | |
| Compact Ice 1374 | |
| Bridge Construction 1233 | |
| Ditching 1222 | |
| Drifting Snow 1174 | |
| Brushing 1075 | |
| Mowing 1065 | |
| Heavy Snowfall 972 | |
| Avalanche 950 | |
| Plowing & Sanding In Progress 868 | |
| Muddy with Slippery Sections 835 | |
| Water Ponding 792 | |
| Police Incident 772 | |
| Winter Highway Maintenance 765 | |
| Rain on Compact Snow 749 | |
| Hydro Lines Down 715 | |
| Limited Visibility with Smoke 712 | |
| Livestock on Road 656 | |
| Heavy Traffic Volume 649 | |
| Heavy Ferry Traffic Volume 617 | |
| Rock Scaling 604 | |
| Heavy Rain 549 | |
| Line Painting 545 | |
| Material Spill 537 | |
| Winter Highway Maintenace 520 | |
| Vehicle Stall 359 | |
| Tree on Road 282 | |
| Seal Coating 277 | |
| Vehicle Fire 277 | |
| Traffic Congestion 255 | |
| Fog and Black Ice 226 | |
| Strong Wind 224 | |
| Heavy Rain and Wind 171 | |
| Black Ice with Blowing Snow 158 | |
| Bridge Wash Out 153 | |
| Heavy Slush 143 | |
| Ice Fog 91 | |
| Uneven Compact Snow 56 | |
| Abandoned Vehicle 39 | |
| Signal Light Failure 28 | |
| Sweeping 7 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment