RE: [MI-L] Generating points table

2006-08-31 Thread Llewellyn, David
Hi Sandra, Just to add to the good responses you have already. Depending on your version of MapInfo there is a tool call Coordinate Extractor (add tool using the tool manager) you can use. This tool will even create the columns for you and you can specify what coordinate system you

[MI-L] Hotlink Mouse-over icon

2006-08-08 Thread Llewellyn, David
Title: Hotlink Mouse-over icon Dear all, Does anyone know if it is possible to change the mouse-over icon (hand with a lightening bolt through it) that is used with the Hotlink tool in MapInfo (v8.0)? (The icon used with the tool is a normal hand icon, but when you move the mouse over an

RE: [MI-L] Counting points in buffers

2006-07-20 Thread Llewellyn, David
Lee, Say your buffers are in table buffers and your points are in table points, try the following query: Fields {buffers.ID, Count(*)} Tables {points, buffers} Where {points.Obj Within buffers.Obj} Group {buffers.ID} Order {} Into {Selection} Browse I havent filtered out the

RE: [MI-L] Selecting records with objects

2006-07-16 Thread Llewellyn, David
Nicholas, You can select those rows that have objects before you do any other processing and then just process those object rows. A selection such as: Select * From MyTable Where Obj Into ObjectRows Would work. You could even just select the lines: Select * From MyTable Where Str$(obj) =

RE: [MI-L] Changing the bounds clause

2006-07-04 Thread Llewellyn, David
John, You can also use the Coordsys Bounds Manager tool. I think this has been included in MapInfo since about V7.0. Go to Tools/Tools Manager to add it into your list of tools. Cheers David Llewellyn -Original

RE: [MI-L] Batch process of ecw to create tabs

2006-07-02 Thread Llewellyn, David
Title: Batch process of ecw to create tabs Chris, See Tabs from ecw on the Directions Mag site: http://www.directionsmag.com/files/index.php/view/586 Cheers David Llewellyn -Original Message- From: [EMAIL PROTECTED]

[MI-L] Selection being shown in map window

2006-06-20 Thread Llewellyn, David
Title: Selection being shown in map window Dear list, Has anyone else had the problem occur that an object selected in the map window does not show up in the selected object style? Zooming in or out will actually result in the object being shown selected, but it is annoying to have to do

[MI-L] Populating Dialog Controls

2006-05-30 Thread Llewellyn, David
Title: Populating Dialog Controls Dear all, Does anyone have some MapBasic code to populate a couple of MapBasic Dialog controls as follows?: - A PopUpMenu containing the names of open tables in Mapinfo, - A ListBox that will be updated with the column names of the table chosen in the

[MI-L] Text to Date

2006-04-30 Thread Llewellyn, David
Title: Text to Date Thanks to Terry, Simon and Jacques for their solutions on the Text to Date question. I think my input data is pretty well consistent in format, so the functions should be ok for purpose. Certainly I will also have a look at your more general solution Jacques. Cheers all

RE: [MI-L] Determining how many polygons occupy the same area

2006-04-23 Thread Llewellyn, David
Alan, I had a project to do something like this and wrote a MapBasic program to do it (description below). I would be happy to forward you the source and or exe if you are interested. Note that the program could take quite a long time to run depending on the complexity of the table of

RE: [MI-L] sql select

2006-04-17 Thread Llewellyn, David
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-

RE: [MI-L] break polyline feature

2006-04-11 Thread Llewellyn, David
Hi Greg, Another approach might be to use Objects/Overlay Nodes rather than polyline split. Then you can add nodes to the polyline(s) at the required intersection points. This will mean that the original polyline remains as a single feature, but you will be able to snap to that

RE: [MI-L] MapInfo versus Oracle Area

2006-04-04 Thread Llewellyn, David
the discrepancy), I would be happy to do a comparison of results between the systems. Cheers David -Original Message- From: Robert Crossley [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 April 2006 2:19 PM To: Llewellyn, David Cc: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L

RE: [MI-L] more labels

2006-03-28 Thread Llewellyn, David
Mike, I haven't followed this through, but Chr$(13) in a label expression will give you a newline. Cheers David Llewellyn -Original Message- From: Mike Gibson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 March 2006 10:01 AM To: mapinfo-l@lists.directionsmag.com; [EMAIL PROTECTED]

RE: [MI-L] Overlap analysis - Oracle tables

2006-03-26 Thread Llewellyn, David
To: Llewellyn, David Cc: MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Overlap analysis - Oracle tables David, How big is the difference if you use the CartesianArea() function in MapInfo ? Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK

RE: [MI-L] [Spam] Tab file to connect to Oracle 10G database

2006-03-26 Thread Llewellyn, David
David, This one works ok: !table !version 500 !charset WindowsLatin1 Definition Table Type ODBC begin_metadata \IsReadOnly = FALSE \DATALINK = \DATALINK\Query = select * from GEOSPATIAL.COAST \DATALINK\ConnectionString = SRVR=GEOSERVE;UID=GEO_SERVICES \DATALINK\ToolKit = ORAINET \CACHE = ON

RE: [MI-L] Overlap analysis - Oracle tables

2006-03-23 Thread Llewellyn, David
PROTECTED] Sent: Thursday, 23 March 2006 8:00 PM To: Llewellyn, David Subject: RE: [MI-L] Overlap analysis - Oracle tables Hi David, Try without the querytype=WINDOW Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S

RE: [MI-L] CONTOUR QUERY

2006-03-22 Thread Llewellyn, David
Title: CONTOUR QUERY Hi Peter, Try putting in another column, type integer. If your contour values are decimals defined to one decimal place, then populate the integer column with decimal column * 10. Then use the integer column to do the filtering. DecCol IntCol 2.0 20 2.5 25

[MI-L] Overlap analysis - Oracle tables

2006-03-21 Thread Llewellyn, David
Title: Overlap analysis - Oracle tables Dear List, This may be slightly off-topic, if so perhaps someone could suggest a more appropriate forum. I have been using MapInfo EasyLoader facility to upload MapInfo tables to Oracle Spatial. The tables uploaded are Lat/Long GDA94 and when opened

RE: [MI-L] CONTOUR QUERY

2006-03-16 Thread Llewellyn, David
Title: CONTOUR QUERY Peter, One way that comes to mind would be to add an integer column to the table and populate it with an integer representation of the contour value (999.5 becomes 9,995 for instance). Then you could use the Mod oprator in SQL to sift them (Select Where

RE: [MI-L] To pin an object on an alfanumeric row without object

2006-03-06 Thread Llewellyn, David
Hi Sergi, One way to attach (or replace) an object in an existing row in a table is to open the MapBasic Window and type in: Dim tmp as object 'define an object variable Then in a map window select the object you want to attach to the row and type: Tmp = selection.object Open a browser for

RE: [MI-L] labels formatdate$()

2006-01-10 Thread Llewellyn, David
Mike, Not sure if this is what you want. But you could pass your dates (converted to strings first) to this function to test them before doing the labelling: Function IsDate(sDateText as string) as logical OnError goto Error_IsDate dim iDay as smallint iDay =

[MI-L] Opening .jp2 raster files in MapInfo

2006-01-08 Thread Llewellyn, David
Hello all, Has anyone had experience opening .jp2 raster files in MapInfo? The .jp2 files I have are accompanied by a .ers file which contains registration information. I tried opening the .ers files with MapImagery but get the following error message: Problem generating algorithm: ERS Raster

[MI-L] Opening registered ECW files in MapInfo

2005-11-21 Thread Llewellyn, David
Title: Opening registered ECW files in MapInfo Dear listers, I have some imagery in .ecw format with accompanying .alg and .ers files. I know that these can be opened, registered, in MapInfo using MapImagery, but does anyone know if they can be opened, registered in MapInfo by some other

[Mapinfo-l] Programmatic MapInfo TAB to Shapefile translation

2005-11-13 Thread Llewellyn, David
Title: Programmatic MapInfo TAB to Shapefile translation Hi all, Does anyone know of a way to run a MapInfo TAB to Shapefile translation via MapBasic? Or is there a command line way to invoke the Universal Tanslator? This would save a fair bit of manual work using the Universal

MI-L MapInfo crashes opening raster table

2005-10-24 Thread Llewellyn, David
Thanks to all those who responded to my problem with MapInfo (V8.0) crashing opening raster tables. Indeed the problem lay with the interaction between MapImagery and MapInfo. Uninstalling mi6701 and installing mi6604 fixed the problem. Best regards, David Llewellyn Geospatial Specialist

MI-L MapInfo crashes opening workspace containing raster table

2005-10-23 Thread Llewellyn, David
Dear List, When I try to open a workspace which includes a raster layer, MapInfo crashes (using V8.0 Build 21). Has anyone else experienced this problem? Any causes identifed? Best regards, David Llewellyn Geospatial Specialist Regional Team (West) NNTT Principal Registry, Perth Phone: 08