Time database
Mailing list
Comparison of features
Topic | Time keeping database (tkdb) | IANA time zone database (tzdb) |
---|---|---|
Terminology | Exactly one term for one kind of object |
|
Smallest territorial unit | "sector" | "zone" |
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. |
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" |
Sector | Each sector has exactly one SectorID. | Some zones have multiple IDs via links. These links can
|
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 -._ |
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:
|
Sector | Relations between deprecated sectors and the sectors that have been created out of them are published. | No split history is explicitly published. |
Jurisdiction | ISO 3166-1 alpha-3 codes for jurisdiction. | 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. |
Jurisdiction | Support for former jurisdictions at least back to 1946-01-01, the first full year where the UN existed. | No support for former countries. E.g. no way to get data for ISO 3166 alpha-2 code DD (East Germany) |
Jurisdiction | At any point in time (at least after 1946-01-01) the land surface is associated to a jurisdiction. | 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. |
Sector-Jurisdiction | At any point in time no jurisdiction boundary is located inside a sector. | 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. |
Coverage | Record all legal time |
|
ZoneId | 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. |
DataFormat | Publication in
|
Publication in IANA specific format. |
Tables
Id
Name | Regex | Description |
---|---|---|
ContinentId | /[3-8]/ |
|
JurisdictionId |
The ID for these should /not/ be the ISO 3166-1 alpha-2 codes, as they have been re-assigned, e.g. CS stands for 1) Czechoslovakia and 2) Serbia and Montenegro. There exists no ISO codes for countries that did not exist after the first ISO 3166 publication. It is proposed to use the ISO 3166-1 alpha-3 codes and where needed the Private Use Area of that set. These IDs could be used to relate source documents like laws and newspaper articles to the database. | |
RegionId | ||
SectorId | /[3-8][A-Z0-9]{1,}/ | The first digit is the ContinentId. Further restriction likely.
|
ZoneId | /[A-Z]{1,}/ | Maybe using acronyms similar to the Internationalized time point unique time zone abbreviations |
Area
Except for zone, alphabetical sorting leads to decreasing size.
Name | Boundary | Description |
---|---|---|
Continent | Fixed | All surface of the earth belongs to exactly one continent. |
Jurisdiction | Not fixed |
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:
|
Region ? | ||
Sector | Fixed | All land surface belongs to exactly one sector.
A 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
They allow grouping of sectors and delegation of SectorId creation.
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
Many common maps have the Chukotka Peninsula to the right hand, using the Umnak meridian (Bering Strait) as map limits. Except for Antarctica no continent shall be divided by the Umnak meridian, to avoid that a continent is depicted in two parts on such a map.
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. |
48 | Africa-Asia | 4 | 8 | From the north follow the border of Egypt through the Red Sea. In the Gulf of Aden go to the West until 56.25° East, then go South to the Equator. |
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) |
68 | Asia-Oceania | 6 | 8 | From the Umnak meridian follow the Equator westwards to 56.25° East. |
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.
Assignment of all of Ex-Soviet Union to Europe as for ITU region 1 http://life.itu.ch/radioclub/rr/art05.htm#Reg |
Jurisdiction
Sector
RelationSectorToIanaZone
Publish relations between sectors and IANA zones at least for some IANA releases.