高级邮政编码匹配 [英] Advanced post code matching
问题描述
我正在为一家酒店连锁店准备一个Access数据库，这家酒店遍布英国各地的几家酒店
。所需的功能如下：
1.客户想知道距离特定地点最近的酒店。
2。客户端邮政编码中的db用户密钥和系统返回
最接近他们的三家酒店，格式类似如下：
距离表格邮政编码酒店名称地点电话
5.5英里皇家布里斯托尔
01555 5551
123英里丽晶酒店0207
557 5555
125英里伦敦广场
0207 667 4444
是否有人知道将使用第三方工具做这个？我需要的全部
是可以占用所有酒店邮政编码（约30个）和
计算每个人与用户输入的邮政编码的距离。我可以做剩下的
。
谢谢，
Paul
co ********** @ googlemail。 com 写道：
我正在为一家酒店连锁店准备一个Access数据库，其中包括几家酒店
遍布英国各地。所需的功能如下：
1.客户想知道距离特定地点最近的酒店。
2。客户端邮政编码中的db用户密钥和系统返回
最接近他们的三家酒店，格式类似如下：
距离表格邮政编码酒店名称地点电话
5.5英里皇家布里斯托尔
01555 5551
123英里丽晶酒店0207
557 5555
125英里伦敦广场
0207 667 4444
是否有人知道将使用第三方工具做这个？我需要的全部
是可以占用所有酒店邮政编码（约30个）和
计算每个人与用户输入的邮政编码的距离。我可以做剩下的
。
谢谢，
Paul
将选择权交给GoogleMaps在
那个地区的酒店会不会更容易？
11月12日16:35，Salad< o ... @ vinegar.comwrote：
comcraft1 ... @ googlemail.com写道：
我正在为一家酒店连锁店准备一个Access数据库，该连锁酒店遍布英国各地的几家酒店
。所需的功能如下：
1.客户想知道距离特定地点最近的酒店。
2.客户端邮政编码中的db用户密钥和系统返回
最近的三家酒店它们的格式类似于以下格式：
距离表格邮政编码* *酒店名称* * *位置* * *电话
5.5英里* * * * * * * * * * * *皇家** * *布里斯托尔
01555 5551
123英里* * * * * * * * * * * *丽晶* * *伦敦* * * * * 0207
557 5555
125英里* * * * * * * * * * * * Plaza ** * * London
0207 667 4444
是否有人知道第三方工具会这样做？我需要的全部
是可以占用所有酒店邮政编码（约30个）和
计算每个人与用户输入的邮政编码的距离。我可以做剩下的
。
谢谢，
Paul
将选择权交给GoogleMaps在
那个地区的酒店会不会更容易？
感谢您的回复。
这不行不通; Access数据库存储了这家连锁酒店拥有的30家
酒店的列表。
我正在努力寻找这些酒店中最好的三场比赛。
用户输入邮政编码。
Paul
你好，
我不知道第三方工具，除了谷歌地图和
相关的api。你面临的问题是了解邮政编码之间的距离
，你没有参考这个数据来支付
。
正如我所看到的那样，实际上只有两种方法可以实现这一点，或者是沙拉建议的
，让google地图为你计算
，或者，找到一个数据库/创建一个包含各种郊区的表格，并将邮政编码及其地理位置（GPS类型数据）位置和
自己进行距离计算。 app。
无论哪种方式，你都要找到一个地理起点
（客户的原点）和''最近''目的地点（
酒店）通过计算出发点和每个
目的地之间的距离并选择最短的，可能对它们进行排名
$ b $那样的。关键是你需要地理数据。
希望这有帮助
干杯
青蛙
I am planning an Access database for a Hotel chain with several hotels
all over the UK. The required functionality is as follows:
1. A client wants to know the nearest hotel/s to a specific location.
2. The db user keys in the client''s postcode and the system returns
the three hotels nearest to them in a format similar to the following:
Distance form Postcode Hotel Name Location Tel
5.5 miles The Royal Bristol
01555 5551
123 miles The Regent London 0207
557 5555
125 miles The Plaza London
0207 667 4444
Does any one know of a third party tool that will do this? All I need
is the bit that can take all of the Hotel postcodes (about 30) and
calculate the distance of each of them to the user entered postcode. I
can do the rest.
Thanks,
Paul
co**********@googlemail.com wrote:
I am planning an Access database for a Hotel chain with several hotels
all over the UK. The required functionality is as follows:
1. A client wants to know the nearest hotel/s to a specific location.
2. The db user keys in the client''s postcode and the system returns
the three hotels nearest to them in a format similar to the following:
Distance form Postcode Hotel Name Location Tel
5.5 miles The Royal Bristol
01555 5551
123 miles The Regent London 0207
557 5555
125 miles The Plaza London
0207 667 4444
Does any one know of a third party tool that will do this? All I need
is the bit that can take all of the Hotel postcodes (about 30) and
calculate the distance of each of them to the user entered postcode. I
can do the rest.
Thanks,
PaulWouldn''t it be easier to pass the selection to GoogleMaps for hotels in
that area?
On 12 Nov, 16:35, Salad <o...@vinegar.comwrote:comcraft1...@googlemail.com wrote:I am planning an Access database for a Hotel chain with several hotels
all over the UK. The required functionality is as follows:
1. A client wants to know the nearest hotel/s to a specific location.
2. The db user keys in the client''s postcode and the system returns
the three hotels nearest to them in a format similar to the following:
Distance form Postcode * *Hotel Name * * *Location * * *Tel
5.5 miles * * * * * * * * * * * * The Royal ** * * Bristol
01555 5551
123 miles * * * * * * * * * * * * The Regent * * *London * * * * *0207
557 5555
125 miles * * * * * * * * * * * * The Plaza ** * *London
0207 667 4444
Does any one know of a third party tool that will do this? All I need
is the bit that can take all of the Hotel postcodes (about 30) and
calculate the distance of each of them to the user entered postcode. I
can do the rest.
Thanks,
Paul
Wouldn''t it be easier to pass the selection to GoogleMaps for hotels in
that area?Thanks for your reply.
No that would not work; the Access database stores a list of the 30
hotels owned by this hotel chain.
I am trying to find the best three matches amongst those hotels to a
user entered postcode.
Paul
Hi there,
I am not aware of a third party tool except for google maps and the
associated api. The issue you face is one of knowing the distance
between postcodes, and you dont have a reference with that data to
work with.
As I see it there are really only two ways to achieve this, either do
what Salad has suggested and let google maps do the calculation for
you, or, find a database / create a table that has the various suburbs
and postcodes along with their geographic (GPS type data) location and
do the distance calculations yourself in the app.
Either way, you are going to have to find a geographic starting point
(the customers point of origin) and a ''nearest'' destination point (the
hotel) by calculating the distance between the starting point and each
destination and choosing the shortest, maybe rank them or something
like that. The point is YOU NEED THE GEOGRAPHIC DATA.
Hope this helps
Cheers
The Frog
这篇关于高级邮政编码匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
