MI-L The Fool's World Map
I know it's not quite Friday, but if you need relief now, check this out: The Fool's World Map http://www.zen-style.com/ This is a map of the world as seen through many people's geographic misconceptions. (The graphics aren't bad, either.) - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11742
MI-L State, Regional or National Elevation Maps or Data
Hello, I'm looking for a base map of Washington state that shows the general topography of the state in a shaded relief format. I'd prefer a .tif or geotif, so I don't have to do a lot of processing just to get it to look right, but any advice will be appreciated. I need a base map to overlay some agricultural product and population data, but I'd like one that contributes to the overall aesthetic appeal of the product as well as puts the ag and pop info into the geographic context. Thanks, Tim Rood - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11743
RE: MI-L MI and Geosoft Grids
Hi, Oasis Montaj .GRD files are not the same format as the GRD files readable by Mapinfo... Mapinfo supports Vertical Mapper GRD files only. However all is not lost ... I havent used Oasis for a long while but i'm sure the viewer allows Grid copy/convert to GFX Text format, you should then be able to edit the text file into a 'standard ascii' format that some thing like Gridanalyser can convert to MIG for you ascii format looks like:: ncols (integer ie 100) nrows (integer ie 100) xllcorner (float coord ie 299475.) yllcorner (float coord ie 99375.) cellsize (float ie 50.) NODATA_value (number ie-) the gfx text form is more wordy (it includes the projection data (yippee)) and some of the terms are not as clear so i THINK you need to cull teh data classed as: points rows Xorig Yorig Row separation (gfx can support different cell dimensions but ascii doesnt.) dummy if you have teh GDB files to go with your grids then you can export these as XYZ and regrid within Mi, but i'm guessing you dont, I'm also pretty sure that the viewer also exported ECW and geotiff files so if you want just an image, that may be a pathway too.. I think a mapbasic guru needs to write an ascii import mbx for us...Hint hint Regards R Brit. Geol. Surv. www.bgs.ac.uk -Original Message- From: Hickman, Josh [mailto:[EMAIL PROTECTED] Sent: 12 May 2004 20:54 To: [EMAIL PROTECTED] Subject: MI-L MI and Geosoft Grids Hello all, I'm looking for a good (free) way to import Geosoft .grd's into MapInfo. Geosoft has a MI plug-in but you have to have MapImagery also (which I don't have). What I am trying to import are the USGS magnetics grids. These are published in .grd format. The grids load just fine into the free Oasis Montaj viewer. The problem is that MI dosn't seem to support any of the grid export options of this viewer. Yes it says that MI 7.0 supports .grd format in the open file dialog. The files are visiable but when an attempt to open this made then MI says that they are an unrecognized format. I imagine that some other MI users have imported this same data, so how did you do it? I'm sure everyone feels my pain. ;-) Josh C. Hickman Exploration Geoscientist CNX Gas LLC http://www.consolenergy.com PO Box 947 Bluefield VA 24605 Work: 276-988-1036 Fax: 276-988-1076 * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11733
MI-L digital camera with GPS - Mapinfo
I am looking for a solution in which pictures of patients are taken by a digital camera compatible with hand-held (or builtin) GPS, and these pictures together with patient-related information are linked to Mapinfo, so that by clicking symbols on Mapinfo, these pictures and information could be retrieved. It would be appreciated if you could suggest products of GPS, digital camera, and software. I do no care much about resolution of the photos, but prices do count. I would like to use a handheld GPS, Garmin II, if possible. Thank you. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11734
RE: MI-L MI and Geosoft Grids
Hello all, To display GeoSoft Grids in MI 7.0 you must do the following: 1. MapImagery provides a free plug-in for MI. Download this. 2. Download the free Geosoft plug-in for MI 3. Install the MapImagery plug-in. 4. Install the Geosoft plug-in (must be done in this order since the Geosoft plug-in requires MapImagery to run) 5. Open the geosoft grids. One thing that I am still figuring out is how to display the actual value of a cell in a geosoft grid in this manner. I can't use the normal MI or VM query tools to do this and the free versions of Geosoft or MapImagery don't seem to include these functions. 'WooHoo I can display a grid, now what do I do with it' is the syndrome I am facing. Happy Mapping to All! Josh C. Hickman Exploration Geoscientist CNX Gas LLC http://www.consolenergy.com PO Box 947 Bluefield VA 24605 Work: 276-988-1036 Fax: 276-988-1076 -Original Message- From: Marc Pelletier [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:11 PM To: Hickman, Josh Subject: Re: MI-L MI and Geosoft Grids At 01:54 PM 05/12/04, you wrote: I'm looking for a good (free) way to import Geosoft .grd's into MapInfo. Geosoft has a MI plug-in but you have to have MapImagery also (which I don't have). Josh, I just went through this myself. There are two ways to view geosoft grids in mapinfo. The first is to buy Discovery, which is a bit rich. The second is to use mapimagery, as you mentioned. I've never used either of these, but Geosoft is distributing MapImagery for free with their plugin on the newest install disk. So the mapimagery plugin must be available somewhere. Maybe if you get the latest free version of Oasismontaj (6.0 just came out a couple of days ago ) the mapimagery thingy will tag along. I haven't installed the new version yet, so I am just repeating what I've been told by Geosoft tech support. Good luck. Marc Pelletier Goldak Airborne Surveys - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11735
RE: MI-L MI and Geosoft Grids
Many thanks for that Josh, I didnt know about the Geosoft Plugin so a new world has opened up... but yes, it comes in a dumb format under MI- Mapimagery...so maybe its back to the ascii import fudging? r -Original Message- From: Hickman, Josh [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 14:19 To: [EMAIL PROTECTED] Directionsmag. Com (E-mail) Subject: RE: MI-L MI and Geosoft Grids Hello all, To display GeoSoft Grids in MI 7.0 you must do the following: 1. MapImagery provides a free plug-in for MI. Download this. 2. Download the free Geosoft plug-in for MI 3. Install the MapImagery plug-in. 4. Install the Geosoft plug-in (must be done in this order since the Geosoft plug-in requires MapImagery to run) 5. Open the geosoft grids. One thing that I am still figuring out is how to display the actual value of a cell in a geosoft grid in this manner. I can't use the normal MI or VM query tools to do this and the free versions of Geosoft or MapImagery don't seem to include these functions. 'WooHoo I can display a grid, now what do I do with it' is the syndrome I am facing. Happy Mapping to All! Josh C. Hickman Exploration Geoscientist CNX Gas LLC http://www.consolenergy.com PO Box 947 Bluefield VA 24605 Work: 276-988-1036 Fax: 276-988-1076 -Original Message- From: Marc Pelletier [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:11 PM To: Hickman, Josh Subject: Re: MI-L MI and Geosoft Grids At 01:54 PM 05/12/04, you wrote: I'm looking for a good (free) way to import Geosoft .grd's into MapInfo. Geosoft has a MI plug-in but you have to have MapImagery also (which I don't have). Josh, I just went through this myself. There are two ways to view geosoft grids in mapinfo. The first is to buy Discovery, which is a bit rich. The second is to use mapimagery, as you mentioned. I've never used either of these, but Geosoft is distributing MapImagery for free with their plugin on the newest install disk. So the mapimagery plugin must be available somewhere. Maybe if you get the latest free version of Oasismontaj (6.0 just came out a couple of days ago ) the mapimagery thingy will tag along. I haven't installed the new version yet, so I am just repeating what I've been told by Geosoft tech support. Good luck. Marc Pelletier Goldak Airborne Surveys - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11735 * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11736
Re: MI-L Select Highest Value only in Table - Multiple Records (with same ID)
Hello! Well, I have to express my sincere gratitude! This query worked for me: select * from table Order by ID, ValueA Desc Group By ID Into OrderedList I'm such disbelief that I keep randomly checking some of the records in the results that I might as well have picked the records out manually!! The second query where a First() function was used didn't seem to be recognized by MapInfo. Not being familiar with it, I don't know what the problem is. I am actually trying to solve this query through MapInfo table. But the valuable information offered to do something similar in Access will certainly come in handy in the future. This will definitely go on my Sticky Note Hall of Fame on my wall. Thank you all again, Susan Ian, Herein lies Susan's problem, as you suggest, it is rlatively easy to construct a query that will give you the maximum value of Value A for each ID, but it will not point to the record in that table that has that value to get the values in the rest of the fields. Susan asked what are the values for ValueB and ValueC for the record that has that maximum value of ValueA for each ID. Perhaps somehting like would in theory give the result: select * from table Order by ID, ValueA Desc Group By ID Into OrderedList Select ID, First(ValueA), First(ValueB), First(ValueC) from Orderlist Group By ID But I have witnessed some strange results in SQL queries lately that I would not like to trust this approach too much. I certainly would not trust the results of this unless you saved the first query off as a table first. r On Thu, 13 May 2004 17:01:23 +1200, SCISOFT [EMAIL PROTECTED] wrote: Susan / Robert If you're dealing only with attributes, as I think, the first thing to do would be to use some unique IDs rather than non-unique ones (add an extra column). But assuming you don't want to, it is very easy to construct an Access query to do what you want - SELECT Table1.nonUniqueID, Max(Table1.ValueA) AS MaxOfValueA FROM Table1 GROUP BY Table1.nonUniqueID; (I just used Access's designer for this) My result is - field headings nonUniqueID (ID), MaxOfValueA (ValueA) ID ValueA ABC 50 XYZ 40 Constructing it in MapInfo SQL is another matter! Something for you to do.. Ian Thomas GeoSciSoft - Perth, Australian -Original Message- From: Susan Yu [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 May 2004 8:18 AM To: [EMAIL PROTECTED] Subject: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records Hello everyone, I have a follow-up question since I'm doing something similar. I hope someone has a simple answer that I'm not seeing. What if I wanted to select the RECORD with the highest value from a certain column? I have multiple columns where they would all have a value with the same IDs. But not all the columns are consistantly the highest value. For example: ID ValueA ValueBValueC XYZ20 3040 XYZ30 1520 XYZ40 1110 ABC50 2017 ABC22 3010 I would like to select only the records where ValueA is the higest (regardless of the values in ValueB and ValueC) I would like this result: ID ValueA ValueBValueC XYZ40 1110 ABC50 2017 I'm worried that if I used group by ID, the query will return the ID, with the highest ValueA, but randomly pick the values for ValueB and ValueC. Is there a solution? I would be grateful for any help. Thanks, Susan -- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Date: 05-10-2004 13:37 Thanks Steve, that worked and thanks also to everyone else who came up = with solution, I'm very impressed with the quick responses. I'll be back = again when I hit that next wall! Brian -Original Message- From: Wallace, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:19 PM To: Cowper, Brian Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Select WellID, Easting, Northing, Max(DepthFrom), Max(DepthTo) From YourTableName Group by WellID, Easting, Northing Try that. -- Steve=20 -Original Message- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 04:16 PM To: MapInfo-L (E-mail) Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Thanks to all who have responded. The solutions I have so far show me how to make the data in column = DepthFrom descending or show overall statistics, but that's not what I need. To clarify - each Well has multiple rows, take for instance my example below, there are three rows of data for Well 0001, I want strip out the = 2 rows that contain lower elevations and be left with row that has the = highest DepthFrom value (250) and it is the same for all the other records, so = with Well 0002, I would be left
MI-L Oracle woes: 9i and MapBasic together ?
Hi all, Being an MS/SQL kinda guy, being thrust onto Oracle 9i is a really scary experience. It's not really a GUI based environment even nowadays. But the customer REALLY insisted so I've braced myself, and is currently doing some development on Oracle 9i (not Spatial) with MapBasic. I'm running both the Oracle server and the MapInfo/MapBasic development on a single W2K server machine. -- The problem is that whenever I use one of the (limited) GUI tools, Enterprise Manager Console or SQLPlus worksheet, MapBasic hangs indefinitely when trying to do a compile. Or at least it does until I close the afore mentioned tools ! I.e., I have to switch opening and closing the Oracle GUI tools when developing my MB app, an irritation I don't need to have added onto my normal development frustrations. Having MapBasic open all the time is possble, but it still hangs when trying to do a compile. Has anyone run into this kind of problem before ? And if so, is there some way to remedy this problem ?? I really hope there are some Oracle wiz's out there that can help. -- Ps! And just to add to my Oracle grievances: to have the Oracle server start normally, I have to disconnect the network cable. After it's started I can reconnect the cable and everything runs ok. Strange huh ? Pps! I'm seriously considering developing everything on MS/SQL, and port it to Oracle at the very last minute. But I guess I better not do that . ;-) Best regards / Med venlig hilsen Lars V. Nielsen Hvenegaard Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk
RE: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records
I do similar work and have found that exporting all the data into either a spreadsheet program or database program works easiest and fastest for me. Perhaps it will work for you too. Elizabeth Caponi -Original Message- From: Susan Yu [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 8:18 PM To: [EMAIL PROTECTED] Subject: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records Hello everyone, I have a follow-up question since I'm doing something similar. I hope someone has a simple answer that I'm not seeing. What if I wanted to select the RECORD with the highest value from a certain column? I have multiple columns where they would all have a value with the same IDs. But not all the columns are consistantly the highest value. For example: ID ValueA ValueBValueC XYZ20 3040 XYZ30 1520 XYZ40 1110 ABC50 2017 ABC22 3010 I would like to select only the records where ValueA is the higest (regardless of the values in ValueB and ValueC) I would like this result: ID ValueA ValueBValueC XYZ40 1110 ABC50 2017 I'm worried that if I used group by ID, the query will return the ID, with the highest ValueA, but randomly pick the values for ValueB and ValueC. Is there a solution? I would be grateful for any help. Thanks, Susan -- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Date: 05-10-2004 13:37 Thanks Steve, that worked and thanks also to everyone else who came up = with solution, I'm very impressed with the quick responses. I'll be back = again when I hit that next wall! Brian -Original Message- From: Wallace, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:19 PM To: Cowper, Brian Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Select WellID, Easting, Northing, Max(DepthFrom), Max(DepthTo) From YourTableName Group by WellID, Easting, Northing Try that. -- Steve=20 -Original Message- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 04:16 PM To: MapInfo-L (E-mail) Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Thanks to all who have responded. The solutions I have so far show me how to make the data in column = DepthFrom descending or show overall statistics, but that's not what I need. To clarify - each Well has multiple rows, take for instance my example below, there are three rows of data for Well 0001, I want strip out the = 2 rows that contain lower elevations and be left with row that has the = highest DepthFrom value (250) and it is the same for all the other records, so = with Well 0002, I would be left with row that has the 265 elevation, for Well 0003 an elevation of 239, etc. WellID Easting Northing DepthFrom Depthto 0001 5 40 250 240 0001 5 40 240 220 0001 5 40 220 210 0002 50050 400025 265 255 0002 50050 400025 255 230 0003 50070 45 239 228 0003 50070 45 228 213 etc... What I need to do is extract from this table the records with the = highest DepthFrom value. So I would end up with this table after running my = query: 0001 5 40 250 240 0002 50050 400025 265 255 0003 50070 45 239 228 TIA Brian -Original Message- From: Mcinnis, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 3:47 PM To: Cowper, Brian Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Something like this will work: Select Top 10 From Wells Order By Depthto desc -Original Message- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:26 PM To: MapInfo-L (E-mail) Subject: MI-L Select Highest Value only in Table - Multiple Records I have a table containing thousands of point locations which represent = Water Well Locations, the Well in the following format: WellID Easting Northing DepthFrom Depthto 0001 5 40 250 240 0001 5 40 240 220 0001 5 40 220 210 0002 50050 400025 265 255 0002 50050 400025 255 230 etc... What I need to do is extract from this table the records with the = highest DepthFrom value. So I would end up with this table after running my = query: 0001 5 40 250 240 0002 50050 400025 265 255 Is there any easy way to achieve this using SQL select or select, or do = I have to create a piece of code for this? I should add that I'm very = green with MI 7.0 and haven't looked into MapBasic at all. Regards, BChrisCo - List hosting provided by Directions Magazine | www.directionsmag.com | = To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11672 - List hosting provided by Directions Magazine |
Re: MI-L MI and Geosoft Grids
On Thu, 13 May 2004 09:18:44 -0400, Hickman, Josh [EMAIL PROTECTED] wrote: One thing that I am still figuring out is how to display the actual value of a cell in a geosoft grid in this manner. I can't use the normal MI or VM query tools to do this and the free versions of Geosoft or MapImagery don't seem to include these functions. 'WooHoo I can display a grid, now what do I do with it' is the syndrome I am facing. To query, calculate, analyze (and much more) a grid loaded into MapInfo one can use Grid Analyser. As long as a grid is readable by MapInfo, Grid Analyser reads it too, although it can write to MIG only (but grids can be converted to it). A fully working trial version (5 - 10 days?) can be downloaded from www.terris.sk. Jaromir Svasta - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11740
RE: MI-L Oracle woes: 9i and MapBasic together ?
Lars: I can't give you a definitive answer, but I may be able to open up some avenues of investigation for you. What version of MapInfo are you running? I've not had this problem with Oracle 8i and MapBasic 5 / MapInfo 6.5. Are you using SpatialWare, or is Oracle merely storing attribute data? Are you developing with Personal Oracle, or is this a version of Oracle running on a server somewhere? (if it's Personal Oracle, that may explain the network cable thing). If it's a server version, you might consider using the Oracle GUI tools from within a Remote Desktop session to the server. As you're probably aware, when MapBasic wants to compile something, it checks to see if MapInfo is running first. If MapInfo is open and hanging, MapBasic will also hang. You probably also know that Oracle's GUI tools are written in Java. I've had problems in the past with multiple Java Virtual Machines on the same computer. The .NET Framework is a competitor to JVMs although I've not experienced any problems with it and JVMs running together. Perhaps your Oracle tool is interfering with the communication between MapInfo and MapBasic, or if MapInfo is also open, preventing MapInfo from responding to messages. Hope this helps Spencer -Original Message- From: Lars V. Nielsen [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 9:42 AM To: MapInfo-L Subject: MI-L Oracle woes: 9i and MapBasic together ? Hi all, Being an MS/SQL kinda guy, being thrust onto Oracle 9i is a really scary experience. It's not really a GUI based environment even nowadays. But the customer REALLY insisted so I've braced myself, and is currently doing some development on Oracle 9i (not Spatial) with MapBasic. I'm running both the Oracle server and the MapInfo/MapBasic development on a single W2K server machine. -- The problem is that whenever I use one of the (limited) GUI tools, Enterprise Manager Console or SQLPlus worksheet, MapBasic hangs indefinitely when trying to do a compile. Or at least it does until I close the afore mentioned tools ! I.e., I have to switch opening and closing the Oracle GUI tools when developing my MB app, an irritation I don't need to have added onto my normal development frustrations. Having MapBasic open all the time is possble, but it still hangs when trying to do a compile. Has anyone run into this kind of problem before ? And if so, is there some way to remedy this problem ?? I really hope there are some Oracle wiz's out there that can help. -- Ps! And just to add to my Oracle grievances: to have the Oracle server start normally, I have to disconnect the network cable. After it's started I can reconnect the cable and everything runs ok. Strange huh ? Pps! I'm seriously considering developing everything on MS/SQL, and port it to Oracle at the very last minute. But I guess I better not do that . ;-) Best regards / Med venlig hilsen Lars V. Nielsen Hvenegaard Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11741
Re: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records
I have used this construction earlier: select ID, max(valueA), ValueB, ValueC from group by ValueA I have not seen it failing yet, but it isn't correct SQL and other SQL implementations (such as Access) doesn't allow it. Future MapInfo versions may also bark at this. Regards Uffe - Original Message - From: Susan Yu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 13, 2004 2:18 AM Subject: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records Hello everyone, I have a follow-up question since I'm doing something similar. I hope someone has a simple answer that I'm not seeing. What if I wanted to select the RECORD with the highest value from a certain column? I have multiple columns where they would all have a value with the same IDs. But not all the columns are consistantly the highest value. For example: ID ValueA ValueBValueC XYZ20 3040 XYZ30 1520 XYZ40 1110 ABC50 2017 ABC22 3010 I would like to select only the records where ValueA is the higest (regardless of the values in ValueB and ValueC) I would like this result: ID ValueA ValueBValueC XYZ40 1110 ABC50 2017 I'm worried that if I used group by ID, the query will return the ID, with the highest ValueA, but randomly pick the values for ValueB and ValueC. Is there a solution? I would be grateful for any help. Thanks, Susan - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11731
RE: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records
There is a recently-published (I assume) help file (.CHM) called MapInfo
SQL Language Reference that is a part of the helps for the MapExtreme.NET
trial/beta.
[The helpfile itself is only 62K plus a 68K index file, but to get it the
MapExtreme.NET download is over 35Mb and requires a further download of 23Mb
for the Microsoft dotNET framework (if you don't have it already
installed).]
I would assume that this is the SQL that will be used in future MapInfo Corp
products.
A note in the Summary page says -
The MapInfo SQL Language is based on the SQL-3 and SQL/MM standards. String
literals must be enclosed in single quotation marks ('example') while
identifiers (column names, table names, aliases, etc) should be enclosed in
double quotation marks (example identifier) if necessary. Identifiers only
need to be quoted if the parsing logic is unable to correcly parse the
identifier. This would include identifiers that have spaces in their names
or other special characters.
A table follows with operators. The first notable difference is the +
operator -
+ Addition operator; also concatenation operator. NOTE: MapBasic uses
Further down, we have -
Within: Equivalent to MapBasic's Entirely Within
Contains: Equivalent to MapBasic's Contains Entire
Intersects: Equivalent to MapBasic's Intersects, Partly Within, and Partly
Contains
CentroidWithin: Equivalent to MapBasic's Within
ContainsCentroid: Equivalent to MapBasic's Contains
I won't go further. Obviously, there are some differences but it's for the
better (standards used elsewhere).
Ian Thomas
GeoSciSoft - Perth, Australia
-Original Message-
From: Uffe Kousgaard [mailto:[EMAIL PROTECTED]
Sent: Thursday, 13 May 2004 2:02 PM
To: [EMAIL PROTECTED]
Subject: Re: MI-L [New Question] RE: MI-L Select Highest Value only in Table
- Multiple Records
I have used this construction earlier:
select ID, max(valueA), ValueB, ValueC
from
group by ValueA
I have not seen it failing yet, but it isn't correct SQL and other SQL
implementations (such as Access) doesn't allow it. Future MapInfo versions
may also bark at this.
Regards
Uffe
- Original Message -
From: Susan Yu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 2:18 AM
Subject: MI-L [New Question] RE: MI-L Select Highest Value only in Table -
Multiple Records
Hello everyone,
I have a follow-up question since I'm doing something similar. I hope
someone has a simple answer that I'm not seeing.
What if I wanted to select the RECORD with the highest value from a
certain column?
I have multiple columns where they would all have a value with the same
IDs. But not all the columns are consistantly the highest value.
For example:
ID ValueA ValueBValueC
XYZ20 3040
XYZ30 1520
XYZ40 1110
ABC50 2017
ABC22 3010
I would like to select only the records where ValueA is the higest
(regardless of the values in ValueB and ValueC)
I would like this result:
ID ValueA ValueBValueC
XYZ40 1110
ABC50 2017
I'm worried that if I used group by ID, the query will return the ID,
with the highest ValueA, but randomly pick the values for ValueB and
ValueC.
Is there a solution? I would be grateful for any help.
Thanks,
Susan
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11731
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11732
MI-L MapBasic Trick That's Not in the Book
Here's something about MapBasic that's not exactly documented, but you may find useful one day. If you create menu items that include the ID clause and call custom subroutines, you can also call those subroutines from a different mbx using the 'Run Menu Command ID...' statement. This is handy if you want to run more than one mbx simultaneously but allow them to interact as plugins or modular applications. However, be aware that if you have two or more subroutines with the same ID, then only the one first loaded will run. On the dark side, this sort of exposure could be construed as a breech in security, but the sword of technology always has two edges. - Bill Thoen - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11744
RE: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records
Read up on the MAX() function William Woody Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -Original Message- From: Elizabeth Caponi [mailto:[EMAIL PROTECTED] Sent: May 13, 2004 09:59 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records I do similar work and have found that exporting all the data into either a spreadsheet program or database program works easiest and fastest for me. Perhaps it will work for you too. Elizabeth Caponi -Original Message- From: Susan Yu [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 8:18 PM To: [EMAIL PROTECTED] Subject: MI-L [New Question] RE: MI-L Select Highest Value only in Table - Multiple Records Hello everyone, I have a follow-up question since I'm doing something similar. I hope someone has a simple answer that I'm not seeing. What if I wanted to select the RECORD with the highest value from a certain column? I have multiple columns where they would all have a value with the same IDs. But not all the columns are consistantly the highest value. For example: ID ValueA ValueBValueC XYZ20 3040 XYZ30 1520 XYZ40 1110 ABC50 2017 ABC22 3010 I would like to select only the records where ValueA is the higest (regardless of the values in ValueB and ValueC) I would like this result: ID ValueA ValueBValueC XYZ40 1110 ABC50 2017 I'm worried that if I used group by ID, the query will return the ID, with the highest ValueA, but randomly pick the values for ValueB and ValueC. Is there a solution? I would be grateful for any help. Thanks, Susan -- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Date: 05-10-2004 13:37 Thanks Steve, that worked and thanks also to everyone else who came up = with solution, I'm very impressed with the quick responses. I'll be back = again when I hit that next wall! Brian -Original Message- From: Wallace, Steve [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:19 PM To: Cowper, Brian Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Select WellID, Easting, Northing, Max(DepthFrom), Max(DepthTo) From YourTableName Group by WellID, Easting, Northing Try that. -- Steve=20 -Original Message- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 04:16 PM To: MapInfo-L (E-mail) Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Thanks to all who have responded. The solutions I have so far show me how to make the data in column = DepthFrom descending or show overall statistics, but that's not what I need. To clarify - each Well has multiple rows, take for instance my example below, there are three rows of data for Well 0001, I want strip out the = 2 rows that contain lower elevations and be left with row that has the = highest DepthFrom value (250) and it is the same for all the other records, so = with Well 0002, I would be left with row that has the 265 elevation, for Well 0003 an elevation of 239, etc. WellID Easting Northing DepthFrom Depthto 0001 5 40 250 240 0001 5 40 240 220 0001 5 40 220 210 0002 50050 400025 265 255 0002 50050 400025 255 230 0003 50070 45 239 228 0003 50070 45 228 213 etc... What I need to do is extract from this table the records with the = highest DepthFrom value. So I would end up with this table after running my = query: 0001 5 40 250 240 0002 50050 400025 265 255 0003 50070 45 239 228 TIA Brian -Original Message- From: Mcinnis, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 3:47 PM To: Cowper, Brian Subject: RE: MI-L Select Highest Value only in Table - Multiple Records Something like this will work: Select Top 10 From Wells Order By Depthto desc -Original Message- From: Cowper, Brian [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:26 PM To: MapInfo-L (E-mail) Subject: MI-L Select Highest Value only in Table - Multiple Records I have a table containing thousands of point locations which represent = Water Well Locations, the Well in the following format: WellID Easting Northing DepthFrom Depthto 0001 5 40 250 240 0001 5 40 240 220 0001 5 40 220 210 0002 50050 400025 265 255 0002 50050 400025 255 230 etc... What I need to do is extract from this table the records with the = highest DepthFrom value. So I would end up with this table after running my = query: 0001 5 40 250 240 0002 50050 400025 265 255 Is there any easy way to achieve this using SQL select or select, or do = I have to create
MI-L Using MultiListBox
I am trying to use a multilistbox to show all open tables so I can select several of the tables to close. I am having trouble understanding how it will go through the open tables to see which ones are selected to then close them. Any help would be appreciated. Can anyone help? TIA John - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11746
MI-L Testing to ensure a string is numeric
Listers, Does anyone have a method using MapBasic to test whether a string is numeric? I have a dialog with an edittext box that needs a numeric input. Even if the solution is just a big hack that would be OK, since I am going to make a logical MB function along the lines of IsNumeric(123) = TRUE or something. Thanks, will sum. Tim Nuteson Target - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11747
RE: MI-L Testing to ensure a string is numeric
Below is a function that I wrote to get the North/South footage(123) out of a string with a format of: Fr SE corner 123N 654W. Function strpnsft(ByVal s1 As String) As integer Dim fr, n, s, a As Integer dim s2 as string s2=ucase$(s1) fr = InStr(1, s2, FR ) + 5 n = InStr(fr, s2, N) - 1 s = InStr(fr, s2, S) - 1 If n -1 Then n = n ElseIf s -1 Then n = s Else strpnsft = 0 Exit Function End If For a = n To fr Step -1 Do Case (Mid$(s2, a, 1)) Case 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, Case Else Exit For End Case Next strpnsft = Val(Mid$(s2, a + 1, n - a)) End Function -Original Message- From: Tim.Nuteson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 3:20 PM To: [EMAIL PROTECTED] Subject: MI-L Testing to ensure a string is numeric Listers, Does anyone have a method using MapBasic to test whether a string is numeric? I have a dialog with an edittext box that needs a numeric input. Even if the solution is just a big hack that would be OK, since I am going to make a logical MB function along the lines of IsNumeric(123) = TRUE or something. Thanks, will sum. Tim Nuteson Target - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11747 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11748
RE: MI-L Oracle woes: 9i and MapBasic together ?
Hi Lars/Spencer, Not sure if your problem is just confined to Mapbasic. I'm doing some development is C#.net and Oracle 8.1 and experienced similar problems with Oracle's tools - namely Oracle DBA Studio and SQLplus Worksheet. It will happen intermittently but the effect is the same - the Oracle tools just freeze! Only solution is the three finger solute, end task, restart your tools. You could always try third party Oracle DBA tools, I've recently downloaded TOAD, you can do just about everything in there that Oracle's native tools allow you to do. http://www.toadsoft.com/ The trial download is about 2MB. Have fun! Peter Zyczynski -Original Message- From: Lars V. Nielsen [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 May 2004 11:42 PM To: MapInfo-L Subject: MI-L Oracle woes: 9i and MapBasic together ? Hi all, Being an MS/SQL kinda guy, being thrust onto Oracle 9i is a really scary experience. It's not really a GUI based environment even nowadays. But the customer REALLY insisted so I've braced myself, and is currently doing some development on Oracle 9i (not Spatial) with MapBasic. I'm running both the Oracle server and the MapInfo/MapBasic development on a single W2K server machine. -- The problem is that whenever I use one of the (limited) GUI tools, Enterprise Manager Console or SQLPlus worksheet, MapBasic hangs indefinitely when trying to do a compile. Or at least it does until I close the afore mentioned tools ! I.e., I have to switch opening and closing the Oracle GUI tools when developing my MB app, an irritation I don't need to have added onto my normal development frustrations. Having MapBasic open all the time is possble, but it still hangs when trying to do a compile. Has anyone run into this kind of problem before ? And if so, is there some way to remedy this problem ?? I really hope there are some Oracle wiz's out there that can help. -- Ps! And just to add to my Oracle grievances: to have the Oracle server start normally, I have to disconnect the network cable. After it's started I can reconnect the cable and everything runs ok. Strange huh ? Pps! I'm seriously considering developing everything on MS/SQL, and port it to Oracle at the very last minute. But I guess I better not do that . ;-) Best regards / Med venlig hilsen Lars V. Nielsen Hvenegaard Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11749
RE: MI-L The Fool's World Map
friday here you backward people. :) that map seems about right to me. i like some of the maplogs: 011. Mongolia has vanished. 012. Mongolia has been replaced by Gandhara. 013. The right side of USA became New York. heh. i have no idea what the point is, but sometimes it's cool to just snicker at stuff that's strange for the sake of it. mmm, sake. i've seen the future, and i'm already constructing algorithm's to interface with my garmin which will realign NMEA coordinates based on where someone _thinks_ they are. -Original Message- From: B. Thoen [mailto:[EMAIL PROTECTED] Sent: Friday, 14 May 2004 1:00 AM To: MapInfo-L Subject: MI-L The Fool's World Map I know it's not quite Friday, but if you need relief now, check this out: The Fool's World Map http://www.zen-style.com/ This is a map of the world as seen through many people's geographic misconceptions. (The graphics aren't bad, either.) - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11742 - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11750
Re: MI-L The Fool's World Map
Ashley, Did you notice Australia, oops I mean Atlantis has sunk... ;) Cheers Ian Simmonds, Ashley (OPT) wrote: friday here you backward people. :) that map seems about right to me. i like some of the maplogs: 011. Mongolia has vanished. 012. Mongolia has been replaced by Gandhara. 013. The right side of USA became New York. heh. i have no idea what the point is, but sometimes it's cool to just snicker at stuff that's strange for the sake of it. mmm, sake. i've seen the future, and i'm already constructing algorithm's to interface with my garmin which will realign NMEA coordinates based on where someone _thinks_ they are. -Original Message- From: B. Thoen [mailto:[EMAIL PROTECTED] Sent: Friday, 14 May 2004 1:00 AM To: MapInfo-L Subject: MI-L The Fool's World Map I know it's not quite Friday, but if you need relief now, check this out: The Fool's World Map http://www.zen-style.com/ This is a map of the world as seen through many people's geographic misconceptions. (The graphics aren't bad, either.) ## Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11751
RE: MI-L The Fool's World Map
hey, the only reason i have to believe that the countries look the way they do is because that's how they're shown in atlas's and on tv weather reports. i can't confirm unequivocally what the shape of any place really is, so maybe it's all lies anywho, just some big-ass prank. i don't _feel_ like i'm upside-down. :) in the (paraphrased) werds of a friend abroad: i got on the plane, they shook it about some, then put some clouds and stuff in the way for about a day while they changed the scenery. then they let me off the plane and said 'welcome to Scotland'. -Original Message- From: Ian Tidy [mailto:[EMAIL PROTECTED] Sent: Friday, 14 May 2004 10:04 AM To: Simmonds, Ashley (OPT); MapInfo-L Subject: Re: MI-L The Fool's World Map Ashley, Did you notice Australia, oops I mean Atlantis has sunk... ;) Cheers Ian Simmonds, Ashley (OPT) wrote: friday here you backward people. :) that map seems about right to me. i like some of the maplogs: 011. Mongolia has vanished. 012. Mongolia has been replaced by Gandhara. 013. The right side of USA became New York. heh. i have no idea what the point is, but sometimes it's cool to just snicker at stuff that's strange for the sake of it. mmm, sake. i've seen the future, and i'm already constructing algorithm's to interface with my garmin which will realign NMEA coordinates based on where someone _thinks_ they are. -Original Message- From: B. Thoen [mailto:[EMAIL PROTECTED] Sent: Friday, 14 May 2004 1:00 AM To: MapInfo-L Subject: MI-L The Fool's World Map I know it's not quite Friday, but if you need relief now, check this out: The Fool's World Map http://www.zen-style.com/ This is a map of the world as seen through many people's geographic misconceptions. (The graphics aren't bad, either.) ## Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11752
Re: MI-L Testing to ensure a string is numeric
A quick one would be: Code... If IsNumeric(x) Then do something knowing that it is a number Else do something else because it isn't a number End If More Code... Function IsNumeric(ByVal sTestStr as String) As Logical If Str$(Val(STestStr)) = sTestStr Then IsNumeric = TRUE Else IsNumeric = FALSE End If End Function You can muck around with stripping spaces etc, and adding error handling r On Thu, 13 May 2004 17:19:48 -0500, Tim.Nuteson [EMAIL PROTECTED] wrote: Listers, Does anyone have a method using MapBasic to test whether a string is numeric? I have a dialog with an edittext box that needs a numeric input. Even if the solution is just a big hack that would be OK, since I am going to make a logical MB function along the lines of IsNumeric(123) = TRUE or something. Thanks, will sum. Tim Nuteson Target - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11747 -- Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA 153.549004 E 28.517344 S P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11753
MI-L Intersect function problem
Hi All, Currently I am trying to append a column Suburb to a Streets (line object) table. Have suburb table (polygon objects) which will return the suburb name. Normally this would be easy and I would run an SQL Query along the lines of: SELECT Street.StreetName, Suburb.SuburbName FROM Street, Suburb WHERE Street.Obj INTERSECTS Suburb.Obj The problem however, is where a street crosses a suburb boundary two street objects are returned with the same name but different suburb attributes. Ultimately where there are to objects for the same street, I want to only store the one that has a greater length lying in that particular suburb. Can anyone help. I want to incorporate this in to a MapBasic script. The code would have to be as efficient as possible as the streets table has 250 000 records in it. Samuel Shelley GIS OFFICER FIRE MANAGEMENT UNIT TASMANIA FIRE SERVICE GPO Box 1526 HOBART, Tasmania AUSTRALIA, 7001 (CNR ARGYLE AND MELVILLE STS, HOBART 7000) EMAIL: [EMAIL PROTECTED] PHONE: (03) 6230 8735 FAX: (03) 6230 6647 IF CALLING FROM OUTSIDE AUSTRALIA REPLACE 03 WITH 613
