MySQL Forums
Forum List  »  Newbie

How to determine the extent/envelope of all geometries in a table?
Posted by: Steve Atter
Date: March 30, 2005 03:56AM

How to I calc the envelope of all geometries in a table?
I would suppose with something like

SELECT AsText(Envelope(`geom`)), 1 AS GroupByCommonField FROM `g_table` GROUP BY GroupByCommonField;

But this only returns the Envelope of the first record. There isn't a GROUP BY aggregate function for Union or so.


Thanks,
Stefan.

Options: ReplyQuote


Subject
Written By
Posted
How to determine the extent/envelope of all geometries in a table?
March 30, 2005 03:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.