location irritations

following up on the dorky data-based posts, i've spent a sizable chunk of the day researching options for a static resource that can be referenced dynamically to provide location information, because really, how many local, independently established copies of city-state-country data does the world need. it's a waste of effort and resources for every sales, product, mailing system to have it's own in-house set of tables for this information when they all must comply with rules and conventions established by national organizations. it's ridiculous and i resent the fact that i live in a world that hasn't come up with a better more widely adopted solution for this. oh...incidentally, this is a rant.