Re: [postgis-users] postgis-users Digest, Vol 146, Issue 2

[email protected] Thu, 03 Apr 2014 19:53:22 -0700

Hello,

I’m trying to be taken off the mailing list for these email notifications and am wondering if you could help me with this?

Thanks,

Robert Koehler
Senior Siting and Land Rights Agent
Excel Land Services
[email protected]
651-253-0003

On Apr 2, 2014, at 2:00 PM, [email protected] wrote:

Send postgis-users mailing list submissions to
[email protected]

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
[email protected]

You can reach the person managing the list at
[email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."

Today's Topics:

1. Re: pgsql2shp : failing to output 3D (R?mi Cura)
2. Re: pgsql2shp : failing to output 3D (Sandro Santilli)

----------------------------------------------------------------------

Message: 1
Date: Wed, 2 Apr 2014 11:13:02 +0200
From: R?mi Cura <[email protected]>
To: PostGIS Users Discussion <[email protected]>
Subject: Re: [postgis-users] pgsql2shp : failing to output 3D
Message-ID:
<cajvuf_tuowo7ab6+hofz9s3n3njdxzhs+72dww2r76q_2vs...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

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 <[email protected]>:

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140402/5f6d4523/attachment-0001.html>

------------------------------

Message: 2
Date: Wed, 2 Apr 2014 12:06:18 +0200
From: Sandro Santilli <[email protected]>
To: PostGIS Users Discussion <[email protected]>
Subject: Re: [postgis-users] pgsql2shp : failing to output 3D
Message-ID: <20140402100618.GA10152@localhost>
Content-Type: text/plain; charset=iso-8859-1

On Wed, Apr 02, 2014 at 11:13:02AM +0200, R?mi Cura wrote:

Ok,
now it works,
I added a filter on geom to filter out null geometries.
It seems that pgsql2shp doesn't like NULL geometries.

Could you please file a ticket for that ?

--strk;

------------------------------

_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

End of postgis-users Digest, Vol 146, Issue 2
*********************************************

_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] postgis-users Digest, Vol 146, Issue 2

Reply via email to