[Tile-serving] [osm2pgsql-dev/osm2pgsql] Has relation handling changed recently? (Discussion #2257)

[Marcos Dione]

I have two rendering DBs imported with `osm2pgsql` the way osm-carto still does (`pgsql` backend, not `flex`). One is updated daily, the other is smaller just for faster rendering tests, never updated. But the render is not updated every day, I just do it in batches from time to time.

One of the things I render is subways with a thick semi transparent line using the color from the DB or red if not available. A few weeks back I rendered Paris with subways and noticed that all subway lines were all rendered with red. Today I decided to look into it. Using a smaller sample, I chose Marseille because it's in the smaller static DB.

For instance, M1 has a bluish color:

https://www.openstreetmap.org/relation/6274531

`colour: #0075be`

And yes, I take in account the different spellings of the tag :) Also, notice `osm-carto`'s DB style does not import color as a column, so it's in the `tags` hstore.

Meanwhile, in my updated DB:

```
europe=# select tags from planet_osm_line where osm_id = -6274531;
 tags 
------
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
(19 rows)
```

All empty. In my static DB:

```
paca=# select tags->'colour' from planet_osm_line where osm_id = -6274531;
 ?column? 
----------
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
 #0075be
(19 rows)
```

So it seems all tags have been removed? Any ideas?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2257
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2257 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240930/bd200326/attachment.htm>