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

Sandro Santilli strk at keybit.net
Mon Mar 31 08:14:46 PDT 2014


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;


More information about the postgis-users mailing list