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 <li...@remoteinformation.com.au> wrote: From: Ben Madin <li...@remoteinformation.com.au> Subject: [postgis-users] Size of a multipolygon To: "PostGIS Users Discussion" <postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
