[MI-L] SUM: MAPBASIC Object or not Object?
Thanks to all who have replied I've found out what my mistake is - a bit of a compound of errors I'm afraid. Firstly, I put the if statement the wrong side of the fetch first statement which gave me the argument 2 error, then I had a Print line that was just print the table name, which I had missed hence the blank line with just the tablename on it. DOH!! I think it must have been the end of a hard week - they were two stupid errors. Many thanks again Nicki Previous Message: Hi I have what I believe is an object in a layer - I think it's a line - if I query it in the Maspbasic window in MI with select objectinfo (obj,1) from table_name then look at the selection table I see object type 3 ie a line. If I use the following line in some Mapbasic code which interrogates the same layer: If ObjectInfo(ColAlias, OBJ_INFO_TYPE) = 4 or ObjectInfo(ColAlias, OBJ_INFO_TYPE) = 7 then Then I get the following error when it gets to the object that I believe is a line: (Blah.mb:123)ObjectInfo: argument 2 out of range If I write what is happening out to a text file ie Print #1, (temptablearray(i) + + colname++colAlias + + ObjectInfo(ColAlias, OBJ_INFO_TYPE)) where colAlias is the Alias of the column name: ColAlias = Temptabname . Colname I get the following: Query134 Query134 object Polyline 4 The top line above is the line that I think is causing the problem, the second line above shows a result that works. Is this line an object or not and can I do anything to avoid the out of range error? I hope this all makes sense!! Nicki Nicki Cozens Data Management Officer Highways Development Control Leicestershire County Council County Hall Glenfield Leicester LE3 8RA Tel: 0116 265 7420 Fax: 0116 265 7133 ___ Leicestershire County Council - rated a 'four-star' council by the Audit Commission ___ This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received. Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000. The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council. Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Ang. [MI-L] How to use .TAB files to identify corresponding workspace?
Hi Matt! The only file in a MapInfo tab fileset which is referenced in a workspace file is the *,tab file itself, but with no extension. For example Open Table C:\blah blah...\mytabfile As mytabfile will look for the file mytabfile.tab in the given path The tab file is a kind of pointer to the other files needed to complete the data set. Note that the data set can be a raster file, an excel file or even a shape file, and not only a proprietary MapInfo geodatabase. That said, what you need to look for is the tabfile 'mytabfile' in your workspace files, You can use the F3 search function in Windows Explorer, point it at the right disk or folder and look for *.wor files containing 'mytabfile'. Now, this may not work at first because of a known bug in XP. The extension 'wor' may not be known to XP in the sense it needs to be known for an in-file string search. Microsoft has suggested a fix for this, see http://support.microsoft.com/kb/309173 Qualified text editors, such as UltraEdit use to have a function to search for strings within files on disk. Coupled with a replace function, it is one of my tools to repair workspaces where tabfiles have been relocated. Hälsning / Best regards Mats.E FB Engineering AB Södra Förstadsgatan 26 211 43 Malmö Tel: 040-660 25 50 Mobil: 0705-27 60 27 Fax: 040-660 25 99 [EMAIL PROTECTED] www.fbe.se Matt K [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] 2006-07-31 22:53 Till mapinfo-l@lists.directionsmag.com Kopia Ärende [MI-L] How to use .TAB files to identify corresponding workspace? Hello all, I am curious if there is a way to use one of the 5 files associated with a .tab file to identify which workspace it is attached to? I would like to delete some files, but am not sure if they are part of a workspace, and therefore would have to re-locate those deleted files if I were to open the workspace they are saved to. Thanks Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.___ 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] CoordSys Earth Projection 1, 0
Hi Nick, I asked MapInfo several years ago, and their answer was that the default datum equals WGS84. Best regards / Med venlig hilsen Lars I. Nielsen GisPro [EMAIL PROTECTED] wrote: I have a number of tables with the following coordsys statement in the MIF file CoordSys Earth Projection 1, 0 In the map window, it comes up as lat/long projection, but no datum is mentioned. What datum is 0? I can't find it listed in the manual. Regards, Nick Lawrence Opinions contained in this e-mail do not necessarily reflect the opinions of the Queensland Department of Main Roads, Queensland Transport or Maritime Safety Queensland, or endorsed organisations utilising the same infrastructure. If you have received this electronic mail message in error, please immediately notify the sender and delete the message from your computer. ___ 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] How to use .TAB files to identify corresponding worksp ace?
Title: Message Matt, I'd do it the other way round - see if any of your workspaces reference the tabfiles. You can use a utility like SearchPlus to search through the workspaces for the names of tabfiles. If none of your workspaces contain the table namesthen you're safe to delete them. You can down load SearchPlus here - http://www.paris-pc-gis.com/externes/Files_from_other_origins.htm(towards the bottom of the page). HTH Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message-From: Matt K [mailto:[EMAIL PROTECTED] Sent: 31 July 2006 21:53To: mapinfo-l@lists.directionsmag.comSubject: [MI-L] How to use .TAB files to identify corresponding workspace? Hello all, I am curious if there is a way to use one of the 5 files associated with a .tab file to identify which workspace it is attached to? I would like to delete some files, but am not sure if they are part of a workspace, and therefore would have to re-locate those deleted files if I were to open the workspace they are saved to. Thanks Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. 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] Creating grid of points
Title: RE: [MI-L] Creating grid of points Gordon, There is a tool that will do this, which you can download from http://www.ing.unitn.it/~grass/software.html called punti. It will create a point objects based on an underlying grid. So you'll need to create a 100m grid using the Gridmaker tool and the run the Punti utility to create the points at the intersects of the grid. HTH Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message- From: Barker, Gordon [mailto:[EMAIL PROTECTED]] Sent: 01 August 2006 09:30 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating grid of points Hi I am trying to create a grid with single points appearing at each of the intersections of the horizontal and vertical lines. All attempts that have come to mind so far have not worked correctly. Can anyone please help? Desired result: Single points appearing at 100m spacing related to British Grid 6 figure grid references, (point would need to be at xxx,x00 m E, xxx,x00 m N) Approaches already tried: Gridmaker, Closed Regions (custom line style of single point at start)- start point does not appear at corner but partly up side of square Gridmaker, Straight Polylines followed by Enclose on lines (style as above)- Enclose mostly creates squares in a switchback sequence (N on first column, S on 2nd etc)leaving points only appearing on every 2nd column Approaches not tried: Polyline split of every vertical with every horizontal line and vice versa- 12x10km so too large by hand and don't have tool to automate Thank you Gordon __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l 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] Creating grid of points
Title: RE: [MI-L] Creating grid of points Hi Gordon, I have done this excercise before using postal code densities per km². What I required was a point at every 1km spacing. xxx,000E xxx,000N To overcome the issue I used a semi manual process. Create a grid using GridMaker from ToolManager. but instead of using xxx,000E: xxx,000N use the centres xxx,500E:xxx,500N respectively. This will create millions of 1km² polygons to which I added the 2 Fields CentreX and CentreY. You can now do an update column with the function CentroidX and CentroidY. These will be at xxx,000E etc. Now all you need to do is export the file to .txt and open as points using the CentreX and CentreY as the coordinates. Delet all unwanted points. Stephen J. Smith RND/ TND Manager Oman LM Ericsson Technical Office P.O. Box 1945, Ruwi, PC-112 Sultanate of Oman ' - +968-24636260 / - +968-95212652 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Driver, Greg 9434Sent: 01 August, 2006 1:51 PMTo: 'Barker, Gordon'; mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Creating grid of points Gordon, There is a tool that will do this, which you can download from http://www.ing.unitn.it/~grass/software.html called punti. It will create a point objects based on an underlying grid. So you'll need to create a 100m grid using the Gridmaker tool and the run the Punti utility to create the points at the intersects of the grid. HTH Greg Driver System Administrator Applications Support ICT NOT PROTECTIVELY MARKED -Original Message- From: Barker, Gordon [mailto:[EMAIL PROTECTED]] Sent: 01 August 2006 09:30 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating grid of points Hi I am trying to create a grid with single points appearing at each of the intersections of the horizontal and vertical lines. All attempts that have come to mind so far have not worked correctly. Can anyone please help? Desired result: Single points appearing at 100m spacing related to British Grid 6 figure grid references, (point would need to be at xxx,x00 m E, xxx,x00 m N) Approaches already tried: Gridmaker, Closed Regions (custom line style of single point at start)- start point does not appear at corner but partly up side of square Gridmaker, Straight Polylines followed by Enclose on lines (style as above)- Enclose mostly creates squares in a switchback sequence (N on first column, S on 2nd etc)leaving points only appearing on every 2nd column Approaches not tried: Polyline split of every vertical with every horizontal line and vice versa- 12x10km so too large by hand and don't have tool to automate Thank you Gordon __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l 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] Creating grid of points
Hi Gordon, You're almost there, but I'd transform the closed regions created in Gridmaker (with 100m spacing) into points using a bit of mapbasic code in the Mapbasic window: 1. Open your closed region grid table into a map window 2. Open the mapbasic window (Options Show MapBasic window) 3. Make sure Mapinfo works in the same coordinate system as your table by typing the following text into the MapBasic window on a blank line and pressing return (replace YourTableName with the name of the grid table): set coordsys table YourTableName 4. Replace each region with a point, offset from its centre by 100m in the x and y directions by typing the following text into the MapBasic window on a blank line and pressing return (replace YourTableName with the name of the grid table): update YourTableName set obj = createpoint(centroidx(obj)-100,centroidy(obj)-100) 5. Save the table - it should now show points at the 100m grid intersections. Andrew Barker, Gordon wrote: Hi I am trying to create a grid with single points appearing at each of the intersections of the horizontal and vertical lines. All attempts that have come to mind so far have not worked correctly. Can anyone please help? Desired result: Single points appearing at 100m spacing related to British Grid 6 figure grid references, (point would need to be at xxx,x00 m E, xxx,x00 m N) Approaches already tried: Gridmaker, Closed Regions (custom line style of single point at start)- start point does not appear at corner but partly up side of square Gridmaker, Straight Polylines followed by Enclose on lines (style as above)- Enclose mostly creates squares in a switchback sequence (N on first column, S on 2nd etc)leaving points only appearing on every 2nd column Approaches not tried: Polyline split of every vertical with every horizontal line and vice versa- 12x10km so too large by hand and don't have tool to automate Thank you Gordon __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- Andy Harfoot GeoData Institute University of Southampton Southampton SO17 1BJ Tel: +44 (0)23 8059 2719 Fax: +44 (0)23 8059 2849 www.geodata.soton.ac.uk --- For further information about GeoData's Training Courses, please visit: www.geodata.soton.ac.uk/training --- ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] metadata tool
I don't think there is any way of inserting any type of data into a browser(of a table) without either making a field that actually has the metadata or making the name of the table contain the metadata. There are mapbasic solutions for popups that would extract the true metadata from a table(assuming it was recorded into the table) and how it to the user but there is no way of integrating that information into a browser window without doing something like in the first sentence, above, that I am aware of. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, July 31, 2006 9:04 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] metadata tool Hi guys, I was just wondering if anyones knows of a metadata tool that tags create/edit date into the browser. I am unfortunately not a programmer and so wouldn't have an idea how to go about writting a code to do this. So if anyone has come across anything that can do this, I would appreciate any help or pointers in the right direction please, Thanks in advance, Ruth - Find the home of your dreams with eircom net property Sign up for email alerts now http://www.eircom.net/propertyalerts ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l __ This e-mail has been scanned by Verizon/MessageLabs Managed Email Service. __ This e-mail has been scanned by Verizon/MessageLabs Managed Email Service. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] CoordSys Earth Projection 1, 0
It is true that datum 0 means no datum. However, datum 0 will behave as a sphere _only_ if it is used by itself. When used with another table in a map window, the map will project using the datum of the other table, even when the other table is projected. If you use Map-Options to explicitly select Latitude/Longitude without a datum, the map will stubbornly stick to the other datum! Try this using World (which uses the Robinson projection) and your datum 0 table. Because of this, if you use File-Save Copy As and save the table as latitude/longitude using a named datum, MapInfo (6.5 and 8.5) will not change the table's coordinates. I was able to change the intrinsic datum of a table (lat/lon in datum 33) by using File-Save As twice (first to datum 0, then to the other datum), and verified it by exporting the two files to MIF and running a file compare in TextPad. The only difference between the two MIF files was the datum number in the Coordsys clause. (saving to datum 0 really did change it to datum 0). HTH Spencer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Rideout Sent: Tuesday, August 01, 2006 3:51 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] CoordSys Earth Projection 1, 0 I think it means there is no datum. In other words you are using spherical co-ordinates on what is assumed to be a perfect sphere. The latitude - longitude reference system obviously works on any spherical object with an axis of rotation, whether it is the earth, mars, or a football. You should find out what is the correct datum for your data and then replace the 0 in the co-ord sys statement with the correct number. Don't reproject your data because that will move the positions, and that almost certainly isn't what you want to do. Tim Dr Tim Rideout Director Visit XYZ at the Frankfurt Book Fair, Oct 4 - 8th 2006, Intergeo Munich Oct 10-13th 2006 or IMTA World in Singapore, Nov 2006. The XYZ Digital Map Company Unit 9 Phase 2 Hardengreen Business Park Dalhousie Road, Dalkeith EH22 3NX, Scotland, Europe Tel: +44 131 454 0426 Fax: +44 131 454 0443 Mobile: +44 7766 825937 Email: [EMAIL PROTECTED] Web: www.xyzmaps.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 August 2006 00:11 To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] CoordSys Earth Projection 1, 0 I have a number of tables with the following coordsys statement in the MIF file CoordSys Earth Projection 1, 0 In the map window, it comes up as lat/long projection, but no datum is mentioned. What datum is 0? I can't find it listed in the manual. Regards, Nick Lawrence Opinions contained in this e-mail do not necessarily reflect the opinions of the Queensland Department of Main Roads, Queensland Transport or Maritime Safety Queensland, or endorsed organisations utilising the same infrastructure. If you have received this electronic mail message in error, please immediately notify the sender and delete the message from your computer. ___ 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 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] [Spam] Palm Reading TAB or MIF
Dear List; Does anyone know of a utility to read a simple TAB into a palm hand held? ¡Saludos! / Greetings! Juan José Del Toro Madrueño [EMAIL PROTECTED] Guadalajara, Jalisco MÉXICO ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] MapBasic Question
Hi Listers: Being a MapBasic Neophyte, I have what will probably be a dumb question. But here goes any way. I manually select a record from table A, append it to table B, delete the selected record from table A and then save both tables. To automate steps I have built a button pad and associated program to append the selected record to table B, then commit both tables. But I cant seem to find the right statement to delete the record from table A. I know its simple but Im at my wits end. Any Help? Thanks, Tom H ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Running a batch file from MapBasic...
Hi all, I am in a bit of a bind. I am trying to run a batch file from the following directory using this line of code. Run Program C:\tdrive\Allocate_test\Proposed_test\test_1.bat After reading some past posts, I found that this is incorrect. I found that issuing a DOS command is the way to go. However it has been quite a while since I have done anything in DOS. I know the command should start like this. Run Program command.com /c.. After that I am not sure what to enter. Can anyone help me out with this? Many thanks, Jeremy ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] MapBasic Question
Hi Tom, Try: delete from tablename [where rowid=n] You'll need to supply the table name in place of tablename. The optional rowid where clause allows you to select a particular record to delete. -- Eric Johnson Tom Halbrook wrote: Hi Listers: Being a MapBasic Neophyte, I have what will probably be a dumb question. But here goes any way. I manually select a record from table A, append it to table B, delete the selected record from table A and then save both tables. To automate steps I have built a button pad and associated program to append the selected record to table B, then commit both tables. But I can’t seem to find the right statement to delete the record from table A. I know it’s simple but I’m at my wits end. Any Help? Thanks, Tom H ___ 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
[MI-L] Custom Symbols
Hi List: I created and imported a custom North Arrow symbol in MapInfo (8.0)successfully. It looks very crisp and clear in MapInfo and prints great. As soon as I create a PDF from this document, my North Arrow looks pixelly and of low resolution. The PDF I am creatingis of medium resolution. Any suggestions? Thanks NazAli | GIS Marketing Services CB Richard Ellis Limited West Georgia Street, Suite 600 | Vancouver,BCV6E 4M3 T604 662 5173 | F 604 684 9368 [EMAIL PROTECTED] | www.cbre.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Centroids not Recentering
Hi All, I've been trying to write a tool that recenters polygons based on a user defined point. I've got it all figured out, except one strange problem. I've noticed the centroid of the polygons can shift during the recentering. I've tried the ConvertToPline, ConvertToRegion trick, but the centroid wont recenter if the original centroid (before polygon moving) is within the new bounds of the polygon. When I try to set the centroid to the user-defined point using the Alter Object command, I get an error that the point must be within the region. Argh! It's the point I used to recenter, so it's right at the center of the region!! Any thoughts? Here's a sample of my code too: For j=1 to numNode - 1 nodeX = ObjectNodeX(Mover, 1, j) nodeY = ObjectNodeY(Mover, 1, j) Alter Object Mover Node Set Position 1, j (nodeX + DeltaX, nodeY + DeltaY) Next Update Selection Set Obj = Mover Where Rowid = i Update Selection Set Obj = ConvertToPline(Mover) Where Rowid = i Update Selection Set Obj = ConvertToRegion(Mover) Where Rowid = I 'Alter Object Mover Geography OBJ_GEO_CENTROID, Targ_obj 'Update Selection Set Obj = Mover Where Rowid = i Thanks! Erin Erin Comparri | Mapping Specialist CB Richard Ellis | CBRE Mapping Center 1620 Fountainhead Pkwy, Suite 610 | Tempe, AZ 85282 MC 877 580 4674 | F 480 929 6400 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] | www.cbre.com http://www.cbre.com/ | mapping.cbre.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Custom Symbols
Title: Message If this is what I expect, you'll be happy to know, it's not a problem with Mapinfo, or even Adobe, but you will need to change a setting in Adobe to display your graphics asthetically. I'm running Adobe 6.0, but I'm sure this would apply to Adobe Acrobat and other versions. While viewing any of your PDF's, from the file menu click [Edit] / [Preferences] / [General] Select "Display" from the list and look for the "Smoothing" area of the dialog. You should find several check boxes that when applied will smooth text, line art and images. Depending on what application you're viewing your PDF's with, the wording and location for these features may be a bit different but should be in there somewhere. HTH Dave -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ali, Naz @ VancouverSent: Tuesday, August 01, 2006 11:14 AMTo: 'mapinfo-l@lists.directionsmag.com'Subject: [MI-L] Custom Symbols Hi List: I created and imported a custom North Arrow symbol in MapInfo (8.0)successfully. It looks very crisp and clear in MapInfo and prints great. As soon as I create a PDF from this document, my North Arrow looks pixelly and of low resolution. The PDF I am creatingis of medium resolution. Any suggestions? Thanks NazAli | GIS Marketing Services CB Richard Ellis Limited West Georgia Street, Suite 600 | Vancouver,BCV6E 4M3 T604 662 5173 | F 604 684 9368 [EMAIL PROTECTED] | www.cbre.com --Checked by AVG Free Edition.Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 07/31/2006 -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 07/31/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] MapBasic Question
Hi Tom, The statement Delete FromTable_A Where Rowid = id_number should work.Good Luck! Erin Erin Comparri | Mapping SpecialistCB Richard Ellis | CBRE Mapping Center1620 Fountainhead Pkwy, Suite 610 | Tempe, AZ 85282MC 877 580 4674 | F 480 929 6400 [EMAIL PROTECTED] | www.cbre.com | mapping.cbre.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Extracting data from gridded file
Hi all I have data in a gridded txt file that I have imported into MapInfo I am unfamiliar with this type of file, I can use the info tool to display data but I need to extract this data by regions into a database (file is 800 columns which excel Access cannot handle) and all the SQL functions seem to be unavailable for this file type Can you help? Kind regards Graham Bish Senior Consultant Neil Clark Associates Ph. 03 5441 1244 Fx. 03 5441 1366 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] RowID question [SEC=UNCLASSIFIED]
Guys, I may be showing my ignorance but I cant seem to include RowID in an SQL query. EG: Select Col1, Col2, Col3, ROWID RowIdentifier from I dug up an old post: [MI-L] Returning RowID in the Select Statement (SQ Author:Ben A Greenberg(207.250.113.---) Date:03-25-2006 08:17 I am querying a large dataset and would like the select query to return the RowID as a temporary column. Can this be done. When i run the following query: But couldnt find and answer. Can anybody help? Cheers Percy Percy Bell Research Statistics and Technology Branch Phone: (02) 6271 1463 Mob: (0415) 260 805 Fax: (02) 6271 1144 Department of Communications, Information Technology and the Arts GPO Box 2154, Canberra ACT 2601 Australia URL:http://www.dcita.gov.au Email: [EMAIL PROTECTED] ___ Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial. Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties. Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments. Forallotherenquiriespleasering(02)6271-1000. ___ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Symbol identification
Hello all Can anyone point me towards how I can printa full list of available symbolsfor reference purposes - image and meta info i.e. Symbol (48,255,8,""MapInfo Cartographic"",0,0). Below is atxt export of browser which is used to define symbology within and asset program. I'd like to be able to add and re define entries from a known reference sheet. Thanks Micheal FEATURE_TYPE Symbol Unknown Symbol (32, 16711680, 15)Blank CapSymbol (48,255,8,""MapInfo Cartographic"",0,0)Fire Hydrant Symbol (32, 16776960, 8)"Fountain Symbol (94,255,12,""Wingdings"",0,0)Meter Symbol (77,255,8,""Symbol"",1,0)Dummy Node Symbol (33, 0, 8)Pump StationSymbol (35,255,16,""MapInfo Real Estate"",0,0)Reservoir Symbol (40, 255, 15) and so on "Tap""Symbol (44,255,8,""MapInfo Cartographic"",0,0)""Valve""Symbol (101,255,8,""MapInfo Cartographic"",0,0)""Treatment Plant""Symbol (40,255,16,""MapInfo Real Estate"",0,0)""ManholeBore Site""Symbol (40, 255, 15)""Valve Pit with PigValve PitCross ConnectionMarker Post""Symbol (54, 16776960, 12)""HeadWallPit"""__ DISCLAIMER This email and any attachment is solely for the named addressee and may be confidential. If you have received this email in error, please notify the sender immediately and then destroy any copy of this message. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Rous Water. Before opening any attachments the recipient should check for the presence of viruses or defects. Rous Water accepts no liability for any damage caused by any virus transmitted by this email. Rous Water 218-232 Molesworth Street, Lismore NSW 2480 Australia www.rouswater.nsw.gov.au __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RowID question [SEC=UNCLASSIFIED]
Percy, Unfortunately you can't select the ROWID "column".You have to update a column with the ROWID value and then use this static column instead. You can however use the ROWID to select certain records, by adding the condition to the where clause 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 Bell, PercySent: Wednesday, August 02, 2006 4:49 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] RowID question [SEC=UNCLASSIFIED] Guys, I may be showing my ignorance but I cant seem to include RowID in an SQL query. EG: Select Col1, Col2, Col3, ROWID RowIdentifier from I dug up an old post: [MI-L] Returning RowID in the Select Statement (SQ Author:Ben A Greenberg(207.250.113.---)Date:03-25-2006 08:17I am querying a large dataset and would like the select query to return the RowID as a temporary column. Can this be done. When i run the following query: But couldnt find and answer. Can anybody help? Cheers Percy Percy Bell Research Statistics and Technology Branch Phone: (02) 6271 1463 Mob: (0415) 260 805Fax: (02) 6271 1144Department of Communications, Information Technology and the Arts GPO Box 2154, Canberra ACT 2601 AustraliaURL:http://www.dcita.gov.auEmail: [EMAIL PROTECTED] ___Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial.Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties.Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments.Forallotherenquiriespleasering(02)6271-1000.___ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RowID question [SEC=UNCLASSIFIED]
Thanks Peter, I have been getting around it by calling the RowID from the temporary table Commandinfo(CMD_INFO_ROWID) when I need it for my variable but it would be nice to be able to simply select the RowID into the query as a column. But it looks like it cant be done without creating a table and updating a column. Cheers Percy From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: 02 August 2006 15:40 To: Bell, Percy; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] RowID question [SEC=UNCLASSIFIED] Percy, Unfortunately you can't select the ROWID column.You have to update a column with the ROWID value and then use this static column instead. You can however use the ROWID to select certain records, by adding the condition to the where clause 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 Bell, Percy Sent: Wednesday, August 02, 2006 4:49 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] RowID question [SEC=UNCLASSIFIED] Guys, I may be showing my ignorance but I cant seem to include RowID in an SQL query. EG: Select Col1, Col2, Col3, ROWID RowIdentifier from I dug up an old post: [MI-L] Returning RowID in the Select Statement (SQ Author:Ben A Greenberg(207.250.113.---) Date:03-25-2006 08:17 I am querying a large dataset and would like the select query to return the RowID as a temporary column. Can this be done. When i run the following query: But couldnt find and answer. Can anybody help? Cheers Percy Percy Bell Research Statistics and Technology Branch Phone: (02) 6271 1463 Mob: (0415) 260 805 Fax: (02) 6271 1144 Department of Communications, Information Technology and the Arts GPO Box 2154, Canberra ACT 2601 Australia URL:http://www.dcita.gov.au Email: [EMAIL PROTECTED] ___ Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial. Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties. Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments. Forallotherenquiriespleasering(02)6271-1000. ___ ___ Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial. Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties. Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments. Forallotherenquiriespleasering(02)6271-1000. ___ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Symbol identification
Mike, There is an unlimited number of symbols availeble in MapInfo. Just consider the combination possibilities between the 32 different symbols in MapInfo 3.0 Symbols, a number of million colours and sizes between 3 and 72. And this is just one set of symbols. When you look in the Symbol dialog, you can see maybe 30 different symbol fonts containing any number of symbols. But in the MapInfo Professional User Guide 8can be found on the MapInfo installation cd and for MapInfo 8.5 in the document folder in the installation folder) you can in Appendix E MapInfo Map Interchange Format - MapInfo 8.5 - find a list of symbols available in the MapInfo 3.0 Symbols. You could also create you own list in this way. 1. Create a new mappable table containing one column called NAME 2. Insert points into this table with the symbols that you like and need and add a description in the NAME column 3. With this SQL Select statement, you can get a list of NAMES and SYMBOLS from this table. You can copy the statement and execute it from the MapBasic window or just use the bold text and insert these into the SQL Select Dialog Select NAME, Str$(ObjectInfo(OBJ, 2) "SYMBOL" From SYMBOLTABLE Order By NAME 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 Mike GibsonSent: Wednesday, August 02, 2006 7:16 AMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Symbol identification Hello all Can anyone point me towards how I can printa full list of available symbolsfor reference purposes - image and meta info i.e. Symbol (48,255,8,""MapInfo Cartographic"",0,0). Below is atxt export of browser which is used to define symbology within and asset program. I'd like to be able to add and re define entries from a known reference sheet. Thanks Micheal FEATURE_TYPE Symbol Unknown Symbol (32, 16711680, 15)Blank CapSymbol (48,255,8,""MapInfo Cartographic"",0,0)Fire Hydrant Symbol (32, 16776960, 8)"Fountain Symbol (94,255,12,""Wingdings"",0,0)Meter Symbol (77,255,8,""Symbol"",1,0)Dummy Node Symbol (33, 0, 8)Pump StationSymbol (35,255,16,""MapInfo Real Estate"",0,0)Reservoir Symbol (40, 255, 15) and so on "Tap""Symbol (44,255,8,""MapInfo Cartographic"",0,0)""Valve""Symbol (101,255,8,""MapInfo Cartographic"",0,0)""Treatment Plant""Symbol (40,255,16,""MapInfo Real Estate"",0,0)""ManholeBore Site""Symbol (40, 255, 15)""Valve Pit with PigValve PitCross ConnectionMarker Post""Symbol (54, 16776960, 12)""HeadWallPit"""__ DISCLAIMER This email and any attachment is solely for the named addressee and may be confidential. If you have received this email in error, please notify the sender immediately and then destroy any copy of this message. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Rous Water. Before opening any attachments the recipient should check for the presence of viruses or defects. Rous Water accepts no liability for any damage caused by any virus transmitted by this email. Rous Water 218-232 Molesworth Street, Lismore NSW 2480 Australia www.rouswater.nsw.gov.au __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l