Ok, now it works, I added a filter on geom to filter out null geometries. It seems that pgsql2shp doesn't like NULL geometries.
Cheers, Rémi-C 2014-03-31 17:53 GMT+02:00 Rémi Cura <remi.c...@gmail.com>: > I should add that using ogr2ogr straight, it works ! > > Cheers, > > Rémi-C > > > 2014-03-31 17:47 GMT+02:00 Rémi Cura <remi.c...@gmail.com>: > > 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