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

[Rémi Cura]

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/2649411a/attachment.html>