[postgis-users] pgsql2shp : failing to output 3D

[Rémi Cura]

Ok,
now it works,
I added a filter on geom to filter out null geometries.
It seems that pgsql2shp doesn't like NULL geometries.

Cheers,
Rémi-C


2014-03-31 17:53 GMT+02:00 Rémi Cura <remi.cura at gmail.com>:

> I should add that using ogr2ogr straight, it works !
>
> Cheers,
>
> Rémi-C
>
>
> 2014-03-31 17:47 GMT+02:00 Rémi Cura <remi.cura at gmail.com>:
>
> Hey,
>> thanks for your help !
>>
>> when executing the commands :
>> Initializing...
>> Done (postgis major version: 2).
>> Output shape: Polygon
>>
>> Initializing...
>> Done (postgis major version: 2).
>> Output shape: PolyLine
>> then happily finishes.
>>
>> about pgsql2shp  :
>> RELEASE: 2.2.0dev (r12325)
>> USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
>>        pgsql2shp [<options>] <database> <query>
>>
>> OPTIONS:...
>>
>>
>> Cheers,
>> Rémi-C
>>
>>
>>
>>
>>
>>
>> 2014-03-31 17:37 GMT+02:00 Sandro Santilli <strk at keybit.net>:
>>
>> On Mon, Mar 31, 2014 at 05:25:44PM +0200, Rémi Cura wrote:
>>> > it outputs 2.
>>> >
>>> > creation of the table is more than explicit :
>>> >
>>> > DROP TABLE IF EXISTS registration_joined_with_trajectory;
>>> >             CREATE TABLE registration_joined_with_trajectory (
>>> >                 ...
>>> >                 ,geom geometry(LinestringZ,931008)
>>> >                 ,geom_surf geometry(PolygonZ,931008)
>>> >             )
>>> >
>>> > What do you think?
>>>
>>> And what does pgsql2shp print in the header ?
>>> Like:
>>>
>>>  Initializing...
>>>  Done (postgis major version: 2).
>>>  Output shape: PolyLineZ
>>>
>>> Also, first line of output from pgsql2shp invoked
>>> with no arguments ?
>>>
>>> --strk;
>>>
>>> > 2014-03-31 17:14 GMT+02:00 Sandro Santilli <strk at keybit.net>:
>>> >
>>> > > On Mon, Mar 31, 2014 at 05:06:57PM +0200, Rémi Cura wrote:
>>> > > > Hey,
>>> > > > my pgsql2shp doesn't output 3D (but 2D).
>>> > > >
>>> > > > Am I missing something ?
>>> > > >
>>> > > > /usr/lib/postgresql/9.3/bin/pgsql2shp -f registration_surf_3D -h
>>> > > localhost
>>> > > > -p 5433 -u postgres -P uGuess -g geom_surf -r import_xml
>>> > > > public.registration_joined_with_trajectory
>>> > > >
>>> > > > I have the latest postgis/geos/postgres/gdal.
>>> > > >
>>> > > > Of course ST_AsText output 3D geometry,
>>> > > > the table is defined as geometry(polygonZ, XXXX)
>>> > >
>>> > > What does this give you ?
>>> > >
>>> > >  SELECT max(ST_zmflag("geom_surf"::geometry))
>>> > >  FROM public.registration_joined_with_trajectory;
>>> > >
>>> > > --strk;
>>> > > _______________________________________________
>>> > > postgis-users mailing list
>>> > > postgis-users at lists.osgeo.org
>>> > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>> > >
>>>
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at lists.osgeo.org
>>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>>
>>> --
>>>
>>>  ()  ASCII ribbon campaign  --  Keep it simple !
>>>  /\  http://strk.keybit.net/rants/ascii_mails.txt
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140402/5f6d4523/attachment.html>