[postgis-users] Maximum z-Coordinate

Max postgis at lists.meisel.cn
Mon Jun 9 05:17:25 PDT 2008


i'm using postgis to store 3D multipolygons and i want to get the the
maximum z-corrdinate of a set of multipolygons. Right now i first create
a set of polygons which contains the polygon from all multipolygons,
then i create a set of points from the polygons and at the end i loop
through the points to calc the maximum, but i think this way is slow, so
i want to know if there is an other way, f.e. is there a way in postgis
to extract all points from the multipolygons with one function.

Hope someone can help me.

thank you in advance

best regards

More information about the postgis-users mailing list