countries-states-cities-database icon indicating copy to clipboard operation
countries-states-cities-database copied to clipboard

Typographic mistakes & missing gmt in Timezone data

Open Arkenar opened this issue 2 years ago • 0 comments

1/ GmtOffset & GmtOffsetName wrong TimeZone (UTC+13:45) There is no country currently using UTC+13:45. In your project, this UTC Timezone is related to New Zealand which uses UTC+12:45 which also happens to be missing from the list of timezones.

2/ GmtOffset & GmtOffsetName missing TimeZone (UTC−12:00) This is a timezone for United States Minor Outlying Islands which are currently listed in your project as UTC+12:00 with a "+" instead of "-". There are 37 unique gmtOffsetNames and there should be a total of 38, that's what led me to search for inconsistencies.

3/ Timezone Names typographic errors While i was trying to normalize timezone data i decided to check for inconsistencies to sanitize. This is no big deal (mostly missing parenthesis) but it sits in the way of anyone trying to manipulate this data.

  • "Pacific Standard Time (North America" (missing closing parenthesis)
  • "Mountain Standard Time (North America" (missing closing parenthesis)
  • "Eastern Standard Time (North America" (missing closing parenthesis)
  • "Central Standard Time (North America" (missing closing parenthesis)
  • Two different spellings for Brazilia time "Brasilia Time" vs "Brasília Time" (the difference is in the letter "i")
  • "Bougainville Standard Time[6" (remove unneccessary "[6" sequence from the string)
  • Two different spellings for Amazon Time in "Amazon Time (Brazil)" and "Amazon Time (Brazil)[3" (remove unnecessary "[3" sequence from the string)
  • "Alma-Ata Time[1" (Remove unnecessary "[1" sequence from the string)

Arkenar avatar Oct 18 '22 19:10 Arkenar