[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] pgsql2shp : failing to output 3D
From: Rémi_Cura <remi.cura () gmail ! com>
Date: 2014-03-31 15:53:28
Message-ID: CAJvUf_tb2VqQdpdmdVV=dijfoQZJ_WDhbLsi6uWwRr8Rn_22WQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I should add that using ogr2ogr straight, it works !
Cheers,
R=C3=A9mi-C
2014-03-31 17:47 GMT+02:00 R=C3=A9mi Cura <remi.cura@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=C3=A9mi-C
>
>
>
>
>
>
> 2014-03-31 17:37 GMT+02:00 Sandro Santilli <strk@keybit.net>:
>
> On Mon, Mar 31, 2014 at 05:25:44PM +0200, R=C3=A9mi 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@keybit.net>:
>> >
>> > > On Mon, Mar 31, 2014 at 05:06:57PM +0200, R=C3=A9mi 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
>>
>
>
[Attachment #5 (text/html)]
<div dir="ltr"><div><div>I should add that using ogr2ogr straight, it works \
!<br><br></div>Cheers,<br><br></div>Rémi-C<br></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">2014-03-31 17:47 GMT+02:00 Rémi \
Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" \
target="_blank">remi.cura@gmail.com</a>></span>:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Hey,<br>thanks for your help \
!<br><br>when executing the commands : <br><div class="">Initializing... <br> Done \
(postgis major version: 2).<br></div>Output shape: Polygon<div \
class=""><br>Initializing... <br>Done (postgis major version: 2).<br> Output shape: \
PolyLine<br></div></div>then happily finishes.<br><div><br>about pgsql2shp \
:<br>RELEASE: 2.2.0dev (r12325)<br>USAGE: pgsql2shp [<options>] \
<database> [<schema>.]<table><br> pgsql2shp \
[<options>] <database> <query><br>
<br>OPTIONS:...<br><br><br></div><div>Cheers,<br>Rémi-C<br></div><div><br><br><br><br></div></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">2014-03-31 17:37 GMT+02:00 \
Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" \
target="_blank">strk@keybit.net</a>></span>:<div> <div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div>On Mon, Mar 31, 2014 at 05:25:44PM +0200, Rémi Cura \
wrote:<br> > it outputs 2.<br>
><br>
> creation of the table is more than explicit :<br>
><br>
> DROP TABLE IF EXISTS registration_joined_with_trajectory;<br>
> CREATE TABLE registration_joined_with_trajectory (<br>
> ...<br>
> ,geom geometry(LinestringZ,931008)<br>
> ,geom_surf geometry(PolygonZ,931008)<br>
> )<br>
><br>
> What do you think?<br>
<br>
</div>And what does pgsql2shp print in the header ?<br>
Like:<br>
<br>
Initializing...<br>
Done (postgis major version: 2).<br>
Output shape: PolyLineZ<br>
<br>
Also, first line of output from pgsql2shp invoked<br>
with no arguments ?<br>
<br>
--strk;<br>
<div><br>
> 2014-03-31 17:14 GMT+02:00 Sandro Santilli <<a href="mailto:strk@keybit.net" \
target="_blank">strk@keybit.net</a>>:<br> ><br>
> > On Mon, Mar 31, 2014 at 05:06:57PM +0200, Rémi Cura wrote:<br>
> > > Hey,<br>
> > > my pgsql2shp doesn't output 3D (but 2D).<br>
> > ><br>
> > > Am I missing something ?<br>
> > ><br>
> > > /usr/lib/postgresql/9.3/bin/pgsql2shp -f registration_surf_3D -h<br>
> > localhost<br>
> > > -p 5433 -u postgres -P uGuess -g geom_surf -r import_xml<br>
> > > public.registration_joined_with_trajectory<br>
> > ><br>
> > > I have the latest postgis/geos/postgres/gdal.<br>
> > ><br>
> > > Of course ST_AsText output 3D geometry,<br>
> > > the table is defined as geometry(polygonZ, XXXX)<br>
> ><br>
> > What does this give you ?<br>
> ><br>
> > SELECT max(ST_zmflag("geom_surf"::geometry))<br>
> > FROM public.registration_joined_with_trajectory;<br>
> ><br>
> > --strk;<br>
> > _______________________________________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> > > <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
> ><br> <br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> > <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
<br> <br>
</div><span><font color="#888888">--<br>
<br>
() ASCII ribbon campaign -- Keep it simple !<br>
/\ <a href="http://strk.keybit.net/rants/ascii_mails.txt" \
target="_blank">http://strk.keybit.net/rants/ascii_mails.txt</a><br> \
</font></span><div><div>_______________________________________________<br> \
postgis-users mailing list<br> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div></div></div><br></div> </blockquote></div><br></div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic