[mapserver-users] two shapes one layer/query

[Brent Fraser]

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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120627/2e18b1d0/attachment.htm>