<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>in OpenStreetMap PostgreSQL/PostGIS database there is a table
with a geometry of type "geometry(Geometry,4326)".</p>
<p>see</p>
<p><tt> \d+ planet_osm_polygon<br>
...<br>
way | geometry(Geometry,4326)
| | | | main
| | </tt><tt><br>
</tt><tt> pointonsurface |
geometry(Point,4326) | |
| | main | | </tt><tt><br>
</tt><tt> bbox</tt><tt> |
geometry(Polygon,4326) | |
| | main | | </tt><br>
...<br>
</p>
<p>The geometry column "way" is not visible in the layer dialog
(Layer/Layer hinzufügen/PostGIS Layer hinzufügen/):</p>
<p>see
<a class="moz-txt-link-freetext" href="https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem.png">https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem.png</a>
and
<a class="moz-txt-link-freetext" href="https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem2.png">https://wambachers-osm.website/images/osm/snaps_2019/tn_qgis_geometry_problem2.png</a></p>
<p>Creating views does help, but performance is very poor. That work
around should not be necessary, i think.</p>
<p>This table is really big: >300 GB without indices, 406.807.497
rows, permanently growing. <br>
</p>
<p>Because that is an osm core table, i can't change the geometry of
this column (way) to "geometry( MultiPolygon, 4326)" because i
can't be shure everything will be running fine after this change.
Or will fail if some core software has been changed.<br>
</p>
<p>QGIS 3.8.0 but older releases too. IIRC 2.x was ok.<br>
</p>
<p>any ideas?</p>
<p>Regards</p>
<p>walter<br>
</p>
<p>-- <br>
</p>
<div class="moz-signature">My projects:<br>
<br>
<a href="https://wambachers-osm.website/boundaries">Admin
Boundaries of the World</a><br>
<a
href="https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries">Missing
Boundaries</a><br>
<a href="https://wambachers-osm.website/emergency">Emergency Map</a><br>
<a href="https://wambachers-osm.website/plz">Postal Code Map
(Germany only)</a><br>
<a href="https://wambachers-osm.website/fools">Fools (QA for
zipcodes in Germany)</a><br>
<a href="https://wambachers-osm.website/pcoundaries"> Postcode
Boundaries of Germany</a></div>
</body>
</html>