[mapserver-users] two shapes one layer/query

[Jessica Clarke]

Hi, 
I'm trying to draw a 'shape' and a 'related shape'. 
These shapes are both from the same View in Oracle (For eg. asset_shape, rel_shape, asset_ID, rel_ID). 
 
Can I call for two geometry shapes somehow?
 
My current 'data' call in my mapfile is:
 
DATA "REL_SHAPE FROM (SELECT ASSET_ID, REL_ID, ASSET_SHAPE, REL_SHAPE FROM DB.VIEW) USING UNIQUE REL_ID"
 
I want both rel_shape and asset_shape to be drawn on the map. 
 
Currently, I can only see the related shape (obviously). 
 
Thanks, 
Jess
 

---------------------------------------------------------------------------------------------------------------------------------------------
This transmission is intended solely for the person or organisation to whom it is addressed.
It is confidential and may contain legally privileged information.
If you have received this transmission in error, you may not use, copy or distribute it.
Please advise us by return e-mail or by phoning 61 3 6235 8333 and immediately delete the transmission in its entirety.
We will meet your reasonable expenses of notifying us.
Despite our use of anti-virus software, Forestry Tasmania cannot guarantee that this transmission is virus-free.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120627/36b73f9c/attachment.html>