<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi list,</p>
<p>I can make a spatial 3d view and add it to geometry_columns?</p>
<p>I'm on PostgreSql 9.5 and Postgis 2.3<br>
</p>
<p>I did in this way:</p>
<p>CREATE OR REPLACE VIEW view3d AS <br>
select st_force3dz(st_transform(the_geom, 25832)), ....</p>
<p>after <br>
</p>
<p>select populate_geometry_columns('view3d'::regclass);</p>
<p>in the geometry_columns i look that:</p>
<p> f_table_catalog | f_table_schema | f_table_name |
f_geometry_column | coord_dimension | srid | type <br>
----------------------+--------------------+-------------------+--------------------------+-----------------------+-------+-------<br>
database | public | view3d |
the_geom | 2 | 0 |
GEOMETRY<br>
</p>
<p>wrong coord_dimention, srid and type</p>
<p>If instead to do a view a I do a table, all is correct.</p>
<p>Someone can help me.</p>
<p>Thanks in advance</p>
<p>Walter<br>
</p>
<div class="moz-signature">-- <br>
<p style="font-size:12px;">
Walter Lorenzetti phD<br>
email: <a class="moz-txt-link-abbreviated" href="mailto:lorenzetti@gis3w.it">lorenzetti@gis3w.it</a><br>
skype: aiki74<br>
twitter:<a href="https://twitter.com/w_lorenzetti">w_lorenzetti</a><br>
g+:<a href="https://plus.google.com/117055903318462447104/">aiki74</a><br>
Tel/Cell: (+39) 347-6597931<br>
Viale Verdi 24 - 51016 Montecatini Terme (PT)
<br>
<a
href="http://gis3w.it/it/calendario-corsi-software-geografici">Nuovi
corsi QGIS e GFOSS</a>
</p>
</div>
</body>
</html>