RE: FN-FORUM: Search by proximity

date posted 11th December 2007 15:21


> Maybe the Google Maps API can give you this kind of info - ive seen it done before with Estate Agent sites
>
> http://code.google.com/apis/maps/
>
> Kind regards
>

This was discussed on this list a while back. There is (or was) a file
http://www.jibble.org/ukpostcodes/ giving coordinates of the first 3
digits of UK postcodes. Stick that in a database, and some basic maths
will get you a very rough version of what you want. I've got some simple
queries for that somewhere, if you want them.

The Post Office has detailed postcode mapping files, and there are
various APIs out there which give distances between points allowing for
the curvature of the earth, if you want to go that far.

Graham

>
> Brendan Oliver
> [FSW Multimedia]
>
>
> T: +44 (0)1949 21202
> F: +44 (0)1949 21021
> E: [EMAIL REMOVED]
>
> 14 Main Street
> East Bridgford
> Nottingham
> NG14 8PA
>
> Internet E-mail Confidentiality: This E-Mail may contain confidential and/or privileged information. It is only intended for the use of the addressee indicated in this message. If you are not an intended addressee of this email (or responsible for delivery of the message to such person), the disclosure, copying or delivering of the contents of this email to anyone else is strictly prohibited and may be unlawful. If you receive this e-mail by mistake destroy the message and please notify us immediately by e-mail. Please advise immediately if you or your employer do not consent to Internet E-Mail for messages of this type. Information or opinions in this message that do not relate to this business shall be treated as neither given or endorsed by it. Please note that whilst we try to ensure that messages and attachments are virus free, we cannot accept responsibility for situations where this is not the case.
>
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Phillip Healey
> Sent: 11 December 2007 15:34
> To: Brendan Oliver
> Subject: FN-FORUM: Search by proximity
>
>
>
> Hi,
>
> I'm about to start work on a project that involves searching for places in the database by various fields. So this is quite easy.
>
> However, there is also a need to search for places by postcode (eg local garage). My client however would like the ability to search for by a given postcode with results shown based on proximity. Does anybody know how this can be achieved? Surely it needs some sort of interaction with a postcode database?
>
> Any help / ideas etc would be a great help.
>
> Thanks
> Phill
>
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>