Hi Regina,<br>this gave me the result, but there are lot of overlapping polygons.<br>Is there any more syntax (keywords) to ask system to polygonise such that there are no overlapping polygons.<br>cheers<br>Ravi Kumar<br><br><br><b><i>"Obe, Regina" <robe.dnd@cityofboston.gov></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta content="MSHTML 6.00.6000.16481" name="GENERATOR"> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">First I would call your field something other than geometry since that is confusing and could get you into trouble since its a psuedo keyword</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span
class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">So would be something like</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">DROP TABLE abc</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">CREATE TABLE abc(code smallint, info smallint, the_geom geometry) with oids</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">(you might want to use addgeomtrycolumn to create the_geom field so geometry_columns table is updated, but I'm not sure what you are expecting
for a geometry so not sure what parameters to feed you but would be something like this.</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span class="691344412-13092007"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">CREATE TABLE abc(code smallint, info smallint) with oids;</font></span></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">SELECT AddGeometryColumn('public', 'abc', 'the_geom', 4326, 'MULTIPOLYGON', 2);</font></span></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">--The insert</font></span></div>
<div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span class="691344412-13092007"><font color="#0000ff" face="Arial" size="2">INSERT INTO abc(code, info, the_geom)</font></span></div> <div dir="ltr" align="left"><span class="691344412-13092007"> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2">SELECT newtb.code, newtb.info, geomunion(newtb.cgeom) as thenewgeom</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2">FROM </font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2">( SELECT <span class="691344412-13092007">a</span>.code, <span class="691344412-13092007">b</span>.info, geomunion(<span class="691344412-13092007">a</span>.geom<span
class="691344412-13092007">etry</span>, <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span>) as cgeom</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font face="Arial"><font color="#0000ff"><font size="2"> FROM <span class="691344412-13092007">a</span></font></font></font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> INNER JOIN <span class="691344412-13092007">b</span> ON <span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span> && <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span> AND intersects(<span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span>, <span class="691344412-13092007">b</span>.geom<span
class="691344412-13092007">etry</span>)</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"> <font color="#0000ff" face="Arial" size="2">UNION ALL</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"> <font color="#0000ff" face="Arial" size="2">SELECT <span class="691344412-13092007">a</span>.code, null As info, <span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span> as cgeom</font> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> FROM <span class="691344412-13092007">a</span> </font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> LEFT JOIN <span class="691344412-13092007">b</span> ON <span
class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span> && <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span> AND intersects(<span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span>, <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span>)</font></span></div></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> WHERE <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span> IS NULL</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"> <font color="#0000ff" face="Arial" size="2">UNION ALL</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"> <font color="#0000ff" face="Arial"
size="2">SELECT null as code, <span class="691344412-13092007">b</span>.info, <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span> as cgeom</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> FROM <span class="691344412-13092007">b</span> LEFT JOIN <span class="691344412-13092007">a</span> ON <span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span> && <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span> AND intersects(<span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span>, <span class="691344412-13092007">b</span>.geom<span class="691344412-13092007">etry</span>)</font></span></div> <div dir="ltr" align="left"><span
class="217440812-13092007"><font color="#0000ff" face="Arial" size="2"> WHERE <span class="691344412-13092007">a</span>.geom<span class="691344412-13092007">etry</span> IS NULL</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2">) AS newtb</font></span></div> <div dir="ltr" align="left"><span class="217440812-13092007"><font color="#0000ff" face="Arial" size="2">GROUP BY newtb.code, newtb.info</font></span></div></span></div><br> <div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us"> <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>RAVI KUMAR<br><b>Sent:</b> Thursday, September 13, 2007 8:17 AM<br><b>To:</b> postgis<br><b>Subject:</b> [postgis-users] Join
variation<br></font><br></div> <div></div>Hi Andreas and Regina,<br>I have used the following to get a result which will have polygons that do not overlap.<br>But failed. <br>Pl help me and correct the following query.<br>All I want is that after UNION of two layers, the polygons must split and have both the attributes of source layers. (NO PLace for overlapping polygons)<br><br>drop table abc;<br>create table abc (code smallint, info smallint, geometry geometry) with oids;<br><br>insert into abc (select a.code, b.info,(geomunion(a.geometry,<br> b.geometry)) AS abc FROM b inner JOIN a ON (a.geometry && b.geometry AND intersects(a.geometry, b.geometry)));<br><br>I can actually send two small shape files 'a' and 'b' If U want to private mail Ids..<br>Along with the result I wish to get..<br><br>Cheers<br>Ravi Kumar<br> <div> </div><hr size="1"> Got a little couch potato? <br>Check out fun <a
href="http://us.rd.yahoo.com/evt=48248/*http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz">summer activities for kids.</a><div></div><hr size="1"><div></div> <div><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></div>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote><br><p>
<hr size=1>Moody friends. Drama queens. Your life? Nope! - their life, your story.<br> <a href="http://us.rd.yahoo.com/evt=48224/*http://sims.yahoo.com/">Play Sims Stories at Yahoo! Games. </a>