InsightsCategory: Public SafetyWhat city in San Diego County experiences the highest number of traffic accidents?
1 Answers
Best Answer
eric Staff answered 1 month ago

Here is a count of the number of recorded accidents for the two year period, 2014 and 2016, for the cities in San Diego county, from SWITRS.

| name             |   accidents |   area_rate |   pop_rate |
|:-----------------|------------:|------------:|-----------:|
| San Diego        |       19465 |    23.1106  |  1415.83   |
| Chula Vista      |        3024 |    23.5249  |  1160.41   |
| Oceanside        |        2229 |    20.8626  |  1282.29   |
| Escondido        |        1468 |    15.2893  |   979.241  |
| Vista            |        1375 |    28.4207  |  1395.09   |
| Carlsbad         |        1254 |    12.8334  |  1119.56   |
| El Cajon         |        1252 |    33.3722  |  1216.79   |
| National City    |        1221 |    64.7639  |  2023.23   |
| San Marcos       |         703 |    11.1401  |   768.482  |
| Encinitas        |         530 |    10.878   |   852.638  |
| La Mesa          |         522 |    22.1635  |   882.875  |
| Santee           |         412 |     9.79591 |   724.854  |
| Poway            |         400 |     3.95201 |   805.234  |
| Coronado         |         394 |    19.1809  |  1585.39   |
| San Diego County |         382 |   nan       |    11.7417 |
| Imperial Beach   |         205 |    19.0207  |   754.231  |
| Lemon Grove      |          74 |     7.36653 |   280.08   |
| Solana Beach     |          71 |     7.78894 |   533.353  |
| Del Mar          |          67 |    15.1565  |  1553.8    |

The first column, accidents, is the raw number of accidents, but this number isn’t very meaningful, since some cities are a lot bigger, in both area and population, than others, so the next two columns divide by area ( accidents per square km ) and population ( accidents per 100,000 population )
San Diego has the most accidents, of course, because it is by far the largest. National City has the highest rate per area and per population. So even though San Diego has more accidents, it’s National City that has more dangerous roads, at least by these measures.
However, the best way to compare cities would be relative to the number of vehicle miles driven in the area. So, here is the number of accidents per 1000 daily vehicle miles traveled. In this list, Coronado ranks first, but National City is still high on the list, and National City is also highest for the accidents per mile of road.

 | name             |   dvmt_rate |   road_rate |
|:-----------------|------------:|------------:|
| Coronado         |  4.04671    |   7.52066   |
| National City    |  2.51172    |  11.6697    |
| Imperial Beach   |  1.75136    |   3.39073   |
| San Diego        |  1.53343    |   6.50108   |
| Oceanside        |  1.52983    |   5.00029   |
| Vista            |  1.50055    |   8.02395   |
| El Cajon         |  1.39777    |   6.56932   |
| Chula Vista      |  1.25354    |   6.26039   |
| Escondido        |  1.04965    |   4.39609   |
| Santee           |  0.921506   |   3.46367   |
| La Mesa          |  0.83269    |   3.48544   |
| San Marcos       |  0.82492    |   3.99339   |
| Encinitas        |  0.638869   |   3.16724   |
| Carlsbad         |  0.632655   |   3.68647   |
| Del Mar          |  0.531792   |   2.74433   |
| Poway            |  0.500138   |   2.34567   |
| Solana Beach     |  0.49642    |   1.66796   |
| Lemon Grove      |  0.29348    |   1.16952   |
| San Diego County |  0.00479763 |   0.0418833 |
eric Staff replied 1 month ago

Turns out Vehicle Miles Traveled (VMT) for cities are not hard to find: http://www.dot.ca.gov/hq/tsip/hpms/datalibrary.php