Thank you so much to all who replied so promptly with very helpful suggestions to my query, particularly Jan,Robert & Doug. I found my way to Bill's demo which I'm sure is just what I was looking for. Unfortunately we at Cairns City Council are behind the eight ball as far as newer versions of MI go. Still stuck with V 7.5, the demo needs V 7.8 ho hum. We GIS staff keep banging our collective heads against the IS dept brick wall to no avail. Again Thanks for input Listers. Cheers, Nola
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, 27 July 2006 10:16 AM To: [email protected] Subject: MapInfo-L Digest, Vol 9, Issue 56 Send MapInfo-L mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://www.directionsmag.com/mailman/listinfo/mapinfo-l or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of MapInfo-L digest..." Today's Topics: 1. background color (Eric Gagnon) 2. RE: SerachInfo, SearchRect and SearchPoint or .....something else ? (Spencer Simpson) 3. tool to get bounds in MapInfo Pro (Fred Williams) 4. RE: tool to get bounds in MapInfo Pro (Peter Horsb?ll M?ller) 5. Working with the Vertical Mapper SDK (Bill Thoen) 6. Street Pro Autoloader not working (Ed Sloat) 7. MI Link to Access DB (Strawbridge Nola) ---------------------------------------------------------------------- Message: 1 Date: Wed, 26 Jul 2006 14:49:29 -0300 From: Eric Gagnon <[EMAIL PROTECTED]> Subject: [MI-L] background color To: "[email protected]" <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed hi, Can I change background color of my mapper so it's not white? my other question is.. When I use the GElink tool to export into google, can I specify a transparent raster somewhere in MI ? I keep getting this white background with my streets. Thanks Eric -- Eric Gagnon,B.Sc., GIS Specialist [EMAIL PROTECTED] 47°02'57"N 67°44'11"W ------------------------------ Message: 2 Date: Wed, 26 Jul 2006 15:13:00 -0400 From: "Spencer Simpson" <[EMAIL PROTECTED]> Subject: RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ? To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" SearchPoint() and SearchRect() search all of a Map window's selectable layers at once, using MI's screen picking capability, which appears to have a builtin cache. This is much faster than multiple SQL queries for a Map window's various layers. You can always filter the objects of the rows pre-screened by SearchRect through an object, but that object wouldn't 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'; [email protected] 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'; [email protected] 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: [email protected] 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 ------------------------------ Message: 3 Date: Wed, 26 Jul 2006 12:35:36 -0700 From: "Fred Williams" <[EMAIL PROTECTED]> Subject: [MI-L] tool to get bounds in MapInfo Pro To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" Hello, I am looking for a tool that will look at the region objects in an open table and create or update columns with the bounds of that region object. I am surprised that there doesn't seem to be a built in function like the centroid function that I can just run as an update query. Thanks Fred Williams Offroute, Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060726/3ce3cc17/attachment-0001.htm ------------------------------ Message: 4 Date: Wed, 26 Jul 2006 22:22:38 +0200 From: Peter Horsb?ll M?ller <[EMAIL PROTECTED]> Subject: RE: [MI-L] tool to get bounds in MapInfo Pro To: <[EMAIL PROTECTED]>, <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" Fred, There is such a function. You just need to know where to look ;-) Here is a update statement, that you can use from the MapBasic window - just remember to select all five lines before you hit the Enter key Update MYTABLE Set MINX = ObjectGeography(OBJ, 1), MINY = ObjectGeography(OBJ, 2), MAXX = ObjectGeography(OBJ, 3), MAXY = ObjectGeography(OBJ, 4) HTH, 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] <mailto:[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 Fred Williams Sent: Wednesday, July 26, 2006 9:36 PM To: [email protected] Subject: [MI-L] tool to get bounds in MapInfo Pro Hello, I am looking for a tool that will look at the region objects in an open table and create or update columns with the bounds of that region object. I am surprised that there doesn't seem to be a built in function like the centroid function that I can just run as an update query. Thanks Fred Williams Offroute, Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060726/12722a4f/attachment-0001.htm ------------------------------ Message: 5 Date: Wed, 26 Jul 2006 15:09:13 -0600 From: Bill Thoen <[EMAIL PROTECTED]> Subject: [MI-L] Working with the Vertical Mapper SDK To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii I'm looking for ideas on how others work with the Vertical Mapper SDK. The dlls in the vm directory are not "findaable" by applications unless you put your MBXs in the vm directory. Doing this could eventually clutter up this directory, and also users with normal privileges usually cannot write to files in this tree (\Program Files\...) so you have to pay attention to where your MBXs write data. If you put your MBX elswhere then you have to copy all the dlls that your program references to the same directory. I'm wondering if it wouldn't be such a bad idea to put the vm directory in the search path, but then I'll have to get users to learn how to do that if they want to run apps I've built. I also found that you have to have Vertical Mapper loaded if you use vm progress bars and want them to be visible. Calling vmInit() isn't enough by itself. I don't know if there are other issues like this, or if there's a simple function I need to call that's not in the manual. Anyway, I'd like to hear from anyone who's found a clean way to organize things to develop and deploy Vertical Mapper SDK apps. Once I get these to work, they're pretty slick, but it seems like there are a lot of arbitrary issues caused by file locations. - Bill Thoen ------------------------------ Message: 6 Date: Wed, 26 Jul 2006 14:49:19 -0700 From: "Ed Sloat" <[EMAIL PROTECTED]> Subject: [MI-L] Street Pro Autoloader not working To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" I have installed Street Pro V9.0 for Maricopa County, Arizona and I am trying to use the Autoloader utility to select the layers I want to display. However, When I click on Autoloader.mbx from the tools box I get nothing. I must have installed it incorrectly. Anyone having similar problems? How may I fix this problem? Thanks for any advice you can provide. Ed Sloat Edward F. Sloat, Director Research, Planning, and Assessment Peoria Unified School District 6330 West Thunderbird Road Glendale, Arizona 85306 623-486-6077 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060726/15569df0/attachment-0001.htm ------------------------------ Message: 7 Date: Thu, 27 Jul 2006 10:11:00 +1000 From: "Strawbridge Nola" <[EMAIL PROTECTED]> Subject: [MI-L] MI Link to Access DB To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" Hello Listers, I would appreciate some pointers to creating a read only link from MI V7.5 to a Capital Works program stored in a live Access table. My manager wants to be able to click on a symbol, which would then open an Access table at that individual Row in the Access spreadsheet. I think the project number could be the common object to link the tables. I have set up a Hotlink which opens the whole Access DB but he wants the link to point directly to that Row without having to drill down or search through the spreadsheet to find the record he clicked on. Is this possible? I'm not an experienced programmer so need a reasonably straight forward ODBC connection method. Kind Regards, Nola Nola Strawbridge GIS Admin/Analyst City Works & Services Cairns City Council Tel: 4044 3219 Fax: 4044 3838 email: [EMAIL PROTECTED] ------------------------------ Cairns City Council Disclaimer ------------------------------ "This message, and any attachments, may contain privileged and confidential information intended only for the use of the intended addressee(s). Any unauthorized use of this material is prohibited. If you receive this message in error, please notify the sender immediately, delete the message and destroy any printed or electronic copies. Opinions expressed in this e-mail are those of the sender and do not necessarily represent the views of the Cairns City Council. Council does not accept any responsibility for the loss or damage that may result from reliance on, or the use of, any information contained in this e-mail or attachments." ------------------------------ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://www.directionsmag.com/pipermail/mapinfo-l/attachments/20060727/8396e896/attachment.htm ------------------------------ _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l End of MapInfo-L Digest, Vol 9, Issue 56 **************************************** ------------------------------ Cairns City Council Disclaimer ------------------------------ "This message, and any attachments, may contain privileged and confidential information intended only for the use of the intended addressee(s). Any unauthorized use of this material is prohibited. If you receive this message in error, please notify the sender immediately, delete the message and destroy any printed or electronic copies. Opinions expressed in this e-mail are those of the sender and do not necessarily represent the views of the Cairns City Council. Council does not accept any responsibility for the loss or damage that may result from reliance on, or the use of, any information contained in this e-mail or attachments." ------------------------------ _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
