GPS / Mapping data

[Millzy01]

Hi,
I have a table of UK out codes that contains longitude and latitude information, does ayone know how i could use this information to list all the out codes within a certain distance from one out code i.e. all out codes within 100 miles of AB10?

Thanks

Dave

 

[ca8msm]

There's a mathematical function you can use to calculate the distance between the two points. However, if you want to do this at the database level you'll be better off asking the question in a database forum.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[Millzy01]

The data i need to obtain is a list of postcodes with 100 miles of any location, i want to get this data so it can be displayed on a ASP.net page and if needs be edited by the user, the list will then be used to query a database of contacts who live in the postcode area's.

I was just wondering if someone can point me in the direction of some software they may have used for a simlar situation.

Thanks

 

[ca8msm]

You'll need to contact the Royal Mail. They have the software and database to do this but it is not free. Try looking at their website for more info.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[AlexCuse]

Do you have all the codes that you will need or want to compare? If so it's relatively easy to implement the function Mark described. See this thread (its' MSSQL, but you should be able to make it work in any database you are using)

http://www.tek-tips.com/viewthread.cfm?qid=1197121&page=3

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom