[postgis-users] st_collect, st_union

Bob Pawley rjpawley at shaw.ca
Thu Jun 30 14:59:12 PDT 2011


select st_summary returns empty.

Are you suggesting that the problem is the postgis version??

Postgris v 1.4.1

Bob

-----Original Message----- 
From: Sandro Santilli
Sent: Thursday, June 30, 2011 1:42 PM
To: Bob Pawley
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] st_collect, st_union

On Thu, Jun 30, 2011 at 08:55:04AM -0700, Bob Pawley wrote:
> I see what you mean.
>
> Try this one. It does import and will st_collect with fewer than the
> five rows but returns an empty value for all rows.

$ pg_restore import_process.backup  | psql
$ psql
strk=# select st_summary(st_collect(wkb_geometry)) from import_process;
             st_summary
-------------------------------------
MultiLineString[ZB] with 5 elements
   LineString[M] with 46 points
   LineString[M] with 2 points
   LineString[M] with 46 points
   LineString[M] with 46 points
   LineString[M] with 46 points

(1 row)

strk=# select postgis_full_version();
                                           postgis_full_version
----------------------------------------------------------------------------------------------------------
POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 
2009" LIBXML="2.7.6" USE_STATS
(1 row)

You are facing bad dragons.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html 




More information about the postgis-users mailing list