[postgis-users] Merge rectangles
DrYSG
ygutfreund at draper.com
Wed Aug 15 11:39:05 PDT 2012
In the table portal.catalog
column poly is a geometry (always a rectangle, with datum EPSG 4326)
column type is a text field.
I want to find all the records who have a type of "CADRG" and merge the
polygons into the simplest shape that covers all the items in the array
(I.e. if they form a square with a hole, then I want that, if it has to be a
multipolygon, so be it).
Is this the correct way to do that?
SELECT ST_AsText(ST_Union(
ARRAY(
SELECT poly
FROM portal.catalog as cat
WHERE cat.type='CADRG'
LIMIT 10
)
)
)
--
View this message in context: http://postgis.17.n6.nabble.com/Merge-rectangles-tp4999357.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users
mailing list