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

Thu Apr 3 17:14:01 PDT 2014

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
rkoehler at excellandservices.com
651-253-0003

On Apr 2, 2014, at 2:00 PM, postgis-users-request at lists.osgeo.org wrote:

Send postgis-users mailing list submissions to
	postgis-users at lists.osgeo.org

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
	postgis-users-request at lists.osgeo.org

You can reach the person managing the list at
	postgis-users-owner at lists.osgeo.org

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 <remi.cura at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] pgsql2shp : failing to output 3D
Message-ID:
	<CAJvUf_tUOwo7ab6+hOfz9S3N3NjDxzhs+72dwW2R76Q_2vsoqQ at 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 <remi.cura at 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.cura at 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 <strk at 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 <strk at 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 at lists.osgeo.org
>>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>>> 
>>> 
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at 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 at lists.osgeo.org
>>> 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 <strk at keybit.net>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] pgsql2shp : failing to output 3D
Message-ID: <20140402100618.GA10152 at 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
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140403/62478efe/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PastedGraphic-2.tiff
Type: image/tiff
Size: 30056 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140403/62478efe/attachment.tiff>