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
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:
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
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
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
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
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
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
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
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.
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
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
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
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
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
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,
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
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
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
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
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
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*
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
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
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
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]
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
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
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
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!
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
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
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
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
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
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
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
37 matches
Mail list logo