The University heights area is bound by:
north-east corner: 35.081171328253525, -106.61331860351561
south-west corner: 35.07378816436824, -106.62242300415039
It would be cool to include a map here.
mysql> select YEAR, count(*) from uhaRecords WHERE (GIS_LAT >= 35.07378816436824) and (GIS_LAT = -106.62242300415039) group by year;
+------+----------+
| YEAR | count(*) |
+------+----------+
| 2011 | 187 |
| 2012 | 173 |
| 2013 | 157 |
+------+----------+
3 rows in set (0.00 sec)
mysql>
This doesn't look so bad. However, we also have data from 2010....?
mysql> select YEAR, count(*) from uhaRecords group by year;
+------+----------+
| YEAR | count(*) |
+------+----------+
| 2010 | 15448 |
| 2011 | 16943 |
| 2012 | 15532 |
| 2013 | 16006 |
+------+----------+
4 rows in set (0.03 sec)
mysql>
PROBLEM 1 - What happened to 2010 for our neighborhood?
When looking at specific intersections, it becomes clear that that 2011-2013 also have problems. Let's consider one particularly busy intersection, Central and Yale.