2012 General Election: PA Senate 37th Senatorial District

A late replacement on the ballot after the original Democratic party candidate Greg Parks dropped out for "personal reasons", State Representative Matt Smith defeated former Mt. Lebanon Commissioner D. Raja by five points.

Full Results (Excel)

2012 General Election: PA House 30th Legislative District

An open seat as a result of the election of Randy Vulakovich to the State Senate in the August special election, Pennsylvania's 30th Legislative District saw a competition between community leader and elder law attorney Hal English, and newcomer David Tusick.  Despite getting a late start in the race as replacement on the ballot for Senator Vulakovich, English defeated Tusick by a margin of almost 15 points.

Full Results (Excel)

2012 General Election: PA House 16th Legislative District

Bellevue Borough Councilwoman Kathy Coder faced off against incumbent State Representative Rob Matzie in the 16th Legislative District.  Despite a strong showing in Allegheny County and parts of Beaver County, Kathy Coder was not able to overcome the strength of the Democratic party support in Aliquippa.

Full Results (Excel)

Creating maps in SQL Server Reporting Services

Thank you to everyone who attended my presentation on using spatial data in SQL Server Reporting Services (SSRS) today! I hope that I was able to show everyone at least one thing that they will be able to use in their own reports in the future.

I have included a link below to my PowerPoint slide deck, a (SQL Server 2012) backup of the database, and the shapefiles that I used. The slides have notes that might be helpful, particularly the demo slides - I have included step by step instructions that you can use to walk through the demos again.

Presentation file downloads (zip file)

Please note that these are just the rough slide notes that I used for the presentation - I will post an updated version of the PowerPoint with a few more helpful links in the next day or two, so please check back.

Please e-mail me with any questions that you might have, and also please feel free to connect with me on LinkedIn if you're on there.

Thank you!

2012 Primary Election: Delegate to the Republican Convention, Pennsylvania 12th District

Ann Wilson and Jane Gleason of Cambria County, Lidia Turzai of Allegheny County, and Jill Cooper of Westmoreland County defeated six other candidates to become delegates to the Republican National Convention representing Pennsylvania's 12th Congressional District.  The other candidates, in order of their finish, were Mike McMullen, Dave Majernik, Jeannette Pavlick, Stephen LaPorta, Larry Borland, and Christopher Fromme.

Full Results (Excel)

Combined result maps (click for full resolution):


Individual Maps (click name for full resolution):  Ann Wilson, Lidia Turzai, Jill Cooper, Jane Gleason, Mike McMullen, Dave Majernik, Jeannette Pavlick, Stephen LaPorta, Larry Borland, and Christopher Fromme.

2012 Primary Election: U.S. Congress, Pennsylvania 12th District

In a contest between two incumbent Congressmen forced by population loss and redistricting, Mark Critz defeated Jason Altmire for the Democratic nomination and will face off against Republican challenger Keith Rothfus in the general election in November.  Congressman Critz's victory came largely as a result of high totals in the eastern part of the 12th district that he represented before the districts were merged.

Full Results (Excel)

Result map (click for full resolution):

2012 Primary Election: U.S. Senate Republican Primary

Businessman Tom Smith defeated former State Representative Sam Rohrer, entrepreneur Steve Welch, veteran David Christian, and former Santorum aide Marc Scaringi to claim the Republican nomination for U.S. Senate and the chance to face incumbent Bob Casey in the fall.

Full Results (Excel)

Combined result maps (click for full resolution):

2012 Primary Election: PA Senate 37th Senatorial District

Republican voters soundly rejected State Representative Mark Mustio's negative advertisements against former Mt. Lebanon Commissioner and County Executive Candidate D. Raja, nominating Raja with 43.56% of the vote compared to Mustio's third-place finish with 24.66%.

Full Results (Excel)

Combined result maps (click for full resolution):


Individual maps (click for full resolution):

2012 Primary Election: PA House 16th Legislative District

Bellevue Borough Councilwoman (and President from 2008-2011) Kathy Coder faced off against Ambridge Area Chamber of Commerce Executive Director Jeremy Angus for the Republican nomination for the Pennsylvania House of Representative's 16th District.  In a hard-fought but positive race between two excellent candidates, Kathy Coder pulled out an impressive victory by a margin of almost two to one.

Full Results (Excel)