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.

Best Regards,
Brent Fraser

On 6/26/2012 7:37 PM, Jessica Clarke wrote:
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.

--------------------------------------------------------------------------------------------------------------------------------------------



_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users


_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to