Steve, I drew up a specification for this once, but the client decided not to buy the "geocoding" and programming needed. There are lots of google-able resources out there.
Basically, you need to: - geocode the addresses in your database that would be points within the radius. There are inexpensive services that you can find that will take a CSV file of your addresses and return them with latitude and longitude. - Develop a stored procedure or other R:BASE calculation that will take the Lat-Lon of your central point, and compute the approximate longitude boundaries radius-width miles east and west of your central point, and then compute the approximate north and south latitude boundaries north and south. You can google lots of formulae for this, and some could be quite easy to translate into R:BASE. e.g. http://janmatuschek.de/LatitudeLongitudeBoundingCoordinates#SQLQueries - Then you do your query for points with longitude between EastLong and WestLong and latitude between NorthLat and SouthLat. There are also ways to do http based queries on demand for new addresses. Bill On Wed, Jul 31, 2013 at 9:03 PM, Steve Breen <[email protected]> wrote: > Has anyone ever developed a application that can do the following in rbase? > **** > > ** ** > > Searching in range of miles from a location. IE Indianpolis, IN - 50 mile > radius.**** > > ** ** > > Stephen Breen**** > > ** ** >
