In preparation for an upcoming database migration -- converting a web site from a homegrown CMS to Drupal -- I've been spending a fair amount of time learning Drupal's Migrate module. Although I knew that Drupal 7 could connect to SQL Server, upon further scrutiny I found out that the sqlsrvr module requires the PHP SQL Server Driver 2.0 from Microsoft, a Windows-only driver. Since I work primarily on a Mac, I decided to first convert the SQL Server database to MySQL.
The trend in public radio is to move away from the term “public radio” and, in many cases, embrace the term “public media.” For instance: the Public Radio Development and Marketing Conference recently became the Public Media Development and Marketing Conference; Louisville's Public Radio Partnership became Louisville Public Media; American Public Media calls itself "the second largest producer and distributor of public radio programming"; and, of course, National Public Radio changed its name to NPR.
This is not a how-to article. This is more the story of how I found out why making even a simple map is so darn complex, and why ultimately I plan to rebuild the map I made. Going from an idea to an end product is no simple task. In this case, my idea concerns the distribution of WPR pledges throughout the state of Wisconsin by zip code. I am curious about which areas of the state (and country) produce the most revenue. I'm not exactly sure what I will do with this information, although I have a few ideas.