Return to Answer

Using OSMConvert, the wiki shows how you can extract/display the timestamp from the file header:

osmconvert yourfile.pbf --out-timestamp

you can download it here

Using OSM2PGL, the wiki describes how the timestamp is retrieved with each object by editing the default.style file (or create a new one). A new column is created in the database for the extract. Simply unremark the timestamp at line 78 and use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.

Using OSMConvert, the wiki shows how you can extract/display the timestamp from the file header:

osmconvert yourfile.pbf --out-timestamp

This could be included in your update process and piped into the database for your GUI to read later.

you can download it here

Using OSM2PGL, the wiki describes how the timestamp is retrieved with each object by editing the default.style file (or create a new one). A new column is created in the database for the extract. Simply unremark the timestamp at line 78 and use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.

Using OSMConvert, the wiki shows how you can extract the timestamp:

osmconvert yourfile.pbf --out-timestamp

you can download it here

Using OSM2PGL, the wiki describes how the timestamp is retrieved by editing the default.style file (or create a new one) to unremark the timestamp at line 78.

Then use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.

Using OSMConvert, the wiki shows how you can extract/display the timestamp from the file header:

osmconvert yourfile.pbf --out-timestamp

you can download it here

Using OSM2PGL, the wiki describes how the timestamp is retrieved with each object by editing the default.style file (or create a new one). A new column is created in the database for the extract. Simply unremark the timestamp at line 78 and use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.

Using OSM2PGL, the wiki describes how the timestamp is retrieved by editing the default.style file (or create a new one) to unremark the timestamp at line 78.

Then use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.

Using OSMConvert, the wiki shows how you can extract the timestamp:

osmconvert yourfile.pbf --out-timestamp

you can download it here

Using OSM2PGL, the wiki describes how the timestamp is retrieved by editing the default.style file (or create a new one) to unremark the timestamp at line 78.

Then use the following command without --hstore and include the style file reference:

osm2pgsql --extra-attributes -S default.style -d databasename yourfile.pbf

You don't have to get that from the database. When you are downloading the PBF you can retrieve the timestamp at that time.