[QGIS-Developer] PostGIS 3D cube lacks vertical faces

[Jakob Lanstorp]

Hi Anita et al,

How did you get the geometry into QGIS. I have tried running a sql from
within the db manager plugin on a postgis datebase like:

SELECT
'POLYHEDRALSURFACE Z (
    ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),
    ((0 0 0, 0 1 0, 0 1 1, 0 0 1, 0 0 0)),
    ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
    ((1 1 1, 1 0 1, 0 0 1, 0 1 1, 1 1 1)),
    ((1 1 1, 1 0 1, 1 0 0, 1 1 0, 1 1 1)),
    ((1 1 1, 1 1 0, 0 1 0, 0 1 1, 1 1 1))
  )'::geometry

It show the polyhedral in 2D in both QGIS 2D and 3D window, but crashes QGIS
when changing properties.

I have also tried creating a view in postgis like:

CREATE OR REPLACE VIEW test.polyhedraltest AS (
  SELECT
    row_number() OVER () AS row_id,
    'POLYHEDRALSURFACE Z (
    ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),
    ((0 0 0, 0 1 0, 0 1 1, 0 0 1, 0 0 0)),
    ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
    ((1 1 1, 1 0 1, 0 0 1, 0 1 1, 1 1 1)),
    ((1 1 1, 1 0 1, 1 0 0, 1 1 0, 1 1 1)),
    ((1 1 1, 1 1 0, 0 1 0, 0 1 1, 1 1 1))
  )'::geometry AS geom
);

This just loades an empty layer in QGIS.

regards
Jakob

Using the 64 bit OSGEO4W downloaded 2017-dec-14:
QGIS version 2.99.0-Master
QGIS code revision 010cb1567b



-----
Jakob Lanstorp
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html