RE : [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ?
Thank you for all your help I just don't understand why there is not a SearchCircle statement corresponding to this selection mode ! Chris -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Spencer Simpson Envoyé : mercredi 26 juillet 2006 21:13 À : mapinfo-l@lists.directionsmag.com Objet : RE: [MI-L] SerachInfo,SearchRect and SearchPoint or .something else ? SearchPoint() and SearchRect() search all of a Map windows selectable layers at once, using MIs screen picking capability, which appears to have a builtin cache. This is much faster than multiple SQL queries for a Map windows various layers. You can always filter the objects of the rows pre-screened by SearchRect through an object, but that object wouldnt have to be a polygon. HTH Spencer From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Paris Sent: Wednesday, July 26, 2006 8:11 AM To: 'Driver, Greg 9434'; 'Christophe Brabant'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SerachInfo,SearchRect and SearchPoint or .something else ? Why not converttoregion(circle) and search with resulting polygon? Jacques -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Driver, Greg 9434 Sent: 26 juillet 2006 04:20 To: 'Christophe Brabant'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Chris, You could always use the MBR of the circle and then use this in the SearchRect() function. You can then use SearchInfo() function to return the Table/RowID of objects found within the search area and then test to see if these objects do fall within the radius of circle. Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message- From: Christophe Brabant [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 15:32 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Hi There are at least 4 selection modes on a map : - by clicking a point (SearchPoint(x,y)) - by selecting a rectangle (SearchRectangle(x1,y1,x2,y2) - by selecting all the objects included into a closed polygon - by selecting a circle with a variable radius : in this case, how to query (by program) the objects included into the circle ? Not with SearchPoint, not with SearchRect, Thank you Chris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ?
Title: Message Why not converttoregion(circle) and search with resulting polygon? Jacques -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Driver, Greg 9434 Sent: 26 juillet 2006 04:20 To: 'Christophe Brabant'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Chris, You could always use the MBR of the circle and then use this in the SearchRect() function. You can then use SearchInfo() function to return the Table/RowID of objects found within the search area and then test to see if these objects do fall within the radius of circle. Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message- From: Christophe Brabant [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 15:32 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Hi There are at least 4 selection modes on a map : - by clicking a point (SearchPoint(x,y)) - by selecting a rectangle (SearchRectangle(x1,y1,x2,y2) - by selecting all the objects included into a closed polygon - by selecting a circle witha variableradius : in this case, how to query (by program) the objects included into the circle ? Not with SearchPoint, not with SearchRect, Thank you Chris Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ?
SearchPoint() and SearchRect() search all of a Map windows selectable layers at once, using MIs screen picking capability, which appears to have a builtin cache. This is much faster than multiple SQL queries for a Map windows various layers. You can always filter the objects of the rows pre-screened by SearchRect through an object, but that object wouldnt have to be a polygon. HTH Spencer From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Paris Sent: Wednesday, July 26, 2006 8:11 AM To: 'Driver, Greg 9434'; 'Christophe Brabant'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SerachInfo,SearchRect and SearchPoint or .something else ? Why not converttoregion(circle) and search with resulting polygon? Jacques -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Driver, Greg 9434 Sent: 26 juillet 2006 04:20 To: 'Christophe Brabant'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Chris, You could always use the MBR of the circle and then use this in the SearchRect() function. You can then use SearchInfo() function to return the Table/RowID of objects found within the search area and then test to see if these objects do fall within the radius of circle. Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message- From: Christophe Brabant [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 15:32 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] SerachInfo, SearchRect and SearchPoint or .something else ? Hi There are at least 4 selection modes on a map : - by clicking a point (SearchPoint(x,y)) - by selecting a rectangle (SearchRectangle(x1,y1,x2,y2) - by selecting all the objects included into a closed polygon - by selecting a circle with a variable radius : in this case, how to query (by program) the objects included into the circle ? Not with SearchPoint, not with SearchRect, Thank you Chris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ?
Title: Message Chris, You can always create a polygon from your circle and use this to select the objects with. This can be done thru SQL: oCircle = Buffer(CreatePoint(X,Y), 24, fRadius, "m") Select * From MYTABLE Where OBJ Within oCircle Into Selection You can of course use Entirely Within or Intersects in stead of Within - depending on your requirements. As far as I remember you can also thru MapX (and MapXtreme2004 ?) do a dynamic selection with a circle, where the selection changes when you make the circle smaller og bigger Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe BrabantSent: Tuesday, July 25, 2006 4:32 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] SerachInfo,SearchRect and SearchPoint or .something else ? Hi There are at least 4 selection modes on a map : - by clicking a point (SearchPoint(x,y)) - by selecting a rectangle (SearchRectangle(x1,y1,x2,y2) - by selecting all the objects included into a closed polygon - by selecting a circle witha variableradius : in this case, how to query (by program) the objects included into the circle ? Not with SearchPoint, not with SearchRect, Thank you Chris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
