I should add that using ogr2ogr straight, it works ! Cheers,
Rémi-C 2014-03-31 17:47 GMT+02:00 Rémi Cura <[email protected]>: > 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 <[email protected]>: > > 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 <[email protected]>: >> > >> > > 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 >> > > [email protected] >> > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > >> >> > _______________________________________________ >> > postgis-users mailing list >> > [email protected] >> > 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 >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
