Hello Community members;
The objective is to move daily updates to “overpass” database from Geofabrik server to OSM planet server.
Two points before going any further; database is for a limited area or region, so an EXTRACT needs to be made from planet differ file before applying. The second point might be silly, but the timestamp in both Geofabrik and planet files are the same UTC time, so we do not need to worry about any time zone difference here.
The OSM planet server generates (calculates) daily differs at 00:00:00 each day; or midnite.
The following is the last “state.txt” for differ file applied to my overpass database:
# original OSM minutely replication sequence number 6350444
timestamp=2024-11-16T21\:21\:14Z
sequenceNumber=4246
The key from the first line is the sequence number 6350444 from OSM PLANET server is for minutely already applied changes, so I need to start just after that timestamp?
The timestamp line puts me about 39 minutes away from the hour, so I need the next 39 minutely change files to be at 22:00:00 that is next hour.
Then I need the next two hours to get to midnite to reach the daily cut-off time?
To ensure that I do not loose any data, there has to be an overlap period when moving from minute to hour and again from hour to day, what is the optimal period?
Any thoughts are very much appreciated.
Wael