Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Thanks for the heads up. I'm forking osm-carto, but I haven't been following it much, mostly for lack of time. I can keep the experiment alive while I reimport Europe, if you want. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11135194 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Carto switched to flex last week, see https://github.com/gravitystorm/openstreetmap-carto/issues/4977. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11133801 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
osm-carto still uses the `pgsql` output, and my style is a fork of that one, so for now I'm forced to keep using it. There are efforts to use `flex`, but as far as my low attention span can tell, it's not done yet. Here: https://github.com/gravitystorm/openstreetmap-carto/issues/4112 As for a reproducer, I just wrote a script to count subway routes with a colour tag before and after updating the Paris region. I know for a fact there are 190 routes and all have the tag, and I hope no new lines are in the near future and nobody breaks them :) Once I catch a difference, I can come up with a reproducer. This might take a while, tho. I'm closing for now. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11133526 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Closed #2192 as resolved. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Sorry, you lost me. The issues seem to be jumping around here. If I understand correctly you are saying that some data is not updated correctly. But without a clear repeatable minimal case, nobody is going to be able to track this down. So: We need an input file, a change file, all config files and the command line used that clearly shows the problem. And another thing: The pgsql output is now deprecated. Even if there is something wrong with it, it is unlikely this will get much attention. Please switch to the flex output. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11133254 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
I have another example: ```sql -- freshly imported ile-de-france-latest.osm.pbf paris=# SELECT COALESCE(tags->'colour', tags->'color', 'red') as color FROM planet_osm_line WHERE osm_id = -3328716; -- Ligne 11 subway color - #d2d200 #d2d200 (2 rows) ``` vs. ``` --- Europe imported on 2024-09-30T20:21:15Z updated daily europe=# SELECT COALESCE(tags->'colour', tags->'color', 'red') as color FROM planet_osm_line WHERE osm_id = -3328716; color --- red red (2 rows) ``` I still think something's fishy. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11131327 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Thanks, that was it. I just noticed that there are **3** line tables: `planet_osm_ways`, `planet_osm_roads` AND `planet_osm_lines`. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11131305 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
The `roads` table only contains major roads, for small zoom levels. You have to look into the `lines` table for that way 983355274. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11131120 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Reopened #2192. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
> `--hstore` or `-k` adds any tags not already in a conventional column to a > hstore column called tags. With the default stylesheet this would result in > tags like highway appearing in a conventional column while tags not in the > style like `name:en` or `lanes:forward` would appear only in the hstore > column. > `--hstore-all` or `-j` adds all tags to a hstore column called tags, even if > they’re already stored in a conventional column. I don't think that's what I want. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11129501 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
``` osm2pgsql version 2.0.0 Libosmium 2.20.0 Proj 9.5.0 Lua 5.3.6 ``` -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11129483 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
> I import that .pbf: osm2pgsql ... --hstore Perhaps it might be better to use `--hstore-all` instead of `--hstore` . Could you test it with that option as well? By the way, which osm2pgsql version are you using? (v1 or v2) in the https://osm2pgsql.org/doc/manual.html#use-of-hstore : > `--hstore-all` or `-j` adds all tags to a hstore column called tags, even if they’re already stored in a conventional column. With the standard stylesheet this would result in tags like `highway` appearing in conventional column and the hstore column while tags not in the style like name:en or lanes:forward would appear only in the hstore column. > You can not use both `--hstore` and `--hstore-all` together. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11129419 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
Re: [Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)
Ok, I know this was closed, but the only answer I got was why I was getting two borders instead of one. But the original question remains: why some tags are not imported? I just found the same again today. While trying to report another instance of this, I got a question about `osm_id`: are they stable? Exhibit A: https://www.openstreetmap.org/way/983355274 Exhibit B: ``` europe=# select tags from planet_osm_roads where osm_id = 983355274; tags -- (0 rows) ``` This way is 3yo and I reimported Europe recently, and been updating it daily. -- Reply to this email directly or view it on GitHub: https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11128834 You are receiving this because you are subscribed to this thread. Message ID: ___ Tile-serving mailing list Tile-serving@openstreetmap.org https://lists.openstreetmap.org/listinfo/tile-serving
