FCapo
asked on
Vb.net Mapping
Hi,
I have an access database with 2 columns, a project number and the address; there's about 5000 records.
When working on a new project, many of the employees would like a way to determine if historically there are other projects that were done in proximity to their current project. In order to this I would have to have a way of searching through those 5000 records and somehow determining the closest projects based on the address they enter.
The only solution I found was to manually enter each address as a pin in Google Maps, they could then search the location of their project and then compare to the closest pins. Doing this with 5000 records is a terribly painful task, and the result will probably be difficult to handle for Google to display 5000 pins at once on screen.
I was wondering if there would be a simpler method using vb.net that does or doesn't necessarily involve a map?
All our projects are located in one city. Montreal, Canada
Thank you
I have an access database with 2 columns, a project number and the address; there's about 5000 records.
When working on a new project, many of the employees would like a way to determine if historically there are other projects that were done in proximity to their current project. In order to this I would have to have a way of searching through those 5000 records and somehow determining the closest projects based on the address they enter.
The only solution I found was to manually enter each address as a pin in Google Maps, they could then search the location of their project and then compare to the closest pins. Doing this with 5000 records is a terribly painful task, and the result will probably be difficult to handle for Google to display 5000 pins at once on screen.
I was wondering if there would be a simpler method using vb.net that does or doesn't necessarily involve a map?
All our projects are located in one city. Montreal, Canada
Thank you
ASKER
Thank you for your reply,
I really have no idea how to implement this, say I have a specific address, is there a way to obtain the Lat and Long from it in vb.net? If so is it possible to get a step by step on doing this?
I really have no idea how to implement this, say I have a specific address, is there a way to obtain the Lat and Long from it in vb.net? If so is it possible to get a step by step on doing this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://stackoverflow.com/questions/365826/calculate-distance-between-2-gps-coordinates
You can easiy translate it to VB.net
for example:
var dLat = (lat2-lat1).toRad();
dim dlat as var= Math.PI ( lat2-lat1)/ 180
You can find latitude and longtitidue from GeoCoordinate class.(if you have Framework 4+)
Otherwise google APi should provide you this.