Re: [MI-L] Merging Layers
Hi Stephen! I'm a bit confused as to what you are trying to do here. But this is how I understand it: First you append TAB2 to TAB1, and that is no problem. But you get a number of overlapping region objects. I assume that your tabs contain a large number of regions. In order to find a total area you try to combine or merge all the objects in TAB1+2 to one object. Well, this may well provoke geometrical errors due to 1/ the number of nodes involved and /2 the overlapping objects. Let me suggest some other approaches. Keeping the two tables apart, make an SQL select to find the overlapping objects and save those as a third table. Then you can use the geometry cleaning tools to simplify the geometry and weed out overlapping entities. Or you could try to run a cleaning on the table as a whole. One thing you should try to bring down is node density. I think this would be the most efficient step on the way to reduce the overall size of the data set. To find the total area, use an SQL select with the Sum function on the area of the objects - Sum(Area(obj, sq mi)) Even if this was brief, I hope it helps in some way. 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 [EMAIL PROTECTED] wrote: - To: MapInfo-L@lists.directionsmag.com From: Stephen Smith XS \(MC/TKO\) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] Date: 04/15/2006 03:09PM Subject: [MI-L] Merging Layers Hopefully this group can help. I have 2 x Map Layers [tab] files. [tab1 = 18MB][tab2 = 8MB]. About 75% of TAB2 overlaps TAB1. I want to copy TAB2 onto TAB1 then combine/ merge the two TABS to give one layer from which I can calculate total area. The problem I have is the combine constantly results in errors where I loose the entire layer and all records within the underlying table are lost. The copy from TAB2 to TAB1 works perfectly and all is visible. Just the combine is causing a problem. I am assuming this error is due to the number of vertices which I have had problems with in Arcview. Is there any way I can overcome this. Has anyone come across this similar problem before? I can say, which might helpunderstand what I am trying to do. I want to calculate the amount of GSM coverage in Oman and distribute the MIF file in as small a file as possible. With the layers merged I eliminate all the duplicated info. Regards Steve Smith ___ 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] MI-L Mr Sid Image Error
I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message "Raster Engine Error : 4." Ther error occurs after I have selected the projection and a Mapper Window opens, but the image is not visible. Note that I can view the image though using Global Mapper. Any advice would be appreciated. Regards, Bill ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] MI-L Mr Sid Image Error
Data Directions wrote: I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message *Raster Engine Error : 4*. I think this is an upgrade in the MrSID format that is addressed by the MapInfo 8.0 upgrade. - Bill Thoen ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Speed up opening tables
Philip, The interesting question is what actual is taking the time. Is it opening the tables, showing these in a mapper or setting the layer settings for the layers ? I would recommend, that you add some MapBasic code to a copy of your workspace to make some speed testing. At the top of the workspace you write this (written in bold): ** !Workspace !Version 400 !CharSet WindowsLatin1 Dim nTime As Integer nTime = Timer() ** Now whenever you want to see how much tiime has been used, you can write some thing like this: ** ... Open Table "C:\HereAreMyTable\MyTable.Tab" As MyTable Print "Tables opened: " + (Timer() - nTime) + " secs" ... ** And at the bottom of the workspace, you write: ** ... Undim nTime ** I have used this method to track down speed issues before. I mostly put the timing before the Map >From and Set Map statements. One thing that might be time consuming is the default view of the tablee first put into the map. This table will decide how thee map, should appear and how large a zoom will be used. This has been a problem is previous versions of MapInfo, but it should have been fixed with the latest patch for MapInfo 8.0 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 Lesnik, Philip S.Sent: Thursday, April 13, 2006 5:20 PMTo: MAPINFO Discusion GroupSubject: [MI-L] Speed up opening tables Group. I was wondering if there is a way to speed up the process of opening up tables when starting a workspace. Last year we bought Terrain Data for the whole US which is over 900 tables. We have all 900 tables set up in our main .WOR templates that we use. It takes about 45 seconds to open the workspace because of the 900 additional tab files. Is there a way to speed up the process? I messed around with merging some tables but it didn't work, so I gave up. Any ideas? Thanks Philip Lesnik Research Systems Analyst Market Research Dept. General Growth Properties www.generalgrowth.com NYSE: GGP 110 N. Wacker Drive Chicago, IL 60606 Phone:312-960-2998 BSC - 3N13G +++Notice: This e-mail including attachments) is covered by theElectronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521, isconfidential and may be legally privileged. If you are not theintended recipient, you are hereby notified that any retention,dissemination, distribution, or copying of this communication isstrictly prohibited. Please reply to the sender that you havereceived the message in error, then delete it. Thank you.+++ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Workspace not opening all the way
Hi All, I checked the archives and found the same question but no response from like 2001. Googled the message and couldnt find anything either. Ive had this problem occasionally and would just start over from scratch and dont want to do that any more if I can fix or prevent this from happening again. When opening the workspace I get the following message - WorkspaceName.wor:14) found [where] instead of[(]. And then it says workspace not open completely and there is nothing there. Thank you, in advance, for your help!! Valerie Scott Local Investment Commission 3100 Broadway, Suite 1100 Kansas City, MO 64111 816-889-5050, ext 1246 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Workspace not opening all the way
Valerie, Sounds like there's a query embedded in the workspace, for which the SQL syntax is incorrect. Specifically, there may be a problem with whether all parentheses occur in pairs of one opening "(" and one closing ")" You may want to open the workspace in a text editor and examine any SQL statements you find. -- Eric Johnson Valerie Scott wrote: Hi All, I checked the archives and found the same question but no response from like 2001. Googled the message and couldnt find anything either. Ive had this problem occasionally and would just start over from scratch and dont want to do that any more if I can fix or prevent this from happening again. When opening the workspace I get the following message - WorkspaceName.wor:14) found [where] instead of[(]. And then it says workspace not open completely and there is nothing there. Thank you, in advance, for your help!! Valerie Scott Local Investment Commission 3100 Broadway, Suite 1100 Kansas City, MO 64111 816-889-5050, ext 1246 ___ 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] MapInfo Pro - Oracle Spatial
I guess you are adding a new record to the table ? If so the problem is that you need to enter a unique value into the column MI_PRINX. The best solution would of course be to add a trigger in the Oracle database, that using a Sequence will update this column for you. This is one of the few things that should be fixed to make the interoperability between MapInfo and Oracle better. 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 17, 2006 3:15 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MapInfo Pro - Oracle Spatial Dear Everyone, I have tried to store spatial data into Oracle Spatial database and it worked. But when I try to open it from MapInfo Professional and make editing and draw some new object into the layer then I save it, the error occur explain that the MI_PRINX value is not unique. Could anybody help me please, how to solve this problem. Thank you. Regards, Alit ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] MI-L Mr Sid Image Error
Hi Bill, I am using the latest version of MapInfo, build 33 (version 8). I opened other images fromn this site four months ago without a problem. So do you mean that the Mr Sid format may have been upgraded and we now need to possibly wait for MapInfo 8.5? Cheers, Bill - Original Message - From: Bill Thoen [EMAIL PROTECTED] To: MapInfo-L@lists.directionsmag.com Sent: Monday, April 17, 2006 10:51 PM Subject: Re: [MI-L] MI-L Mr Sid Image Error Data Directions wrote: I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message *Raster Engine Error : 4*. I think this is an upgrade in the MrSID format that is addressed by the MapInfo 8.0 upgrade. - Bill Thoen ___ 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] MI-L Mr Sid Image Error
On Tue, Apr 18, 2006 at 06:48:56AM +0800, Data Directions wrote: I am using the latest version of MapInfo, build 33 (version 8). I opened other images fromn this site four months ago without a problem. So do you mean that the Mr Sid format may have been upgraded and we now need to possibly wait for MapInfo 8.5? Ah, well no... In that case, I guess you have a strange new problem. A little something from Fate to make your Monday just a little more surreal. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] San Diego GIS Position
Dear List, please see the below information regarding a career opportunity with American Medical Response, the nations largest private ambulance provider. This position is located in San Diego, California - American Medical Response is currently recruiting for the position of Geographic Information Systems (GIS) Specialist for our San Diego Emergency Communications Center. Position Summary Under the direction of the Communications Manager the Geographic Information Systems (GIS) Specialist will be responsible for all computer based mapping and geographic analysis activities for the operation. The incumbent will be responsible for the maintaining all GIS and locations data for the Computer Aided Dispatch (CAD) systems and will provide geographic analysis of response activity. Analysis activities will include support of on-going initiatives through regular report submissions and authoring of new reporting on-demand to assist the operation in appropriate planning and response activities. Minimum Qualifications o High school graduate or General Education Degree (GED) required o Minimum of one year experience operating in a Map Info Professional environment o Minimum of two years prior data analysis experience o Ability to explain reports and analysis results to non-technical audiences o Ability to read and interpret documents such as safety rules, or operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. o Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. o Ability to solve practical problems, collect data, establish facts, and draw valid conclusions. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form. o Ability to tolerate pressures and remain calm. o Ability to concentrate on fine detail with constant interruption o Ability to interact effectively with internal and external customers o Excellent time management and organizational skills o Effective oral and written communication skills o Effective interpersonal skills Preferred Qualifications o Bachelor of Arts/Science Degree in Geography, Cartography or Geographic Information Systems o Previous demographic analysis experience utilizing Map Infos TargetPro application o System Status Management experience o Understanding of CAD systems, managed healthcare and Emergency Medical Services (EMS) Work Environment While performing the duties of this job, the employee is consistently required to sit; use hands to finger; and talk, hear and see. The employee is occasionally required to reach with hand and arms. The employee uses equipment such as computer, copy machine, fax, telephone, keyboard, calculator and stapler. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. American Medical Response offers a competitive compensation program to include, salary, employer sponsored health, dental and vision plans, employee assistance program, tuition reimbursement, 401k with employer matching, paid time off, holidays and other benefits. Contact Veronique Jones at (858) 492-3540 or via e-mail at [EMAIL PROTECTED] for more information. American Medical Response is an Equal Opportunity Employer American Medical Response San Diego 8808 Balboa Avenue, Suite 150 San Diego, CA 92123 --- Meixner, William Manager, Communications [EMAIL PROTECTED] Our mission is to make a difference by caring for people in need. tel: fax: mobile: 858-492-3676 858-492-3677 858-518-9706 Add me to your address book... American Medical Response 8808 Balboa Avenue Suite 150 San Diego, CA 92123 The information in this e-mail transmission, or the documents accompanying this e-mail transmission, may contain confidential health information that is legally protected by state and federal law, including, but not limited to the Health Insurance Portability and Accountability Act of 1996 and related regulations. This information is intended only for the use of the individual or entity to whom this e-mail transmission is addressed. If you are not the intended recipient of this information, or if you are not properly authorized to receive this information, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this e-mail or the attached documents is strictly prohibited. If you have received this information in error, please notify the sender immediately by sending a reply e-mail indicating that you have arranged for the deletion of this e-mail and a
[MI-L] MI-L Brazil Index Map
Does anyone know where I can get a map index for Brazil maps, produced at 100K scale. I am starting a new project in MapInfo. If you go to this website, IBGE Website http://www.ibge.gov.br/english/# it allows you to download PDF, TIF and DGN maps at various scales (click on Download Geoscience Mapas Topographicos). Trouble is though, there does not appear to be an index map, and I'm trying to find the sheet for an area / place called ARICA ACU. Many thanks once again, Bill ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] sql select
Robert, Another way, that works regardless of whether or not either table is mappable is a query of this form: Tables {TableA} Where {ID in (select ID from TableB)} Or: Tables {TableB} Where {ID in (select ID from TableA)} Cheers David L -Original Message- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Friday, 14 April 2006 1:43 AM To: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] sql select That's what the problem was. Table A was not mappable and Table B was mappable. I made Table A mappable and ran the same query and it selected the records from Table A. Thanks for the help. -Bob Mike Mayer [EMAIL PROTECTED] on Thursday, April 13, 2006 at 9:46 AM -0700 wrote: Are the records in Table A mappable? If so, try going to table maintainence and uncheck the box that makes the table mappable and try again. We came across this same problem and that solution seemed to work, but Im not sure why! You may need to try switching the table order again as well. Mike Mayer GIS Technician Strongbow Exploration Inc. Suite 800- 625 Howe St. Vancouver, BC V6C 2T6 (604)668-8370 www.strongbowexploration.com From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Robert DeRubeis Sent: Thursday, April 13, 2006 9:22 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] sql select List, I'm having a problem with a selection query. I have 2 tables both editable with a common column named ID. Table B is my deleted records which I want to find in table A to delete. When I run the following sql select statement- Select * from Table A, Table B where Table A.ID = Table B.ID It selects the records, but only from Table B, not from Table A which is the table I need to delete them from. I also tried switching around the table order (Select * from Table B, Table A where Table B.ID = Table A.ID), but it still only selects records from Table B, not table A. How can I get it to select the records in Table A, not the records in Table B? Thanks, -Bob ***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. *** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] MI-L Mr Sid Image Error
Bill, How about exporting the SID file out of Global Mapper as a geoTiff for use in MapInfo. I have had good success changing projections of raster files within Global Mapper for use with MapInfo. Dan == Daniel P. Laux Geologist South Branch Resources LLC Apache Junction, AZ In a message dated 4/17/2006 7:23:26 A.M. US Mountain Standard Time, [EMAIL PROTECTED] writes: I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message "Raster Engine Error : 4." Ther error occurs after I have selected the projection and a Mapper Window opens, but the image is not visible. Note that I can view the image though using Global Mapper. Any advice would be appreciated. Regards, Bill ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Mr Sid Image Error(s)
Perhaps it is due to a MrSID block-size error? Apparently this causes problems with a range of software, including LizardTechs own GeoExpress (prior to the Feb2006 patches). Recently this free utility (from LizardTech) was useful to me MrSID Blocksize Reset Utility for MG3 Files This command line utility resets the blocksize of an input MrSID image. A blocksize of 64 is recommended as optimal for MG3-encoded image files. Resetting the MG3 blocksize to 64 may alleviate memory problems encountered when attempting to view composite mosaic files in third-party applications. Instructions for Use: Once downloaded this tool can be executed from the Windows command line via the following command: mrsidoptimize -i source_image -o output_image -bs 64 Running this utility does not affect the quality, size, or properties of your data. The only change will be that a composite image composed of files whose blocksize has been reset will use less memory upon decoding. It is downloadable from here I havent been following closely any of the MrSID threads here, but it may be helpful to some others to massage the .SIDs. Note that SID files come in a couple of flavours (Generations) MG2 and MG3. This utility applies only to MG3. Theres a free utility that will give info including Generation. Ian Thomas GeoSciSoft - Perth, Australia From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Data Directions Sent: Monday, April 17, 2006 10:20 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] MI-L Mr Sid Image Error I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message Raster Engine Error : 4. Ther error occurs after I have selected the projection and a Mapper Window opens, but the image is not visible. Note that I can view the image though using Global Mapper. Any advice would be appreciated. Regards, Bill ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MI-L Mr Sid Image Error
An alternative (a better one than a GeoTiff export, in my opinion) would be to convert to ECW format, which is a better format than either SID or TIF. There are 3 faster decoders of MrSID files than the LizardTech free MrSIDDecode.exe, if anyone is interested. IL Thomas GeoSciSoft- Perth, Australia From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 9:10 AM To: [EMAIL PROTECTED]; MapInfo-L@lists.directionsmag.com Subject: Re: [MI-L] MI-L Mr Sid Image Error Bill, How about exporting the SID file out of Global Mapper as a geoTiff for use in MapInfo. I have had good success changing projections of raster files within Global Mapper for use with MapInfo. Dan == Daniel P. Laux Geologist South Branch Resources LLC Apache Junction, AZ In a message dated 4/17/2006 7:23:26 A.M. US Mountain Standard Time, [EMAIL PROTECTED] writes: I have downloaded a Landsat image from https://zulu.ssc.nasa.gov/mrsid/ It is in Mr Sid format. Using MapInfo 8.0 I get an error message Raster Engine Error : 4. Ther error occurs after I have selected the projection and a Mapper Window opens, but the image is not visible. Note that I can view the image though using Global Mapper. Any advice would be appreciated. Regards, Bill ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l