[Tile-serving] [openstreetmap/osm2pgsql] Missing MultiPolygons (#866)

ihor-nahuliak notifications at github.com
Sun Sep 30 14:30:20 UTC 2018


I think the issue happens because some boundary linestrings can not be merged as rings.
```sql
select string_agg(distinct name, ', ') as name, ST_IsClosed(ST_LineMerge(ST_Union(way))), ST_IsSimple(ST_LineMerge(ST_Union(way))) from planet_osm_line where admin_level='2' and boundary='administrative' and tags->'name:en' = 'Spain' group by osm_id;

  name  | st_isclosed | st_issimple 
--------+-------------+-------------
 EspaƱa | f           | t
(1 row)
```
```sql
select ST_AsGeoJSON(ST_MakePolygon(ST_LineMerge(ST_Union(way)))) from planet_osm_line where admin_level='2' and boundary='administrative' and tags->'name:en' = 'Spain' group by osm_id;

ERROR:  Shell is not a line
```
Does anybody know how to close unclosed linestrings automatically?

-- 
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/866#issuecomment-425724740
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180930/e2fa85f9/attachment.html>


More information about the Tile-serving mailing list