[postgis-users] Size of a multipolygon

[pcreso at pcreso.com]

Hey Ben,

How goes it?

Does 
http://postgis.refractions.net/documentation/manual-1.5/ST_NumGeometries.html
do what you want?

& FYI, I was interested in this post, as a PL/R user it may interest you as well?

http://www.spatialdbadvisor.com/postgis_tips_tricks/290/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package 

Cheers,

  Brent


--- On Wed, 5/2/12, Ben Madin <lists at remoteinformation.com.au> wrote:

From: Ben Madin <lists at remoteinformation.com.au>
Subject: [postgis-users] Size of a multipolygon
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Wednesday, May 2, 2012, 3:26 PM

Hello all,

I'm sure the answer is simple, but I'm lost on what to search on - I need to quickly search through several thousand multi polygons for any which have more than one part making them up. 

What is the best way to do this…? (I've tried array_length(), but don't seem to be able to feed it the right part. I can't believe I can't find a function that does it… or am I looking at dumping the multi polygons into a new table and counting the number of lines for each one...

cheers

Ben


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120501/e11e2191/attachment.html>