<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">You could use two layers in the mapfile
(and a REQUIRES keyword to link the display). Or use a UNION
construct in the SQL, or create a view in the database using a
UNION.<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
On 6/26/2012 7:37 PM, Jessica Clarke wrote:<br>
</div>
<blockquote
cite="mid:4FEAF097020000DD00016915@mail2.forestrytas.com.au"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.18702">
<div>Hi, </div>
<div>I'm trying to draw a 'shape' and a 'related shape'. </div>
<div>These shapes are both from the same View in Oracle (For eg.
asset_shape, rel_shape, asset_ID, rel_ID). </div>
<div> </div>
<div>Can I call for two geometry shapes somehow?</div>
<div> </div>
<div>My current 'data' call in my mapfile is:</div>
<div> </div>
<div>DATA "REL_SHAPE FROM (SELECT ASSET_ID, REL_ID, ASSET_SHAPE,
REL_SHAPE FROM DB.VIEW) USING UNIQUE REL_ID"</div>
<div> </div>
<div>I want both rel_shape and asset_shape to be drawn on the map.
</div>
<div> </div>
<div>Currently, I can only see the related shape (obviously). </div>
<div> </div>
<div>Thanks, </div>
<div>Jess</div>
<div> </div>
<br>
<p> <font face="Arial" size="1">---------------------------------------------------------------------------------------------------------------------------------------------
</font><br>
</p>
<p> <font face="Arial" size="1">This transmission is intended
solely for the person or organisation to whom it is addressed.
</font> </p>
<p> <font face="Arial" size="1">It is confidential and may
contain legally privileged information. </font> </p>
<p> <font face="Arial" size="1">If you have received this
transmission in error, you may not use, copy or distribute it.
</font> </p>
<p> <font face="Arial" size="1">Please advise us by return e-mail
or by phoning 61 3 6235 8333 and immediately delete the
transmission in its entirety. </font> </p>
<p> <font face="Arial" size="1">We will meet your reasonable
expenses of notifying us. </font> </p>
<p> <font face="Arial" size="1">Despite our use of anti-virus
software, Forestry Tasmania cannot guarantee that this
transmission is virus-free. </font> </p>
<p> <font face="Arial" size="1">--------------------------------------------------------------------------------------------------------------------------------------------
</font> </p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
<br>
</body>
</html>