Re: MI-L SQL Query

2004-01-15 Thread Norman Mabunda
I have a table that I wanted to do a similiar thing to what Andrew Tracey wanted to do. Please see the attachment to see what I did: Select Columns: Province, Type, Count(Sub_Type) 5 From Tables:National_Health_Facility_List_ Where Condition: Group By Columns: Sub_Type

RE: MI-L SQL Query

2004-01-15 Thread Peter Horsbøll Møller
The Count(*) aggregation is bound to the Group By section of the query: Ex 1: Select Columns: Province, Type, Sub_Type, Count(*) COUNT From Tables: National_Health_Facility_List_ Group By Columns: Province, Type, Sub_Type Order By Columns: into Table Named:

RE: MI-L SQL Query

2004-01-15 Thread Norman Mabunda
Thanx Peter Another question: Is't possible 1000 records count to see only a certail number of records. For instance, of the 100 records count, to see the 1st 20 records, or to see only 20 records of the 100 records. If yes, how? Regards, Peter Horsbøll Møller [EMAIL PROTECTED] 01/15/04

Re: MI-L SQL Query

2004-01-15 Thread Uffe Kousgaard
To do that, you will have to add a field called ID, update it to contain rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL: where rowid=20 or where rowid=20 and rowid=100 If you want to see only the top 20 records in the output (i.e. after the group by), then the answer is

RE: MI-L SQL Query

2004-01-15 Thread Peter Horsbøll Møller
I think you are looking for TOP10, TOP20 or TOP100 function. This feature is not supported directly in MapInfo, but you can get there if you do like this: Start by doing your normal group query (note the special Order By section) Select Columns: Province, Type, Sub_Type, Count(*) COUNT

Re: MI-L SQL Query

2004-01-15 Thread Norman Mabunda
Very much answered. Thanks a mil. Uffe Kousgaard [EMAIL PROTECTED] 01/15/04 09:59AM To do that, you will have to add a field called ID, update it to contain rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL: where rowid=20 or where rowid=20 and rowid=100 If you want to see

RE: MI-L SQL Query

2004-01-15 Thread Norman Mabunda
Yes, thank you. Peter Horsbøll Møller [EMAIL PROTECTED] 01/15/04 10:01AM I think you are looking for TOP10, TOP20 or TOP100 function. This feature is not supported directly in MapInfo, but you can get there if you do like this: Start by doing your normal group query (note the special Order By

RE: MI-L Altering Map Window Preferences using MapBasic

2004-01-15 Thread Peter Horsbøll Møller
Hi Davis, A happe New Year to you, too. The answer is: No ! You cannot access the preferences from within MapBasic. These settings are all saved in the MapInfow.prf file, so if you want to change this value you'll have to decode this file, and that's not easy... Peter Horsbøll Møller GIS

MI-L Ang. RE: MI-L Altering Map Window Preferences using MapBasic

2004-01-15 Thread Mats Elfström
Hear, hear! Anybody who would care to decode mapinfow.prf, and provide an external interface to edit it, would render the MapInfo User community a great service. Why? Because MapInfo Pro Viewer uses this file as well, but cannot change it. MapInfo Corp has discontinued the localized versions

MI-L Cookie cutter tool

2004-01-15 Thread King David
Dear List, Can anyone tell me where I might be able to get hold of a cookie cutter tool which will allow me to define an area to be deleted in an editable polygon object. I'm looking for one that I can use in MapInfo 5.5. I'm hoping that there will be one out there that I do not have pay for.

MI-L Ang. MI-L Cookie cutter tool

2004-01-15 Thread Mats Elfström
Hi David! I would have thought that this is dealt with by the standard object editing tools? Split, Erase, Erase Outside I have in v7.5 for this sort of thing. But memory may serve me wrong. v5.5 was a long time ago and I don't remember if these are a later invention. Hälsning/ Best regards

RE: MI-L Altering Map Window Preferences using MapBasic

2004-01-15 Thread paul.crisp
To handle the specific raster layer problem - I believe it is MapInfo trying to be helpful and making a guess on suitable zoom settings based on image size and DPI - try this - If you add the rasterlayers in your own code then use Set MAp Window n Layer x zoom as soon as you add them - set

MI-L Converting UTM into lat and longs

2004-01-15 Thread Neil Evans
What is probably a very simple question. How do I convert UTM coordinates into lat and longs. Thanks in advance to anyone who can point me in the right direction. Cheers Neil

RE: MI-L Ang. MI-L Cookie cutter tool

2004-01-15 Thread Darrin Clement
Try the Send To MapX Mobile utility that comes with MapInfo (at least v 7 and later, maybe earlier as well). You may also want to learn the MapX Geoset utility, depending on how you end up saving the resulting workspace. Darrin -Original Message- From: Mats Elfström [mailto:[EMAIL

RE: MI-L Converting UTM into lat and longs

2004-01-15 Thread Landmark Geographic Solutions
Hey Neil, If you currently have them in MI, I would change the map window projection to lat/long then use the centroid command to update a lat long column in your database. mapbasic window update yourfile set lat = centroidx(obj) update yourfile set lat = centroidy(obj) LGS -Original

MI-L Recall: MI-L Cookie cutter tool

2004-01-15 Thread Pederson, Cheryl [neuro]
Pederson, Cheryl [neuro] would like to recall the message, MI-L Cookie cutter tool. - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

MI-L Ang. RE: Ang. RE: MI-L Altering Map Window Preferences using MapBasic

2004-01-15 Thread Mats Elfström
Hi Peter! You are awesome! The wild goose chase paid off! It actually worked, much to my astonishment. I have tried something similar before to trick ProViewer into doing stuff, but without success. It seems as the line Create Menu... is important, even if no menu is created. Because if I use

MI-L RE: Ang. RE: Ang. RE: MI-L Altering Map Window Preferences using MapBasic

2004-01-15 Thread Peter Horsbøll Møller
And do remember that the new menu must be named after me, PetersSecrets. If not it wont work ;-) The tricky part is that you cannot use the Run Menu Command on menus that haven't been created. They don't have to be shown, as long as you have created them, you are up and rolling. Peter

Re: MI-L Importing from Excel

2004-01-15 Thread P. Srinivasan
This has been a quirk or a thorn in the user friendliness of MapInfo since version 3.0. Instead of specifying in the MapInfo's Excel Information dialog [ ] Use Row Above Selected Range for Column Titles the dialog box should have asked [ ] First Row Contains Column Headings like MS Access

MI-L Speeding up a MapBasic tool

2004-01-15 Thread Driver, Greg 9434
I've written a simple UK placename search tool which basically reads the user input and does a search on a MapInfo table (25618 rows) using and an SQL select statement to find an exact match. This bit works fine. The speed issue arises when an exact match isn't found. I wanted to do some sort

Re: MI-L Speeding up a MapBasic tool

2004-01-15 Thread Uffe Kousgaard
Hi, You should try to run your routine without doing the actual LD computation. Then you have a good guess, if a Delphi-DLL version would make much of a difference. I guess it would, but looping through the table could also be a significant part. Kind regards Uffe Kousgaard www.routeware.dk

MI-L VBasic-MapInfo Save Problem

2004-01-15 Thread Mehmet ALKAN
Hello, I connect via VisualBasic(VB) for MapInfo(MI). I wrote code (under below). Dim mi As Object Private Sub Command1_Click() Set mi = CreateObject(MapInfo.application) mi.Do Open Table D:\dene1\1\c1 Interactive Map From c1 mi.Do Create Menu MapperShortcut ID 17 as (- mi.Do select*

Re: MI-L Rhetorical Question about DPI on a Vector File

2004-01-15 Thread P. Srinivasan
You are correct. WMF is a vector format. In fact the scale information is stored in the WMF header records as 'number of vector units' per inch. This scale is used later in the conversion of pen width (which is specified in vector units) to points. I don't remember the details very well (I

RE: MI-L Speeding up a MapBasic tool

2004-01-15 Thread paul.crisp
Greg My experience has been that string searching of MI Tables is very slow, even when indexed - if you have the option of putting the function into a DLL and using a search on Access then you will see a dramatic improvement in performance. HTH Paul Crisp Syntegra Innovation Place Delta Bank

MI-L Layer # of most recently added layer

2004-01-15 Thread Berk Charlton
What is the easiest way in MapBasic of determining the layer number of the most recently added layer in a map window? I've been doing it by looping through all the layers, and matching the loop control variable with the layer name I'm interested in. I'm pretty sure there must be an easier way

RE: MI-L Speeding up a MapBasic tool

2004-01-15 Thread Jacques Paris
If looking through the table is a cause of slow speed, could storing the strings in a MB array improve the search/comparison operations? Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com -Original Message- From: [EMAIL PROTECTED]

MI-L Erdas image files

2004-01-15 Thread Martin . A . Spiers
One of our clients has given us some Erdas image files *.img with accompanying *.rrd files. The accompanying text file describes these as: Raster files: Satellite: Landsat ETM+, pan-sharpened Bands: 1,2,3,4,5,7 Format - ERDAS Imagine Projection - UTM, WGS84, Zone 35 Pixel size: 15m. Can these

MI-L Mauritius Projection

2004-01-15 Thread Ian Sotheran
Dear All, I have a problem regarding editing the mapinfo.prj file. I am required to produce some maps of Mauritius using the local grid projection. The parameters are: Projection: Lambert Conical Orthomorphic Spheroid: Clarke 1880 Units: Meters Origin: 57.52183E, 20.19507S FE: 10 FN: 10

MI-L Mauritius Projection

2004-01-15 Thread Ian Sotheran
Dear All, Correction to previous mailing, the False Easting Northing should read 1,000,000 -- I have a problem regarding editing the mapinfo.prj file. I am required to produce some maps of Mauritius using the local

MI-L Snap/This

2004-01-15 Thread namitao
Hi I am trying to use the snap\thin tool on Street. I am not sure how do I decide the tolerance values. I played around with some values and I got different results. IS there a way I can decide on a tolerance value Thanks Namita = __ Do you Yahoo!? Yahoo!

MI-L IMPORT PDF MAPS

2004-01-15 Thread Grinshpun, Petr
Hello, Is here some way except digitizing to import a map in PDF format into MI? Thank you. Petr Grinshpun Senior Analyst LDS, Inc. Fairfax, VA 703-259-5247

RE: MI-L Poly size increase

2004-01-15 Thread Bagwell, Ross
Bob, The application that Sarah asked about would be very applicable in situations such as disaster planning (spill sites, contamination areas, etc) and telecommunications (uniform gain in the strength of a tower signal or broadcast area), just to think of a few. -Ross E. Bagwell GIS Manager

Re: MI-L IMPORT PDF MAPS

2004-01-15 Thread Ted Florence
Actually, yes. If you have Adobe Illustrator and MAPublisher or FreeHand and MAPublisher, you can convert the pdf directly to mid/mif and then straight into MAPinfo. This assumes that the PDF is a vector pdf and not a raster one. But yes, it can be done. Grinshpun, Petr wrote: Hello, Is here

RE: MI-L Snap/This

2004-01-15 Thread Ryan Morgan, Aerials Express
Yes, in OptionsPreferencesMap Window you can set the snap tolerance. MI defaults to 5 pixels. Hope this helps! Ryan Morgan Aerials Express www.AerialsExpress.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 11:52 AM To: '[EMAIL

MI-L MapInfo invites you to .NET SDK BETA

2004-01-15 Thread Moshe_Binyamin
Valued MapInfo-L Members, MapInfo announces the immediate public availability of .NET SDK BETA of our Windows Mapping Technology. You are invited to download and preview our .NET BETA Software Development Kit (SDK) from the following site: http://www.mapinfo.com/dotnet The download includes a

MI-L ADA Compliance of the HTML Image Map

2004-01-15 Thread ALICIA HENDERLITER
I work at the Department of Human Services, and just got back from an internet/intranet meeting where the main focus (for about an hour of it) was the ADA Compliance of anything that goes out on our Internal or External Web-pages. Before I even TRY and work on a map for the Intra-net, I was

RE: MI-L Poly size increase

2004-01-15 Thread bob
Hi Ross I appreciate your answer and hope that my over simplistic approach can be of some value to Sarah. I am a techie by nature and perhaps sometimes over complicate things. Your suggested applications surely would have some constraints though? Wind and slope would mean a more complex