Looks simple enough, but you may need to find some way of ordering the centroids to have a sensible line progressing through the individual polygons.
I guess you could stick an order by X() or Y() of the centroid's coords so the lines always run EW or NS?? Cheers, Brent Wood --- On Wed, 9/17/08, Obe, Regina <[EMAIL PROTECTED]> wrote: > From: Obe, Regina <[EMAIL PROTECTED]> > Subject: RE: [postgis-users] visually linking the polygons of multipolygon > layer > To: "PostGIS Users Discussion" <[email protected]> > Date: Wednesday, September 17, 2008, 2:15 AM > First thing that comes to mind to me is string the centroids > together. > > Something like > > SELECT gid, ST_MakeLine(ST_Centroid(the_geom)) As arc > FROM (SELECT gid, (ST_Dump(the_geom)).geom As the_geom > FROM multipolytable > ) As foo > GROUP BY gid > > Hope that helps, > Regina > > ________________________________ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of erik > Sent: Tuesday, September 16, 2008 9:06 AM > To: PostGIS Users Discussion > Subject: [postgis-users] visually linking the polygons of > multipolygon > layer > > > Hi, > > I'm not sure I know how to formulate this > I have a set of Multipolygons. I'd like to link somehow > the polygons of > each multipolygon with a "string", an arc, that > expresses their > belonging to the same polygon. > > Is this possible, is there some predefined function that > could > accomplish this? > > Many thanks, > > Erik > > > > ----------------------------------------- > The substance of this message, including any attachments, > may be > confidential, legally privileged and/or exempt from > disclosure > pursuant to Massachusetts law. It is intended > solely for the addressee. If you received this in error, > please > contact the sender and delete the material from any > computer. > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
