We need .net WinForm exe application to find companies in some distance of given address in our customer database. The companies with address information are stored in table in Oracle database. We will provide sample table after the contract is done.

Current plan is that there would be logic in pl/sql in oracle database to convert addresses to gps coordinates and store that information to database. There should be a system to set the gps coordinates for all existing rows and then maintain those coordinates automatically. The addresses are in all of the world, so we suggest to use free Google Geocode api unless you have some better free suggestions. If google geocode is used then the maximum 2500 free google geocode api calls limit per day should be handled properly. The logic to fetch and store coordinates for companies must be implemented inside Oracle in pl/sql read more