UK Postcodes : nearby/adjacent

Liam Byrne

Hi folks

A client of ours is looking for a site that has the capability to make suggestions based on the web visitors postcode or county, listing nearby results first.

We've done something similar for Irish counties (which is where she spotted it) but I'm not sure how complex an equivalent for the UK would be ?

There are (pretty expensive) paid-for resources that do it, but the subscription for those is an issue for her.

Has anyone tried anything similar in the past ? If so, any chance of a few pointers, or possibly licensing the code from you ?

Tech note: Site will be a PHP / MySQL / JavaScript / jQuery combo, so the postcode info would need to integrate into that.

Cheers,
L

replicantface

pm sent

ChicoMendez

you could try querying google maps api to get the long/lat based on the address, postal code and then use that to get distance from whatever you are talking about ?


tnx

matt-dublin

add an extra colum in the relevant table and add nearby postcodes seperated by a comma.

then when a user enters their postcode do a select sequence like:

select * from tablename where postcodes like %xxxxxxx%

that should give you what you need and is fairly straight forward

jmcc

The UK Postcodes are based on longitude/latitude (or at least there is a formula for converting them to long/lat and vice versa). It might be possible to find it on the web.

Regards...jmcc

Liam Byrne

matt-dublin wrote:

add an extra colum in the relevant table and add nearby postcodes seperated by a comma.

That's what we've done for previous clients in Ireland (using the counties as the basis), but the complexity for postcodes seemed like it would require something more intuitive/intelligent/automatic, particularly if the "nearby" was based on a distance that the user could enter.

I've since found a zip file containing all the postcodes & lat/long co-ords so am going to have a look at reverse-engineering that.

ChicoMendez

hi liam
would i be able to get that zip off you please ?

i have a function that calculates distance between two long/lats if you want it ?

tnx