[postgis-users] Select largest polygon of a multipolygon ?

Arnaud Lesauvage thewild at freesurf.fr
Tue Jul 11 10:29:44 PDT 2006


Nahum Castro a écrit :
> select the area, order by area desc and limit to 1

You did not understand the question nore did you read previous 
answers.
"Is there a simple way to get the largest polygon of a 
multipolygon geometry ?"
I can't find another way to explain that, but it seems that my 
question is not clear.

Anyway, as I already said, I wrote a plpgsql function that does 
the trick...

Regards
--
Arnaud



More information about the postgis-users mailing list