I need a C# CLR stored procedure for SQL Server 2005
MUST DELIVER BY 4/23/08 CRITICAL!
Project must be done in Visual Studio 2005 Pro (or below)
C# .NET 2.0
The stored procedure must GeoCode US addresses, it? must accept US address data, and return the lat/long of the address with a high degree of accuracy. If unable to code the address it must return the lat/long based on zip plus 4 or zip, always returning the best possilble lat/long and a status code to indicate which method was used to find the lat/long.
Geo coding data must be obtained via web service using the web service available at geocode.com.
You may code using a trial account at [url removed, login to view], however the code you generate must read all critical setup and authorization data from an external file so that it may be updated easily to our paid account.
In additon, if your work is of high quality, I would like you to code a second version that uses Map Suite Geocode USA from ThinkGeo.com. This product also offers a 60 day trial version which may be used to develop the code.
Please note this project may be awarded before the bidding period is scheduled to end so bid immediately if interested and capable.
Project? must be completed using Visual Studio 2005
Pro version is not require but may be used, Enterprise only functions may not be used!