什么是皇家邮政的 PAF 地址数据库?
我很难理解如果您购买了皇家邮政的英国地址 PAF 文件数据集,您会从皇家邮政获得什么。
我原以为 PAF 是某种形式的数据库,您可以自己托管,而皇家邮政则提供该数据库的 API。
但是,在阅读此后,我'我假设您得到的只是一系列包含数据的文件。 我找不到任何有关 API 的明显信息。
- 是否有任何库可以帮助您处理这些文件,尤其是 Java 中的文件?
- 您是否必须自己解析文件并将其保存在自己的数据库中,以便可以从应用程序中进行快速查找?
- 如果这一切都是真的,你为什么还要费心从皇家邮政购买这个呢? 难道所有第三方提供商都拥有基于 Web 的 API,在编程和数据维护方面都更易于使用吗?
如果我错过了这一点,我很抱歉,但我发现皇家邮政网站缺乏信息。 我开始认为我误解了他们提供的 PAF 文件。
I'm struggling to understand what you would get from the Royal Mail if you bought their PAF file dataset of UK addresses.
I was expecting that PAF was some form of database which you would host yourself, and the Royal Mail provide APIs into that database.
However, after reading this, I'm presuming that all you get is a series of files containing the data. I can't find any obvious information regarding an API.
- Are there any libraries available to help you handle these files, especially from Java?
- Do you have to parse the file yourself and stick it in your own database, so you can do quick lookups from an application?
- If all this is true, why would you ever bother buying this off the Royal Mail? Aren't all the third party providers, with their web based APIs, just far simpler to use - in terms of both programming and data maintenance?
Apologies if I've missed the obvious on this one, but I find the Royal Mail site lacking in information. I'm beginning to think that I've misunderstood their PAF file offering.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
邮政编码地址文件 (PAF) 是皇家邮政提供的一组数据文件,其中包含英国的所有地址。 我的理解是一般三个月更新一次。
我知道有两家公司拥有向 PAF 数据提供 API 的产品:QAS 和 Capscan。 通过这些,您可以搜索地址以查找丢失的邮政编码,反之亦然。 API 包括基于 Web 的解决方案和本机调用。
为什么你直接从皇家邮政购买? 因为您想要编写自己的查询工具而不是依赖第三方产品,或者您想要进行其他产品无法提供的数据挖掘。
可以导入到 SQL 数据库吗? 是的,但前提是您编写了自己的 PAF 文件解析器。
为什么要使用这些而不是基于网络的工具? 因为您位于 Intranet 后面,所以服务器的 Internet 访问受到限制,任何基于 Web 的解决方案的许可也受到限制,等等。
The postcode address file (PAF) is a set of data-files provided by Royal Mail that contain all address in the UK. My understanding is that it's normally updated every three months.
I'm aware of two companies that have products that supply APIs into the PAF data: QAS and Capscan. With these you're able to search addresses to find missing postcodes or vice versa. APIs include both web-based solutions and native calls.
Why you'd buy direct from Royal Mail? Because you'd want to write your own query tools rather rely on third party products or you want to do data-mining that other products can't provide.
Could you import into a SQL database? Yes, but only after you'd written your own PAF file parser.
Why use these over web-based tools? Because you're sitting behind an intranet, have limited internet access from servers, restrictive licensing from any web-based solution, etc.
全部在维基百科
http://en.wikipedia.org/wiki/Postcode_Address_File
It's all in wikipedia
http://en.wikipedia.org/wiki/Postcode_Address_File
查看 www.PostcodeAnywhere.co.uk 一个基于网络服务的查找网站。 还提供桌面查找应用程序。 决策可能基于查找量、易用性、成本等。但对于中低量,只需几分钟即可简单实施,并且内置“自动”维护。
Check out www.PostcodeAnywhere.co.uk a web-service based lookup site. Also desktop lookup app available. Decision likley to be based on lookup volume, ease of use, costs, etc. But for low-medium volumes, simple implementation in a few minutes and 'automatic' maintenance built-in.
我随后找到了此页面,您可以在其中订购样本数据集。 它指出:
CD 上的英国地址页面继续有关“英国地址实用程序”的内容,其中指出:
I've subsequently found this page where you can order a sample data set. It states:
The UK Addresses on CD page goes on about something called "UK Addresses Utilities", and it states:
我用 C# 编写了一些内容,可以将这些文件解析到 SQL Server
https://github .com/Telexx/Royal-Mail-PAF-Parser/
I have written something in C# that can parse these files into SQL Server
https://github.com/Telexx/Royal-Mail-PAF-Parser/