NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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!

asked 07 Jan '22, 15:24

ghelbing's gravatar image

ghelbing
11112
accept rate: 0%


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 tags->'cuisine', e.g.

SELECT name, tags->'cuisine' as cuisine
FROM planet_osm_point

Anyway this has nothing to do with the Geofabrik download file; the .osm.pbf contains all data ans all tags.

permanent link

answered 07 Jan '22, 15:30

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

edited 07 Jan '22, 15:31

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×40

question asked: 07 Jan '22, 15:24

question was seen: 1,019 times

last updated: 07 Jan '22, 15:31

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum