I'm working on a DB-spacial project in Mysql and I was trying to perform a union operation for a group of shapes. Im looking for something similar to the SQL Server function
UnionAggregate, or the PostGIS Spatial Aggregate function
for example (In SQL SERVER):
SELECT geometry::STGeomFromWKB(Shape,27582), area_code FROM area_table WHERE area_code='xxxxxxx';
ST_GeomFromWKB do the same job in Mysql.
in the second part and with the
UnionAggregate function + group by :
select dbo.UnionAggregate((geometry::STGeomFromWKB(Shape,27582)).MakeValid()), area_code FROM area_table WHERE area_code='xxxxxxx' GROUP BY area_code;
Any Idea how to perform a similar operation (aggregate+group by) in Mysql.