-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 March 2005 15:16
To: Terry McDonnell
Subject: MI-L SQL help?
Group
I have a Interstate shield's layer for the U.S. that has a shield (node) every
mile along that Interstate. What I want to do is make the same layer but, only
Group
I have a Interstate shield's layer for the U.S. that has a shield (node)
every mile along that Interstate. What I want to do is make the same layer
but, only have nodes that are 5 miles apart. Any ideas on how to do this?
Thanks for any help.
---
Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860
-Original Message-
From: "Wangberg, Willie (USBORAX)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Fri, 22 Oct 2004 09:15:55 -0700
Subject: MI-L SQL
Does someone know a sql statement that allows me to add an incremental number to a
table? I have a list of 60 things and I want to number them starting from 1-60. Or is
there another way to do this in MapInfo?
Willie Wangberg
Information Technology
Rio Tinto Exploration
52 Glen Carran Circle
Sp
You can then use this table to do your thematic maps.
HTH
Regards
martin
- Original Message -
From: "Burchfield, Robin 10088" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 11:12 AM
Subject: MI-L SQL Help
> Hi listers
>
>
Hi listers
I have two MI tables, one contains postcode (Zipcode) boundaries and the
other contains points that are attributed with a crime type e.g. 'C1', 'C2',
'C3' etc.
What I require is a query that can count the number of each crime type that
fall within each postcode boundary so that I can
Mitchell Geographics, Inc.
> 496 Congress Street
> Portland, Maine 04101
> 207.879.7769
> www.mitchellgeo.com
>
>
> -Original Message-
> From: Carolyn Bergin [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 08, 2003 8:31 PM
> To: [EMAIL PROTECTED]
>
Carolyn,
Use the table> Update Column menu item and set it up so that you use
this expression to update your new field.
Left$(OldField,Instr(1,"/",OldField)-1)
r
On Tue, 9 Dec 2003 12:31:15 +1100, Carolyn Bergin
<[EMAIL PROTECTED]> wrote:
Hi guys
I have a dataset that contains a field wi
Carolyn,
Use the Instr function in combination with the Left$ function
Instr(1,"123/456","/") returns 4, which is the chanacter position of the
"/"
So,
Update TableName Set FirstPart = left$(Data,InStr(1,Data,"/")-1)
will update the column FirstPart in table Tablename with everything
before th
OTECTED]
Sent: Monday, December 08, 2003 8:31 PM
To: [EMAIL PROTECTED]
Subject: MI-L SQL Help
Hi guys
I have a dataset that contains a field with references like 1/375 and
2/540 etc. I need to update another column with the just number
preceeding the /. Is there any way I can do this using an SQ
Hi guys
I have a dataset that contains a field with references like 1/375 and
2/540 etc. I need to update another column with the just number
preceeding the /. Is there any way I can do this using an SQL. The
dataset is huge and im trying to save some time rather than going
through and manually
[EMAIL PROTECTED]cc:
, 2002 12:13 PM
To: 'Morrier, Steve'; MapInfo-L (E-mail)
Subject: RE: MI-L SQL Help
Steve,
Not to worry, you won't get fired. Remember we are the ones who actually do
the work!
Here is a method for selecting records in one table that do not match
records in another table.
Consi
rrier, Steve [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 10:13 AM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL Help
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi all,
I have what I t
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi all,
I have what I thought would be an easy query but it is giving me problems. I
have 2 street files, one new and one old. They have roughly the same
struc
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi All,
I am trying to select all the streets in my street table that are within
5kms of a city file. The city file is a point file while the street file is
ob
I have a table with two columns one called numbers one called groups. In
the table certain numbers like 2 fall within multiple groups. How do I get
MapInfo to grab just the numbers that are within more than one group?
Travis Lathrop
Intercarrier Services
913/762-4806
17 matches
Mail list logo