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

[Rémi Cura]

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?

Cheers,
Rémi-C


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140331/0419fda9/attachment.html>