There is no direct statement that I know which can select objects based on there type. However a point is a geographic object with 0 length and area so..
Select * from Nadi_El_Seid where (Area(obj, "sq mi")=0) and (ObjectLen(obj, "mi")=0) into Selection The same can be applied to line objects: Select * from Nadi_El_Seid where (Area(obj, "sq mi")=0) and (ObjectLen(obj, "mi")>0) into Selection And polygon objects: Select * from Nadi_El_Seid where Area(obj, "sq mi")>0 into Selection Regards, Ahmed Saber GIS Expert MobiNil Cairo-Egypt +20 12 323 53 50 [EMAIL PROTECTED] -----Original Message----- From: Norm Shea [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 2:48 PM To: MapInfo-List (E-mail) Subject: MI-L Selecting Points Is there a way using an SQL query to select only point objects in a layer. I�m trying to separate the objects in a drainage layer (points for catch basins, lines for pipes) so I can export it to ArcView. Any ideas about that would be appreciated also. Norm Shea Director, Lakes Management Kiawah Island Community Association 20 Kestrel Court Kiawah Island, SC 29455-5657 843-768-2315 office 843-768-0298 fax 843-708-3608 mobile [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3182
