RE: MI MB: Run Command Limitation

2000-09-21 Thread Warren Vick, Europa Technologies Ltd.

Hello Jacques,

Interestingly, your program stops at 309 on Pro v4.5, suggesting that the
limit was raised in latter versions. The limit has never caused me much of a
problem. Most tasks can be broken down or redesigned to accommodate the
restriction.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques Paris
> Sent: Thursday, September 21, 2000 4:18 PM
> To: Mike Taylor; 'Mapinfo List'
> Subject: RE: MI MB: Run Command Limitation
>
>
> I have written the most sophisticated program of all :
>
> dim a,b as string
> onerror goto crash
> a=""
> boucle:
> a=a+"A"
> b="print "+""""+a+""""
> print len(b)
> run command b
> goto boucle
> goto fin
> crash:
> print "error "+err()
> fin:
> end program
>
> and it gets stuck on a command at 508 characters (error 965,
> expression too
> complex). The run command accepts thus a string of 507characters.
> That would
> be 512 - 5 (let us assume that it is some code id).
>
> Aren't they other places in MI where the 512 character limit is imposed?
> Don't I remember something of the sort with the "where" clause of the SQL
> requester?
>
>
> Jacques PARIS
>
> e-mail[EMAIL PROTECTED]
> For MapInfo support, see the Paris PC Consult enr. site  at
> http://www.total.net/~rparis/gisproducts.htm
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mike Taylor
> Sent: September 21, 2000 1:04 AM
> To: 'Mapinfo List'
> Subject: RE: MI MB: Run Command Limitation
>
> Hi again
>
> Seems I spat the dummy at the wrong statement.
> I changed the string (from select to print) that I was sending to run
> command. eg,
> From:
> qs = "select ...  ... from table into anothertable"
> run command qs
> To:
> qs = "print ""select ...  ... from table into
> anothertable"""
> run command qs
>
> This worked fine, so I will change my question to why is this
> happening with
> select??
> The amount of characters seems to be variable as well depending on the
> expression?
> I've attached a program which will generate the problem on my machine.
>
>
> -Original Message-
> From: Mike Taylor [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 21 September 2000 15:20
> To: 'Mapinfo List'
> Subject: MI MB: Run Command Limitation
>
>
> Hi
>
> I seem to have run into a size limitation on the string you can
> pass to run
> command.  It works when I trim the string down to 421 characters and fails
> (badly, invalid page fault) when it is 422 characters.
> The command also fails when I put it into the mapbasic window of
> professional.
> Is there any workaround for this?
> Why is 422 the magic number?
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI MapInfo Certification / Exam

2000-08-15 Thread Warren Vick, Europa Technologies Ltd.

Hello Richard,

The MapInfo Professional Accreditation exam is a partner competency test and
I don't think it's available to end users. I don't know if it's UK specific.
To be honest, I found it a bit archaic anyway with ambiguous questions, a
slightly illogical scoring system and flexible exam time. The exam was said
to be put together based on the technical support query database.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, August 15, 2000 4:48 PM
> To: [EMAIL PROTECTED]
> Subject: RE: MI MapInfo Certification / Exam
>
>
>
> I'm beginning to wonder if its a UK-only program.  As MapInfo partners, we
> were informed directly of the program (from the UK Windsor office).
>
> Richard.
>
> -Original Message-
> From: Ken Archer [mailto:[EMAIL PROTECTED]]
> Sent: 15 August 2000 14:48
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: RE: MI MapInfo Certification / Exam
>
>
> Richard,
>
> I haven't seen anything on MI's Web site about this.  Where did you get
> info?
>
> Ken
>
>
> >From: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> >Subject: RE: MI MapInfo Certification / Exam
> >Date: Tue, 15 Aug 2000 09:51:47 +0100
> >
> >Dan,
> >
> >MapInfo have!  I took the MapInfo Pro 'Product Specialist' exam which is
> >part f the 'MapInfo Professional Technical Accreditation Programme'.
> >
> >Richard Burkmar
> >
> >-Original Message-
> >From: Dan Phillips [mailto:[EMAIL PROTECTED]]
> >Sent: 15 August 2000 03:24
> >To: [EMAIL PROTECTED]
> >Subject: MI MapInfo Certification / Exam
> >
> >
> >Has anyone come up with an exam that would test a person's knowledge of
> >MapInfo? It seems like I've seen this question before but don't recall
> >seeing any answers.
> >
> >TIA
> >
> >Dan Phillips
> >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >
>
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Setting label angles

2000-08-14 Thread Warren Vick, Europa Technologies Ltd.

Hello Bob,

I'm pretty sure that you can only set label rotation for specific labels,
not all in a layer. Try performing a loop which goes through every object in
your layer. This however, may not be practical for large table.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Rosen
> Sent: Monday, August 14, 2000 5:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: MI Setting label angles
>
>
> I'm trying to use MapInfo 4.1 (for a legacy application) to rotate
> labels.
>
> A previous set of statements in my application is to set the label
> orientation with:
>
>   set map layer ReplayTable Label Position Below (or
> Above/Left/Right)
>
> These are successful.
> I then try to rotate the labels with:
>
> set map layer ReplayTable Label Object LabelID Angle 45
> print "Setting angle of label " & LabelID
>
> the major difference from the previous statement being that if I try to
> set the Angle argument for all labels as with the Position argument, I
> get a pile of compiler errors (starting with "Incomplete or invalid
> label sub-clause").
> The "Setting angle" message appears when I run the application, so I
> know that the Set Map statement is being executed.  However, the labels
> never rotate.  Any idea why, or what I have to do to get them to
> actually rotate?
>
> Bob Rosen
> Meteor Communications
>
>
> P.S. Thank God that the next version of this application will be using
> the ActiveX interface!
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI LAYER_INFO_NAME and ObjectInfo

2000-08-14 Thread Warren Vick, Europa Technologies Ltd.

Hello Eric,

You need to use an "alias". Although you have assigned szLayerName a table
name, you cannot access .obj from it. The rule-of-thumb is that if you have
a variable containing a table name, you need to use an alias to get any
fields from that table. When an alias variable is encountered, it is
interpreted literally by MapBasic. The following should work:

Include "MapBasic.Def"

Dim szLayerName As String
dim ObjAlias as alias

szLayerName = LayerInfo(FrontWindow(), 1, LAYER_INFO_NAME)
ObjAlias = szLayerName+".obj"

Fetch First From szLayerName

Dim obj_type As Integer
obj_type = ObjectInfo(ObjAlias, OBJ_INFO_TYPE)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Eric Frost / HR and
> Associates, Inc.
> Sent: Monday, August 14, 2000 6:10 PM
> To: [EMAIL PROTECTED]
> Subject: MI LAYER_INFO_NAME and ObjectInfo
>
>
>
> What is wrong with this code:
>
> Include "MapBasic.Def"
>
> Dim szLayerName As String
> szLayerName = LayerInfo(FrontWindow(), 1, LAYER_INFO_NAME)
>
> Fetch First From szLayerName
>
> Dim obj_type As Integer
> obj_type = ObjectInfo(szLayerName.obj, OBJ_INFO_TYPE)
>
> I have tried all sorts of work-arounds like assigning the object to an
> object variable and Run Command but have not hit on the solution.
>
> Thanks in advance!
>
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI SUM - World Cities Database

2000-05-04 Thread Warren Vick, Europa Technologies Ltd.

Hello James,

Can I just append my company's world data offering onto your excellent sum:

Europa Technologies has a series of world data sets which includes the popular Global 
Insight 
product line. The entry level product in this family is Global Insight Lite - a 1:3m 
scale up-to-date 
political map combined with a places layer of over 19,500 places. Locations are 
generally 
categorised into capitals, major cities and cities/large towns. Lite is a "soft 
product" which is 
downloaded from the web. A login/password is assigned and is valid for one year during 
which 
customers can download free updates. Single user costs are GBP245 or USD415.

For heavier gazetteers, there is Global Insight and Global Insight Plus (>345,000 
places). Full 
details at http://www.europa-tech.com

I probably don't need to tell you this James but here are some general points for list 
members 
considering world gazetteers:

1) Strictly speaking, a gazetteer is simply a location look-up. It does not guarantee 
that, when 
visualised on a map, it will inter-match. e.g. Coastal places may be in the sea!

2) Many free gazetteers are not maintained but the world changes politically every 
year.  A 
vendors history and commitment to maintenance is important to ensure one does not buy 
a 
dead-end product.  Old Digital Chart of the World type gazetteers list Victoria 
instead of Harare - 
a change that happen a very long time ago!

3) Few gazetteers have a grading system to allow differentiation between "important" 
places and 
"less important". There is no unified population model for the world and combing 
straight 
statistics from national census agencies does not always gives an apples-to-apples 
comparison.

4) In addition to place name and location, a good gazetteer will also provide rich 
attribute 
information. Administrative area will help ambiguous place name searches and will 
importance 
classifications. e.g. Troy, USA will have many matches but Troy, New York, USA will 
only have 
one. Coding systems like FIPS and ISO for data processing may also be important.

Needless to say, Global Insight products address all of these issues!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Anyone Going to MapWorld 2000?

2000-04-21 Thread Warren Vick, Europa Technologies Ltd.

Hello Jeff,

I'll be there. As last year, I'm going to print some "I'm on MapInfo-L"
stickers which listers can attached to their conference badges. They will be
attached to the notice boards. Just take one and look out for others in our
exclusive gang!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of JEFF PEDDYCOART
> Sent: Friday, April 21, 2000 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: MI Anyone Going to MapWorld 2000?
>
>
> Listers - anyone going to MapWorld 2000 in San Antonio April 30 -
> May 3rd?  I am looking to meet other MI users in my line of work
> to discuss experiences, techniques, uses of MI, success and
> horror stories, possibilities of data-sharing, etc.  Drop me an
> e-mail & I can give you more of my background & possibly arrange
> a meeting during one of the days.  Thanks all!
>
> Jeff Peddycoart - State Of Illinois - Dep't. of Human Services
> [EMAIL PROTECTED]
>
>
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI World Time Zone Data!

2000-02-23 Thread Warren Vick, Europa Technologies Ltd.

Hello Stephen

> Does anybody know of a good source for Time Zone Boundary data for the
world,
> preferably cheap!! Any help is appreciated.

We have a data product family called Map Elements which has a world time
zone data set. The data is based on an up-to-date political world map at
1:1M scale. Attribute data includes offset from UTC, TZ letter code ("Zulu
time"), country name, FIPS code, ISO code, and a colour code which make it
easy to colour the data by odd, even and fractional TZ offset. At $845, it's
not cheap but is an attribute rich and well maintained data set. Further
information and a picture snapshot on our web site at
http://www.europa-tech.com

Let me know if you have any questions.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Algebra

2000-01-08 Thread Warren Vick, Europa Technologies Ltd.

As an additional to Ole's list, you can get base 10 (or indeed any base) log
of x from the natural log function using;

(log(x) / log(10))

Replace 10 with any base.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ole Gregor
> Sent: Saturday, January 08, 2000 5:56 PM
> To: 'Swayze, Natalie: #PNWT - PTNO'; Dyan Catamaran; [EMAIL PROTECTED]
> Subject: RE: MI Algebra
>
>
> You dont need to export and the functions is inside Mapinfo.
>
> The only problem is, that you need more knowledge about Mapbasic - one
> source is Jacques Paris, but it's would bee a great help if Mapinfo Corp.
> had included this information in the normal help and reference material.
>
> I have copyed a bit from the Mapbasic help file
>
> The syntax is;
>
> Exp(column) Returns the number  e  raised to a specified exponent
> sqr(column) for square root
> log(column) for natural log (ln in normal math)
> + Addition. Example: x = a + b
> - Subtraction or negation. Example: x = a - b
> * Multiplication. Example: x = a * b
> / Division. Example: x = a / b
> \ Integer division (remainder is dropped). For example, the
> expression: 10 \ 8 has a value of one.
> Mod   Remainder from integer division. For example, the
> expression: 10 Mod 8 has a value of two.
> ^ Exponentiation. For example, the expression: 2 ^ 3  has a
> value of eight.
>
>
> -Original Message-
> From: Swayze, Natalie: #PNWT - PTNO [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 08, 2000 6:41 PM
> To: Dyan Catamaran; [EMAIL PROTECTED]
> Subject: RE: MI Algebra
>
>
> Please forward any info to me as well!!
>
> Thanks in advance,
> Natalie Swayze
> Spectrum/ROS/IC/GC/CA
>  --
> From: Dyan Catamaran
> To: [EMAIL PROTECTED]
> Subject: MI Algebra
> Date: Friday, January 07, 2000 4:36PM
>
>
> Hi
>
> I would like to perform some mathematics algebra like Square root, use PI,
> Ln or log etc. It seems that MI doesn't have this capability.  Is
> there any
> suggestion to work with update column using mathematical operators without
> export the table out of MI?
>
> Thanks
>
> Dyan C. Catamaran
> Phero Tech Inc.
>  --
> 604-940-9944
> 604-940-9433
>
>  --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Buffers with problems...

1999-12-20 Thread Warren Vick, Europa Technologies Ltd.

Hello Ian,

If I understand your message correctly, the bug you describe is not related
to the accuracy issue of passing objects through the cosmetic layer but one
regarding MapInfo's inability to create large spherical buffers correctly.
This is has been a long standing bug in Pro - since I started to use v3.0
anyway. The problem is demonstrated by creating large buffers (typically
several hundred miles) around objects. Pro converts a single lat/lon (at the
centroid I'm told) and turns the buffer distance into a unit measurement of
latitude and longitude. The problem here is that a degree of longitude
changes width depending on latitude. The single sample point means that
buffers always appear elliptical (in the normal rectangular world
projections). I have also observed that the "spread" which should be seen as
a buffer approaches the poles does not occur. Changing projection does not
seem to have any effect as the buffer functions do not take coordinate
system into account (unless deciding between spherical and Cartesian
schemes). The errors induced can be quite staggering (I've seen ~20%),
especially if you create a large buffer around a latitude rich region (like
the country Chile).

If this is the problem you are experiencing, then as you say, it has been
reported and it has come up on the list a couple of times. The separation of
spherical and Cartesian buffers highlights the problem more-so since Pro's
implementation is not a spherical calculation at all - more a sort of
adaptive linear system. Personally, I think it's the most serious bug in the
product. I have not found any workaround apart from having to write my own
spherical buffer code. Extreme caution is needed in this area for safety or
commercially critical applications.

BTW, please take it easy on those attachments when posting to the list!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ian Erickson
> Sent: Friday, December 17, 1999 11:42 PM
> To: [EMAIL PROTECTED]
> Subject: MI Buffers with problems...
>
>
> Here's a challenge for those of you who are willing to accept:
>
> I know there has been extensive documentation of buffers created in the
> Cosmetic Layer being elliptical.  I understand that MapInfo is
> aware of the
> problem and is working to fix it.  The proposed work-around is to
> create the
> buffers in a MapInfo table that has a projection.  So if I was
> 'Joe User', I
> might find a point layer make the layer editable, select
> Objects->Buffer...
> and then create the buffers in the same layer as the points.  Once the
> buffers are created I would save the selected buffers as a new table, and
> all is good right?  Wrong!
>
> When 'Joe User' does this, (ie the Objects->Buffer... menu
> command) MapInfo
> executes the command:
>
>   Create Object As Buffer
>   From Selection
>   Into Table {sourcetable}
>   Width 200
>   Units "mi"
>   Resolution 50
>   Group By RowID
>
> Guess what, if your layer is somewhat dispersed over the earth,
> the objects
> on the edges are more and more deformed.  Meaning: they become elliptical.
> I've attached an .MBX, source code and the MapInfo table used to recreate
> the problem.  All this program does is compute the distance from
> the center
> of the circle, to the nodes on the edge of the circle.  In an ideal world,
> you would expect to see the 200 miles from the center of the
> circle to each
> of the points comprising the buffer.  For those of you out there who are
> experts in the field of projections, datums and spherical
> coordinates, help
> me out here.  I ran the same program on a version of 4.5 and the
> problem did
> not occur, however, 5.5 really messes things up.  I've got a
> work-around for
> myself, which is slower and more time consuming, but I suggest
> that this is
> a bug NOT a feature.
>
> Ian Erickson
> GIS Analyst
>  <>  <>  <>
> <>
> <>  <>  <>
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI Pro generated web maps with info pop-ups

1999-12-20 Thread Warren Vick, Europa Technologies Ltd.

Hello all,

Over the weekend I updated the Map Gallery on the Europa web site to reflect
new versions of our products. I added something that may be of interest to
the list. Each of the map gallery pages now has a map which includes pop-up
information. This is a bit like a floating info-tool window or a rich tool
tip. Hovering your mouse pointer over the black place dots reveals some
information about the location. It's pretty useful when MapInfo's anti label
collision method has prevented certain place names appearing - now you can
just point to reveal. I'm currently just displaying some attribute
information... there's no reason why the pop-up could not show contact
details, etc. Overall, I think it's a good example of intelligent map
interaction without the need for a map server. There are still a few
improvements to be made. The biggest problem is that modifications need to
be made to support Netscape - so, for now, try it with IE. An additional
problem is that pointing to a location on the far left brings up a largely
off-screen pop-up - I'll fix that one tomorrow.

You can look at any of over 200 maps which use this scheme at
http://www.europa-tech.com/gallery.htm

For the technically minded, the maps and HTML pages were generated by a
MapBasic program. The program has now been enhanced to generate a client
side image map (CSIM) which details calculated hot-spot circles for each
place dot on the map. The pop-ups are based on some JavaScript code called
overLIB (http://www.bosrup.com/web/overlib/).  There is of course no reason
why each of the hot-spots could not link to other web pages.

Let me know what you think about it, or if you experience any problems with
your IE browser.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI MapBasic : Distance point to line

1999-12-20 Thread Warren Vick, Europa Technologies Ltd.

Hello Véronique,

May I add to Bill's reply that a truly accurate implementation of
point-object distance is not very efficient to implement in MB as it
involves iteration through nodes. This is the reason why many utilities will
compromise accuracy by not calculating the true perpendicular distance.
Also, ensure that very long "straight" lines have a suitable number of
coincident nodes. This will reduce errors induced by the geometric straight
line vs. great circle path discrepancy.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Thoen
> Sent: Friday, December 17, 1999 6:57 PM
> To: V. VESTRI
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: MI MapBasic : Distance point to line
>
>
> The shortest distance between a point and a line is the length of
> a line originating at the point and intersecting the line
> perpendicularly (not necessaerily the midpoint). You also have to
> test the line's endpoints if a perpendicular intersection cannot
> be drawn from the point to a line segment.
>
> - Bill Thoen
>
>
> "V. VESTRI" wrote:
> >
> > Hello,
> >
> > Can you tell me how to calculate the minimum distance between one point
> > and few lines or polylines with MapBasic ?
> >
> > It's the last point of my developpement and i don't have idea how i can
> > do that.
> > My MapBasic application is simple :
> > - it create circle, using coordinates in a table
> > - user define the radius
> > - it select all line or polyline in the circle
> > - it calculate the minimum distance between the circle centroid and this
> > line or polyline
> >
> > I'm sorry for this very bad english ...
> >
> > Thanks a lot,
> >
> > Véronique VESTRI
> > Ingénieur S.I.G.
> > [EMAIL PROTECTED]
> >
> > ASCOPARG
> > Surveillance de la qualité de l'air
> > dans la région grenobloise
> > FRANCE
> >
> > --
> > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Help for MapInfo "Uncombine" ?

1999-12-20 Thread Warren Vick, Europa Technologies Ltd.

Hello Jon Petter,

On the surface of it, an uncombine function doesn't seem complicated, but
from experience I know there are several things that complicate the
solution.

MB provides an easy way of extracting the Nth polygon from a region using
the ExtractNodes() function. If the begin_node and end_node arguments are
both 1, you get the Nth whole polygon. So, this will give you a way of
extracting individual polygons, then using the area() function you can
perform your "threshold" test.

The difficult part comes with determining whether a polygon is an "include"
or "exclude". For example, a donut would be 2 polygons, 1 include and 1
exclude. However, not all 2 polygon regions are donuts - you can quite
easily have 2 disjoint includes. Also, you can nest inclusion and exclusion
zones to create more complex regions. Finally, the first polygon in a region
is not guaranteed to be an include. So, even with a simple donut, the hole
may be expressed as the first polygon.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jon Petter Nielsen
> Sent: Monday, December 20, 1999 3:01 PM
> To: '[EMAIL PROTECTED]'
> Subject: MI Help for MapInfo "Uncombine" ?
>
>
> Hi
> I am trying to develop a function to perform "uncombine" on
> multi-polygon regions. Then classify them based on area values ("Remove
> all smaller than ...")
> - Anyone programmed this in MapBasic ?
> - Am I able to perform this by looping the polygons using data from
> ObjectInfo ?
> - How, in general, to detect which polygons are islands and which are
> not ? Example : Donut region = 2 polygons.
>
> Jon Petter Nielsen
> InfoWiz AS, Oslo Norway,
> [EMAIL PROTECTED]
> +47 2296 1563
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Problem with data types

1999-11-26 Thread Warren Vick, Europa Technologies Ltd.

Hello Jacques,

The problem you have observed is due to these lines:

> dim a as string
> a=123.45678

You're asking MI/MB to perform an implicit cast and this seems to be the
cause of the decimal rounding. Replacing the assignment with a more
type-friendly form...

> a="123.45678"

... solves the problem.

I rarely rely on implicit type casting in any language these days as
something always comes back to bite you. [Fond memories of date<->string
conversions in MB].

Giorgio's original post is probably just due to rounding using the "print"
command, and as you have shown, the use of format$() to request a particular
number of decimal places solves that problem.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.comt

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Looking for European city points

1999-11-25 Thread Warren Vick, Europa Technologies Ltd.

Hello John,

No place size indicators at all in DCW and VMap0 (unless you count the fact
that larger places are spelt in capitals). The other problem with DCW data
is that there are no accented characters which is quite a problem for
Europe.

We have a European gazetteer in our Map Elements product family with over
73,000 graded places - cost $845. This is just a point gazetteer - if you
need reference mapping instead, take a look at the Global Insight products.
Full details at http://www.europa-tech.com

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Alan Pritchard
> Sent: Thursday, November 25, 1999 7:33 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: MI Looking for European city points
>
>
> I am not too familiar with DCW, but I believe that it only holds broad
> size indicators, and it is somewhat old now.
>
> The Global Gazetteer uses actual recent population figures
>
> Best wishes
> Alan Pritchard
> The GLOBAL GAZETTEER: the world on file
> http://www.allm-geodata.com
>
> > doesn't the Digital Chart of the World hold population figures?
> > If it does then download country sized chunks from www.gisdatadepot.com
> > for
> > free and enjoy.
> >
> > - Original Message -
> > From: Alan Pritchard <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Thursday, November 25, 1999 11:18 AM
> > Subject: Re: MI Looking for European city points
> >
> >
> > > John,
> > >
> > > The Global Gazetteer includes around 125,000 settlements in Europe and
> > > 25,000 in Asia with actual population figures (out of a total of
> > > 930K, and
> > > 600K respectively).
> > >
> > > Selections can be made on population size or administrative function
> > > within the country (e.g. country capital, province capital etc)
> > >
> > > Price depends upon number of records & fields supplied, with a
> > > minimum of
> > > $400.
> > >
> > > Best wishes
> > > Alan Pritchard
> > > The GLOBAL GAZETTEER: the world on file
> > > http://www.allm-geodata.com
> > >
> > >
> > >
> > > > Can anyone direct me to a source for cheap/free city points for
> > > > Europe?
> > > > I have
> > > > the European capitols that were included with Mapinfo 4.1 but I need
> > > > the top 200
> > > > or so cities(by population) for Western Europe.
> > > > Accuracy/supplementary
> > > > data are
> > > > relativly unimportant. The same for Asia would also help down the
> > > > road.
> > > >
> > > > Thanks,
> > > > John Vitiello
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI-OS projection & creating points

1999-11-24 Thread Warren Vick, Europa Technologies Ltd.

Hello Sharon,

> I have a database of points (1000's of them!) with a column defining
> geographic location using Ordnance Survey Grid References.
>
> I would like to use MI's create points function on this dataset but it
> seems to me that x,y coordinates are required using degrees (lat/long).

MapInfo can handle national grid easting/Northing coordinates without
converting to latitude/longitude. When you use the "Create Points" function,
simply choose "Projection", then "British Coordinate Systems" and "British
National Grid". This coordinate system is already set-up to work in metres.

Your problem may be getting your data into 2 neat metre based Easting and
Northing columns.

> Column A
> 5205 7171
> 5214 7170
> 5204 7161
> etc...

Is there just this one column of coordinate data? Is there another with a
two letter code (like "TQ" for the London area)? If this field is all there
is then I would assume they are expressed to 100m resolution and need to be
multiplied up to convert to metres.

If you can described your coordinate data fully, I'd be happy to guide you
through the coordinate preparation and create points process.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI MB: Window Maximize Bug

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Christian

> Sub WinChangedHandler
>
>   If WindowInfo(FrontWindow(), WIN_INFO_STATE) = WIN_STATE_MAXIMIZED
> Then
> Set Window FrontWindow() Restore
>   End If
>
> End Sub

This is a bit of an odd thing to do in a WindowChangedHandler. I haven't
tried it but from inspection it looks like when you change focus to a window
which is maximised, you restore it to its normal size. This would happen for
windows of all types and may well fail on some.

I also suspect that changing a window size will cause WinChangedHandler to
be called again and you may end up in recursion.

What effect are you trying to achieve?

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Extracting X and Y Values of Nodes in MapInfo

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello,

> Hello. I'm trying to extract and save(as dbf or other) the x,y
> coordinates of the nodes for a bunch of tracts. I'm able to
> extract centroids using SQL Select but haven't had any success
> with the nodes. Any suggestions? Thanks.

Extracting nodes is a little more complicated. In the same way CentroidX()
and CentroidY() work, you can use ObjectNodeX() and ObjectNodeY(). The
parameters for both functions are [1] object, [2] polygon or segment number
and finally [3] node number. This is fine for single node queries but you
want to iterate through them all.

You could explore the use of Table>Export to save your data in MIF/MID
format. The MIF file contains lists of coordinates with a short header and
footer. The attribute data is stored in the MID file. With some editing (I
don't know how much data you have and whether this is going to be a regular
task) you could turn it into something which could be imported into Access
or Excel and then exported as DBF.

The best solution would be to write a MapBasic program. It should be a
relatively short program which would not take long to develop and would
perform your task quickly and easily.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Mapinfo coordinates problem

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello John,

> I have 3 simple questions:-
>
> 1. In MapInfo, if I can break the polyline at the node I want ?

Yes, but you have to drawn a polygon around one half of the polyline,
snapping onto the node you wish to break at, and then use Objects>Split. I
think it's quite a popular wish to be able to "break as selected node". I'm
sure I've seen a MapBasic utility that makes this job easier - check the
mapinfo-L file archives.

> 2. If i can enter polylines using coordinates using GUI?

Again not natively in MapInfo Pro, but a utility to do so may exist or is
simple to develop.

> 3. If I can list the above polylines and edit the coordinates of the
> polylines ?

Answer as 2).

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI american latina DEM

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Thomas,

> I need a Digital Elevation Model of this area
> (Bolivia, Peru, Chile) but unfortunetely, this zone on
> GTOPO 30 has not a good accurancy for altitude datas.
>
> Do you know another websites or organisms who offer a
> more precise DEM than QTOPO 30?

GTOPO30 DEMs and Digital Chart of the World (and V-Map0) is, I believe, the
most detailed data you will find in the public domain for these South
American countries. If this is not sufficient, you could try contacting the
national mapping agencies of each country. They would perhaps be sympathetic
to academic work concerning their nations.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI saving toolbar preferences

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Sonya,

> Does anybody know how to save your preferred mapinfo desktop (say,
> drawing and main toolbars docked, the rest closed) so that it comes up
> this way at start up?  It's very annyoing to keep rearranging things...
> you can reply directly, will sum.

How about right clicking on the toolbars to bring up the "Toolbar Options"
dialog and checking "Save as default". Is there anything with this option
that is not being saved?

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

P.S. This message is free of any data touting.

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI zoom display

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Leith,

> I don't know about anybody else,
> but trying to set zoom display is drviving me nuts!
>
> I've tried so many combinations for the min and max values,
> and can't get the darn layer to display or not when desired.
>
> Is there some trick to this?

Switch on your Status Bar and set it to display Zoom (Window Width).
Manually switch on your layers one-by-one and zoom in/our until you see your
desired range. Note the zoom value for min and max. Finally, in Layer
Control set the Zoom Layering parameters to the values.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com



--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Layout Window Title

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello,

> Does anybody know that how I can convert one Postscript file(*.ps, for
> HP755) to one MAPINFO table? I can convert the .ps file to .eps file(by
> GSView), but I haven't find the way to obtain one mapinfo table from eps
> file. Or there are some other ways?

This is a tricky one. As you probably know, Postscript is intended to be an
output description language rather than a generic vector storage format. For
vector data however, the line work may preserved well - at least within the
resolution of the page.

One of my very first efforts in mapping (before encountering MapInfo) was to
take some map clipart of Europe is EPS and convert it into a vector data set
for use with a home-brew mapping engine. It worked, but used a custom
developed program to make the extraction. Raster data would be much harder
to extract but still possible.

I wonder if there is a route via a drawing package. Perhaps you can find a
product that can read and render Postscript (a Mac applications may do a
better job) and then export in AutoCAD DXF. DXF can then be imported into
MapInfo.

If you do find a route, you will still have the problem of geo-referencing.
The data in the [E]PS file will only represent page coordinates. The "real"
coordinate will be lost.

As a last resort, you could hi-res scan and digitise.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Date: Fri, 5 Nov 1999 15:17:35 -0600

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Eric,

> I am starting a search for detailed street data (and possibility
> demographic data) for a "market plan" in Singapore.
> 
> Do any of you know of sources for Singapore data?

Try;

ERSIS (http://www.ersis.com)

or

The Data Source (http://www.thedatasource.com)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Problems

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Sami,

> functions CentroidX and CentroidY are giving me headache.
> My coordinate system is Myanmar, but these functions
> seems to give me latitudes and longitudes in decimal
> format. Does anyone know where the problem is?

As other L-ers have mentioned, MapInfo Pro uses latitude/longitude
coordinates unless told otherwise. On this that was not mentioned is that
the MB window command "set coordsys.." does not need to be typed out in full
with all the parameter information. If you have a table open which is set to
your Myanmar coordinate system, you can make Pro use this by issuing the MB
window command;

set coordsys table 

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI: Geometry Manager - pricing

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Dick,

> How does one communicate with MI management about things like
> this? That is, the huge price of Geometry Manager
> If I were a shareholder - and this kind of behavior is why I am
> not - I'd be wanting MI to include a product like this and MapBasic with
MI
> professional.

If you have a relationship with a MapInfo partner, tell them. With the
MapInfo Partners conference being this week (Marco Island, FL), your partner
(if attending) may have an ideal opportunity to talk with MapInfo staff at
all levels.

I'm sure GM will be the discussion of many conversations next week!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Map of France (administrative)

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Pancho,

> Would someone have a (free) map of France with the administrative
> boundaries (departments) ?

The only "free" admin data I have seen for France is on the (dare I say it)
ESRI web site(http://www.esri.com). I haven't looked for sometime but in the
past you could follow the links down into their data download areas and
download the admin data from their ArcWorld product. It's 1:3M scale which
is quote coarse but is about the only thing you'll find for nothing.
Download in shapefile format and use the Universal Translator to bring it
into MapInfo. Best check the smallprint to ensure you are allowed to
translate the data. Also not that ArcWorld has the admin of the world as of
1995 - a lot has changed since then for many countries. From memory, France
had regional divisions - not departments.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI RE: ObjectGeography(object, OBJ_GEO_CENTROID)

1999-11-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Claude,

> Although not documented under the ObjectGeography() function in MapBasic's
> Reference Guide, I infer the statement ObjectGeography(object,
> OBJ_GEO_CENTROID) returns a point object.  Therefore, I use it on a text
> object I want to resize in a MapBasic application, but get the
> error message "Could not convert data".

The function ObjectInfo() can return different data types depending on the
parameters used and this has always caused problems when querying. One
solution is to create a temporary column and do an update with the
ObjectInfo() value which does work. Then, reissue your query using the
results in the temporary column. I have tried other methods (casting, etc.)
but nothing seems to work, or work well. If anyone has cracked the direct
method, do let me know!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI SUM: Simulated click

1999-10-25 Thread Warren Vick, Europa Technologies Ltd.

Hello Paul,

> I was trying to activate a MB link to plume modelling software (aloha).

UK based partner Dotted Eyes have a MapInfo/Aloha link. Perhaps they have
already done what you are trying to achieve. Their web site is at
http:/www.dottedeyes.com  Follow the link to the MapInfo utilities page.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI Query a toggle button's checked state

1999-10-24 Thread Warren Vick, Europa Technologies Ltd.

Hello all,

Perhaps I've missed something, but I cannot find a way to query if a
buttonpad toggle button is in a checked/unchecked state. I could of course
maintain a local variable which is toggled by the called subroutine, but my
use of the button on this occasional is on a mapper-by-mapper basis and I do
not want to maintain arrays storing window IDs and button on/off states.
Logically this should hang of CommandInfo() or have it's own query
function - perhaps something like ButtonPadButtonInfo().

Someone let me know what I've missed for all these years before I have to
resort to tedious workarounds!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello again Bjorn,

> > Does anyone know how I can write to a textfile from a given position?
> > I see that there is a SEEK() function to find the current position in an
> > open file but I can't find a PLACE() function or something like it. I'm
> > trying to figure out how to change the coordsysclause in a MIF file.

I stand corrected. Several listers have taken great delight in getting one
over me. :-)

There is of course a seek command in MB. The syntax is;

   seek [#]filenum, position

My comment about sufficient space for updating the MIF file coordsys clause
still stands... for now!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello again Bjorn,

> > Does anyone know how I can write to a textfile from a given position?
> > I see that there is a SEEK() function to find the current position in an
> > open file but I can't find a PLACE() function or something like it. I'm
> > trying to figure out how to change the coordsysclause in a MIF file.

I stand corrected. Several listers have taken great delight in getting one
over me. :-)

There is of course a seek command in MB. The syntax is;

   seek [#]filenum, position

My comment about sufficient space for updating the MIF file coordsys clause
still stands... for now!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello again Bjorn,

> > Does anyone know how I can write to a textfile from a given position?
> > I see that there is a SEEK() function to find the current position in an
> > open file but I can't find a PLACE() function or something like it. I'm
> > trying to figure out how to change the coordsysclause in a MIF file.

I stand corrected. Several listers have taken great delight in getting one
over me. :-)

There is of course a seek command in MB. The syntax is;

   seek [#]filenum, position

My comment about sufficient space for updating the MIF file coordsys clause
still stands... for now!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello again Bjorn,

> > Does anyone know how I can write to a textfile from a given position?
> > I see that there is a SEEK() function to find the current position in an
> > open file but I can't find a PLACE() function or something like it. I'm
> > trying to figure out how to change the coordsysclause in a MIF file.

I stand corrected. Several listers have taken great delight in getting one
over me. :-)

There is of course a seek command in MB. The syntax is;

   seek [#]filenum, position

My comment about sufficient space for updating the MIF file coordsys clause
still stands... for now!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello again Bjorn,

> > Does anyone know how I can write to a textfile from a given position?
> > I see that there is a SEEK() function to find the current position in an
> > open file but I can't find a PLACE() function or something like it. I'm
> > trying to figure out how to change the coordsysclause in a MIF file.

I stand corrected. Several listers have taken great delight in getting one
over me. :-)

There is of course a seek command in MB. The syntax is;

   seek [#]filenum, position

My comment about sufficient space for updating the MIF file coordsys clause
still stands... for now!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Writing to a file

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello Bjorn,

> Does anyone know how I can write to a textfile from a given position?
> I see that there is a SEEK() function to find the current position in an
> open file but I can't find a PLACE() function or something like it. I'm
> trying to figure out how to change the coordsysclause in a MIF file.

Seeking to the start of the coordsys line in a MIF file and overwriting may
not be safe as the clause has variable length and there may not be enough
space for your new text. Although it sounds a waste of processing, the only
safe way of doing this is re-exporting the MIF file from MapInfo or
line-by-line file copying with replacement.

There is indeed no seek() function native to MapBasic. It's pretty straight
forward in a DLL, especially in C where this function has been a long
standing part of the standard run-time library,

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Expression too complex

1999-10-20 Thread Warren Vick, Europa Technologies Ltd.

Hello Xu,

> In delphi and MaoInfo Ole , I wrote this code:
>
> //-code
> ..
> ts := '';
>  for j := 0 to 34 do begin
>   if j<>34 then
> ts := ts + 'bs_no = "'+slist.strings[j] + '" OR '
> else
> ts := ts + 'bs_no = "'+slist.strings[j] + '"';
>  end;// for
>  ts := 'Select * from CELL where '+ts;
>  MapInfo.Do(ts);
> ...
> //-code
>  It runs Ok!
>  but when i change "34" --> "35">
>  it runs error , mapinfo show error message box " Expression too complex".
>  Why? How can i do?

Wow! A 35 part where clause! Is this really necessary in your application? I
am sure there is a limit to the number of clauses, or length of SQL command,
in MI/MB and I'm not surprised that you've hit it. Two potential solutions:

1) Restructure your database so that the number of clauses is reduced. If
you have 35 logical fields which you are OR testing, perhaps you could
combined these into a single indexed string field (e.g. "YNNYYNYN...") .
Although sub-string SQL queries are not great in MI/MB, the performance may
be comparable with such a complex original SQL statement. If your table are
relatively small, performance is probably not an issue anyway.

2) If the number of fields has to remain, consider breaking your query into
more that one sub-query parts and combine the results (perhaps inserting
them into a temporary results table). Since you're ORing, you just need to
combine and remove duplicates. Work with ANDs would be a bit more
complicated.

Sounds like a "data rich" project. Good luck!

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Group IV TIFF

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Jure,

> I have a lot of raster images in TIFF - Group IV Compression.
> MapInfo can't open/display them correctly.
>
> I have software that can convert Group IV Tiff to MapInfo readable
> TIFF, but I'd prefer a direct solution.

The TIFF specification is quite detailed and many implementations are not
complete or only comply up to a certain version. Group IV compression is a
believe (normally black and white) compression method normally associated
with second generation fax technology. While this may not be complicated, it
may not be implemented in MapInfo's TIFF support. Can you open the images at
all? Do they open but not display properly?

The only solution to get your existing images working with Pro is to develop
a custom raster handler. The toolkit to do this is available from MapInfo
but I would not take on this project lightly! It would be much easier to
find (or develop using a image toolkit component) a program to batch convert
your images to something that Pro can read.

Before MI users grumble too much about occasional TIFF loading problems, we
should consider ourselves lucky in comparison to ESRI ArcView users!
ArcView's TIFF implementation is much worse than MI's and a certain popular
form of compression (LZW) is only supported by the addition of a charged-for
supplement file (to get around the Unisys IPR problem).

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Display order of objects in a table.

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Martin,

> Can someone please let me know if a solution was ever discovered to gain
> control over the display order - I can categorically state that
> changing the order of the objects in the table (on the assumption that
objects
> are drawn in the order they are listed in the table) definitely doesn't
work.

There was a pretty interesting message thread about this and many -L'ers,
including myself, were not quite right with our conclusions. Andrew Dressel
cleared things up although there are still many people who want to believe
otherwise!

Firstly, as you have found, record order (ie. rowid) has nothing to do with
it. MapInfo draws map objects/features in the order processed using the map
datas spatial index. The spatial index allows MapInfo to draw quickly when
viewing only a small part of a much larger data set. Rather than check each
and every map object to see if it's on-screen the spatial index allows
MapInfo's software products to ascertain which objects need drawing with a
fraction of the processing overhead.

The problem with MapInfo's spatial indexing is that, by observation, it has
a complicated behaviour which I, for one, would not bother trying to figure
out!

The only way to guarantee that one set of objects is drawn before another is
to put them in separate layers. However, I have found (with only occasional
exception) that if you put your objects in record (rowid) order and objects
are in close proximity, then the record order is preserved for local
drawing. I've done this where it has been necessary to put region and
overlaying polyline objects in the same layer with the polylines on top.
It's not guaranteed but is the best you can do in a single layer.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI MB sanity check: Insert/Alter Objs/Table

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello John,

> This is a sanity check:
> Please confirm that it is not possible to insert both objects and values
> into a table w/ a single statement.

Yes it is. The following is perfectly valid MI/MB SQL:

insert into MyTable (obj, Field1, Field2) values (MyObj, MyField1, MyField2)

> Likewise, with Alter one can either alter an Object or a Table
> both not both at the same time.

The "alter" command has many applications including changing an object and
changing a table structure. Although the operations are strung off the same
MB command they do completely unrelated "alterations".

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI help

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Susan,

> I think this might be a fairly easy one (I hope!)  I'm trying to build an
> array based off of user input.  In the custom dialog there will only be on
> Edit Text box for the user to input the data.  There will also be
> a Control Button titled "Next".  The gist of it being that after the user
inputs a
> string/value in the edit text box and clicks "next" the value
> will be stored and the edit text box cleared so that the next value can be
> inputted.  I've tried a few different things (readcontrolvalue etc. but to
no avail) Any
> suggestions (I'm limited to MB)?

You have a choice of re-using or re-starting your dialog. To re-use it, you
need to use the "alter control ..." statement to clear the text of the
message box. To restart it, just arrange your code so that the "Next>"
button is an "okbutton" which dismissed the dialog, and loop around to call
the "dialog ..." statement again.

One thing to think about is that most user use the mouse to press buttons
and not any keyboard shortcuts. So, your user will probably be switching
between typing, mouse click several times. I don't know how many entries
you're expecting from the user but I think a better solution would be to use
a larger dialog with a reasonably sized text box. Put a note on the dialog
asking the user to enter their value using a comma (or other) separator.
Then, when they hit "OK", it's quite straight forward to write an MB loop
which runs through the entered string and extracts the sub-strings/numbers
for your array.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI mapbasic input variables

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Scott,

> I would like to
> have one sub routine such as
> save copy C:\city.tab as E:\temp\city.tab
> in which the input variable city would represent the variable
> that the user has selected

You can use your CITY variable in an expression in table processing
commands. However, there is no "save copy" type command in MI. The easiest
thing to so is to open the selected table and save it again.

open table "c:\"+CITY as TO_COPY_SAVE
commit table TO_COPY_SAVE as "e:\"+CITY

With open and commit, you do not need to put ".tab" extensions in the
expression as MI assumes it. Also, it would be wise to have your directory
paths implemented as variables rather than hard-coded and also to check for
the existence of the copy table before attempting the copy. You can do this
with the FileExists() function.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI scripts

1999-10-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Megan,

> I was wondering whether anyone has written a script with enables you to
> view the coordinates for rectangles and polygons drawn in mapinfo

For rectangle objects, you can just double-click or select & F7 for the
Object Info dialog. This will tell you the coordinates of the corners.

For "many-node" type objects such as polylines and polygons, this would need
a MB program to be done well. It would also need to be quite smart since it
would not be possible to fill a listbox with all the coordinates in large
object. Some form of "block view" when the node count reaches a certain
threshold would be necessary. A good utility would also need to handle
multi-polygon regions and multi-segment polylines.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Popup title maximum size

1999-10-18 Thread Warren Vick, Europa Technologies Ltd.

Hello Teguh,

> i have problem of using popup menu in mapbasic.
> I want to make a list that will appear in pop up menu. This list
> will be as
> a number from 1 to 124. Any time i compile it, it will create an
> error. But
> if i just use the list of number from 1 to 101 it will success. So i think
> the problem is the size of character that allowed to used in popup title.

I think there is a limit of 255/256 characters for control item text in MB.
The solution I would use is not to do this at all! It is a little unusual to
put that many numeric items in a pop-up menu (or list/combo control) - try
using it to see how bizarre it is. It is more in line with Windows GUI
guidelines to have the user enter the number in a dialog editbox and then a
button to validate & action.

Regards,
Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI "Adding Coloumns"??????

1999-10-14 Thread Warren Vick, Europa Technologies Ltd.

Hello Haavard,

> How do I add charaterdata from to coloumns into one?
>
> example:  the first column contains first_names (john)
> and the second coloumn contains second names
> (Smith)I want the result to appear as JohnSmith in
> only one coloumn.There should be no space between John
> and Smith). There are tousands of records so
> I can't do this manually.

When using the "Table>Update" menu option, or SQL typed into the MapBasic
window, you are not just limited to updating by a single field. MI Pro
allows you to use expressions.

To get the desired results update your table with the expression:
first_names+second_names
If you wanted a space you would use: first_names+" "+second_names

Even with thousands of records, this update will not take too long.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI selecting 10m contours from a 2m contour map

1999-10-14 Thread Warren Vick, Europa Technologies Ltd.

Hello Gabor,

> I have a 2m contour map that is attributed with height.
> What query can I run so that I only select the 10, 20, ,,, N contours.
> Ie show a map with a 10m contour interval.
> I do not want to write a query that spells out all my contour
> heights such as
> select where contour = 10m or 20m or 30m etc. there could be a
> lot of intervals.

If your elevation data field is an integer, try using the MODulo operator.
Your SQL "where" clause should be something like:

Elevation mod 10 = 0

This will only select records where the elevation field is divisible by ten
with no remainder. ie. the result you require.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI finding files in a windows directory whose name contain a specific string

1999-10-13 Thread Warren Vick, Europa Technologies Ltd.

Hello Ben,

> I was wondering if it is at all possible to somehow query the windows
> environment about the files contained in a specific directory.  The idea I
> had was that I would query a directory where an open table resides for a
> file containing a certain string in its name.

Yes, it is possible, but yet again it involves venturing into the Windows
API. There are two functions which you need to use. The first allows you to
setup the file search filter and returns the first matching file. The second
allows you to fetch successive file names. The functions are both "legacy"
in nature and are therefore preceded by an underscore.

   long _findfirst(char* filespec, struct _finddata_t *fileinfo)
   long _findnext(long handle, struct _finddata_t *fileinfo)

I've never tried to access these before directly from MB and think there may
be a problem with reproducing the _filedata_t structure with correct byte
packing, etc. I've always wrapped the functions into my own DLL which is MB
accessible, and provides an easy way to return matching files using a simple
MB do loop.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MB MI Pro title

1999-10-12 Thread Warren Vick, Europa Technologies Ltd.

Hello Spencer

> Is there a way, using MapBasic, to change the title that appears at the
top
> of the MI window from 'MapInfo Professional' to 'My Application'?

Within MapInfo Pro, it is only possible with the runtime edition. The MB
command "set window title ..." doesn't work on full MI Pro. The sneaky
approach is to use the Windows API, specifically the SetWindowText(HWND,
char*) function. MapInfo's HWND is obtained through a call to
SystemInfo(SYS_INFO_APPLICATIONWND). I've always wrapped the title set
function up in a DLL but I am sure you can access it directly from MB with a
suitable external function declaration.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI WIN_INFO_HEIGHT

1999-10-09 Thread Warren Vick, Europa Technologies Ltd.

Hello David,

> rescueing the message window.

There's only so much you can do to accommodate user changing resolution, etc. There 
will 
always be something they can do which will make restoration of settings awkward. I 
would try to 
detect if the message window has been dragged, or been forced off by resolution 
change, and 
reset the x/y/width/height to default values, but preserve the maximised/minimised 
property. If this 
doesn't work, you could provide a menu option "Reset Message Window" or similar. 
Perhaps a 
little messy but it will get your users out of a pickle. Good luck!

P.S. Are you going to the new F1 Grand Prix in KL?

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI WIN_INFO_HEIGHT

1999-10-08 Thread Warren Vick, Europa Technologies Ltd.

Hello David,

> I believe that if I use the following command: 
> Print WindowInfo(FrontWindow(), WIN_INFO_HEIGHT)
> it gives me the height of the map window if it is in it's 
> NORMAL state. Would anyone know how I can get the height of 
> the map window when it is in it's MAXIMIZED state?
> 
> I'm trying to save the position of the message window, so I 
> can put it back in the same place when the program is 
> restarted.

You can indeed query the WIN_INFO_HEIGHT and WIN_INFO_WIDTH of a window and save it 
for restoration later. However, for handling the window maximised (or minimised) 
state, you don't 
have to remember the size - just the fact that it is maximised or minimised. Use the 
WIN_INFO_STATE attribute to query the windows states and store that along with the 
width and 
height information. Use "set window ..." to restore the height, width and state.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI clearing the message window

1999-10-08 Thread Warren Vick, Europa Technologies Ltd.

Hello Ben,

> what can I type in the mapbasic window to clear all text from the message
> window.  It mentions this in the help file but there aint nuthin' there!

Simply the command CLS. This is a little unusual as it is not really an MB command but 
a 
definition found in MAPBASIC.DEF:

define CLS print chr$(12)

CLS will not work if you type it in manually into the MI/MB window. You'll have to use 
print 
chr$(12).
 
> This question is worth an extra 50 cents at $21
Boy am I gonna be rich out of you. :-)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: Help with MIF: Coordsys/Projection Type

1999-10-08 Thread Warren Vick, Europa Technologies Ltd.

Hello Anne-Leslie,

> I have some MIF/MID files that I am working on
> translating into a propriatery format for my employer.
> They contain the line:
> 
> CoordSys Earth Projection 1, 104

This MapInfo coordinate system clause means that the data is expressed in 
longitude/latitude 
coordinates using the WGS-84 datum. This is correct for DCW and VMAP0 data.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI deleting a range of rows

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Ben,

> Is there a way through mapbasic to specify a range of rows to 
> delete rather than 1 or all?

All part of living with a basic SQL implementation. The lack of fully feature where 
clauses in 
UPDATEs and DELETEs is a bit of a pain. The solution is to simply make a selection of 
the 
records you want to delete and delete the results. For example:

select * from TestTable where rowid mod 2 = 0 into TO_DEL   ' Select every even record
delete from TO_DEL

Ditto for updates.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI returning the directory structure leading to an open table

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Ben,

> Is there any way in mapbasic to issue a command that returns 
> the directory structure leading up to an open table?

You can obtain the full directory and filename for a table using:

TableInfo(TabName, TAB_INFO_TABFILE)

and then you can obtain the directory part of the string using:

PathToDirectory$(PathString)

> Thanks in advance to anybody with the answer to my $20.50 question

If only I could earn $20.50 so quickly all the time. :-)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI How to check if a workspace has been modified before closing w/o

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Carter,

> Is there any way to programmatically check if a workspace has 
> changed since it was opened.

No easy way I believe. Workspaces are a little unusual since they are not a document 
in the 
traditional sense of Windows. They are more like a state snapshot of a user session, 
expressed 
in MB. You could try to detect if anything has been added/changed/deleted in cosmetic 
layers or 
for changes in layer control but this would be quite tedious. Alternatively you could 
save a 
temporary workspace and line-by-line compare with your chosen WOR file. All of these 
techniques involve wedging into MapInfo's basic features (replacing menu items and 
buttons with 
ones which call your own functions, "remembering things", and then invoke the standard 
MI 
functionality). It's all a bit messy, but possible. For some applications, it may be 
prudent to allow 
the user to save at the end of any session. Leaving the standard concept and behaviour 
of 
workspaces may not be a bad thing - no matter how much your app' changes MI Pro's 
presentation.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI Speeding up things

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Bjorn,

> I have a MapMasic program which uses a table of 90 records 
> to update an Oracle table (many million records). The problem 
> is it has to do 3 checks on the Oracle table for every record. 
> My estimation is now that it is going to take me 10! days 
> before it is finished.

If the 900K table is a MapInfo TAB, consider uploading it to Oracle before performing 
your update 
operations. It is possible that the richer SQL implementation may speed things up with 
everything 
within Oracle.

My general rule for optimising batch performance is to take a representative sample 
(say 1000 
records) and perform some analysis (using tools or perhaps just tweaking) to see what 
makes a 
difference. A 0.1 second saving will you a day by my linear reckoning.

Of course the thing not to do is spend 10 days think about it... :-)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI Telecom '99 Geneva

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello all,

Any telecoms -L'ers going to the massive ITU event in Geneva next week? Finally 
arrangements 
permitting, I hope to be there for a day or two.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI UTM/Korea/Ready-to-Go Grids?

1999-10-07 Thread Warren Vick, Europa Technologies Ltd.

Hello Henk,

> I'm trying to recreate a grid an author used in a book which  was published 1945
> (no typo).  The author uses 10km and 100km grids for Korea in  UTM grid system
> for Korea (Grid Zones 51S, 52S and 51T and 52T; what do the S and T's refer
> too?).

Well, the 51 and 52 definitely refer to the UTM zones which cover South Korea. 
52/North will 
cover the mainland with 51/North perhaps being used for marine coverage in the Yellow 
Sea (and 
maybe for those little islands off China's coast that are South Korean). I thought for 
a moment 
that "S" and "T" may refer to North and South in Romanised local language but Korea 
should 
clearly have northing to do with the Southern hemisphere.

You should be able to make a grid in UTM51 or 52 using the standard GridMaker utility. 
Watch out 
for false northing origins. Just for reference, Seoul/Soul should be at (317585, 
4157043) in 
UTM52/North.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI accurate draw region

1999-10-06 Thread Warren Vick, Europa Technologies Ltd.

Hello Laith,

> Is there a way to draw a rectanglular region or rectangular 
> selection marquee accurate to Lat. Long. coordinates?

It may not be a satisfactory solution but I just draw a rectangle roughly and then 
double-click the 
newly created object to change corner coordinates.

> PS  I've borrowed this divider from another lister.

I'd give it back. :-)

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI: World Data Bank II question

1999-10-06 Thread Warren Vick, Europa Technologies Ltd.

Hello Jason,

> I was downloading and converting some shoreline data from the 
> USGS Coastline Extractor (http://crusty.er.usgs.gov/coast/getcoast.html)
> and noticed some errors for the coastlines in Northern Canada. 
>  It was derived from the World Data Bank II (scale 1:2M), which I 
> understand was created by the CIA.  I can't find an original source or 
> contact to notify of these errors though.
> Does anyone out there know who is currently responsible for 
> maintaing this data?

The WDB data (which is at a scale more like 1:20M) gets passed through so many hands 
and 
gets modified that it's hard to know what the original is. As far as I know, it is not 
a maintained 
data set so reporting errors and required updates will unfortunately not yield a new 
version.

If you would consider a maintained commercial product, take a look at Global Insight 
Lite. It 
contains up-to-date political mapping (evening including East Timor) and a 19,500 
place 
gazetteer. It's a soft product downloaded from the web and licence purchase includes a 
years 
worth of updates free of charge. Full details on our web site at 
http://www.europa-tech.com

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI Pro Area Bug

1999-09-17 Thread Warren Vick, Europa Technologies Ltd.

Hello all,

Here's an interesting bug which threw me for some time yesterday. I was making a quick 
"not the 
same" check between two region objects, the first test being a comparison of areas 
(spherical in 
this case). The problem is it was stating that two polygons had very slightly 
different areas when I 
knew they were the "same" ie. node identical. The problem turned out to be that one 
region was 
composed of a clockwise polygon, the other counter-clockwise. MapInfo reports a very 
slightly 
different area for each which is clearly incorrect.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI FW: BUFFER INACCURACIES

1999-09-08 Thread Warren Vick, Europa Technologies Ltd.

Hello Paul,

> Does anyone know why buffers become increasingly more inaccurate on certain 
> bearings above distances of 4000+ Nautical Miles??

Large buffers have never been correctly implemented in MapInfo Professional. MapInfo 
are fully 
aware of the problem since I've nagged them about it several times - even more so 
since v5.5 
where buffers were split between Cartesian and Spherical flavours. Calling the 
buffering 
"spherical" is completely incorrect as the calculation is done in a planar fashion.

Basically, Pro takes a point (probably the first) in your object to buffer and 
calculate "what is the 
conversion of longitude (a unit of which changes with latitude) for the specified 
buffer size". Of 
course this is nonsense as a large buffer will cover area where the distance of a unit 
of longitude 
changes greatly. I have observed errors of 20%. The other problem with buffers is that 
they are 
always oval. As a buffer approaches the poles, it should "spread out" on a cylindrical 
projection to 
cover the line which represents 90N and 90S. Interestingly, the circle tool is 
MapXtreme gets this 
right!

IMHO, this is one of the most serious bugs in MapInfo. Given that professionals may 
stake their 
reputation on distances and areas, it really does need to be looked at immediately.

By the way, complex buffer performance is terrible in v5.5... I've gone back to v5.0.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI JPEG mystery ...

1999-09-03 Thread Warren Vick, Europa Technologies Ltd.

Hello Scott,

> I have a map window, that I have set through code to be 8 x 7 inches.  =
> Why, when I save the map window to a JPEG using the same proportions and =
> then open it in a 3rd party graphics package, does it say that it is =
> actually 26.48 x 23.17 inches at 29 pixels per inch??

I think the JPEG file format does not have any way of specifying the resolution of an 
image (or if it 
does, MI Pro does not set them). By resolution I mean the pixel density per inch - not 
the size in 
pixels. MapInfo only exports images at "screen" resolution - often this should be 
changed when 
you need to send maps to film for printing (typically 300dpi). TIFF images, although 
generally 
larger, do have built-in attributes for resolution and they can be changed by many 
paint programs 
(I use Corel PhotoPaint quite a lot) without changing the image size. When the images 
are then 
brought into a page layout program (say PageMaker), they are sized correctly and at a 
suitable 
resolution for the output device.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI Max number of lines of code in MB?

1999-09-03 Thread Warren Vick, Europa Technologies Ltd.

Hello Richard,

> How many lines of code are allowed in one MB program? or total  characters? 32k?
> HELP seems confusing.

I believe the text control used in the MapBasic editor will have a Windows legacy 64k 
limit. Some 
L'ers mentioned not so long ago that they used external editors to crate much bigger 
files. 
However, I would challenge whether this is good development practice. If you work in a 
professional environment with a version control system, putting everything into one 
gargantuan 
file is not too clever.

Back in the days of v3 and v4 of Pro, there were some nasty problems with MapBasic 
incorrectly 
compiling and linking with large files. Although these may all be cleared up now, I 
would say 
keeping source files down to a reasonable level is the sensible option.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI Mapbasic DLL programming question

1999-09-03 Thread Warren Vick, Europa Technologies Ltd.

Hello Karl,

> I have a MapBasic programming question.  I am trying to link to a DLL
> but when I run my MBX I get the message "Unable to load library abc.dll.
> Unable to link to external library abc.dll".  Has anyone come across
> this before?  I heard from MapInfo that only 32 bit dll's are supported
> and this is a 32 bit dll so that shouldn't be the problem.

This could be a number of things but the most common problems are;

1) Your functions are not being declared for export properly. I use the following 
definition for 
C/C++ functions:

#define DllExport   __declspec( dllexport )

Then declare your functions like this;

DllExport int
MyFunction(int Arg1)
// etc...

2) Your functions are being exported with C++ mangled names which are not matched by 
the 
calling MB program. Remember that C++ messes around with function names internally so 
that 
function overloading (the ability to have the 'same' function have several variants 
handling 
different argument types). Your functions must have "C linkage". This is not to say 
you cannot 
use C++ features in the function themselves - you just cannot have more than one 
function with 
that name. To specify C linkage, use extern "C" { }. For example;

extern "C"
{
   DllExport int
   MyFunction(int Arg1)
   {
  return Arg1;      // Dummy function
   }
}

Hope this helps.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI: World Places

1999-08-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Laura,

> Can somone point me in the right direction?  I'm looking for a Web site
> that can provide the Lat/long for world cities.

I wasn't too sure if you're specifically looking for a web service or a site to 
download data from the 
web to use with MapInfo.

The places data on the MI Pro CD-ROM (DCW based I think) is not too bad although it 
has many 
significant places missing and has no field indicating level of importance.

If you're looking for a commercial product, take a look at Europa Technologies data 
sets. Global 
Insight is one of the largest place gazetteers available which has an intermatching 
up-to-date 
political map. Names include accented characters (using ANSI fonts like Arial, Times 
Roman on 
Windows) and feature local and alternative names (English, second national languages, 
long/short form). So, whether you're searching for Rome/Roma or Helsinki/Helsingfors, 
you'll find 
the location successfully.

Full details, map images and sample to download at http://www.europa-tech.com

There are plenty of web based services around but watch out for accuracy. Many of the 
sites 
featuring large gazetteers only have accuracy to the nearest degree or minute. For 
anything other 
than a basic find, this may not be sufficient positional accuracy.

Feel free to e-mail if you have any questions.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI: World Places

1999-08-19 Thread Warren Vick, Europa Technologies Ltd.

Hello Laura,

> Can somone point me in the right direction?  I'm looking for a Web site
> that can provide the Lat/long for world cities.

I wasn't too sure if you're specifically looking for a web service or a site to 
download data from the 
web to use with MapInfo.

The places data on the MI Pro CD-ROM (DCW based I think) is not too bad although it 
has many 
significant places missing and has no field indicating level of importance.

If you're looking for a commercial product, take a look at Europa Technologies data 
sets. Global 
Insight is one of the largest place gazetteers available which has an intermatching 
up-to-date 
political map. Names include accented characters (using ANSI fonts like Arial, Times 
Roman on 
Windows) and feature local and alternative names (English, second national languages, 
long/short form). So, whether you're searching for Rome/Roma or Helsinki/Helsingfors, 
you'll find 
the location successfully.

Full details, map images and sample to download at http://www.europa-tech.com

There are plenty of web based services around but watch out for accuracy. Many of the 
sites 
featuring large gazetteers only have accuracy to the nearest degree or minute. For 
anything other 
than a basic find, this may not be sufficient positional accuracy.

Feel free to e-mail if you have any questions.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



Re: MI area calculations broken

1999-08-03 Thread Warren Vick, Europa Technologies Ltd.

Hello Mark,

> I have been making comparisons of the area of various objects, and have
> found MapInfo's area calculating function to be seriously broken, at least
> in some projections (Polar Azimuthal projections).

MapInfo Pro's area calculation is independent of the current map projection. It just 
assumes a 
spherical Earth, with the option of Cartesian in v5.5. You can see this by the fact 
that the MB 
area() function does not have any coordsys or map window ID clause.

The problem you are having can be seen by simply reverting to a rectangular 
projection. One of 
your triangles crosses the 180 degree meridian. While this looks perfectly fine on the 
polar 
projection, it is in fact implemented by a massive triangle crossing the entire world 
and this is the 
reason for your outsized area. Try breaking your trans-meridian region into a two 
polygon region, 
broken at 180deg. You should find that the area are then equal, but they may still be 
incorrect. I 
rarely trust MI's distance and area calculations these days.

One additional point. Having polygons with such long edge lengths doesn't really make 
sense 
since they are straight lines no matter what the projection is. It's better to decide 
on an 
acceptable resolution for your "lines" and insert nodes accordingly. You can then 
decide whether 
these lines are great circles, rhumb lines, etc. and be in better control of the areas 
definition.

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]