MapForums
Community of VE/MapPoint Users and Developers
compare longitude and latitude values of two tables
This is a discussion on compare longitude and latitude values of two tables within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; compare longitude and latitude values of two tables advance thanks to all i want to do one report based on ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-29-2008
| |||
| |||
| compare longitude and latitude values of two tables advance thanks to all i want to do one report based on long and lat values.can anybody help me the logic behind this???? one eg i have one table in my sql db which contain lon and lat values of vehicle movement. eg: lon is 58.549315555555559 and lat is 23.619708888888891 this table does not contain any location name. ........................... i have another table which contain location name and corres lang and lat values. In this table exact value of vehicle long and lat is not there but i have nearly 10 records that long and lat values are near to above values(first table) from this how i will select one location? using which formula i want to do this? nearly 20 meters differ is there then i can select. ..........         |
|
03-31-2008
| |||
| |||
| Re: compare longitude and latitude values of two tables
Hi, to find the distance between 2 latitude / longitude positions is very easy. For Latitude 1 arc second is exact 1 sea mile. For Longitude you have to multiply with Cosine(Latitude).
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
|
03-31-2008
| ||||
| ||||
| Re: compare longitude and latitude values of two tables
Wilfried: That would give you what I was calling a "corrected Pythagoras". It is quick, but not hugely accurate. Might be good enough for this query though. iirc, the nautical mile is defined for a specific latitude - the Earth is not a sphere, so the length of an arc second of latitude varies between the Equator and the Poles. On top of that you have to correct for the geoid, but this will be a smaller (and more difficult!) correction. Richard
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
|
04-02-2008
| |||
| |||
| Re: compare longitude and latitude values of two tables
Thanks Richard for clarify. I saw your reply in another thread after I replied to this one 
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
 |
| ||||
| Posted By | For | Type | Date | |
| Pushpin Tool Add-in - MP2K Magazine | This thread | Refback | 03-31-2008 03:28 PM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| compare longitude and latitude values of two tables | meenu | MapPoint 2006/2009 Discussion | 12 | 04-09-2008 11:39 PM |
| Latitude and Longitude | virgilar | MapPoint 2006/2009 Discussion | 1 | 03-21-2005 01:01 PM |
| Latitude and Longitude | Anonymous | MapPoint 2006/2009 Discussion | 1 | 11-25-2003 12:52 PM |
| NMEA latitude/longitude and mappoint latitude/longitude | muurman | MapPoint 2006/2009 Discussion | 3 | 11-22-2003 04:42 AM |
| How do I get the latitude and longitude values of .... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 03-21-2001 01:22 AM |
All times are GMT -5. The time now is 08:03 PM.
