<html><body><div style="font-family: garamond,new york,times,serif; font-size: 12pt; color: #000000"><div>Hi,</div><div><br data-mce-bogus="1"></div><div>Did you try to specify the geometry type on the fly using typemod with ::geometry(geometrytype, srid) ?</div><div><br data-mce-bogus="1"></div><div>Regards,</div><div><br data-mce-bogus="1"></div><div>Hug</div><div></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>De: </b>"Walter Lorenzetti" <lorenzetti@gis3w.it><br><b>À: </b>"PostGIS Users Discussion" <postgis-users@lists.osgeo.org><br><b>Envoyé: </b>Mardi 26 Septembre 2017 12:51:38<br><b>Objet: </b>[postgis-users] Postigs 2.3 spatial view and geometry_columns<br></div><div><br></div><div data-marker="__QUOTED_TEXT__"><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" target="_blank">lorenzetti@gis3w.it</a><br>
skype: aiki74<br>
twitter:<a href="https://twitter.com/w_lorenzetti" target="_blank">w_lorenzetti</a><br>
g+:<a href="https://plus.google.com/117055903318462447104/" target="_blank">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" target="_blank">Nuovi
corsi QGIS e GFOSS</a>
</p>
</div>
<br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>https://lists.osgeo.org/mailman/listinfo/postgis-users<br></div></div></body></html>