a small and simple tool to get the correct replicate sequence id of OpenStreetMap's replation-diffs from a timestamp. Currently deployed on a server near you: https://osm.mazdermind.de/replicate-sequences/
Besides the Web-Form the tool can handle the following API-Call:
https://replicate-sequences.osm.mazdermind.de/?2013-01-01T10:00:00Z
This can be used to always fetch the latest state.file in conjunction with some unix-foo:
curl "https://replicate-sequences.osm.mazdermind.de/?$(date --utc "+%FT%TZ")"
And with even more unix-foo it can be used to fetch the right state.file for a given planet file, assuming that its modification time was preserved when downloading it ("curl" and "wget" usually do):
curl "https://replicate-sequences.osm.mazdermind.de/?$(date -u -d "@$(stat -c "%Y" planet-latest.osm.pbf)" +"%FT%TZ")"
Setting up your own copy of this service is quite easy. Check out into a PHP-Enabled docroot. Create a MySQL-Database and a User that has INSERT and SELECT permissions on it. Copy conf.php.tpl to conf.php and fill in your database name and user credentials. You also MUST FILL IN an E-Mail-Adress where admins of planet.osm.org can contact you, in case this script runs crazy on your server.
Now populate your database with schema.sql to get the empty tables. You could now start running update.php and it will download >750000 state.txt-files to populate your database. This will take at least one complete day. Be sure to keep running update.php every 1-2 minutes to keep your database up to date.
This tools consists of two Containers, both running the same image (mazdermind/replicate-sequences:v2 but with different environment. Additionally a MySQL database container is needed. Check out docker/compose.yaml for an example on how to deploy the containers.
If you need to rebuild the docker image, use the scripts provided:
cd docker
./build-container.sh
./push-container.sh
If you have any questions just ask at osm@mazdermind.de.
Peter