英国邮政编码查找字段覆盖一系列地区
需要针对英国某个地区的地区范围选择器的一些有效解决方案。假设我选择了曼彻斯特，它涵盖了许多小地区，例如 M1、M2、M3.....M20、M30... 我的用户可以分担曼彻斯特某些地区的责任，例如从 M1 到 M10，另一个用户可以分担 M11至 M21。他们也可以有多个区域，如曼彻斯特（M）、阿伯丁（AB）等，即使这样，也需要范围。
如何为其开发接口，以便它在 mysql DB 上创建最小负载，并方便用户添加大量具有所需分区范围的区域。
所有选定的邮政编码范围都将添加到数据库中，并且邮政编码信息将与每个邮政编码信息进行匹配，以便可以参考负责人。
如需更多想法：http://screencast.com/t/6qwCVhKA
提前致谢
Need some efficient solution of district range selector for an area in UK. Lets say I selected Manchester which covers many small districts like M1,M2,M3.....M20, M30... My users can be sharing responsibility of some of the districts of Manchester like from M1 to M10 and another user with M11 to M21. Also they can have multiple areas like Manchester(M), Aberdeen(AB) and so on and the range will be needed even then.
How to develop the interface for it so that it should create minimum load on mysql DB as well as handy for user to add a lots of areas with their desired district range.
All selected range postcodes will be added in DB and postcode info will be matched against each one so that the person responsible can be referenced.
For more idea: http://screencast.com/t/6qwCVhKA
thanks in advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
听起来您应该将邮政编码分为地区、地区和扇区。所以你有
等等，这将使你能够按你想要的任何级别进行参考。
此的第 17 页和 < a href="http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom" rel="nofollow">维基百科,这实际上是非常准确的。
It sounds like you should be breaking the postcodes down into area, district and sector. So you have
etc, this will enable you to reference by whatever level you want.
It's described in more detail on page 17 of this and on wikipedia, which is actually very accurate.