Sql Server 2008 Geocoder, Shapes

We are looking to have an in-house Geocoder (similar to GoogleMaps or Yahoo geocoder) that resolves addresses to geopoints (long/lat). We also need the TIGER/Line (latest, 2007) shapefiles loaded into the Sql server 2008 Geospatial database. We need all geography/geometry polygons for the US shapes to all levels (Country, State, Metro (MSA), Place/City, County, Zipcode, Neighboorhoods, Census tracts). NOTE: SQL Server 2008 HAS all required functionality, the MAIN task in this project is to LOAD the TIGER Shapefile into SQL Server. SQL Server 2008 natively supports loading Shapefile. Should be straight forward. On top of the Database needs to be a .Net (c#) WCF service that provides the required operations to Geocode and Reverse Geocode US addresses and provide geocoded accuracy level (street, intersection, zipcode, etc). Cross-reference with Google KML and MS VirtualEarth will be useful. Also WCF operations to extract specific child shapes (i.e. Zippcodes in a given City. FIPS IDs should be used when possible as unique table identifiers to maintain cross-referenceability back to original data) Using TIGER database is royalty free ([login to view URL]). The developer must ensure he has all rights to provide additional data not based on TIGER (if additional data is required). SQL Server 2008 is able to import ShapeFiles hence should be a straight forward job. Do NOT bid on this project unless you clearly understand what is all about. Thanks! Quality control will be done by comparing results with those obtained from Google/Yahoo/MS Virtual Earth products. ## Deliverables On the System requirements side: Geocoding a US address in a densely populated Zipcode or City such as San Francisco should execute under 100 ms with 10 parallel/simultaneous requests on the following test system specs: Windows Server 2003 Standard Intel Quad Core Q6600 2.4 GHz. 4 GB RAM Appropriate Spatial indexes should be used and intelligent input parsing of the address string should be employed (i.e. if zipcode is present search inside the zip for the street name, if no zipcode then identify city + state and search inside that Geometry). The execution should FULLY leverage the Geospatial support provided by Sql Server 2008, no workarounds from sql 2005 please. Thanks! 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows Server 2008, sql Server 2008, .Net 3.5, WCF