我该如何找到美国最长的邮寄城市名称?

发布于 2024-08-20 01:46:27 字数 223 浏览 11 评论 0原文

我能找到的最长的城市名称(有邮政编码)是“La Canada Flintridge”,位于加利福尼亚州。我通过谷歌偶然发现了这一点。为了测试我们的邮寄地址,我想从 USPS 数据库中获取明确的“这是您可能邮寄到的最长的城市名称”。

我如何才能a)免费且b)快速找到这些信息?

致“与编程无关”的终结者:这决定了我们数据库中“城市”字段的字段长度。那是与编程相关的。

The longest city name I was able to find (that had a Zip code) was "La Canada Flintridge" which is in CA. I found that haphazardly via google. For testing our mailing addresses, I'd like to get a definite "this is the longest city name you could possibly mail to" out of a USPS database.

How would I go about finding this information a) for free and b) quickly?

To the "Not Programming Related" closers: This determines the field length of a City field in our database. That is programming related.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(4

银河中√捞星星 2024-08-27 01:46:27

USPS 数据库最多使用 28 个字符作为地名。目前有 6 个可邮寄的地名这么长(全部被截断以适合 28 个字符):GREAT SAND DUNES NATIONAL MO、INDIAN SPRINGS AIR FORCE AUX、KINGSVILLE NAVAL AIR STATION、ROANOKE RAPIDS AIR FORCE STA、SOUTHERN UTE INDIAN RESERVAT、UNITED STATES AIR强制ACAD。

但是,USPS 数据库还为任何长度超过此长度的地名提供 13 个字符的形式。例如,YOSEMITE NTPK 是 YOSEMITE NATIONAL PARK 的缩写。截至 2009 年 8 月 1 日,CASS 软件(用于根据 USPS 法规标准化地址)需要在查找地址时自动提供 13 个字符的地名。

The USPS databases use a maximum of 28 characters for the place name. Currently there are 6 mailable place names that long (all truncated to fit in 28 chars): GREAT SAND DUNES NATIONAL MO, INDIAN SPRINGS AIR FORCE AUX, KINGSVILLE NAVAL AIR STATION, ROANOKE RAPIDS AIR FORCE STA, SOUTHERN UTE INDIAN RESERVAT, UNITED STATES AIR FORCE ACAD.

However, the USPS database also provides a 13-character form for any place name longer than that. Eg, YOSEMITE NTPK is the short form for YOSEMITE NATIONAL PARK. As of 8/1/09, CASS software (used to standardize addresses to USPS regulations) is required to automatically provide 13-character place names when looking up addresses.

旧夏天 2024-08-27 01:46:27

USPS 建议地址的行长度:

http://pe.usps.com/text/pub28/pub28c2.html

编辑:上面的链接已失效,但一般地址格式指南可以在< a href="https://pe.usps.com/text/pub28/28c2_001.htm" rel="nofollow noreferrer">https://pe.usps.com/text/pub28/28c2_001.htm 。它们非常广泛并且分为小部分,因此搜索它们是一件痛苦的事情。我无法再找到最大长度的参考。使用官方城市/州列表的建议仍然有效。

还有一个包含城市和州名称的文件(仅提供示例下载):

http://www.usps.com/ncsc/addressinfo/citystate.htm

编辑:此链接也已失效- 您在工作中缴纳的税款。城市/州文件仍然可用,价格为 420 美元,但我找不到样本了:https://postalpro.usps.com/address-quality/city-state-product

The USPS recommends line lengths for addresses:

http://pe.usps.com/text/pub28/pub28c2.html

Edit: the above link is dead, but general address formatting guidelines can be found at https://pe.usps.com/text/pub28/28c2_001.htm. They're quite extensive and broken down into small sections, so searching through them is a pain. I can no longer find a reference for a maximum length. The recommendation to use the official city/state list still holds.

There's also a file with city and state names (only a sample is available for downloading):

http://www.usps.com/ncsc/addressinfo/citystate.htm

Edit: this link is dead too - your tax dollars at work. The city/state file is still available at a cost of $420, but I couldn't find a sample anymore: https://postalpro.usps.com/address-quality/city-state-product.

意犹 2024-08-27 01:46:27

根据维基百科
http://en.wikipedia.org/wiki/Longest_word_in_English#Place_names
这是 Chargoggagoggmanchauggagoggchaubunagungamaugg
但那是一个湖..算了吧..:|

美国地质调查局的数据库将这些作为最长的非连字符社区名称,字符数为:

Mooselookmeguntic, ME (17)
宾夕法尼亚州克莱因费尔特斯维尔 (17)
佐治亚州奇卡萨瓦奇 (16)
弗吉尼亚州切斯勒斯维尔 (16)
宾夕法尼亚州艾切尔伯格敦 (16)

http://askville .amazon.com/longest-Canadian-city-town/AnswerViewer.do?requestId=3617728

According to Wikipedia at
http://en.wikipedia.org/wiki/Longest_word_in_English#Place_names
It's Chargoggagoggmanchauggagoggchaubunagungamaugg
But that's a lake.. forget it.. :|

The US Geological Survey’s database has these as the longest non-hyphenated community names, with the number of characters:

Mooselookmeguntic, ME (17)
Kleinfeltersville, PA (17)
Chickasawhatchee, GA (16)
Chancellorsville, VA (16)
Eichelbergertown, PA (16)

at http://askville.amazon.com/longest-Canadian-city-town/AnswerViewer.do?requestId=3617728

他夏了夏天 2024-08-27 01:46:27

美国任何建制地名中最长的名称是密苏里州 Bellefontaine Neighbors,包含空格在内有 23 个字符。

The longest name of any incorporated place in the United States is Bellefontaine Neighbors, Missouri, 23 characters including spaces.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文