[Tile-serving] [openstreetmap/osm2pgsql] Unexpected output: no polygon for specific OSM relation. (#1372)
Alexey Grachev
notifications at github.com
Tue Dec 15 11:21:58 UTC 2020
Hi @pnorman
thanks for the update and fix.
How can I debug and fix such issues by myself? There are lots of them. You may see that there are about 4-5 missed counties in the NY state. I guess there are many of them in the US and other countries.
Another example https://www.openstreetmap.org/relation/1837992#map=10/42.7495/-77.4316

Also apart from unclosed relation issue, osm2ppsql was unable to recognize this line https://www.openstreetmap.org/way/303266774#map=11/42.7624/-77.4948 , despite its nodes exist in DB
```
with w as (
select unnest(ow.nodes) way_node
from osm_ways ow
where ow.id=303266774
)
select way_node, ST_GeographyFromText('Point(' || lon/10000000.0 || ' ' || lat/10000000.0 || ')')
from w, osm_nodes osn
where osn.id=way_node;
way_node |st_geographyfromtext |
----------|------------------------------|
263513941|POINT (-77.587997 42.85401) |
3076177262|POINT (-77.5880389 42.8419625)|
3076177263|POINT (-77.5878147 42.8164676)|
263508743|POINT (-77.5884498 42.7629665)|
```
It seems to be a separate issue.
Is it possible to implement additional feature in osm2pgsql like special option --enclose-relation-to-polygon, which would try to enclose relation into polygon?
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1372#issuecomment-745226339
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20201215/259dda09/attachment.htm>
More information about the Tile-serving
mailing list