[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