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 <s...@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 <s...@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@lists.osgeo.org > > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@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@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users