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

[Rémi Cura]

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/20140331/1a410e57/attachment.html>