2

I have downloaded and converted a geofabrik pbf file to a db file. When I open it as a SpatiaLite layer there is no timestamp for each feature. Is there a way to get this information or is it lost in the conversion?

The timestamp is important for me to compare updates.

I have tried using the QuickOSM plugin but I need to work with large datasets and it is too slow.

1
  • How did you do the conversion?
    – user30184
    Nov 30, 2021 at 18:43

1 Answer 1

1

If you have used GDAL for conversion, read the driver manual https://gdal.org/drivers/vector/osm.html and find the osmconf.ini file from your GDAL_DATA directory. The keys which will be converted are selected with that configuration file. For most users the timestamps are waste of space and they are skipped by default. See the default settings in the osmconf.ini file

[points]
# common attributes
osm_id=yes
osm_version=no
osm_timestamp=no

There are separate settings for each layer (points, lines...).

3
  • That's what I used. I can't locate the osmconf.ini file. I'm on windows 10, any ideas?
    – brink
    Nov 30, 2021 at 19:48
  • If you used OSGeo4W installer it may be at C:\OSGeo4W\share\gdal but you will find it by name with file explorer or from the command line dir \s osmconf.ini. Or check the value of the environmental variable with set gdal_data.
    – user30184
    Nov 30, 2021 at 20:05
  • Awesome, that worked. I see there are other edits I can make as well, this helps a lot. Thank you.
    – brink
    Nov 30, 2021 at 23:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.