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

[Sandro Santilli]

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