Graham, I'd be interested in looking at the PHP code please. If you look at my website you'll find a small demo where you can do what you want with any address, zipcode etc with Microsoft Visual Earth, VFP and a little JAVA script.
You can get back the Lat/Long details and distance between any two points etc etc. I haven't shown how to do this but the API is easy to use if you download it and it's all free. It may well help you. http://www.replacement-software.co.uk/blog/index.php?/archives/29-VFP-integr ation-with-Microsoft-Virtual-Earth.html#extended or http://tinyurl.com/2cguto Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 15 October 2007 18:58 To: ProFox Email List Subject: [OT] Ordnance survey maps x/y coordinates Hi all Completely off topic this one. I've inherited some really neat PHP code today which takes a UK postcode (zipcode!) and looks in a database to find the nearest database record with that postcode. The php code is basically for entering your postcode and finding where the nearest stockist is to your location. It does this by using the Ordnance Survey X/Y coordinates and looking up the first part of the postcode "LE4" to find the X/Y. Mainland UK postcodes can be easily looked up with http://www.streetmap.co.uk/streetmap.dll?GridConvert?name=CV32%204AT&type=Po stcode The code works really well but before I port it to VFP I've tested it with Jersey (little place between the mainland uk and france!) and it fails. Although I have the JE2 postcode I can't find anywhere which publishes the OS x/y for the channel islands. Would anyone happen to know if Ordnance Survey is one of the quirky mainland uk things or where i can find OS cordinates for outside the mainland uk. ps if anybody wants the php code let me know! Cheers Graham [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
