Time database
Mailing list
Desired features
| Topic | Time keeping database (tkdb) | IANA time zone database (tzdb) |
|---|---|---|
| Terminology | Exactly one term for one kind of object |
|
| Geography - Sector | Smallest territorial unit is named "sector" | Smallest territorial unit is named "zone" |
| Geography - Sector | For any point in time, except for war time, the legal time in all territory of a sector is the same. | For any point in time after 1970-01-01T00:00:00 clocks in a IANA zone have agreed. |
| Geography - Sector | The sectors cover the whole surface of the earth | Some areas are not covered, e.g. no IANA zone exists the ISO 3166 country "Bouvet Island" |
| Geography - Sector | Each sector has exactly one SectorID. | Some zones have multiple IDs via links. These links can
|
| Geography - Sector | A SectorID only contains alphanumeric characters, letters upper case. REGEX: /[3-8][A-Z0-9]{1,}/ (Note: further restriction likely) | A zone ID contains ASCII letters and / and can contain -._ |
| Geography - Sector | New sectors are created only by splitting and deprecating old sectors, so a user can know if an assignment of an ID to an object needs a check for correctness. |
After a split one zone retains the ID of the old zone. That means:
|
| Geography - Sector | Relations between deprecated sectors and the sectors that have been created out of them are published. | No split history is explicitly published. |
| Geography - Country | ISO 3166-1 alpha-3 codes for countries. | ISO 3166-1 alpha-2 codes for countries. Some of the codes have been re-assigned, e.g. CS can refer to Czechoslovakia or Serbia and Montenegro. |
| Geography - Country | Support for former countries at least back to 1946-01-01, the first full year where the UN existed. | No support for former countries. No way to get data for ISO 3166 alpha-2 code DD (East Germany) |
| Geography - Country | At any point in time (at least after 1946-01-01) the land surface is associated to a country. | Some areas are not associated to a country, e.g. the land of the ISO 3166 country "Bouvet Island" is not associated to any country. |
| Geography | At any point in time a sector is located in only one country. | Zones can be located in different former countries, e.g. Europe/Berlin is located in East Germany (DD) and West Germany (DE) prior to 1990. |
| Geography | Publish relations between sectors and IANA zones at least for some IANA releases. | |
| Other | Record all legal time |
|
| Other | For any point in time, for any country, a time zone acronym used for a sector that is located in that country refers to exactly one offset from a base time. | For some points in time during DST observance in Australia, the acronyms EST and CST for time records in Australia can refer to different offsets from UTC, depending on whether a zone observes DST or not. That means for a given point in time during summer the offset from UTC and therefore UTC itself cannot be derived from the local time representation. |
| Data format | Publication in
|
Publication in IANA specific format. |
Tables
Area
Alphabetical sorting leads mostly to decreasing size.
| Name | ID regex | Boundary | Description |
|---|---|---|---|
| Continent | /[3-8]/ | Fixed | All surface of the earth belongs to exactly one continent. |
| Jurisdiction | Not fixed | ||
| Region ? | |||
| Sector | /[3-8][A-Z0-9]{1,}/ (Note: further restriction likely) | Fixed | All land surface belongs to exactly one sector. |
| Zone | Not fixed | Real world time zone, e.g. Mountain Time Zone. For a given point in time located in one jurisdiction? That could contradict zones like Central European Time if there is no jurisdiction "Europe". |
Boundary
Continent
That allows grouping of sectors by larger geographic regions.
ContinentID:
- Not used:
- 0 - to avoid misreadings as O
- 1 and 2 - to avoid that a 4-digit SectorID could look like a year
- 9 - to have room for extensions, e.g. other planets, or private use area.
- similar to first digit of country calling code, https://commons.wikimedia.org/wiki/File:CallingCodesWorld-Labeled.svg
- 7 is taken from former Soviet Union and applied to all of Europe, this frees 3 and 4
- 3 is assigned to Antarctica to have this special region at the border of the 3-8 ID space
- 8 is taken from East Asia and used for all of Asia
| ID | Name | max E/W | Description |
|---|---|---|---|
| 3 | Antarctica | 360° | As defined by Antarctic Treaty |
| 4 | Africa | 90° | |
| 5 | America | 135° | The East and West boundaries are strict, i.e. Greenland and Umnak are divided. |
| 6 | Oceania | 135° | |
| 7 | Europe | 225° | Includes territory of former Soviet Union, Cyprus (island), Malta, Turkey. |
| 8 | Asia |
ContinentBoundary
Assignment of Ex-Soviet Union to Europe as for ITU region 1
| ID | Name | LowerID | HigherID | Description |
|---|---|---|---|---|
| 34 | Antarctica-Africa | 3 | 4 | 60° South |
| 35 | Antarctica-America | 3 | 5 | 60° South |
| 36 | Antarctica-Oceania | 3 | 6 | 60° South |
| 45 | Africa-America | 4 | 5 | 33.75° West |
| 46 | Africa-Oceania | 4 | 6 | 56.25° East |
| 47 | Africa-Europe | 4 | 7 | Line in the Mediterranean, South of Malta, West to the Strait of Gibraltar it is a straight line. |
| 56 | America-Oceania | 5 | 6 | 168.75° West (Umnak meridian) |
| 57 | America-Europe | 5 | 7 | 33.75° West up to the North Pole, then South on 168.75° West (Umnak meridian) |
| 58 | America-Asia | 5 | 8 | 168.75° West (Umnak meridian) |
| 78 | Europe-Asia | 7 | 8 | From America follows the southern border of former Soviet Union, at the border of Turkey follow the southern border of Turkey to the Mediterranean. Passing between Cyprus and Syria. |
Jurisdiction
A jurisdiction is a political entity. The concept is similar to the concept of country in ISO 3166-1. But the term jurisdiction is preferred:
- to have the initial letter different from Continent
Sector
A sector
- is located in exactly one Continent
- has exactly one SectorID
- is not divided by jurisdiction boundaries since 1946-01-01T00:00:00, except for time of war, when the boundaries between jurisdictions moved.
A SectorID:
- conforms to the REGEX: /[3-8][A-Z0-9]{1,}/ (Note: further restriction likely)
- has the ContinentID as the first character
- contains no reference to a country (IANA zone sometimes to, e.g. those for Argentina)
There should be a Private Use Area in the SectorID space, to allow people that like to do different sectorization to create non-clashing SectorIDs.