<div dir="ltr"><div><div><div>it outputs 2.<br><br></div>creation of the table is more than explicit :<br><br>DROP TABLE IF EXISTS registration_joined_with_trajectory;<br>            CREATE TABLE registration_joined_with_trajectory (<br>
                ...<br>                ,geom geometry(LinestringZ,931008)<br>                ,geom_surf geometry(PolygonZ,931008)<br>            )<br><br></div>What do you think?<br><br></div>Cheers,<br>Rémi-C<br></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2014-03-31 17:14 GMT+02:00 Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On Mon, Mar 31, 2014 at 05:06:57PM +0200, Rémi Cura wrote:<br>
> Hey,<br>
> my pgsql2shp doesn't output 3D (but 2D).<br>
><br>
> Am I missing something ?<br>
><br>
> /usr/lib/postgresql/9.3/bin/pgsql2shp -f registration_surf_3D -h localhost<br>
> -p 5433 -u postgres -P uGuess -g geom_surf -r import_xml<br>
> public.registration_joined_with_trajectory<br>
><br>
> I have the latest postgis/geos/postgres/gdal.<br>
><br>
> Of course ST_AsText output 3D geometry,<br>
> the table is defined as geometry(polygonZ, XXXX)<br>
<br>
</div></div>What does this give you ?<br>
<br>
 SELECT max(ST_zmflag("geom_surf"::geometry))<br>
 FROM public.registration_joined_with_trajectory;<br>
<br>
--strk;<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div>