Falsehoods programmers believe about geography

The lesson is clear. There are no safe assumptions. Addresses should not have parts. Just let people write the address without assuming it has any definable parts. Yes, that interferes with creating searchable databases. Deal with it.

https://wiesmann.codiferes.net/wordpress/archives/15187

Places have only one official name
Place names follow the character rules of the language
Place names can be written with the usual character set of a country
Place names can be written with the exhaustive character set of a country
Places have only one official address
Countries have capitals
Buildings do not move
Street addresses contain street names
Language codes will match the country code of the country they are associated with

BTW...

https://www.mentalfloss.com/article/79836/only-5-natural-features-us-possessive-apostrophes-their-names

But of all the decisions the Board has taken over the years, perhaps the strangest or the most controversial is its on-going war against possessive apostrophes.

Only 5 places in the USA are allowed a possessive apostrophe. Martha's Vineyard, full of wealthy people, is one.

#data-base #data-bases #programming #programmers #falsehoods #cs #computers #database-programming #geography #places #place-names