473,473 Members | 1,954 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Postcode radius searching

Hi - I know this isn't really a specific SQL Server question but I
can't think of a better forum.

I want to implement a more sophisticated UK postcode search on a site
- "LIKE 'NW%'" etc, is not bringing back good enough results.

A feature that would allow me to ask: "give me all outward postcodes
in a 30 mile radius of NW10" would be ideal.

Has anyone had to do this before? - any advice on how much
appreciated. Some of the postcode products available don't really
seem to offer this feature.

NH
Jul 20 '05 #1
2 3270
Thanks for the links - I'll follow them up.

NH
Jul 20 '05 #2
Nazir wrote:
Hi - I know this isn't really a specific SQL Server question but I
can't think of a better forum.

I want to implement a more sophisticated UK postcode search on a site
- "LIKE 'NW%'" etc, is not bringing back good enough results.

A feature that would allow me to ask: "give me all outward postcodes
in a 30 mile radius of NW10" would be ideal.

Has anyone had to do this before? - any advice on how much
appreciated. Some of the postcode products available don't really
seem to offer this feature.


There is a system called Address Point which associates a OS grid ref with
each Delivery point (full post code + street number). This is, I suppose,
how MultiMap works. Whether you could adapt this system just to deal with
the outward portion of the postcode I am not sure.

Kennedy
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Xenophobe | last post by:
I have successfully created a zip code radius search, but the performance is unacceptable. I have two tables. The first is 52K zip codes w/lat and long. The second is 3K national business...
5
by: Lapchien | last post by:
I have a field for a postcode. I'd like another field to auto contain an 'area' number, based on the first part (only) of the postcode. For example, if a postcode LS4 4DJ was entered, another...
9
by: Sandy | last post by:
Hello - I need either a cheap tool or code & DB that calculates, eg. within 50-mile radius of a zip code. Anyone have any suggestions? -- Sandy
5
by: Alan | last post by:
Hi, I'm getting as bit confused with my queries. I simply (!) want to insert a space into a postcode field the 4th character from the right, so, for example, ML201TQ becomes ML20 1TQ, which is...
4
by: Dave | last post by:
Hi I want to add functionality to my site so that customers can type in a postcode and we can tell them the "nearest store" in our database. I have noticed there are loads of sites on the net...
3
by: mark | last post by:
I have a table of UK companies whose records I want to filter using a map of postcode regions. For the benfit of people outside the UK, our postcodes are a pain to work with because they are not...
5
by: Widge | last post by:
s there such a plug in or piece of code that can handle the following scenario? 1) I have a list of suppliers, goods they sell and addresses/postcodes 2) Customer comes along, says they need...
5
by: billynastie2007 | last post by:
Hi i am writing a balloon race site and i am having problems with some functions to calculate the distance the balloon travels firstly i am reading my info from the database using the fetch assoc...
0
by: Pinna | last post by:
Hiya, I am trying to select based on a range on postcode on a table. The field POSTCODE is a varchar2(8). The problem is when refinng on 'where postcode between 'PE1' and 'PE29'', because this is...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.