MapForums

ppsivya · #1 (**permalink**) 08-15-2007

We need to display Map of locations within a give area. We do not want to upload the data but rather do a search on the local data by longitude/latitude

I checked the following microsoft article for that

Implementing a Proximity Search with SQL Server 2000

The third paramter to the stored procedure dbo.sp_FindNearby is SearchDistance but what should be the value of the last parameter @EarthRadius to call this stored procedure.

**Wilfried** · #2 (**permalink**) 08-18-2007

Hi,

The average radius of earth is 6366 km (just measured it hihi). If your geoUnits are in miles you have to give it in miles I suppose.

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/proximity-search-6167.html
Posted By	For	Type	Date
Merging Multiple Routes - MapPoint Articles - MP2K Magazine	This thread	Refback	08-25-2007 05:28 AM
MapPoint User Community - MP2K Magazine	This thread	Refback	08-15-2007 09:54 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Proximity Search	ppsivya	MapPoint Web Service and Virtual Earth	0	07-24-2007 06:42 PM
Proximity Counting	Anonymous	MapPoint 2006/2009 Discussion	1	08-19-2004 08:11 AM
proximity	Anonymous	MapPoint 2006/2009 Discussion	0	01-12-2004 10:15 AM
proximity	Anonymous	MapPoint 2006/2009 Discussion	0	10-16-2003 01:16 PM
Looking for proximity locator solution	Anonymous	MapPoint 2006/2009 Discussion	2	03-14-2003 03:28 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

MapForums

Proximity Search

Proximity Search

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/proximity-search-6167.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/proximity-search-6167.html