基于区域的邮政编码轮询
我正在编写一个应用程序,它必须生成东海岸(美国)中存在的所有邮政编码与我们内部数据库中存在的邮政编码之间的差异作为输出。 关于上述问题,我有以下问题 -
1)我首先如何获得东海岸下方的所有拉链?我可以使用任何在线 API 或库来实现此目的吗?
2)假设考虑了上述问题,考虑到结果可能会很广泛,显示这种差异的最佳方式是什么。我希望将数据显示到适当的抽象级别。
任何建议将不胜感激。
p1nG
Im writing an app that has to generate as output the diff between all the zips present in the east coast(US) and the zips present in once of our in house databases.
With regard to the above I have the following questions --
1) How do i in the first place get all the zips that fall under the East coast ? Is there any online API or library I can use to achieve this ?
2) Assuming the above point is taken care of, what would be the best way to display such a diff, given that the results might be extensive. I would want to display data to a decent level of abstraction.
Any suggestions would be greatly appreciated.
p1nG
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
http://federalgovernmentzipcodes.us/
从 CSV 导入到您的数据库中,然后从其中选择邮政编码,其中该州位于您想要认为的任何州列表中“东海岸”。两个表之间的外部联接应该为您提供该集中不在您的房屋数据库中的所有邮政编码。
http://federalgovernmentzipcodes.us/
Import from CSV into your database, then select from it zip codes where the state is in whatever list of states you want to deem the "east coast". An outer join between the two tables should give you all zip codes in that set that are not in your house database.