[MI-L] Strange Find results geocoding in MI ProViewer
Greetings list, As a temporary solution to an unrelated Mapinfo issue, we're running MI Proviewer on a particular workstation, Proviewer 6.0 btw. Yesterday, on various addresses entered to the Find dialog, it started geocoding some of these addresses as much as 1/2 mile from where the address is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem? Thanks, David Reid Colbert County 9-1-1 Colbert County Alabama -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.4/375 - Release Date: 06/25/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapBasic
Matt, If you have a "newer" version of MapInfo Pro, you can on the installation cd find a folder called PDF_DOCS. In this folder there is a copy of a number of usefull manuals. You can here find as well the MapInfo User Guide as well as the MapBasic User Guide and MapBasic Reference Guide 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] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew DolanSent: Tuesday, June 27, 2006 3:13 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] MapBasic Hi all: I was wondering if there is a site or book, etc.. that introduces users to MapBasic functionality and commands. I am a heavy user of MapInfo 6.5, but have no programming background. I am thinking that using the MB control would open up a whole new world to me and take my skills to another level. Two main issues I have currently: 1)Labels getting scrambled when I refresh a database. 2)Creating transparent polygons. Thanks and I hope this makes sense to the experts out there. Matt DolanDirector of Market Analytics GISColliers Arnold4350 West Cypress St, Suite 300 Tampa, FL 33607-4175 813.221.2290 813.224.9403 (Fax) www.colliersarnold.com [EMAIL PROTECTED] Colliers Arnold - Tampa / Clearwater / Orlando / Ft. Myers Colliers International - 241 offices in54 countries on six continents This e-mail and attachments (if any) is intended only for the addressee(s) and is subject to copyright. This e-mail contains information which may be confidential or privileged. If you are not the intended recipient please advise the sender by return e-mail, do not use or disclose the contents and delete the message and any attachments from your system. Unless specifically stated, this e-mail does not constitute formal advice or commitment by the sender or Colliers Arnold or any of its subsidiaries. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Querying Style Attributes
Title: Querying Style Attributes Hi, I have a table of points, each is a different size, colour, symbol etc Does anybody know how to determine the various style attributes for each of this when I query them individually ? Thanks Stu Visit our website at http://www.halcrow.com The contents of this email are confidential, for the sole useof the intended recipient at the email address to which it hasbeen addressed and do not give rise to any binding legalobligation upon Halcrow companies unless subsequently confirmedon headed business notepaper sent by fax, letter or as an emailattachment. Whilst reasonable care has been taken to avoid virustransmission, no responsibility for viruses is taken and it isyour responsibility to carry out such checks as you feelappropriate. Emails supplied are as found and there's noguarantee that the messages contained within the body of theemail have not been edited after receipt. If you receive thisemail in error, please contact the sender immediately and deletethe message from your system.Thank you.- ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Strange Find results geocoding in MI ProViewer
On Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the Find dialog, it started geocoding some of these addresses as much as 1/2 mile from where the address is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem? Are these addreses supposed to be near the start or end of a long rural road? MapInfo's algorithm moves addresses near a road intersection back up the road about 10% of the length of the segment. This keeps the locations from bunching up on intersections in the cities, but it's not helpful in the country. I think there's a preference setting for this somewhere. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Querying Style Attributes
Title: Querying Style Attributes Hi, I answered my own question. If anyone is interested. Dim sPointObj As Alias sPointObj = sTableName + ".obj" Select your point using SearchInfo() Note ObjectInfo(sNodeOBJ, OBJ_INFO_SYMBOL) Cheers From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibb, StuartSent: 27 June 2006 15:06To: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Querying Style Attributes Hi, I have a table of points, each is a different size, colour, symbol etc Does anybody know how to determine the various style attributes for each of this when I query them individually ? Thanks Stu Visit our website at http://www.halcrow.com The contents of this email are confidential, for the sole useof the intended recipient at the email address to which it hasbeen addressed and do not give rise to any binding legalobligation upon Halcrow companies unless subsequently confirmedon headed business notepaper sent by fax, letter or as an emailattachment. Whilst reasonable care has been taken to avoid virustransmission, no responsibility for viruses is taken and it isyour responsibility to carry out such checks as you feelappropriate. Emails supplied are as found and there's noguarantee that the messages contained within the body of theemail have not been edited after receipt. If you receive thisemail in error, please contact the sender immediately and deletethe message from your system.Thank you.- Click here to report this email as spam. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Strange Find results geocoding in MI ProViewer
I should have added that within the Workspace being used, I have Inset address from end of street set to zero as these are mainly rural streets set to 0.001 mile addressing format. Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs Off ClosestAddr Off OtherBdy Off Symbol Inset 0 Distance Units ft Offset 15 Distance Units ft When I plot the two addresses (that have come to our attention) in Mapinfo, they geocode right where their supposed to. Thus far, all other addresses that have been searched appear where their supposed to. Additionally, the tables being used are maintained in MI 6.5, but the Proviewer we're using is 6.0. I would think that would be an issue though. Strange indeed Dave -Original Message- From: Bill Thoen [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 9:08 AM To: David Reid Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Strange Find results geocoding in MI ProViewer On Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the Find dialog, it started geocoding some of these addresses as much as 1/2 mile from where the address is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem? Are these addreses supposed to be near the start or end of a long rural road? MapInfo's algorithm moves addresses near a road intersection back up the road about 10% of the length of the segment. This keeps the locations from bunching up on intersections in the cities, but it's not helpful in the country. I think there's a preference setting for this somewhere. -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 06/26/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Number of points in a buffer
Title: Number of points in a buffer Hi all, I asked this question last week and Peter suggested the below. I'm just not sure where to include the Where OBJ in Buffer Table Contains OBJ in Points Table statement in the TableUpdate Column window. Can anyone help? Thanks Christine -Original Message- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]] Sent: Wed 6/21/2006 2:17 PM To: Ronning, Christine; MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Wrong Subject on last one: Spatial Query Christine, I'm sure there are a number of ways to do this. Here is mine 1. Make sure that your table contains a column with a unique ID. You could use ROWID to update a numerical column. 2. Use Table Buffer to create a new table of buffers around your points 3. Add a column to hold the number of points, let us call it NUMPOINTS 4. Using Table Update Column you can now update you table of buffers with the number of points that fall within each buffer. Update Table Buffer Column NUMPOINTS Get Values From Table Points Where OBJ in Buffer Table Contains OBJ in Points Table Calculate Value Count(*) 4. Now do a SQL Select: Select * From Points Where ID In (Select ID from Buffers Where NUMPOINTS 10 I'm not sure if you want to select the points where there are 10 or more points within .5 km including the point or excl the point. But that should just be a question of comparing NUMPOINTS to 10 or 11. 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 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ronning, Christine Sent: Wednesday, June 21, 2006 10:53 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Wrong Subject on last one: Spatial Query Hi all, I have mapped a points layer. I would like to select those records where there is more than 10 points within a radius of .5km. I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts? Thanks Christine -Original Message- From: [EMAIL PROTECTED] on behalf of Spencer Simpson Sent: Wed 6/21/2006 11:34 AM To: 'Alan Silvester'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Creating a line from a series of points I think we need to know a little more about the table, such as: 1. Are there columns specifying X and Y, or formulas, or a point object you can derive X and Y Coordinates from? 2. Is there a column specifying the order that a point appears in the polyline? 3. Is there more than one polyline? If so, is there a column specifying which polyline a row belongs to? If so, then it's possible to write a MapBasic application to chain the points together. Some of the other listers may have even written such applications. A. Sort by (select statement with order by clause) polyline specifier and order specifier B. Iterate through the result table. For each record: if the line specifier changed, finish the current polyline (insert) and start a new one with the coordinates from current rec (Create Pline). If not, add the coordinates from the current rec to the end of the current line. (Alter Object Add Node) C. At the end, finish the current polyline. Hope this helps Spencer _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Alan Silvester Sent: Wednesday, June 21, 2006 11:30 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating a line from a series of points Dear All, Does anybody know how to automatically create a line from a series of points, i.e. rather than drawing a line from point to point, I want to be able to make a line that automatically joins up the points. The problem is, is that the next point to join up with the line may not be the next record in the table?! The points are however all 1km apart. Does anyone have any ideas? Regards, Alan Alan Silvester GIS Manager GroundSure Limited Unit E, Level 7 New England House Brighton BN1 4GH Tel: +44 (0)1273 819500 (Switchboard) +44 (0)1273 647811 (Direct dial) Email: [EMAIL PROTECTED] This e-mail is private and confidential. Access by or disclosure to anyone other than the intended recipient for any reason other than the business purpose for which the message is intended, is unauthorised. If you are not the intended recipient, you must not act or omit to take any action based on this message. This e-mail and any views or opinions contained in it are subject to any terms and conditions agreed between GroundSure Limited and the recipient. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As GroundSure Limited cannot accept responsibility for loss or damage arising from the use of this e-mail or attachments we recommend that you subject
RE: [MI-L] Number of points in a buffer
Title: RE: [MI-L] Number of points in a buffer Hi all, Sorry please ignore my last note. Thanks Peter your suggestion works like a charm! Christine -Original Message- From: [EMAIL PROTECTED] on behalf of Ronning, Christine Sent: Tue 6/27/2006 9:26 AM To: Peter Horsbøll Møller; MapInfo-L@lists.directionsmag.com Subject: [MI-L] Number of points in a buffer Hi all, I asked this question last week and Peter suggested the below. I'm just not sure where to include the Where OBJ in Buffer Table Contains OBJ in Points Table statement in the TableUpdate Column window. Can anyone help? Thanks Christine -Original Message- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]] Sent: Wed 6/21/2006 2:17 PM To: Ronning, Christine; MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Wrong Subject on last one: Spatial Query Christine, I'm sure there are a number of ways to do this. Here is mine 1. Make sure that your table contains a column with a unique ID. You could use ROWID to update a numerical column. 2. Use Table Buffer to create a new table of buffers around your points 3. Add a column to hold the number of points, let us call it NUMPOINTS 4. Using Table Update Column you can now update you table of buffers with the number of points that fall within each buffer. Update Table Buffer Column NUMPOINTS Get Values From Table Points Where OBJ in Buffer Table Contains OBJ in Points Table Calculate Value Count(*) 4. Now do a SQL Select: Select * From Points Where ID In (Select ID from Buffers Where NUMPOINTS 10 I'm not sure if you want to select the points where there are 10 or more points within .5 km including the point or excl the point. But that should just be a question of comparing NUMPOINTS to 10 or 11. 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 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ronning, Christine Sent: Wednesday, June 21, 2006 10:53 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Wrong Subject on last one: Spatial Query Hi all, I have mapped a points layer. I would like to select those records where there is more than 10 points within a radius of .5km. I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts? Thanks Christine -Original Message- From: [EMAIL PROTECTED] on behalf of Spencer Simpson Sent: Wed 6/21/2006 11:34 AM To: 'Alan Silvester'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Creating a line from a series of points I think we need to know a little more about the table, such as: 1. Are there columns specifying X and Y, or formulas, or a point object you can derive X and Y Coordinates from? 2. Is there a column specifying the order that a point appears in the polyline? 3. Is there more than one polyline? If so, is there a column specifying which polyline a row belongs to? If so, then it's possible to write a MapBasic application to chain the points together. Some of the other listers may have even written such applications. A. Sort by (select statement with order by clause) polyline specifier and order specifier B. Iterate through the result table. For each record: if the line specifier changed, finish the current polyline (insert) and start a new one with the coordinates from current rec (Create Pline). If not, add the coordinates from the current rec to the end of the current line. (Alter Object Add Node) C. At the end, finish the current polyline. Hope this helps Spencer _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Alan Silvester Sent: Wednesday, June 21, 2006 11:30 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating a line from a series of points Dear All, Does anybody know how to automatically create a line from a series of points, i.e. rather than drawing a line from point to point, I want to be able to make a line that automatically joins up the points. The problem is, is that the next point to join up with the line may not be the next record in the table?! The points are however all 1km apart. Does anyone have any ideas? Regards, Alan Alan Silvester GIS Manager GroundSure Limited Unit E, Level 7 New England House Brighton BN1 4GH Tel: +44 (0)1273 819500 (Switchboard) +44 (0)1273 647811 (Direct dial) Email: [EMAIL PROTECTED] This e-mail is private and confidential. Access by or disclosure to anyone other than the intended recipient for any reason other than the business purpose for which the message is intended, is unauthorised. If you are not the intended recipient, you must not act or omit to take any action based on this message. This e-mail and any views or opinions contained in it are
[MI-L] Selecting object types
Title: Selecting object types Hi all, Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? Thanks Christine -Original Message- From: [EMAIL PROTECTED] on behalf of David Reid Sent: Tue 6/27/2006 7:50 AM To: 'Bill Thoen' Cc: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Strange Find results geocoding in MI ProViewer I should have added that within the Workspace being used, I have Inset address from end of street set to zero as these are mainly rural streets set to 0.001 mile addressing format. Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs Off ClosestAddr Off OtherBdy Off Symbol Inset 0 Distance Units ft Offset 15 Distance Units ft When I plot the two addresses (that have come to our attention) in Mapinfo, they geocode right where their supposed to. Thus far, all other addresses that have been searched appear where their supposed to. Additionally, the tables being used are maintained in MI 6.5, but the Proviewer we're using is 6.0. I would think that would be an issue though. Strange indeed Dave -Original Message- From: Bill Thoen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 27, 2006 9:08 AM To: David Reid Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Strange Find results geocoding in MI ProViewer On Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the Find dialog, it started geocoding some of these addresses as much as 1/2 mile from where the address is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem? Are these addreses supposed to be near the start or end of a long rural road? MapInfo's algorithm moves addresses near a road intersection back up the road about 10% of the length of the segment. This keeps the locations from bunching up on intersections in the cities, but it's not helpful in the country. I think there's a preference setting for this somewhere. -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 06/26/2006 ___ 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] Selecting object types
Title: Selecting object types Christine, There is a few ways of doing this: Select * From MYTABLE Where 1. Str$(OBJ) = "Point" 2. Str$(ObjectInfo(OBJ, 1) = "5" 3. Area(OBJ, "sq m") = 0 And ObjectLen(OBJ, "m") = 0 I would recommend using the second. If you need to find other object type, the values to be used are these (copied from the MapBasic.def): Define OBJ_TYPE_ARC 1Define OBJ_TYPE_ELLIPSE 2Define OBJ_TYPE_LINE 3Define OBJ_TYPE_PLINE 4Define OBJ_TYPE_POINT 5Define OBJ_TYPE_FRAME 6Define OBJ_TYPE_REGION 7Define OBJ_TYPE_RECT 8Define OBJ_TYPE_ROUNDRECT 9Define OBJ_TYPE_TEXT 10Define OBJ_TYPE_MPOINT 11Define OBJ_TYPE_COLLECTION 12 By the way, a different approach would be to export the table to Shape using Universal Translator. This would result in a number of tables named by the object types. Remember that Shape can notcontain different objecttypes in the same file. Then you just need to reimport - or open - the generated Shape files. 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] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Tuesday, June 27, 2006 7:32 PMTo: David Reid; Bill ThoenCc: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Selecting object types Hi all,Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? ThanksChristine-Original Message-From: [EMAIL PROTECTED] on behalf of David ReidSent: Tue 6/27/2006 7:50 AMTo: 'Bill Thoen'Cc: mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Strange "Find" results geocoding in MI ProViewerI should have added that within the Workspace being used, I have "Insetaddress" from end of street set to zero as these are mainly rural streetsset to 0.001 mile addressing format.Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs OffClosestAddr Off OtherBdy Off SymbolInset "0" Distance Units "ft" Offset "15" Distance Units "ft"When I plot the two addresses (that have come to our attention) in Mapinfo,they geocode right where their supposed to. Thus far, all other addressesthat have been searched appear where their supposed to.Additionally, the tables being used are maintained in MI 6.5, but theProviewer we're using is 6.0. I would think that would be an issue though.Strange indeedDave-Original Message-From: Bill Thoen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 27, 2006 9:08 AMTo: David ReidCc: mapinfo-l@lists.directionsmag.comSubject: Re: [MI-L] Strange "Find" results geocoding in MI ProViewerOn Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the "Find" dialog, it started geocoding some of these addresses as much as 1/2 mile from where theaddress is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem?Are these addreses supposed to be near the start or end of a long ruralroad? MapInfo's algorithm moves addresses near a road intersection back upthe road about 10% of the length of the segment. This keeps the locationsfrom "bunching up" on intersections in the cities, but it's not helpful inthe country. I think there's a preference setting for this somewhere.--Outgoing mail is certified Virus FreeChecked by AVG Free Edition.Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 06/26/2006___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://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] Templates for Thematic Mapping Missing After 8.5 Installed
Greetings All! Does anyone know how to retrieve templates for thematic maps? After we installed MiPro 8.5 I can't seem to find my templates!!! Yet, when I try to save a new one (saved under the same name as a previous one) it claims that I already have a template by that name! I am sooo confused...someone please help me! :) Akua ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] no DAT found
Title: no DAT found Okay, Sorry about this multitude of questions today: In MapBasic I want to save a copy of a table and open it in the workspace. I've used Commit Table Pen_Ver_Emp As F:\CHSPR\data\cronning\Data\Proof of Concept\Buffer_Employee.TABTYPE NATIVE Charset WindowsLatin1 Open Table F:\CHSPR\data\cronning\Data\Proof of Concept\Buffer_Employee.TAB Interactive Add Map Auto Layer Buffer_Employee The program compiles with no errors, but when I run it in the open workspace I get the error message (cluster alert.mb:5)File Buffer_Employee.DAT not found. Unable to create new table. I seem to remember this happening before when using the MapBasic Window in MapInfo, but don't remember how I fixed it. Thanks in advance, Christine ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE : [MI-L] Selecting object types
Title: Message Hi, See below, it goes much further than what you're asking for (it selects all sorts of things, including points for exemple) Rob. From IAA Website : http://members.iinet.net.au/~haycraft/iaa/(an Information Technology consultancy business located in Canberra, Australia) Select By Drawing Style (SDS)If you're a Mapinfo Pro user and you want to Select some rows of a table, not by values in the text fields, but by the Drawing Style of the objects in the Obj field, then it's a real chore. For example if you need to select, from a table of Text objects, the rows containing Text features drawn with Box background Bold and Shadow effects then you'll have to type select * from TextTable into Selection where (((StyleAttr(ObjectInfo(Obj,2),2)\256) mod 2)=0) and (StyleAttr(ObjectInfo(Obj,2),5)-1) and (((StyleAttr(ObjectInfo(Obj,2),2)\1) mod 2)=1) and (((StyleAttr(ObjectInfo(Obj,2),2)\32) mod 2)=1) SDS is query builder tool that lets you build and execute such queries through familiar style-picker dialogs. For a screenshot of the SDS dialog settings for the above query see SDS. To get a copy see Downloads. http://members.iinet.net.au/~haycraft/iaa/iaa11g.htm -Message d'origine-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Peter Horsbøll MøllerEnvoyé: mardi 27 juin 2006 19:57À: Ronning, ChristineCc: mapinfo-l@lists.directionsmag.comObjet: RE: [MI-L] Selecting object types Christine, There is a few ways of doing this: Select * From MYTABLE Where 1. Str$(OBJ) = "Point" 2. Str$(ObjectInfo(OBJ, 1) = "5" 3. Area(OBJ, "sq m") = 0 And ObjectLen(OBJ, "m") = 0 I would recommend using the second. If you need to find other object type, the values to be used are these (copied from the MapBasic.def): Define OBJ_TYPE_ARC 1Define OBJ_TYPE_ELLIPSE 2Define OBJ_TYPE_LINE 3Define OBJ_TYPE_PLINE 4Define OBJ_TYPE_POINT 5Define OBJ_TYPE_FRAME 6Define OBJ_TYPE_REGION 7Define OBJ_TYPE_RECT 8Define OBJ_TYPE_ROUNDRECT 9Define OBJ_TYPE_TEXT 10Define OBJ_TYPE_MPOINT 11Define OBJ_TYPE_COLLECTION 12 By the way, a different approach would be to export the table to Shape using Universal Translator. This would result in a number of tables named by the object types. Remember that Shape can notcontain different objecttypes in the same file. Then you just need to reimport - or open - the generated Shape files. 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] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Tuesday, June 27, 2006 7:32 PMTo: David Reid; Bill ThoenCc: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Selecting object types Hi all,Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? ThanksChristine-Original Message-From: [EMAIL PROTECTED] on behalf of David ReidSent: Tue 6/27/2006 7:50 AMTo: 'Bill Thoen'Cc: mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Strange "Find" results geocoding in MI ProViewerI should have added that within the Workspace being used, I have "Insetaddress" from end of street set to zero as these are mainly rural streetsset to 0.001 mile addressing format.Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs OffClosestAddr Off OtherBdy Off SymbolInset "0" Distance Units "ft" Offset "15" Distance Units "ft"When I plot the two addresses (that have come to our attention) in Mapinfo,they geocode right where their supposed to. Thus far, all other addressesthat have been searched appear where their supposed to.Additionally, the tables being used are maintained in MI 6.5, but theProviewer we're using is 6.0. I would think that would be an issue though.Strange indeedDave-Original Message-From: Bill Thoen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 27, 2006 9:08 AMTo: David ReidCc: mapinfo-l@lists.directionsmag.comSubject: Re: [MI-L] Strange "Find" results geocoding in MI ProViewerOn Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the "Find" dialog, it started geocoding some of these addresses as much as 1/2 mile from where theaddress is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem?Are these addreses supposed to be near the start or end of a long ruralroad? MapInfo's algorithm moves addresses near a road intersection back upthe road about 10% of the length of
RE: [MI-L] Templates for Thematic Mapping Missing After 8.5 Installed
Hi, If you go to Options Preferences Folders, you can see where your Themes Templates are located. They are mostly found here: c:\Documents and Settings\PEM\Application Data\MapInfo\MapInfo\Professional\850\ThmTmplt\ where PEM is your Windows username and 850 is the version of your MapInfo Pro 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] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, June 27, 2006 8:31 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Templates for Thematic Mapping Missing After 8.5 Installed Greetings All! Does anyone know how to retrieve templates for thematic maps? After we installed MiPro 8.5 I can't seem to find my templates!!! Yet, when I try to save a new one (saved under the same name as a previous one) it claims that I already have a template by that name! I am sooo confused...someone please help me! :) Akua ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Recalculate Centroids of Region Objects
Title: Untitled Document Hi All, Was wondering if anyone has some hints/ code to recalculate the centroids of region objects, as I've made some changes (clipping/ erasing/ aggregating) and some of the centroids look a little off.. Regards, Jeremy Brown Level 1 Special ProjectsManager 150 Jolimont Road CityWide Service Solutions East Melbourne VIC 3002 Ph: + 61 3 9261 5000 Fax: + 61 3 9261 5005 Email: [EMAIL PROTECTED] Mob: + 61 4 1211 1695 Web: www.citywide.com.au ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Recalculate Centroids of Region Objects
On 6/27/06, Brown Jeremy [EMAIL PROTECTED] wrote: Hi All, Was wondering if anyone has some hints/ code to recalculate the centroids of region objects, as I've made some changes (clipping/ erasing/ aggregating) and some of the centroids look a little off.. Regards, Jeremy Brown Level 1 Special ProjectsManager 150 Jolimont Road CityWide Service Solutions East Melbourne VIC 3002 Ph: + 61 3 9261 5000 Fax: + 61 3 9261 5005 Email: [EMAIL PROTECTED] Mob: + 61 4 1211 1695 Web: www.citywide.com.au Convert your regions to polylines and then convert them back to regions, and you will have the MapInfo calculated centriods.-- Richard Greenwood [EMAIL PROTECTED]www.greenwoodmap.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Recalculate Centroids of Region Objects
Title: Untitled Document x = centroidX(obj) y = centroidY(obj) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brown JeremySent: Wednesday, 28 June 2006 12:34 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Recalculate Centroids of Region Objects Hi All, Was wondering if anyone has some hints/ code to recalculate the centroids of region objects, as I've made some changes (clipping/ erasing/ aggregating) and some of the centroids look a little off.. Regards, Jeremy Brown Level 1 Special ProjectsManager 150 Jolimont Road CityWide Service Solutions East Melbourne VIC 3002 Ph: + 61 3 9261 5000 Fax: + 61 3 9261 5005 Email: [EMAIL PROTECTED] Mob: + 61 4 1211 1695 Web: www.citywide.com.au ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Linking Mapinfo and excel
I Have an excel table which is an output of a cost calculation. I open this in mapinfo as a n excel table and save a .tab file. I can link this to a .tab polygon layer or boundaries to thematically display costs per polygon. I would like to change the values in the excel table and have the thematic display update. Is there a way to do this? have a refresh button in mapinfo which refreshes the .dat file? regards Sam ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
