Last night Andy Warren ( blog | twitter ) shot me an email and asked if I could come up with a map of all the cities in the US that haven’t held a SQL Saturday yet. Sadly, I love this kind of stuff so much that I knew right off the top of my head that in the US “cities” are broken down into “Metropolitan Statistical Areas” and there are 366 of them (I’m glossing over the 29 sub-areas of some of the big cities). I said Sadly because not only did I know that 366 number but I also cary a list of the 14 largest cities not to hold a SQL Saturday yet in my wallet.
In any event I figured I might as well generate a map of a more complete list of cities so I grabbed my handy-dandy copy of the 2009 Census estimates and I was off. I selected only the 100 largest cities and then removed any of the cities that had held or are planning a SQL Saturday. I was left with 62 cities most of which are at least an hour away from a city that has held a SQL Saturday. (The cities I didn’t remove aren’t among the 29 sub-areas of larger cities.**)
I fired up MapPoint 2010 to Link my data and discovered two things that I was really happy about. The first is that MapPoint recognizes Metropolitan Areas. This meant no parsing was required on my part. Secondly, since I had copied out the population figures with all of the cities, I was able to make the legend for my cities different based on the size of the population. While I was playing around with that I found out I can further scale that legend again based on how densely populated the area is.
This whole process literally took a handful of minutes.
Here is what the results tell us:
- The largest section of under-served SQL Saturday areas is in a nice strip from St. Louis, MO to Providence, RI (Bragging rights go to Kansas City)
- California is the most underserved state.
- Texas really is bigger. Just look at the number of underserved folks who aren’t near Dallas or Houston
- Despite 5 regular/annual SQL Saturdays in the state of Florida there are still 3 cities of note that are not within an hour of a SQL Saturday and are missing out.
Here’s a list if the top 25:
|Rank||Metropolitan Statistical Area||Latest Population Estimate|
|13||San Francisco-Oakland-Fremont, CA||4,317,853|
|14||Riverside-San Bernardino-Ontario, CA||4,143,113|
|18||St. Louis, MO-IL||2,828,990|
|28||San Antonio, TX||2,072,128|
|30||Las Vegas-Paradise, NV||1,902,834|
|31||San Jose-Sunnyvale-Santa Clara, CA||1,839,700|
|35||Austin-Round Rock, TX||1,705,075|
|36||Virginia Beach-Norfolk-Newport News, VA-NC||1,674,498|
|37||Providence-New Bedford-Fall River, RI-MA||1,600,642|
|39||Milwaukee-Waukesha-West Allis, WI||1,559,667|
|44||Oklahoma City, OK||1,227,278|
|45||Hartford-West Hartford-East Hartford, CT||1,195,998|
|46||New Orleans-Metairie-Kenner, LA||1,189,981|
|50||Buffalo-Niagara Falls, NY||1,123,804|
**You would think that since I started with 100 cities and ended up with 62 that means there are 38 cities that have held a SQL Saturday in the US but you’d be wrong. 2 cities that aren’t even in the top 100 largest cities in the US have held SQL Saturdays! So why isn’t your city in there?