|
Hi there, I am using the osmtw/postgis docker image running PostgreSQL 10.4 and osmtw/osm2pgsql to synchronise with osm on Geofabrik using the osmupdate and osm2pgsql utilities. I limited myself to the region Europe/Germany/Berlin. Everything went smooth and seems to be working. The table planetosmpoints contains the node objects and their tags. However, I noticed that not all tags are in the table. For instance, the "cuisine"-tag is available via the OverpassAPI, but the planetosmpoints table does not contain it. Can you think of any reason why some tags may be missing from the table? Many thanks in advance! |
|
I am not familiar with the details of this docker image but generally, when importing the data with osm2pgsql, a so-called "style file" governs which OSM tags get their own database columns and which do not. The style file that comes with the standard OSM map style (https://github.com/gravitystorm/openstreetmap-carto/blob/master/openstreetmap-carto.style) does not request a column for "cuisine". Usually you would import with the "hstore" option which leads to the creation of a column "tags" containing all tags that do not have their own column. If this is the case in your setup, then you can access the "cuisine" value with the syntax Anyway this has nothing to do with the Geofabrik download file; the .osm.pbf contains all data ans all tags. |
