[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
![изображение](https://user-images.githubusercontent.com/2371914/102207943-d0676c00-3edf-11eb-8243-f3ceb9098208.png)

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