<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hello, <div><br></div><div>I’m trying to be taken off the mailing list for these email notifications and am wondering if you could help me with this?</div><div><br></div><div>Thanks, </div><div><br><div>Robert Koehler<br>Senior Siting and Land Rights Agent<br>Excel Land Services<br><a href="mailto:rkoehler@excellandservices.com">rkoehler@excellandservices.com</a><br>651-253-0003<br><br><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><br class="Apple-interchange-newline"><span><img height="92" width="249" apple-inline="yes" id="21CA0973-2FC6-4869-B974-94D77B24E4EB" apple-width="yes" apple-height="yes" src="cid:214FC082-2ABB-4503-A1CB-860FB8D0BCE3@wp.comcast.net"></span>
</span><br></div><br>On Apr 2, 2014, at 2:00 PM, <a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a> wrote:<br><br>Send postgis-users mailing list submissions to<br><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span class="Apple-tab-span" style="white-space:pre"> </span>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br>or, via email, send a message with subject or body 'help' to<br><span class="Apple-tab-span" style="white-space:pre"> </span>postgis-users-request@lists.osgeo.org<br><br>You can reach the person managing the list at<br><span class="Apple-tab-span" style="white-space:pre"> </span>postgis-users-owner@lists.osgeo.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of postgis-users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: pgsql2shp : failing to output 3D (R?mi Cura)<br> 2. Re: pgsql2shp : failing to output 3D (Sandro Santilli)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 2 Apr 2014 11:13:02 +0200<br>From: R?mi Cura <remi.cura@gmail.com><br>To: PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>Subject: Re: [postgis-users] pgsql2shp : failing to output 3D<br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CAJvUf_tUOwo7ab6+hOfz9S3N3NjDxzhs+72dwW2R76Q_2vsoqQ@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Ok,<br>now it works,<br>I added a filter on geom to filter out null geometries.<br>It seems that pgsql2shp doesn't like NULL geometries.<br><br>Cheers,<br>R?mi-C<br><br><br>2014-03-31 17:53 GMT+02:00 R?mi Cura <remi.cura@gmail.com>:<br><br><blockquote type="cite">I should add that using ogr2ogr straight, it works !<br><br>Cheers,<br><br>R?mi-C<br><br><br>2014-03-31 17:47 GMT+02:00 R?mi Cura <remi.cura@gmail.com>:<br><br>Hey,<br><blockquote type="cite">thanks for your help !<br><br>when executing the commands :<br>Initializing...<br>Done (postgis major version: 2).<br>Output shape: Polygon<br><br>Initializing...<br>Done (postgis major version: 2).<br>Output shape: PolyLine<br>then happily finishes.<br><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>Cheers,<br>R?mi-C<br><br><br><br><br><br><br>2014-03-31 17:37 GMT+02:00 Sandro Santilli <strk@keybit.net>:<br><br>On Mon, Mar 31, 2014 at 05:25:44PM +0200, R?mi Cura wrote:<br><blockquote type="cite"><blockquote type="cite">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></blockquote><br>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><br><blockquote type="cite">2014-03-31 17:14 GMT+02:00 Sandro Santilli <strk@keybit.net>:<br><br><blockquote type="cite">On Mon, Mar 31, 2014 at 05:06:57PM +0200, R?mi Cura wrote:<br><blockquote type="cite">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></blockquote>localhost<br><blockquote type="cite">-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></blockquote><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>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br><br></blockquote></blockquote><br><blockquote type="cite">_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></blockquote><br><br>--<br><br>() ASCII ribbon campaign -- Keep it simple !<br>/\ http://strk.keybit.net/rants/ascii_mails.txt<br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br><br></blockquote><br><br></blockquote><br></blockquote>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140402/5f6d4523/attachment-0001.html><br><br>------------------------------<br><br>Message: 2<br>Date: Wed, 2 Apr 2014 12:06:18 +0200<br>From: Sandro Santilli <strk@keybit.net><br>To: PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>Subject: Re: [postgis-users] pgsql2shp : failing to output 3D<br>Message-ID: <20140402100618.GA10152@localhost><br>Content-Type: text/plain; charset=iso-8859-1<br><br>On Wed, Apr 02, 2014 at 11:13:02AM +0200, R?mi Cura wrote:<br><blockquote type="cite">Ok,<br>now it works,<br>I added a filter on geom to filter out null geometries.<br>It seems that pgsql2shp doesn't like NULL geometries.<br></blockquote><br>Could you please file a ticket for that ?<br><br>--strk;<br><br><br>------------------------------<br><br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br><br>End of postgis-users Digest, Vol 146, Issue 2<br>*********************************************<br><br></div></body></html>