<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=397345915-18082008><FONT face=Arial
color=#0000ff size=2>Its supposed to merge and dissolve boundaries where as
ST_Collect just collects the geometries into one record.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=397345915-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=397345915-18082008></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>erik<BR><B>Sent:</B> Monday, August 18, 2008 10:48 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] PostGIS 1.3.3 on Windows
XP Unstable<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Isn't a Union supposed to merge all polygons in one? The only thing
I get to do this in ArcView is the "Merge" and that's also the functionality I
get from ST_Union.<BR><BR>Btw, for ST_Union'ing many complex polygons I'm using
CascadedUnion as written here: <A
href="http://postgis.refractions.net/pipermail/postgis-users/2007-December/017995.html">http://postgis.refractions.net/pipermail/postgis-users/2007-December/017995.html</A>.
<BR><BR><BR><BR>
<DIV class=gmail_quote>On Mon, Aug 18, 2008 at 4:12 PM, Bresnahan, Mike <SPAN
dir=ltr><<A href="mailto:Mike.Bresnahan@bestbuy.com"
target=_blank>Mike.Bresnahan@bestbuy.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>> How the hell do you get it to do a real union?<BR><BR></DIV>Heh.
Intuitive ArcMap is not. It took me forever to figure it out as well. You can
do a union a couple different ways. The way that seemed to work the best for
this is to:<BR><BR>1) Run ArcMap<BR>2) Add the shapefile to your map<BR>3)
Open the edit toolbar.<BR>4) Click on Start Editing.<BR>5) Select the entire
dataset by left clicking and then dragging a rectangle around the
geometry.<BR>6) Select Union from the menu on the edit toolbar.<BR><BR>You
should see the union happen right before your eyes.<BR><BR>I think I tried the
Union Tool like you did and didn't get what I expected. I think it just did a
union on each individual feature instead of doing an aggregate
union.<BR><BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>