Run two queries Use the ObjectLen() function to query out the points from the lines (or the lines from the points)
Example (POints) select * from MyTable where objectlen(Obj,"mi") = 0 (Lines) select * from MyTable where objectlen(Obj,"mi")> 0 Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: Craig, Fergus [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 10:00 AM To: [EMAIL PROTECTED] Subject: MI-L Points and lines from the same table Dear All, I'm sure there is a simple solution to this, but I can't seem to find it. A table (all in the same table, so moving them on the layer control doesn't work) has both points and lines which overlap. I would like all the points to show on top of the lines, just now some are on top and some are being covered by the lines. How do I get all the points to show above the lines? I am using MI 7. Thanks in anticipation, Fergus Craig 020 8774 2881 Mott MacDonald Limited, Registered office St.Anne House, 20-26 Wellesley Road, Croydon CR9 2UL Tel: +44 (0) 0208 774 2000 Fax: +44 (0) 0208 681 5706 Registered in England No. 1243967 Web: www.mottmac.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10987
