Where is the Next SQL Saturday Coming From – Map

SQLSatKey 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.

image_map

Here’s a list if the top 25:

RankMetropolitan Statistical AreaLatest Population Estimate
13San Francisco-Oakland-Fremont, CA4,317,853
14Riverside-San Bernardino-Ontario, CA4,143,113
18St. Louis, MO-IL2,828,990
20Baltimore-Towson, MD2,690,886
22Pittsburgh, PA2,354,957
24Cincinnati-Middletown, OH-KY-IN2,171,896
25Sacramento–Arden-Arcade–Roseville, CA2,127,355
28San Antonio, TX2,072,128
30Las Vegas-Paradise, NV1,902,834
31San Jose-Sunnyvale-Santa Clara, CA1,839,700
34Indianapolis-Carmel, IN1,743,658
35Austin-Round Rock, TX1,705,075
36Virginia Beach-Norfolk-Newport News, VA-NC1,674,498
37Providence-New Bedford-Fall River, RI-MA1,600,642
39Milwaukee-Waukesha-West Allis, WI1,559,667
41Memphis, TN-MS-AR1,304,926
44Oklahoma City, OK1,227,278
45Hartford-West Hartford-East Hartford, CT1,195,998
46New Orleans-Metairie-Kenner, LA1,189,981
50Buffalo-Niagara Falls, NY1,123,804
51Rochester, NY1,035,566
52Tucson, AZ1,020,200
53Tulsa, OK929,015
54Fresno, CA915,267
55Honolulu, HI907,574

**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?

Please Share This:

You may also like:

0 Responses

    1. Thats’s a great point Noel; I’ll have to come up with an icon to point out cities that are holdng non-SQLSaturday SQL events.

  1. I was actually thinking that it would be cool to show case either a google or bing map that plots all the held events along with the upcoming SQL Saturday events on the SQLSaturday.com site. This way some who navigates to the site can click on a point of interest and get driving directions and nearby information.

    1. Yeah I can do that for the most part with the static map that I have. But when I thought about if an event changed the address or something I started worrying about breakdown points.

      I think what I may do is put something together like Rob Farley did for the Chapters: http://www.sqlpass.org/PASSChapters.aspx

      As far as the data analysis goes though, MapPoint has been extremely easy to use to crunch numbers and display them on the map (so far).

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow:

Subcribe to Blog Via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

What I'm Saying on Twitter

Subscribe via feedburner

%d bloggers like this: