<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD><TITLE>RE: [postgis-users] PostGIS 1.3.3 on Windows XP Unstable</TITLE>
<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=334073315-18082008><FONT face=Arial
color=#0000ff size=2>Thanks Mike,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2> Yap that looks more like a union and was pretty
fast, but then couldn't figure out how to export it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>I right clicked on the layer - selected export data to
shape.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>Very strangely when I reopen the new shape file in ArcMap -
it looks unioned, but then when I open the same shape file in OpenJump - I
can still see the boundaries still and opening up the dbf there are clearly 274
records. I even deleted the mxd, sbn, sbx files ArcMap created and it
still looked unioned when I reopened it in ArcMap and not unioned when I look at
it in open jump.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>The union created in open jump is half the size of the
ArcMap one too and dbf is empty as I would expect since I didn't ask for any
roll up of attributes.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>I'm very puzzled. I have no idea why ArcMap shows
this as unioned when the size of the shape and the stats don't look that much
different from the original. I'm sure I must be missing something
here.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>Stats looks like this is in open jump</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><SPAN
class=334073315-18082008><FONT face=Arial color=#0000ff size=2>
<H2 dir=ltr align=left><FONT size=3>Layer: OpenJumpUnion</FONT> </H2>
<DIV dir=ltr align=left><B>Envelope: </B>Env[-179.14734 : 179.77850341796875,
17.884813 : 71.35256064399981]<BR><B># Features: </B>1<BR></DIV>
<DIV dir=ltr align=left>
<TABLE border=1>
<TBODY>
<TR>
<TD bgColor=#cccccc> </TD>
<TD align=middle bgColor=#cccccc>Min </TD>
<TD align=middle bgColor=#cccccc>Max </TD>
<TD align=middle bgColor=#cccccc>Avg </TD>
<TD align=middle bgColor=#cccccc>Total </TD></TR>
<TR>
<TD bgColor=#cccccc>Pts </TD>
<TD align=right>69795 </TD>
<TD align=right>69795 </TD>
<TD align=right>69795.0 </TD>
<TD align=right>69795 </TD></TR>
<TR>
<TD bgColor=#cccccc>Holes </TD>
<TD align=right>0 </TD>
<TD align=right>0 </TD>
<TD align=right>0.0 </TD>
<TD align=right>0 </TD></TR>
<TR>
<TD bgColor=#cccccc>Components </TD>
<TD align=right>219 </TD>
<TD align=right>219 </TD>
<TD align=right>219.0 </TD>
<TD align=right>219 </TD></TR>
<TR>
<TD bgColor=#cccccc>Area </TD>
<TD align=right>1104.3917345465716 </TD>
<TD align=right>1104.3917345465716 </TD>
<TD align=right>1104.3917345465716 </TD>
<TD align=right>1104.3917345465716 </TD></TR>
<TR>
<TD bgColor=#cccccc>Length </TD>
<TD align=right>733.4595414659133 </TD>
<TD align=right>733.4595414659133 </TD>
<TD align=right>733.4595414659133 </TD>
<TD align=right>733.4595414659133 </TD></TR></TBODY></TABLE></DIV>
<DIV dir=ltr align=left> </DIV></FONT>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff><STRONG>ArcMap Union</STRONG></FONT></SPAN></DIV></SPAN>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><STRONG>Envelope:
</STRONG>Env[-179.14734 : 179.77850341796875, 17.884813 :
71.35256064399981]<BR><B># Features: </B>274 </SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=334073315-18082008><FONT face=Arial
color=#0000ff size=2>
<TABLE border=1>
<TBODY>
<TR>
<TD bgColor=#cccccc><FONT color=#0000ff size=2></FONT></TD>
<TD align=middle bgColor=#cccccc>Min </TD>
<TD align=middle bgColor=#cccccc>Max </TD>
<TD align=middle bgColor=#cccccc>Avg </TD>
<TD align=middle bgColor=#cccccc>Total </TD></TR>
<TR>
<TD bgColor=#cccccc>Pts </TD>
<TD align=right>5 </TD>
<TD align=right>45836 </TD>
<TD align=right>688.0 </TD>
<TD align=right>188644 </TD></TR>
<TR>
<TD bgColor=#cccccc>Holes </TD>
<TD align=right>0 </TD>
<TD align=right>0 </TD>
<TD align=right>0.0 </TD>
<TD align=right>0 </TD></TR>
<TR>
<TD bgColor=#cccccc>Components </TD>
<TD align=right>1 </TD>
<TD align=right>219 </TD>
<TD align=right>1.0 </TD>
<TD align=right>492 </TD></TR>
<TR>
<TD bgColor=#cccccc>Area </TD>
<TD align=right>1.0783706500011592E-5 </TD>
<TD align=right>1104.373302353546 </TD>
<TD align=right>8.061118897843844 </TD>
<TD align=right>2208.7465780092134 </TD></TR>
<TR>
<TD bgColor=#cccccc>Length </TD>
<TD align=right>0.013284095041776186 </TD>
<TD align=right>733.3902842391406 </TD>
<TD align=right>8.213194606088345 </TD>
<TD align=right>2250.4153220682065
</TD></TR></TBODY></TABLE></FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=334073315-18082008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=334073315-18082008></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>O<SPAN
class=334073315-18082008>riginal</SPAN></FONT></FONT></FONT></DIV><FONT
face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=334073315-18082008>
<H2>Layer: st99_d00 </H2>
<DIV><B>Envelope: </B>Env[-179.14734 : 179.77850341796875, 17.884813 :
71.35256064399981]<BR><B># Features: </B>274<BR></DIV>
<DIV>
<TABLE border=1>
<TBODY>
<TR>
<TD bgColor=#cccccc> </TD>
<TD align=middle bgColor=#cccccc>Min </TD>
<TD align=middle bgColor=#cccccc>Max </TD>
<TD align=middle bgColor=#cccccc>Avg </TD>
<TD align=middle bgColor=#cccccc>Total </TD></TR>
<TR>
<TD bgColor=#cccccc>Pts </TD>
<TD align=right>5 </TD>
<TD align=right>45836 </TD>
<TD align=right>688.0 </TD>
<TD align=right>188644 </TD></TR>
<TR>
<TD bgColor=#cccccc>Holes </TD>
<TD align=right>0 </TD>
<TD align=right>0 </TD>
<TD align=right>0.0 </TD>
<TD align=right>0 </TD></TR>
<TR>
<TD bgColor=#cccccc>Components </TD>
<TD align=right>1 </TD>
<TD align=right>219 </TD>
<TD align=right>1.0 </TD>
<TD align=right>492 </TD></TR>
<TR>
<TD bgColor=#cccccc>Area </TD>
<TD align=right>1.0783706500011592E-5 </TD>
<TD align=right>1104.373302353546 </TD>
<TD align=right>8.061118897843844 </TD>
<TD align=right>2208.7465780092134 </TD></TR>
<TR>
<TD bgColor=#cccccc>Length </TD>
<TD align=right>0.013284095041776186 </TD>
<TD align=right>733.3902842391406 </TD>
<TD align=right>8.213194606088345 </TD>
<TD align=right>2250.4153220682065
</TD></TR></TBODY></TABLE></DIV></SPAN></FONT></FONT></FONT>
<DIV><BR><SPAN class=334073315-18082008><FONT face=Arial color=#0000ff
size=2>Signed,</FONT></SPAN></DIV>
<DIV><SPAN class=334073315-18082008><FONT face=Arial color=#0000ff size=2>Very
confused Regina</FONT></SPAN></DIV>
<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>Bresnahan, Mike<BR><B>Sent:</B> Monday, August 18, 2008 10:12
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 id=idOWAReplyText46739 dir=ltr>
<DIV dir=ltr><FONT size=2>> How the hell do you get it to do a real
union?<BR><BR>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:</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>1) Run ArcMap</FONT></DIV>
<DIV dir=ltr><FONT size=2>2) Add the shapefile to your map</FONT></DIV>
<DIV dir=ltr><FONT size=2>3) Open the edit toolbar.</FONT></DIV>
<DIV dir=ltr><FONT size=2>4) Click on Start Editing.</FONT></DIV>
<DIV dir=ltr><FONT size=2>5) Select the entire dataset by left clicking and then
dragging a rectangle around the geometry.</FONT></DIV>
<DIV dir=ltr><FONT size=2>6) Select Union from the menu on the edit
toolbar.</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>You should see the union happen right before your
eyes.</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>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.</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV></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>