Re: MI-L Objects split

[Robert Crossley]

Ben,
If you issue the split command as a commndstr created by a loop rather 
than the object split command directly, you can include all the data from 
the target, as follows:

strCommand = "Objects Split Into Target Data  "
For i = 1 To NumCols(gEditFile)
	strCommand = strCommand + ColumnInfo(gEditFile, "col"+i,COL_INFO_NAME) 
+ " = " + ColumnInfo(gEditFile, "col"+i,COL_INFO_NAME)  + ", "	
Next
strCommand = Left$(strCommand, Len(strCommand) - 2)
Run Command strCommand

r
On Wed, 19 May 2004 16:03:15 +1000, Benjamin Scott 
<[EMAIL PROTECTED]> wrote:

Hi all,
I want to split a collection of tab files one by one using one master 
file - I am doing this within a For loop in mapbasic.

I need the data in the output tables to be the same as the input tables 
(ie all new objects in the split table have identical attributes to the 
object they were split from).  The Objects Split command only seems to 
have the option to leave all columns blank or to specify the particular 
columns that are equal pre and post the split - there doesn't seem to be 
an option to say "I want all columns to be equal to the attributes 
before the split"

Is that true or is there a method I am unaware of?
One complication is that the number of columns and the name of each 
column is different for each tab file.

Regards,
Ben Scott
Environmental GIS Analyst
City Solutions
Blue Mountains City Council
(02) 4780 5433
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11834

--
Robert Crossley
Agtrix P/L
9 Short St
PO Box 63
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309
F: New Connection
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11835

MI-L Objects split

[Benjamin Scott]

Hi all,

I want to split a collection of tab files one by one using one master file - I am 
doing this within a For loop in mapbasic.

I need the data in the output tables to be the same as the input tables (ie all new 
objects in the split table have identical attributes to the object they were split 
from).  The Objects Split command only seems to have the option to leave all columns 
blank or to specify the particular columns that are equal pre and post the split - 
there doesn't seem to be an option to say "I want all columns to be equal to the 
attributes before the split"

Is that true or is there a method I am unaware of?

One complication is that the number of columns and the name of each column is 
different for each tab file.  

Regards,

Ben Scott
Environmental GIS Analyst
City Solutions
Blue Mountains City Council
(02) 4780 5433


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11834

MI-L MB Colour codes

[Sam Shelley]

Hi - would anyone know the colour codes for Grey and Orange.  Thanks in
advance.  

 

Samuel Shelley

GIS OFFICER 

FIRE MANAGEMENT UNIT

 

TASMANIA FIRE SERVICE

GPO Box 1526 
HOBART,  Tasmania
AUSTRALIA, 7001

 

(CNR ARGYLE AND MELVILLE STS, HOBART 7000)

EMAIL: [EMAIL PROTECTED]

PHONE: (03) 6230 8735

FAX: (03) 6230 6647

IF CALLING FROM OUTSIDE AUSTRALIA REPLACE 03 WITH 613

 

MI-L MapX in C#.NET

[Peter Zyczynski]

Hi,

I'm Writing an app in C#.Net with an embedded MapX control (this applies to
all you VB.NET people too so don't go deleting this message!)

I have a problem with displaying a MapX map on a tabControl which is a part
of a User Control.  If I put the map on the first tabPage in the tabControl
it works fine, however if I stick the map on a tabPage other than the first
one it won't display!!

Weird  :-/

I smell a bug in .NET.

I've exhausted almost every other avenue with no answers from news lists
that specialise in .NET.  If anyone here has found a workaround I'd be glad
to hear it!

If you don't believe me here's proof:

(Visual Studio designer)
http://www.insightgis.com.au/web/stuff/user_control_designer.gif

(Running app)
http://www.insightgis.com.au/web/stuff/running_app.gif


TO RECREATE:

1. Start a new Win Forms project (VB or C#, doesn't matter)

2. Add a User Control to the project (right click on Solution Explorer).
3. On the User Control add a TabControl.
4. Add two pages to the tabControl.
5. Stick a MapX map on the second page.

6. Add the User Control to the main form in your project.
7. Run the app.
8. Notice something missing on Page2 of the tabControl?



Cheers,

Peter Zyczynski
Analyst Programmer
Insight GIS
Australia
Ph:  (03) 6234-5833
Fax: (03) 6234-5899
[EMAIL PROTECTED]
www.insightgis.com.au




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11832

RE: MI-L MapShop Projection Question

[SCISOFT]

Carolyn
I'm not using MapShop, but I have NATMAP Raster Mapsheets - the 2003 Release
- and discovered that with version 1.4 of the Raster Viewer the "paper
edges" of each map are visible - the legends, etc. And some sheets appear
skewed on the screen by 5 degrees or so. 

A friend in Sydney has 2002 release with v1.3 of the viewer, and only the
actual map bounds are visible. Much more useful, because it means that maps
can be exported to Geotiff and then spliced together. 

Maybe this isn't relevant to you, but I'm about to contact AGSO (Geoscience
Australia) to see whether I can get the previous version of the viewer. As
supplied (v1.4), it's less than useful to me. 

Ian Thomas
GeoSciSoft - Perth, Australia


-Original Message-
From: Carolyn Bergin [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 19 May 2004 8:37 AM
To: MapInfo-L
Subject: MI-L MapShop Projection Question

Hi Listers

For those of you using MapShop, hopefully you can help me.  I have the
problem that when I open up my aerial photography behind a series layer
the projection changes putting my series blocks on an angle rather than
having them straight as they were created.  This happens even if I open
my series layer first but only with my aerial photography, however,
other layers will change to match the series layer.

Is there any way around this?

Aside from that id also like my index box to show the whole LGA and
highlight the square shown on the map, is there a way to change the
settings of the idex box?

Thanks 

Carolyn

Carolyn Bergin
Senior GIS Officer 
Planning and Strategy
email - [EMAIL PROTECTED]
phone - 9976 1593
fax - 9976 1400

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Re-transmitting or re-publishing the content of this email in any media
format without the express permission of the Author is strictly prohibited.
If you have received this email in error please notify Manly Council
immediately.
Information transmitted via email may be subject to corruption by the
process. Information contained in this email should not be relied upon where
loss, damage or injury is possible. Verified information should be obtained
in writing directly from the authorised Council officers.



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11827



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11831

Re: MI-L Quick stupid question -- Key Codes

[Trey Pattillo]

0-31 Control Codes
These are from the old "teletype" days and contain formating commands and
even beeping the speaker #7 [bel]
Some are very functional in providing a "text based" database, even the 911
data has #2 [start text] #3 [end text] #28 [file separator]
Most used in MapInfo/MapBasic [in decimal values] are:

#7 - Bell [beep speaker]
#9 - Tab [note that MapInfo shows as a square and does not indent the text]
#10 - Line Feed
#12 - Form Feed
#13 - Carriage Return
#27 - ESCape [can help stop erronous key press triggering in VB and Delphi]
All the other are historical and special purpose use [field / record markers
for text database]

32-127 are the standard character set [what you type in say Times New Roman]

128-255 are graphic symbols by defination and based on mono spaced fonts
like Courier New or Terminal and will vary amongst the fonts and may not
even be printable in some fonts and applications

Also you can enter key values by holding the ALT key and using the number
pad to enter decimal value then release ALT key

For creating multiple-lined labels all that is needed is Chr$(10)


Trey Pattillo
[EMAIL PROTECTED]
www.wap3.com
N27.799013 W-97.665322

- Original Message -
From: "Brown, Christopher (HI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18, 2004 19:16
Subject: RE: MI-L Quick stupid question


I know Chr$(13) gives a character return as well but could someone point me
to where there is a list of all the Chr$ values?

Regards
Chris
Chris Brown - Cartographer
Resource Evaluation, Land Assets,
Hamersley Iron P/L.
Tel. +61 8 9327 2176
Fax. +61 8 9327 2478
mailto:[EMAIL PROTECTED]
http://www.hamersleyiron.com/


-Original Message-
From: David Reid [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 May 2004 1:06 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Quick stupid question


Josh, give the Chr$(36) a try,  36 is the ASCII decimal value for the $
dollar sign.

Chr$(36)+(column_name)

HTH
David Reid

-Original Message-
From: Josh Forsythe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 11:54 AM
To: [EMAIL PROTECTED]
Subject: MI-L Quick stupid question


I couldn't find the answer to this anywhere, and the question is
frustratingly simple:



I just want to add a dollar sign to the beginning of a label, to indicate
cost. Right now, the number just reads as 111.11, and I just want $111.11.
How do I change the expression on the label to allow for that? I've tried:



"$"(column_name)

\$ (column_name)

\"$" (column_name)

@#$*()^*()^ (column_name)



(the last one was pure frustration).



Thanks,

Josh







Josh Forsythe

Engineering Assistant

Midwest Wireless





-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11822


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11825





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 05/16/2004


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11830

RE: MI-L Quick stupid question

[Apers Mathieu]

ASCII stupid question, get a stupid ANSI

MWOOHAHAHAHAHAHahahahahah (sorry - i couldn't resist)

Mat

-Original Message-
From: B. Thoen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 May 2004 1:01 PM
To: Brown, Christopher (HI)
Cc: [EMAIL PROTECTED]
Subject: RE: MI-L Quick stupid question


On Wed, 19 May 2004, Brown, Christopher (HI) wrote:

> I know Chr$(13) gives a character return as well but could someone point
> me to where there is a list of all the Chr$ values?

It's the decimal values of the ASCII table. Online, you can view the list 
at http://www.asciitable.com/ (kind of silly to devote an entire dot-com 
domain to this, but all things are possible on the Internet!)

- Bill Thoen



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11828 
This email with any attachments is confidential and may be subject to legal privilege. 
 
If it is not intended for you please reply immediately, destroy it and do not copy, 
disclose or use it in any way. 

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11829

RE: MI-L Quick stupid question

[B. Thoen]

On Wed, 19 May 2004, Brown, Christopher (HI) wrote:

> I know Chr$(13) gives a character return as well but could someone point
> me to where there is a list of all the Chr$ values?

It's the decimal values of the ASCII table. Online, you can view the list 
at http://www.asciitable.com/ (kind of silly to devote an entire dot-com 
domain to this, but all things are possible on the Internet!)

- Bill Thoen



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11828

MI-L MapShop Projection Question

[Carolyn Bergin]

Hi Listers

For those of you using MapShop, hopefully you can help me.  I have the
problem that when I open up my aerial photography behind a series layer
the projection changes putting my series blocks on an angle rather than
having them straight as they were created.  This happens even if I open
my series layer first but only with my aerial photography, however,
other layers will change to match the series layer.

Is there any way around this?

Aside from that id also like my index box to show the whole LGA and
highlight the square shown on the map, is there a way to change the
settings of the idex box?

Thanks 

Carolyn

Carolyn Bergin
Senior GIS Officer 
Planning and Strategy
email - [EMAIL PROTECTED]
phone - 9976 1593
fax - 9976 1400

This email and any files transmitted with it are confidential and intended solely for 
the use of the individual or entity to whom they are addressed. Re-transmitting or 
re-publishing the content of this email in any media format without the express 
permission of the Author is strictly prohibited.
If you have received this email in error please notify Manly Council immediately.
Information transmitted via email may be subject to corruption by the process. 
Information contained in this email should not be relied upon where loss, damage or 
injury is possible. Verified information should be obtained in writing directly from 
the authorised Council officers.



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11827

RE: MI-L Quick stupid question

[Upinder Mutti]

Try:

Mapbasic Reference guide (v7) Page 641 - Appendix A: character code
table has a list of characters values from 32 to 255.


-Original Message-
From: Brown, Christopher (HI)
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 19 May 2004 10:17 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Quick stupid question


I know Chr$(13) gives a character return as well but could someone point
me to where there is a list of all the Chr$ values?

Regards
Chris
Chris Brown - Cartographer
Resource Evaluation, Land Assets,
Hamersley Iron P/L.
Tel.+61 8 9327 2176
Fax.+61 8 9327 2478
mailto:[EMAIL PROTECTED]
http://www.hamersleyiron.com/


-Original Message-
From: David Reid [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 May 2004 1:06 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Quick stupid question


Josh, give the Chr$(36) a try,  36 is the ASCII decimal value for the $
dollar sign.

Chr$(36)+(column_name)

HTH
David Reid

-Original Message-
From: Josh Forsythe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 18, 2004 11:54 AM
To: [EMAIL PROTECTED]
Subject: MI-L Quick stupid question


I couldn't find the answer to this anywhere, and the question is
frustratingly simple:

 

I just want to add a dollar sign to the beginning of a label, to
indicate cost. Right now, the number just reads as 111.11, and I just
want $111.11. How do I change the expression on the label to allow for
that? I've tried:

 

"$"(column_name)

\$ (column_name)

\"$" (column_name)

@#$*()^*()^ (column_name)

 

(the last one was pure frustration).

 

Thanks,

Josh

 

 

 

Josh Forsythe

Engineering Assistant

Midwest Wireless

 



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11822


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11825




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11826

RE: MI-L Quick stupid question

[Brown, Christopher (HI)]

I know Chr$(13) gives a character return as well but could someone point me to where 
there is a list of all the Chr$ values?

Regards
Chris
Chris Brown - Cartographer
Resource Evaluation, Land Assets,
Hamersley Iron P/L.
Tel.+61 8 9327 2176
Fax.+61 8 9327 2478
mailto:[EMAIL PROTECTED]
http://www.hamersleyiron.com/


-Original Message-
From: David Reid [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 May 2004 1:06 AM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Quick stupid question


Josh, give the Chr$(36) a try,  36 is the ASCII decimal value for the $
dollar sign.

Chr$(36)+(column_name)

HTH
David Reid

-Original Message-
From: Josh Forsythe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 18, 2004 11:54 AM
To: [EMAIL PROTECTED]
Subject: MI-L Quick stupid question


I couldn't find the answer to this anywhere, and the question is
frustratingly simple:

 

I just want to add a dollar sign to the beginning of a label, to indicate
cost. Right now, the number just reads as 111.11, and I just want $111.11.
How do I change the expression on the label to allow for that? I've tried:

 

"$"(column_name)

\$ (column_name)

\"$" (column_name)

@#$*()^*()^ (column_name)

 

(the last one was pure frustration).

 

Thanks,

Josh

 

 

 

Josh Forsythe

Engineering Assistant

Midwest Wireless

 



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11822


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11825

MI-L Thank you...

[Josh Forsythe]

To everyone that helped me out. Of course it was something as simple as
a plus sign. And it's only Tuesday?

 

Thanks again,

Josh

 

 

Josh Forsythe

Engineering Assistant

Midwest Wireless

RE: MI-L Testing to ensure a string is numeric: another approach

[Tim.Nuteson]

List,

I just wanted to point out another solution from Bill Thoen that seems
to be pretty bulletproof:


function IsNumeric (byval sVal as string) as logical
  dim i as integer

  For i = 1 to Len(sVal)
If NOT InStr (1, " 0123456789.+-e", mid$(sVal,i,1)) Then
  'String contains a non-numeric character!
  Exit Function
End If
  Next
  
  IsNumeric = 1

end function


It basically steps through the string that's being evaluated, testing
each character against a list of 'legal' numeric characters, and if it
finds one that's 'illegal', exits the function and returns FALSE.
Intuitively you would expect that this approach would be much slower,
but in practical usage it blazes along just as fast as the str$(val())
method.  

Tim Nuteson
Target




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 18, 2004 9:43 AM
To: Spencer Simpson
Cc: [EMAIL PROTECTED]
Subject: RE: MI-L Testing to ensure a string is numeric







Spencer,

In terms of speed, I would mostly stick with just the val function. Just
the idea that converting a string to a number and back to a string and
comparing them is fraught with danger, at least for floating point.

Note that the val function returns a number. It returns 0 for things
that don't parse and for real zeroes. So if you had code like:

num = val(somestring)

if num <> 0 then  ' this is definitely a number
 ' return true
else
 ' parse the string looking for spaces/tabs and then a 0 digit to
determine a true 0 endif

This code will be much faster if you think that you usually do have
numbers. The val function will do all the work for you. Call it an
optimistic implementation. You can even design the function so it
returns the number on success so that you don't bother doing it again.

Eric Blasenheim
Software Architect
MapInfo Corporation



Mail List:
 
[EMAIL PROTECTED]
 

 From:  on 05/17/2004 11:54 AM AST

 

 To:   <[EMAIL PROTECTED]>

 

 cc:

 

 Subject:  RE:  MI-L Testing to ensure a string is numeric

 




No, it will notThere are a couple of ways to implement them, some of
which are more efficient than others.

The str$(val()) method is the fastest method, but it's not the most
robust. For one thing, it works only for integers.  However, it's great
for quick applications that require only integers.

For robust, idiot-proof applications, you need more sophisticated
validation routines.

It is possible, of course, to write a routine that scans the string for
the correct format, but this can be very slow, given that you have to
make calls to mid$() for every character in the string.  If you've been
programming for any length of time, you've probably written one that you
can adapt to MapBasic.  Or you can write one in a faster language, put
it in a DLL, and link to it from MapBasic (scanf is NOT recommended).

Another method is to try assigning the string to a MapBasic window
variable, and catching any errors. This method is optimal for validating
strings that can take non-integer values.

run command "Dim v_dbl as float"
...
function good_float (ByVal s as string, f as float) as logical On Error
Goto notvalid run command "v_dbl="+sval OnError goto 0
f=val(Sval)
good_float = true
exit function
notvalid: resume failure
failure:  good_float = false
end function


Hope this helps
Spencer



-Original Message-
From: B. Thoen [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 11:05 AM
To: Tim.Nuteson
Cc: [EMAIL PROTECTED]
Subject: Re: SUM: MI-L Testing to ensure a string is numeric

Would that algorithm return the correct result if you fed it a numeric
string like '0023456', or are numbers with leading zeros not going to be
encountered?


On Mon, 17 May 2004, Tim.Nuteson wrote:

> Thanks to all who responded to my question:  How can I ensure that a 
> value entered into an EditText control of a MB dialog is numeric?  The

> simplest solution was offered by Michael Taylor, Martin Highham, and 
> Robert Crossley:
>
> If str$(val(teststring)) = teststring then
>   'numeric
> Else
>   'not
> End If
>
> Thanks again,
>
> Tim Nuteson
> Target
>
>
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |

> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> Message number: 11784
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11788



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11789







--

RE: MI-L Quick stupid question

[David Reid]

Josh, give the Chr$(36) a try,  36 is the ASCII decimal value for the $
dollar sign.

Chr$(36)+(column_name)

HTH
David Reid

-Original Message-
From: Josh Forsythe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 18, 2004 11:54 AM
To: [EMAIL PROTECTED]
Subject: MI-L Quick stupid question


I couldn't find the answer to this anywhere, and the question is
frustratingly simple:

 

I just want to add a dollar sign to the beginning of a label, to indicate
cost. Right now, the number just reads as 111.11, and I just want $111.11.
How do I change the expression on the label to allow for that? I've tried:

 

"$"(column_name)

\$ (column_name)

\"$" (column_name)

@#$*()^*()^ (column_name)

 

(the last one was pure frustration).

 

Thanks,

Josh

 

 

 

Josh Forsythe

Engineering Assistant

Midwest Wireless

 



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11822

MI-L Quick stupid question

[Josh Forsythe]

I couldn't find the answer to this anywhere, and the question is
frustratingly simple:

 

I just want to add a dollar sign to the beginning of a label, to
indicate cost. Right now, the number just reads as 111.11, and I just
want $111.11. How do I change the expression on the label to allow for
that? I've tried:

 

"$"(column_name)

\$ (column_name)

\"$" (column_name)

@#$*()^*()^ (column_name)

 

(the last one was pure frustration).

 

Thanks,

Josh

 

 

 

Josh Forsythe

Engineering Assistant

Midwest Wireless

 

RE: MI-L Coordinate Conversion

[Cinda Graubard]

Actually, it is more simple than this.  Several years ago the only way to 
accomplish this task was the method described below. However, there is now 
a tool that comes with MI, which you can load through Tools>Tool Manager, 
called "Coordinate Extractor".  The description of the tool may indicated 
that it only updates with native coordinates, but this is not the case, you 
can choose whatever coordinate system you want.

Cinda Graubard
GeoMax
At 08:55 AM 05/18/2004, Spencer Simpson wrote:
Since this is a MapInfo mailing list, I suppose we should let you know
that you can do this in MapInfo without any special add-ons or MapBasic
applications (although you should use MapInfo 7.0 or later to preserve
coordinate precision).
1. Import your list of coordinates into a table.
2. Use Table -> Create Points to create points from
the latitudes and longitudes. Remember to select a Latitude/Longitude
projection using the correct datum.
3. If you want to keep the Lat/Lon values in their columns, add two new
X/Y columns to hold the UTM coordinates.
4. Open the table in a Map window.
5. Show the MapBasic window (Options ->Show MapBasic Window).
6. Use Map->Options to change the projection to UTM (or whatever projection
suits your need).
7. A "Set Map Coordsys" statement will have been printed in the MapBasic
Window.  Delete the word "Map" so that it reads "Set Coordsys" and hit
ENTER.
8. Use Table -> Update column twice to update the X and Y columns you
created in step 3  (or the lat/lon columns if you didn't create any) with
centroidX(obj) and centroidY(obj).  You can also do this in one step
by typing "Update mytable set xcol=centroidX(obj), ycol=centroidY(obj)"
in the MapBasic window (where mytable is the name of the table you created,
and xcol and ycol are the names of the destination columns).
HTH
Spencer

-Original Message-
From: Wangberg, Willie (USBORAX) [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 7:58 PM
To: [EMAIL PROTECTED]
Subject: MI-L Coordinate Conversion
Does anyone know of a MapBasic program or any program for that matter that
will allow me to convert a list of coordinates at once? I am going from
lat/long to UTM. I have found several websites that allow for a single
coordinate, but not one that I can get to work for a batch process. I have
tried the Corpscon and Trailane Evaluation version and cant seem to get them
to work. Are there any others?
Willie Wangberg
Information Tech
Rio Tinto Exploration
52 Glen Carran Circle
Sparks, NV 89431
P: (775) 358-9500
F: (775) 358-9529
email: [EMAIL PROTECTED]
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11798

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11817

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11820

Re: MI-L points with same lat/lon

[Robert DeRubeis]

Thanks Peter.  That is more along the lines of what I was expecting.  It
works great.  Very cool.
-Bob

Peter Horsbøll Møller <[EMAIL PROTECTED]> writes:
>Hi Robert,
>
>I'm not sure whether you saw this solution I sent before. I just checked
>and found some errors in it, but it works, without saving any queries !
>
>Grouping all reocrds by LAT and long, and counting the number of records
>at the same location:
>Select LAT, LONG, LAT + "#" + LONG "LAT_LONG", Count(*) "NUMPOINTS"
>   From 
>   Group By LAT, LONG
>   Order By NUMPOINTS Desc
>
> is the name of the table with the recoords
>
>To select the points where more than 1 point is found in the same
>location, enter the following in SQL Select
>
>Select *
>   From 
>   Where (LAT + "#" + LONG) In (Select LAT_LONG From Selection Where
>NUMPOINTS > 1)
>
>Now you should have a selection of all points that were located were at
>least one other point also was located
>
>Peter Horsbøll Møller
>GIS Developer
>Geographical Information & IT
> 
>COWI A/S
>Odensevej 95
>DK-5260 Odense S.
>Denmark
> 
>Tel+45 6311 4900
>Direct +45 6311 4908
>Mob+45 5156 1045
>Fax+45 6311 4949
>E-mail [EMAIL PROTECTED]
>http://www.cowi.dk
>
>
>-Original Message-
>From: Robert DeRubeis [mailto:[EMAIL PROTECTED] 
>Sent: Monday, May 17, 2004 6:47 PM
>To: [EMAIL PROTECTED]
>Subject: Re: MI-L points with same lat/lon
>
>
>Saving the count query and the last step was what I was missing and it
>worked fine.  I thought it wouldn't take so many steps and having to save
>query results, etc., but better more steps with it being able to be done,
>than it can't do it. Thanks to all -Bob
>
>
>"Spencer Simpson" <[EMAIL PROTECTED]> writes:
>>Assuming you've done the following (which it sounds like you've done):
>>
>>1. Update the lon and lat columns with centroidX and centroidY 2. Make 
>>the group-by query (group by lat and lon. 3. Make the query where 
>>count>1
>>
>>You should then:
>>
>>3. Save the result of query 2 to its own table (we'll call it 
>>DUPLOCS.TAB). 4. Close the query tables generated in steps 1 and 2, 
>>then open the table you saved in step 3 (DUPLOCS).
>>5. If the original table has 1 records or more, index its lat column,
>>and the lat column of DUPLOCS.
>>6. Perform a SQL Select:
>>
>>select * from ORIGTAB, DUPLOCS where (origtab.lon=duplocs.lon) and
>>(origtab.lat=duplocs.lat)
>>
>>
>>Viola'!
>>
>>Hope this helps
>>Spencer
>>
>>
>>-Original Message-
>>From: Robert DeRubeis [mailto:[EMAIL PROTECTED]
>>Sent: Monday, May 17, 2004 12:02 PM
>>To: [EMAIL PROTECTED]
>>Cc: Kir Luong; Peter Horsb¿ll M¿ller
>>Subject: Re: MI-L points with same lat/lon
>>
>>I've done this, and found that I have 100's of duplications of 2 or more,
>>but I need all of the records that are duplicates.When a count query
>>is done it does not select all records with matching lat/lon's.  It 
>>returns, for example,
>>Count Lat Lon
>>6 49.715709   -123.156264
>>5 49.709248   -124.916418
>>4 43.745795   -79.526276
>>etc, etc..
>>
>>There are 15 records above with the same lat/lon.  I need to be able to 
>>select all 15 records? -Bob
>>
>>"Kir Luong" <[EMAIL PROTECTED]> writes:
>>>If the lat or long is the same then a count and group by function on 
>>>those variables should give you the records that are identical (group 
>>>by
>>>clause) and how many duplication (count function):
>>>I'm not sure the mapinfo SqL...but something like:
>>>
>>>Select count(*),lat
>>>from table1
>>>group by lat
>>>having  count(*) > 1;
>>>execute;  ===> returns a table of all lats that are duplicated and the 
>>>number of duplication
>>>
>>>likewise for the longs. Hope this helps.
>>>
>>>kir.
>>>
>>>-Original Message-
>>>From: Robert DeRubeis [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, May 14, 2004 3:03 PM
>>>To: [EMAIL PROTECTED]
>>>Subject: MI-L points with same lat/lon
>>>
>>>
>>>List-
>>>Is there a way to select all records from one table where the values 
>>>in 2 different columns are identical? I wanted to select all records 
>>>where the lat of 1st record = lat of 2nd record AND lon of 1st record 
>>>= lon of 2nd record.  I'm trying to identify where and how many points 
>>>are right on
>>top
>>>of each other and if they need to be dispersed or better geocoding.
>>>
>>>The table has about 30,000 points and I'm using MIPro 6.5. Thanks,
>>>-Bob
>>>
>>>
>>>-
>>>List hosting provided by Directions Magazine | www.directionsmag.com | 
>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>For additional commands, e-mail: 
>>>[EMAIL PROTECTED]
>>>Message number: 11767
>>>
>>>
>>>This communication is intended for the use of the recipient to which 
>>>it is addressed, and may contain confidential, personal and or 
>>>privileged information. Please contact us immediately if you are not 
>>>the intended recipient of

MI-L ann: Future of Geomatics Policy in Canada

[GISuser.com Editor]

hello all,
FYI, I thought this would be of interest to some of you Canucks as there
was little mention of this  event out there.. I'll be there!
 
On May 19, 2004 a one day workshop is to be held in Victoria, BC to
discuss policies that will govern geomatic initiatives in Canada, and in
particular what efforts are being undertaken by the provincial
government in this area.  This is the first in a series of workshops
that the GeoConnections Policy Node and the Geomatics Industry
Association of Canada (GIAC) are hosting
 
More info can be found at

http://www.gisuser.com/content/view/1662/53/
 
and at   
http://www.giac.ca/site/policy.html 
 
Regards
Glenn
 

==
Glenn Letham / Co-founder & Managing Editor
Spatial Media LLC
GISUser.com
  [EMAIL PROTECTED]

Register for our Free GISuser Newsletter
register online or with a simple reply "subscribe"
email message.

  www.GISuser.com
"Taking You Beyond The Map"
==

RE: MI-L Coordinate Conversion

[Spencer Simpson]

Since this is a MapInfo mailing list, I suppose we should let you know
that you can do this in MapInfo without any special add-ons or MapBasic
applications (although you should use MapInfo 7.0 or later to preserve
coordinate precision).

1. Import your list of coordinates into a table.
2. Use Table -> Create Points to create points from
the latitudes and longitudes. Remember to select a Latitude/Longitude
projection using the correct datum.
3. If you want to keep the Lat/Lon values in their columns, add two new
X/Y columns to hold the UTM coordinates.
4. Open the table in a Map window. 
5. Show the MapBasic window (Options ->Show MapBasic Window).
6. Use Map->Options to change the projection to UTM (or whatever projection
suits your need).
7. A "Set Map Coordsys" statement will have been printed in the MapBasic
Window.  Delete the word "Map" so that it reads "Set Coordsys" and hit
ENTER.
8. Use Table -> Update column twice to update the X and Y columns you
created in step 3  (or the lat/lon columns if you didn't create any) with
centroidX(obj) and centroidY(obj).  You can also do this in one step 
by typing "Update mytable set xcol=centroidX(obj), ycol=centroidY(obj)"
in the MapBasic window (where mytable is the name of the table you created,
and xcol and ycol are the names of the destination columns). 

HTH
Spencer



-Original Message-
From: Wangberg, Willie (USBORAX) [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 7:58 PM
To: [EMAIL PROTECTED]
Subject: MI-L Coordinate Conversion

Does anyone know of a MapBasic program or any program for that matter that
will allow me to convert a list of coordinates at once? I am going from
lat/long to UTM. I have found several websites that allow for a single
coordinate, but not one that I can get to work for a batch process. I have
tried the Corpscon and Trailane Evaluation version and cant seem to get them
to work. Are there any others?

Willie Wangberg
Information Tech

Rio Tinto Exploration
52 Glen Carran Circle
Sparks, NV 89431
 
P: (775) 358-9500
F: (775) 358-9529
email: [EMAIL PROTECTED]


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11798



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11817

RE: MI-L Testing to ensure a string is numeric

[Eric_Blasenheim]

Spencer,

In terms of speed, I would mostly stick with just the val function. Just
the idea that converting a string to a number and back to a string and
comparing them is fraught with danger, at least for floating point.

Note that the val function returns a number. It returns 0 for things that
don't parse and for real zeroes. So if you had code like:

num = val(somestring)

if num <> 0 then  ' this is definitely a number
 ' return true
else
 ' parse the string looking for spaces/tabs and then a 0 digit to
determine a true 0
endif

This code will be much faster if you think that you usually do have
numbers. The val function will do all the work for you. Call it an
optimistic implementation. You can even design the function so it returns
the number on success so that you don't bother doing it again.

Eric Blasenheim
Software Architect
MapInfo Corporation



Mail List:
   [EMAIL PROTECTED]
   
 From:  on 05/17/2004 11:54 AM AST 
   
 To:   <[EMAIL PROTECTED]> 
   
 cc:   
   
 Subject:  RE:  MI-L Testing to ensure a string is numeric 
   



No, it will notThere are a couple of ways to implement them, some of which
are more efficient than others.

The str$(val()) method is the fastest method, but it's not the most robust.
For one thing, it works only for integers.  However, it's great for quick
applications that require only integers.

For robust, idiot-proof applications, you need more sophisticated
validation
routines.

It is possible, of course, to write a routine that scans the string
for the correct format, but this can be very slow, given that you
have to make calls to mid$() for every character in the string.  If
you've been programming for any length of time, you've probably written
one that you can adapt to MapBasic.  Or you can write one in a faster
language, put it in a DLL, and link to it from MapBasic (scanf is NOT
recommended).

Another method is to try assigning the string to a MapBasic window
variable,
and catching any errors. This method is optimal for validating strings that
can take non-integer values.

run command "Dim v_dbl as float"
...
function good_float (ByVal s as string, f as float) as logical
On Error Goto notvalid
run command "v_dbl="+sval
OnError goto 0
f=val(Sval)
good_float = true
exit function
notvalid: resume failure
failure:  good_float = false
end function


Hope this helps
Spencer



-Original Message-
From: B. Thoen [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 11:05 AM
To: Tim.Nuteson
Cc: [EMAIL PROTECTED]
Subject: Re: SUM: MI-L Testing to ensure a string is numeric

Would that algorithm return the correct result if you fed it a numeric
string like '0023456', or are numbers with leading zeros not going to be
encountered?


On Mon, 17 May 2004, Tim.Nuteson wrote:

> Thanks to all who responded to my question:  How can I ensure that a
> value entered into an EditText control of a MB dialog is numeric?  The
> simplest solution was offered by Michael Taylor, Martin Highham, and
> Robert Crossley:
>
> If str$(val(teststring)) = teststring then
>   'numeric
> Else
>   'not
> End If
>
> Thanks again,
>
> Tim Nuteson
> Target
>
>
> -
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 11784
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11788



-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11789







-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11816

MI-L New User, Have Question

[Fake Email]

Im using MapInfo 7.0, my company wants me to geocode
their database of sites, which is simple, then create
a program where an end user can input a zip code, and
the program finds all the sites within a 15 mile
radius.  I have a few idea how to do this, but I do
not have MapBasic, is their anyway to do this without
MapBasic? Thanks in advance.




__
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11815

Re: MI-L Logical fields in SQL select

[B. Thoen]

On Tue, 18 May 2004, Driver, Greg 9434 wrote:

> Err, I seem to be having a problem with something that should appear
> straightforward!  I've got a table with a number of logical fields and when
> I query even field using the following:
> 
> Select * from police_stations where HQ = "false"
> 
> all that is returned are the records that are TRUE.  I've tried using false,
> F and >0 in the where condition but to no avail.  So how do I go about
> selecting those records that are false?

If HQ is a Logical type, then you should try this instead:

Select * from police_stations where Not HQ

or 

Select * from police_stations where HQ = 0


 


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11814

SV: MI-L Labelling expression help needed

[Thomsen, Bo Victor]

Assuming the database field (column) is called "xxx", you can label with the
following expression:

Left$ (xxx,InStr( InStr( 1,xxx," " )+1,xxx," " )-1)

Regards
 
Bo Thomsen
GeoConsult I/S 
Denmark

-Oprindelig meddelelse-
Fra: David Reid [mailto:[EMAIL PROTECTED]
Sendt: 18. maj 2004 03:44
Til: 'MapInfo-L'
Emne: MI-L Labelling expression help needed


Greetings List,

I wish to label a map with an expression that would display all characters
of a string until a second space is encountered.

Example:

"Lot 1 in blk 2 of Mapinfo Estates"

I need to extract "Lot XX".

To return:

Lot 5
Lot 34
Etc.


Thanks in advance.
David Reid


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11802

-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11813

RE: MI-L Coordinate Conversion

[paul.crisp]

Willie

I put a VB class up on Directions a couple of years ago, based on an
algorithm that the Ordnance Survey made available as an Excel spreadsheet.
(Look for utmconveter-380.txt - it was spelt correctly when I uploaded it I'm
sure!)

The class instantiates on the values for the UK but they are all properties
that you can reset - or you can reset the starting values for false origin,
scale factor etc to suit your own purpose. 

If you don't want to use VB its easy enough to port to another language -
theres no mapping involved, just numbers.

It also does some other stuff such as converting UK grid refs to national
grid which you can ignore

Rgds

Paul Crisp

BT Syntegra
Innovation Place Delta Bank Road Newcastle NE11 9DJ
Tel 0191 461 4522 Fax 0191 460 1987


-Original Message-
From: Wangberg, Willie (USBORAX) [mailto:[EMAIL PROTECTED]
Sent: 18 May 2004 00:58
To: [EMAIL PROTECTED]
Subject: MI-L Coordinate Conversion


Does anyone know of a MapBasic program or any program for that matter that
will allow me to convert a list of coordinates at once? I am going from
lat/long to UTM. I have found several websites that allow for a single
coordinate, but not one that I can get to work for a batch process. I have
tried the Corpscon and Trailane Evaluation version and cant seem to get them
to work. Are there any others?

Willie Wangberg
Information Tech

Rio Tinto Exploration
52 Glen Carran Circle
Sparks, NV 89431
 
P: (775) 358-9500
F: (775) 358-9529
email: [EMAIL PROTECTED]


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11798





This email may contain information which is privileged or confidential. If you are not 
the intended recipient of this email, please notify the sender immediately and delete 
it without reading, copying, storing, forwarding or disclosing its contents to any 
other person
Thank you

Check us out at http://www.btsyntegra.com

RE: MI-L Labelling expression help needed

[Terry McDonnell]

David

Assuming you can do it in MapBasic, to get your label try:

lnPos1 = InStr ( 1,  lcLot_string,  " ")
lnPos2 = InStr ( lnPos1+1,  lcLot_string,  " ")
lcShort_string = Left$ (lcLot_string,  lnPos2-1 )

HTH

Terry

-Original Message-
 
Greetings List,

I wish to label a map with an expression that would display all
characters
of a string until a second space is encountered.

Example:

"Lot 1 in blk 2 of Mapinfo Estates"

I need to extract "Lot XX".

To return:

Lot 5
Lot 34
Etc.




-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11811

MI-L SUM -MI-L Logical fields in SQL select

[Driver, Greg 9434]

Thanks to Mark, Martin and Photogrammetry GIU (!) who suggested either
inverting the selection or using the following : Select * from
police_stations where not HQ

Thanks Guys.

> -Original Message-
> From: Driver, Greg 9434 
> Sent: Tuesday, May 18, 2004 09:07
> To:   MapInfo-L (E-mail)
> Subject:  MI-L Logical fields in SQL select
> 
> Err, I seem to be having a problem with something that should appear
> straightforward!  I've got a table with a number of logical fields and
> when
> I query even field using the following:
> 
> Select * from police_stations where HQ = "false"
> 
> all that is returned are the records that are TRUE.  I've tried using
> false,
> F and >0 in the where condition but to no avail.  So how do I go about
> selecting those records that are false?
> 
> Thanks
> 
> Greg Driver
> 
> 
> 
> 
> Internet communications are not secure and therefore Surrey Police does
> not
> accept legal responsibility for the contents of this message.  This email
> and any attachments may be confidential. They may contain privileged
> information and are intended for the named addressee (s) only. They must
> not
> be distributed without our consent. If you are not the intended recipient,
> please notify us immediately and delete the message and any attachments
> from
> your computer, do not disclose, distribute, or retain this email or any
> part
> of it. Unless expressly stated, opinions in this email are those of the
> individual sender, and not of Surrey Police. We believe but do not warrant
> that this e-mail and any attachments are virus free. You must therefore
> take
> full responsibility for virus checking. Surrey Police reserves the right
> to
> monitor all email communications through their networks.
> 
> 
> 
> 
Internet communications are not secure and therefore Surrey Police does not
accept legal responsibility for the contents of this message.  This email
and any attachments may be confidential. They may contain privileged
information and are intended for the named addressee (s) only. They must not
be distributed without our consent. If you are not the intended recipient,
please notify us immediately and delete the message and any attachments from
your computer, do not disclose, distribute, or retain this email or any part
of it. Unless expressly stated, opinions in this email are those of the
individual sender, and not of Surrey Police. We believe but do not warrant
that this e-mail and any attachments are virus free. You must therefore take
full responsibility for virus checking. Surrey Police reserves the right to
monitor all email communications through their networks.

Re: MI-L Logical fields in SQL select

[Martin Hodder]

Hi Greg

Try:-

Select * from police_stations where not HQ

Regards

Martin



- Original Message - 
From: "Driver, Greg 9434" <[EMAIL PROTECTED]>
To: "MapInfo-L (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, May 18, 2004 9:06 AM
Subject: MI-L Logical fields in SQL select


> Err, I seem to be having a problem with something that should appear
> straightforward!  I've got a table with a number of logical fields and
when
> I query even field using the following:
>
> Select * from police_stations where HQ = "false"
>
> all that is returned are the records that are TRUE.  I've tried using
false,
> F and >0 in the where condition but to no avail.  So how do I go about
> selecting those records that are false?
>
> Thanks
>
> Greg Driver
>
>
>
>
> Internet communications are not secure and therefore Surrey Police does
not
> accept legal responsibility for the contents of this message.  This email
> and any attachments may be confidential. They may contain privileged
> information and are intended for the named addressee (s) only. They must
not
> be distributed without our consent. If you are not the intended recipient,
> please notify us immediately and delete the message and any attachments
from
> your computer, do not disclose, distribute, or retain this email or any
part
> of it. Unless expressly stated, opinions in this email are those of the
> individual sender, and not of Surrey Police. We believe but do not warrant
> that this e-mail and any attachments are virus free. You must therefore
take
> full responsibility for virus checking. Surrey Police reserves the right
to
> monitor all email communications through their networks.
>
>
>


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11809

MI-L Logical fields in SQL select

[Driver, Greg 9434]

Err, I seem to be having a problem with something that should appear
straightforward!  I've got a table with a number of logical fields and when
I query even field using the following:

Select * from police_stations where HQ = "false"

all that is returned are the records that are TRUE.  I've tried using false,
F and >0 in the where condition but to no avail.  So how do I go about
selecting those records that are false?

Thanks

Greg Driver




Internet communications are not secure and therefore Surrey Police does not
accept legal responsibility for the contents of this message.  This email
and any attachments may be confidential. They may contain privileged
information and are intended for the named addressee (s) only. They must not
be distributed without our consent. If you are not the intended recipient,
please notify us immediately and delete the message and any attachments from
your computer, do not disclose, distribute, or retain this email or any part
of it. Unless expressly stated, opinions in this email are those of the
individual sender, and not of Surrey Police. We believe but do not warrant
that this e-mail and any attachments are virus free. You must therefore take
full responsibility for virus checking. Surrey Police reserves the right to
monitor all email communications through their networks.

MI-L MapXtreme query

[Simon Hume]

Hi

We've recently bought MapXtreme to commence development of an intranet Web mapping 
service for the Authority.  This will then be expanded to out Extranet and finally the 
Internet

MapXtreme is held on it's own server, as are the intranet and internet. The GIS data 
is held on yet another server.

The problem my colleague has found is that of enabling access to the Web mapping 
service when they are using a service ie the Intranet that resides on a seperate 
server.

Has anyone else encountered this problem.  If so, how did they get round it?

Thanks

Simon



This e-mail message is from Daventry District Council but expresses the views of the 
individual and not necessarily that of the authority. This e-mail is intended 
exclusively for the individual(s) to whom it is addressed and may contain information 
that is privileged, or confidential.  If you are not the addressee, you must not read, 
use or disclose the contents of this e-mail.  If you receive this e-mail in error, 
please notify [EMAIL PROTECTED] giving the name of the sender and delete the e-mail 
immediately.
Daventry District Council has taken every reasonable precaution to ensure that an 
attachment to this e-mail has been checked for any viruses. Daventry District Council 
cannot, however, accept liability for any damage sustained as a result of software 
viruses and would strongly advise that you carry out your own virus checks before 
opening any attachment.



This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk


-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11807

RE: MI-L points with same lat/lon

[Peter Horsbøll Møller]

Hi Robert,

I'm not sure whether you saw this solution I sent before. I just checked and found 
some errors in it, but it works, without saving any queries !

Grouping all reocrds by LAT and long, and counting the number of records at the same 
location:
Select LAT, LONG, LAT + "#" + LONG "LAT_LONG", Count(*) "NUMPOINTS"
From 
Group By LAT, LONG
Order By NUMPOINTS Desc

 is the name of the table with the recoords

To select the points where more than 1 point is found in the same location, enter the 
following in SQL Select

Select *
From 
Where (LAT + "#" + LONG) In (Select LAT_LONG From Selection Where NUMPOINTS > 
1)

Now you should have a selection of all points that were located were at least one 
other point also was located

Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
 
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
 
Tel +45 6311 4900
Direct  +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk


-Original Message-
From: Robert DeRubeis [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 17, 2004 6:47 PM
To: [EMAIL PROTECTED]
Subject: Re: MI-L points with same lat/lon


Saving the count query and the last step was what I was missing and it worked fine.  I 
thought it wouldn't take so many steps and having to save query results, etc., but 
better more steps with it being able to be done, than it can't do it. Thanks to all 
-Bob


"Spencer Simpson" <[EMAIL PROTECTED]> writes:
>Assuming you've done the following (which it sounds like you've done):
>
>1. Update the lon and lat columns with centroidX and centroidY 2. Make 
>the group-by query (group by lat and lon. 3. Make the query where 
>count>1
>
>You should then:
>
>3. Save the result of query 2 to its own table (we'll call it 
>DUPLOCS.TAB). 4. Close the query tables generated in steps 1 and 2, 
>then open the table you saved in step 3 (DUPLOCS).
>5. If the original table has 1 records or more, index its lat column,
>and the lat column of DUPLOCS.
>6. Perform a SQL Select:
>
>select * from ORIGTAB, DUPLOCS where (origtab.lon=duplocs.lon) and
>(origtab.lat=duplocs.lat)
>
>
>Viola'!
>
>Hope this helps
>Spencer
>
>
>-Original Message-
>From: Robert DeRubeis [mailto:[EMAIL PROTECTED]
>Sent: Monday, May 17, 2004 12:02 PM
>To: [EMAIL PROTECTED]
>Cc: Kir Luong; Peter Horsb¿ll M¿ller
>Subject: Re: MI-L points with same lat/lon
>
>I've done this, and found that I have 100's of duplications of 2 or more,
>but I need all of the records that are duplicates.When a count query
>is done it does not select all records with matching lat/lon's.  It 
>returns, for example,
>Count  Lat Lon
>6  49.715709   -123.156264
>5  49.709248   -124.916418
>4  43.745795   -79.526276
>etc, etc..
>
>There are 15 records above with the same lat/lon.  I need to be able to 
>select all 15 records? -Bob
>
>"Kir Luong" <[EMAIL PROTECTED]> writes:
>>If the lat or long is the same then a count and group by function on 
>>those variables should give you the records that are identical (group 
>>by
>>clause) and how many duplication (count function):
>>I'm not sure the mapinfo SqL...but something like:
>>
>>Select count(*),lat
>>from table1
>>group by lat
>>having  count(*) > 1;
>>execute;  ===> returns a table of all lats that are duplicated and the 
>>number of duplication
>>
>>likewise for the longs. Hope this helps.
>>
>>kir.
>>
>>-Original Message-
>>From: Robert DeRubeis [mailto:[EMAIL PROTECTED]
>>Sent: Friday, May 14, 2004 3:03 PM
>>To: [EMAIL PROTECTED]
>>Subject: MI-L points with same lat/lon
>>
>>
>>List-
>>Is there a way to select all records from one table where the values 
>>in 2 different columns are identical? I wanted to select all records 
>>where the lat of 1st record = lat of 2nd record AND lon of 1st record 
>>= lon of 2nd record.  I'm trying to identify where and how many points 
>>are right on
>top
>>of each other and if they need to be dispersed or better geocoding.
>>
>>The table has about 30,000 points and I'm using MIPro 6.5. Thanks,
>>-Bob
>>
>>
>>-
>>List hosting provided by Directions Magazine | www.directionsmag.com | 
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: 
>>[EMAIL PROTECTED]
>>Message number: 11767
>>
>>
>>This communication is intended for the use of the recipient to which 
>>it is addressed, and may contain confidential, personal and or 
>>privileged information. Please contact us immediately if you are not 
>>the intended recipient of this communication, and do not copy, 
>>distribute, or take action relying on it. Any communication received 
>>in error, or subsequent reply, should be deleted or destroyed
>
>
>-
>List hosting provided by Directi