[Tile-serving] [osm2pgsql-dev/osm2pgsql] hstore not importing some tags? (Discussion #2192)

[ImreSamu]

> Ok, here's a better query, just a rewrite of the one above, and I can confirm some data is duplicated:


In OSM, the two relations/linestrings are not exactly the same, 
although there may be overlaps. 
It would be advisable to also output the number of points in the linestring in the select statement. (  [ST_NumPoints() ](https://postgis.net/docs/ST_NumPoints.html)  ) 

```
 osm_id   |    boundary    | admin_level | maritime |                                                                                                                                                                                                                        >
-----------+----------------+-------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------>
  -1124039 | administrative | 2           |          | LINESTRING(828124.7276440877 5426682.842113642,828044.0210132627 5426740.121963693,828042.3734847989 5426741.863326018,828041.1823662475 5426743.9437150685,828040.1693588811 5426746.239848712,828039.5237058346 54267>
  -2202162 | administrative | 2           |          | LINESTRING(828124.7276440877 5426682.842113642,828044.0210132627 5426740.121963693,828042.3734847989 5426741.863326018,828041.1823662475 5426743.9437150685,828040.1693588811 5426746.239848712,828039.5237058346 54267>
```

osm_id = -1124039  -->  https://www.openstreetmap.org/relation/1124039  ( Monaco )
osm_id =  -2202162  --> https://www.openstreetmap.org/relation/2202162  ( France )






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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2192/comments/9639877 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240602/4a638400/attachment.htm>