RE: [MI-L] MI raster to Shape file

2005-12-19 Thread James M. Kelly
John I world file is simply a text file that contains some information about the coordinate values of the image, but no coordinate system information. I have not used ArcPad, but I would imagine that the world files are standard old ESRI format. There is a free mbx on the directions website that

[MI-L] MI raster to Shape file

2005-12-19 Thread John Elliot
I am running MapInfo 5.5 and have installed ArcPad 6.0.3 on a handheld. Is it possible to transfer a raster map from MapInfo to ArcPad. I understand that ArcPad needs both a World File and a Projection File (datum file) in order to be able to recognise raster images. The Projection Files come wi

RE: [MI-L] How to get the recs with the "highest" letter code.

2005-12-19 Thread robert
Terry, I am not sure if this technique will work, as I haven't tried it in MapInfo yet. I encounter a similar problem even in Access (selecting all the data from the record that has the maximum value of a particular field. In the past I do a select to identify the maximum value for the field I a

RE: [MI-L] RE: Migrate data : from Mapinfo to Autocad map.

2005-12-19 Thread Blair Rogers
HI To export out the map object data - you have to have ticked the flag - Preserve Attribute Data on the DXF Export Information. However depending on the fields that you have exported you may need to edit the DXF file as well. You have to ensure that no break returns are evident in any character

Re: [MI-L] How to get the recs with the "highest" letter code.

2005-12-19 Thread Lars V. Nielsen (GisPro)
Hi Terry, MIPro SQL is definitely a subset of the full SQL syntax, but it has it's strong points too. Normal SQL doesn't really allow for "intermidiate result sets", but MIPro's selection/queryNN model does just that (I know of the normal select-into but it's not quite the same). It allows o

RE: [MI-L] How to get the recs with the "highest" letter code.

2005-12-19 Thread Terry McDonnell
Uffe Thanks for the reply. I have to max( asc( rte_let)) otherwise I get a data type mismatch error. i.e. MAX() only works on numeric fields. I've resigned myself to the fact that I need more steps, but this isn't helped by the fact that SQL doesn't work on intermediate cursors - only on base

Re: [MI-L] How to get the recs with the "highest" letter code.

2005-12-19 Thread Uffe Kousgaard
Terry, I wouldn't be surprised if MI can't handle your SQL below and I don't really know, what to expect from the result. You have something like select max(.) "maxgen" group by maxgen. In normal SQL it would go like this: select field1, max(field2) group by field1 You also select fields, w

RE: [MI-L] How to get the recs with the "highest" letter code.

2005-12-19 Thread Terry McDonnell
Hi Lars Thanks for the further reply. Erm, there's nothing normal about the cut-down version of SQL in MB. I've been used to (and so spoilt by) the much richer version in VFP and MB's doesn't even come close. As such I've rarely used "group by" but I had a go, as below: Select Rte_No, MAX

RE: [MI-L] Need GPS Unit to produce Snail Trail that ccan be added to Existing MI Pro Street Layer

2005-12-19 Thread Doug Wassmer
Hi List: Thanks to everyone who provided me with a wealth of information on this project. Since I already have a Garmin GPS 12, a pentium laptop with WinXP, MapInfo v3,4,5,6 & 7, and all of the Blue Marble utilities that came with them, I am going to try the least expensive route first - which re

Re: Ang. [MI-L] custom projection

2005-12-19 Thread Michel Wurtz
Mats Elfström a écrit : > Hi Cathy! > > This has been asked before, and I do not think there is an easy way to do this. > I have a recent case and can compare the defining strings. > A shapefile I have in a swedish common projection has the following prj info (in one string, disregard e-mail w

Re: [MI-L] frequency distribution histograms

2005-12-19 Thread Ian Robertson
Hi Nick, >>> I guess a work around would be using SQL to create a new table of frequency counts within specified intervals, then use a "column" graph to plot the results - but the SQL to do that is well beyond me! The SQL to create binned data isn't too difficult. The following query creates a