MI-L SQL syntax
Hello listers, =20 Our customer has the following question about SQL syntax in the MapInfo = Professional: I have two tables (see example bellow) and I want aggregate one value = and after aggregation this value subtract it from another value. =20 Example: 1. Table CAPACITY Type Capacity 1 100 2 200 3 300 =20 2. Table WATER_INLET Type Quantity 11 15 18 22 11 16 37 35 =20 I need get this result: Type CapacitySUM(Quantity)= Difference =3D Capacity-SUM(Quantity) 1 100 21 = 79 2 200 2= 198 3 300 12 = 288 (Some programs allows do that for example this way : SELECT CAPACITY.Type, CAPACITY.Capacity, SUM(WATER_INLET.Quantity) AS = SumQuantity, CAPACITY.Capacity - SUM(WATER_INLET.Quantity) AS Difference = FROM CAPACITY, WATER_INLET WHERE CAPACITY.Type=3DWATER_INLET.Type GROUP = BY WATER_INLET.Type ) =20 The question: is it possible do this in one SELECT at the MapInfo? I = can't write Capacity-SUM(Quantity) as a select column Thanks. Roman Baca =20 [EMAIL PROTECTED] =20 ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
Re: MI-L AutoCAD Import
> I am using MI V. 4.5 and wish to know if and/or how to import AutoCAD files. > Any assistance would be greatly appreciated I don't know if v4.5 has an universal translator, but v5 does, thats capable of converting DWG to TAB or MID/MIF. Otherwise, check this link, and look at the bottom: http://www.directionsmag.com/tools/Default.asp?a=catdetails&title=&id=7&ProductID=&orderby=&Page=2&Pagesize=10 That might help you. /Morten, BlomInfo ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Map Catalogs
Hi, I have to manually create a map catalog for a database created and maintained in FoxPro (Mayrise Application). I have uploaded the ODBC drivers and have the link between the foxpro dbase and mapinfo (ie. it creates a MI table of the FP dbase). BUT...It's not mappable, I tried to map it but an error occurred and it asked me to manually create one...I have the instructions on how to do it (brief ones at that), but I am still unsure and don't want to start doing something that I don't have 100% knowledge about...anyone who knows how to create a MI Map Catalog please reply...treat me as a complete novice... Regards Ben __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
Re: MI-L Adding pages to a layout
Sorry Cameron. I have had a look and found that the option is only available if you have 'Discover' running. I had thought it was part of MapInfo. Caroline - Original Message - From: Cameron Crum <[EMAIL PROTECTED]> To: Caroline Hilton <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2001 3:04 PM Subject: Re: MI-L Adding pages to a layout I don't get that option. Cameron Caroline Hilton wrote: > You can add a frame anywhere in the layout window, even on the greyed out > area outside the paper edges, then right click and there's an option to > extend layout to include all frames (or something like that). > > Caroline > > - Original Message - > From: Cameron Crum <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 08, 2001 11:53 PM > Subject: MI-L Adding pages to a layout > > This may seem pretty basic, but how do I add pages to a layout once the > layout window is already open? I want to add another frame, but on a > second page of the layout. > > Cameron > > ___ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > > ___ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Undo Option
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi All, Is there any way to get your UNDO option to go back more than one action? I have done a quick scan of the shareware and found nothing. Thanks in advance. Steve -- This communication (including all attachments) is intended solely for the use of the person or persons to whom it is addressed and should be treated as a confidential xwave communication. If you are not the intended recipient, any use, distribution, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately delete it from your system and notify the originator. Your cooperation is appreciated. ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
Re: MI-L Adding pages to a layout
Cameron You need to use Layout>options and set the number of pages wide and high. Mark Percival _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call Star Internet for details on the Virus Scanning Service. ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L VB for GUI
Hi, I've come to the decision that I will be developing GUI front end for the users in VB, but I'd like to give a try to MapBasic, Before I develop it in VB,is there a trial version available on mapinfo that I can download??, Where can I find VB sample code that could help me on my proyect??? Has any of you done something like this before, any help or advise would be good... Thanks _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
RE: MI-L Language comparisons
At 04:14 PM 8/11/2001 +0100, you wrote: > > [Delphi] Has the power of C--, much easier to understand and code and >is 99% to 150% faster than C-- and ... > >I'm always interested in where these facts come from as they are usually >not objective. Hello, As a delphi programmer I figure it's the cat's pyjamas as well, but I'm not going to get in any spitting matches about which is better. The evidence seems to be that in the hands of a competent programmer, Delphi can be just as fast as _any_ C++ compiler. For some empirical evidence go to Jake's Code Effficiency challenge ( http://home.xnet.com/~johnjac/JCEC.htm#JCEC ), in all of the challenges there VC++ narrowly beat out Delphi, BCB was generally slower than either. For those of us who aren't gods of programming, Delphi is a much better alternative as it is significantly easier to learn and master. And there is a fantastic user community for support. That's just my $0.02. cheers Marc Pelletier ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L (no subject)
I have a parcel layer open above an aerial photograph layer. The display override is turned on to display a colored foreground pattern while the background is turned off. However, certain parcels are still displaying a background even after the individual parcels were redigitized and the originals were deleted. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L MI Truncates Lat/Lons on Import
My company conducts real estate market feasibility, primarily for multifamily development and we are trying to establish a system to use GPS to do our apartment maps using MapInfo and Access. We have established a process to get lat/lons from the handheld GPS directly into Access, which we use for our apartment analysis and data aggregation. Because the Access DB is so large, we would prefer not to have our GIS specialist not work directly with this large database, but rather a subset of the data specifically for each project we use. In Access, the lat/lons are defined as Number, Double, with 10 decimal places. Our database programmer has designed an export procedure, but we have two problems: 1) if he exports it as a comma delimited file for import into MapInfo, the lat/lons are imported as a character field, so our GIS specialist has to save a copy of the file, open the copy and then change the field type using Table--Maintenance in order to generate the points. 2) if he exports it from Access as an Excel file, Excel seems to natively recognize the fields with only 2 decimal places, despite the definition in Access. Even if we change the number format to 10 decimal places in Access, when we import this table into MapInfo, MI truncates the lat/lons to three decimal places, and even then in a seemingly random manner (sometimes there are only 2 decimal places). Our goal is to pushbutton this as much as possible so that all our GIS specialist has to do is open the file in MI and generate the points. What are we doing wrong here? Greg Grant Webmaster/Utility Infielder The Danter Company: National leaders in real estate research http://www.danter.com ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Switching from D.M.S to UTM
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Switching from D.M.S to UTM In a table of sampling points that I have created on a map, I would like to display the coordinates in UTM rather than in Degrees, Minutes seconds, I have created the Northing and Easting fields but every time I do the update column with Centroidx and Centroidy expressions I end up with a coordinate that is displayed in Degrees. I have checked the projection, (UTM zone 11) and the map options displays the coordinates in meters. I could type in the coordinates but that is not an option I want to pursue. Thank you Stephen Brown B.Sc, AAg. Environmental Planner 425-8325 ext. 7113 [EMAIL PROTECTED] ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
Re: MI-L Switching from D.M.S to UTM
Steve, The easiest way I can think of to do this would be to open the MapBasic Window (Options -> Show MapBasic Window), and type the following: Set CoordSys Earth Projection 8, 104, 7, -117, 0, 0.9996, 5, 0 and hit enter. Run your Update Column, and once you're done, you'll probably want to change it back. Set CoordSys Earth Projection 1, 0 Ian Erickson AnalyGIS http://www.analygis.com - Original Message - From: "Brown, Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 13, 2001 9:03 AM Subject: MI-L Switching from D.M.S to UTM > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > > Switching from D.M.S to UTM > In a table of sampling points that I have created on a map, I would like to > display the coordinates in UTM rather than in Degrees, Minutes seconds, I > have created the Northing and Easting fields but every time I do the update > column with Centroidx and Centroidy expressions I end up with a coordinate > that is displayed in Degrees. I have checked the projection, (UTM zone 11) > and the map options displays the coordinates in meters. I could type in the > coordinates but that is not an option I want to pursue. > > Thank you > > > Stephen Brown B.Sc, AAg. > Environmental Planner > 425-8325 ext. 7113 > [EMAIL PROTECTED] > > > > > > > ___ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
RE: MI-L Language comparisons
Hello Marc, I took a quick look at the Code Efficiency challenge site and you're right - it's just splitting hairs. Trey did reply to me saying that his comments were just his opinion and that he meant 0.99 - 1.5 times performance improvements with Delphi. Opinions are fine but I think it's important not to mislead the list. Some may make decisions on a strong conviction which appears to be fact. I think it's far more interesting to argue about pronunciation: Dell-Fi vs. Dell-Fee. You say tomato... ;-) Regards, Warren Vick Europa Technologies Ltd, U.K. http://www.europa-tech.com ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
Re: MI-L Language comparisons
"Warren Vick, Europa Technologies Ltd." wrote: > I think it's far more interesting to argue about pronunciation: Dell-Fi > vs. Dell-Fee. You say tomato... ;-) > Just don't go too far astray... after all, this is MapInfo-related forum not a Del-Fee, Fie, Fo, Fum list! And BTW, it's tah-MAY-toe... -- - Bill Thoen GISnet, 1401 Walnut St., Suite C, Boulder, CO 80302 tel: 303-786-9961, fax: 303-443-4856 mailto:[EMAIL PROTECTED], http://www.ctmap.com/gisnet ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Thematic maps
Hello All, I'm trying to make a thematic map with two thematic sheme. 1- I would like to use color to represent the increase of the population between two census year. and 2- I would like to use what mapinfo call transparent rotated lines for my statistic area (urban core, urban fridge, urban area outside) but my problem is that these line are not transparent. I see the increase of population or the statistic area, but I can't make the line transparent to see both together. Is there somebody who will know how to make these lines transparent ? Thanks Anne Boucher ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L query problem
Hello, This hopefully will be a very minor problem compared to most that I have read here on the list. I am trying to run a query on my street table to find all segments under the length of 25 feet. The condition that I am using is: ObjectLen(obj, "ft") < 25 which returns the reply of: 1. could not fetch object from the current row, argument ObjectLen. What does this mean and how do I fix the problem? Any help is appreciated. Jackie ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L I see one point
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Obvously something is badly wrong here. Do you have any idea what can be wrong? I have committed the sin of believing the manual bears any relation to the software. I have data in longitude / latitude (it's locations of paratransit vehicles at about 9AM). I extracted it in the form of an Excel file, and then imported it into Mapinfo 5.5 in accord with the instructions on page 118 of the User's Guide (chapter 8: Putting your data on a map > Creating points from an Excel or Lotus table). I did check to ensure the columns are numeric (they say "floating"). I saved as a new file name [July_5_9Am_v_loc_lat_long.TAB] , mappable. The projection is longitude / latitude. I imported with a multiplier of 1. My problem: Although I have 219 points, when I use "New map window" to look at the browser file as a map, I see only one point. I can zoom in until the scale in 1 inch = 0.1 mile, or out until the scale is 1 inch = 5 miles, and it's still only one point. In the original data, these locations are spread out over about half a degree in both latitude and longitude, and I expect that if creating points has gone correctly, I will see several points. I attach a look at the browser window. <> Ian Straus ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Grid Handler and Millenium.
I have just discovered after having been stumped for a while that Grid Engine code based migrid.dll functions are inoperative under Millenium. The essential GE_OpenGrid function will return a grid handle of Zero, which means no good. Even MBX applications compiled with MI 6.0 are dead wood under Millenium. It seems that no compatibility check has ever been carried out by MI between their products and Millenium. I hope to no one to experience that feeling of sheer frustration, but I am pretty sure that some among you (as few as possible I hope) have had such an experience and would share it, at least with me. Jacques Paris [EMAIL PROTECTED] MapInfo Support: http://www.paris-pc-gis.com ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L ODBC & MB
Hi all Could someone please help me out with some code for opening an Access = database & extracting a dbf table. I have tried the MapBasic window while = performing the ODBC connection in MI but the code that is placed in it = doesn't seem to work when used in a MB priogram. I want to open an Access database (called TJSDATA) and extract a DBF file = (called STAND). The Stand.dbf will normally have about 10 fields in it but = I only want to have 3 fields in mine (eg FIELD1, FIELD2,FIELD3). At the end of the code I want to be able to save the changes I have made = to the STAND.DBF back into the Access database and then close the ODBC = link. I have all the in between code working but can't get the initial = code to open & close via ODBC. Would really appreciate some help here. = Have search the list database for sample code but haven't located any that = would work for me. I am running MI & MB 6.5 The DSN would already exist. In my case it would be called BP-primary.dsn Hope somebody can spare the time to help out with a piece of sample code regards Terry ++ WARNING: This email and any attachments may be confidential and/or privileged. They are intended for the addressee only and are not to be read, used, copied or disseminated by anyone receiving them in error. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. The views expressed in this email are those of the sender and do not necessarily reflect the official views of Landcare Research. Landcare Research http://www.landcare.cri.nz ++ ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L SDTS2DEM Fixed!!
Just to let everyone who was thrown for a loop with the new SDTS format not working with the old Sol Katz translator, it has been fixed! You can get the new translator at http://www.cs.arizona.edu/topovista/sdts2dem.html It puts the SDTS files back into Native format. It doesn't "chop" the files like the old translator, but you can still chop them with the chop routine if you need to. Just thought everyone might like to know. I'm sure the USGS won't be too happy to hear this and they'll probably change the format again just to thwart us, but for now we can get the data in something useable. Not being a C programmer I have been struggling with trying to correct this code for the last two weeks, but Gregg Townsend beat me to the punch, thank God. I might never have figured it out. Take it easy. Cameron ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
RE: MI-L ODBC & MB
Hi Terry, I've had success with the MB window method. It requires a little trick and will reveal whats behind the variables that occurs with the normal method. You open an ODBC table and uncheck the boxes in the save dialog (don't link the table - register it instead). Then your MB window shows all the information for your program. You'll just have to extract it and put it into : Server Link Table SQLQuery Using ConnectionString Toolkit Toolkitname Into TableName [ File FileSpec] [ ReadOnly ] Try it out! Venlig hilsen Søren Breddam Teknisk Forvaltning Stevns Kommune Tlf. 5656 1891 > -Original Message- > From: Terry Savage [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 14, 2001 12:56 AM > To: [EMAIL PROTECTED] > Subject: MI-L ODBC & MB > > > > Hi all > Could someone please help me out with some code for opening > an Access = > database & extracting a dbf table. I have tried the MapBasic > window while = > performing the ODBC connection in MI but the code that is > placed in it = > doesn't seem to work when used in a MB priogram. > I want to open an Access database (called TJSDATA) and > extract a DBF file = > (called STAND). The Stand.dbf will normally have about 10 > fields in it but = > I only want to have 3 fields in mine (eg FIELD1, FIELD2,FIELD3). > At the end of the code I want to be able to save the changes > I have made = > to the STAND.DBF back into the Access database and then close > the ODBC = > link. I have all the in between code working but can't get > the initial = > code to open & close via ODBC. Would really appreciate some > help here. = > Have search the list database for sample code but haven't > located any that = > would work for me. I am running MI & MB 6.5 > > The DSN would already exist. In my case it would be called > BP-primary.dsn > > Hope somebody can spare the time to help out with a piece of > sample code > > regards > Terry > > ++ > > WARNING: This email and any attachments may be confidential > and/or privileged. > They are intended for the addressee only and are not to be > read, used, copied > or disseminated by anyone receiving them in error. If you > are not the intended > recipient, please notify the sender by return email and > delete this message > and any attachments. > > The views expressed in this email are those of the sender and > do not necessarily > reflect the official views of Landcare Research. > > Landcare Research > http://www.landcare.cri.nz > ++ > > > > > > __ > _ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
MI-L Placing rasterfiles
When specifying where to place a raster-image in a coordinate-system, I = have to specify the relation between coordinates and pixel-coordinates. Do I specify the coordinate of the center of the pixel? Or of the corner = of the pixel? (if so which corner?) Any help appreciated. /Morten Nielsen ___ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
