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.
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
The USPS recommends line lengths for addresses:
http://pe.usps.com/text/pub28/pub28c2.html
There's also a file with city and state names (only a sample is available for downloading):
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.
Cheap CASS software is at http://www.semaphorecorp.com