story
So as an example, if you use the UPSP Cities by ZIP Code to research 77005 and you would see that they recommend using the city name of “Houston” for mail, but they would also recognize “West University Place”. There’s also a city called “Southside Place” which should be avoided when it comes to sending mail. But then that kind of makes me think that if a house is within the limits of one or these small cities, then it could in theory have the same street name but have two different city values in different databases.
Then on the other hand there’s a somewhat related problem where a small town or village (e.g. Somers, WI and Scotland, CT) can have multiple ZIP codes and that ends up causing a lot of headaches for the residents of the town since they all might live nearby but then each section of the town might end up associated with some other larger city it’s closest to.
[1]: https://tools.usps.com/zip-code-lookup.htm?citybyzipcode