[OSM-dev] Time Confusion

Tom Hughes tom at compton.nu
Fri May 15 16:51:14 BST 2009

Frederik Ramm wrote:

>     I notice that there is a mismatch between timestamps given in the 
> planet file and timestamps as reported by the API. The planet file 
> contains node #2 like this:
>    <node id="2" lat="50.1359444" lon="8.3013034" 
> timestamp="2009-04-14T14:42:58Z"
>   version="8" changeset="524633" user="woodpeck" uid="5164">
> But the API returns
>    <node id="2" lat="50.1359444" lon="8.3013034" version="8" 
> changeset="524633" user="woodpeck" uid="5164" visible="true" 
> timestamp="2009-04-14T15:42:58Z">
> Who is right, and why the difference?

The API is right.

Before the move to 0.6 the database was in UK local time, but it is now 
held in UTC no matter what time of year the edit was made.

The database has 2009-04-14 15:42:58 as the timestamp for that edit 
which is what the API is returning (as a Zulu time) so the API seems to 
be correct.

My guess is that the planet dumper is still assuming the DB is in UK 
local time and is converting to UTC for output.


Tom Hughes (tom at compton.nu)

More information about the dev mailing list