<div dir="ltr"><div><div><div>Ok,<br></div>now it works,<br></div>I added a filter on geom to filter out null geometries.<br></div>It seems that pgsql2shp doesn't like NULL geometries.<br><br>Cheers,<br>Rémi-C<br></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">2014-03-31 17:53 GMT+02:00 Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div>I should add that using ogr2ogr straight, it works !<br><br></div>Cheers,<br><br></div>Rémi-C<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-03-31 17:47 GMT+02:00 Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span>:<div>
<div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hey,<br>thanks for your help !<br><br>when executing the commands : <br><div>Initializing... <br>
Done (postgis major version: 2).<br></div>Output shape: Polygon<div><br>Initializing... <br>Done (postgis major version: 2).<br>
Output shape: PolyLine<br></div></div>then happily finishes.<br><div><br>about pgsql2shp :<br>RELEASE: 2.2.0dev (r12325)<br>USAGE: pgsql2shp [<options>] <database> [<schema>.]<table><br> pgsql2shp [<options>] <database> <query><br>
<br>OPTIONS:...<br><br><br></div><div>Cheers,<br>Rémi-C<br></div><div><br><br><br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-03-31 17:37 GMT+02:00 Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>></span>:<div>
<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On Mon, Mar 31, 2014 at 05:25:44PM +0200, Rémi Cura wrote:<br>
> it outputs 2.<br>
><br>
> 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>
> What do you think?<br>
<br>
</div>And what does pgsql2shp print in the header ?<br>
Like:<br>
<br>
Initializing...<br>
Done (postgis major version: 2).<br>
Output shape: PolyLineZ<br>
<br>
Also, first line of output from pgsql2shp invoked<br>
with no arguments ?<br>
<br>
--strk;<br>
<div><br>
> 2014-03-31 17:14 GMT+02:00 Sandro Santilli <<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>>:<br>
><br>
> > 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<br>
> > 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>
> > 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" target="_blank">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>
> ><br>
<br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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>
<br>
<br>
</div><span><font color="#888888">--<br>
<br>
() ASCII ribbon campaign -- Keep it simple !<br>
/\ <a href="http://strk.keybit.net/rants/ascii_mails.txt" target="_blank">http://strk.keybit.net/rants/ascii_mails.txt</a><br>
</font></span><div><div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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>
</div></div></blockquote></div></div></div><br></div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div>