I'm new to spatial queries. Does anyone have a sample MSSQL 2008 query that would match a Street/City/Zip with the CA State Senate and Assembly Districts? All I need to do is return the Legislator's name, party and district. No mapping necessary. Any help would be greatly appreciated.
Following various recommendations, I already have the 2010 Census shape files (Tiger Line and PL 94-171) along with the 2011 California Redistricting data from the UC Berkeley Statewide Database. I also have the flat files of legislator info.
I've used a trial version of FME Workbench to get it all into SQL Server, but the query is proving elusive. If nobody has a sample, perhaps you could point me to a book that would be easy to understand. Thanks!