<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>geomunion revisited....</TITLE>
</HEAD>
<BODY>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">Well the good news is that I finally got a configuration that wasn't crying about memory nor</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> getting</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> the other error....</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">However, I am back to a much more general question. Have there been any improvements to the geomunion() algorithm in versions after</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">1.2.1? </FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">I have gotten my buffered polygons for all my linestrings and</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">that part of the query returns 32,278 rows in</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">about 22 seconds. But the geomunion of these rows has been running for</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">over</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> 5 hours. My problem is that</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> a person can do this in</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> ArcMap</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">in about</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">20 minutes.</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">So the query that takes 22 seconds is:</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">select simplify(buffer(simplify(the_geom, 5), 400), 150) as the_geom from</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">table1</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">union </FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">select simplify(buffer(simplify(the_geom, 5), 400), 150) as the_geom from</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">table2</FONT></P>
<BR>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">by adding geomunion() to the resulting geometry, it is still running</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">:</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">select geomunion(the_geom) as the_geom from (</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">select simplify(buffer(simplify(the_geom, 5), 400), 150) as the_geom from</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">table1</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> </FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">union </FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">select simplify(buffer(simplify(the_geom, 5), 400), 150) as the_geom from</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">table2</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">) foo</FONT></P>
<BR>
<P ALIGN=LEFT><FONT SIZE=2 FACE="Arial">Yes, I know that I must be insane to ask</FONT><FONT SIZE=2 FACE="Arial">ing</FONT><FONT SIZE=2 FACE="Arial"> for a</FONT> <FONT SIZE=2 FACE="Arial">single multipolygon like this. And I am sure it is outside the normal realm of geomunion(), but it would sure be nice if it would work. :)</FONT></P>
<P ALIGN=LEFT><FONT SIZE=2 FACE="Arial">Suggestions welcome.</FONT></P>
<P ALIGN=LEFT><FONT SIZE=2 FACE="Arial">Thanks in advance,</FONT></P>
<P ALIGN=LEFT><FONT SIZE=2 FACE="Arial">Lee Keel</FONT></P>
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.</BODY>
</HTML>